> Source: [sk169772](https://support.checkpoint.com/results/sk/sk169772)

# sk169772 - Some objects are not available for editing

| Property | Value |
|----------|-------|
| Solution ID | sk169772 |
| Date Created | 2020-10-06 |
| Last Modified | 2022-12-26 |
| Technical Level | General |
| Products | Security Management Server, Multi-Domain Security Management Server |
| Versions | R81.20, R81.10 (EOS), R81 (EOS), R81 (EOS), R81.10 (EOS), R81.20 |
| OS | Gaia |

## Symptoms

- * In a rare scenario, some objects are not available for editing.  

* $FWDIR/log/cpm.elg is flooded every 10s with errors like:  
  * ERROR coresvc.internal.LoginSvcImpl \[taskScheduler-XX\]: Failed to logout session from scheduledClientCheck CpmGeneralException{base='com.checkpoint.management.is.exceptions.CpmGeneralException', errorCode='CP_ERR_WORK_SESSION_NOT_FOUND', errorFamily='null', messageForUser='null', message='null'} at com.checkpoint.management.dleserver.coresvc.internal.WorkSessionMgmtSvcImpl.getAndCacheWorkSessionFromDb_aroundBody40(WorkSessionMgmtSvcImpl.java:1126)
  * ERROR coresvc.internal.WorkSessionMgmtSvcImpl \[taskScheduler-XX\]: Tried to get a non existing session 343deb00-5296-4f77-be6b-4acd5f395754, Couldn't find it in database org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:53)

  <br />

  <br />

* For R80.10, the query returns any result:  

  `

  psql_client cpm postgres -c "select rowid from objectstoresessionentity oss where oss.rowid not in (select objectstoresessionid from worksession) and oss.id != -32768 and oss.id not in (select dlesession from dleobjectderef_data where not deleted);"`  

* R80.20 and higher:  

  `
  psql_client cpm postgres -c "select rowid from objectstoresessionentity oss where oss.rowid not in (select objectstoresessionid from domainworksession) and oss.id != -32768 and oss.id not in (select dlesession from dleobjectderef_data where not deleted);"`

## Cause

In rare scenarios a public session (admin session) performs 'tag revision' with an existing work session, and leaves some objects locked with no open work session assigned to them.

## Solution

This problem was fixed. The fix is included in:

* [Jumbo Hotfix Accumulator for R80.40](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk165456) starting from Take 87
* [Jumbo Hotfix Accumulator for R80.30](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk153152) starting from Take 227
* [Jumbo Hotfix Accumulator for R80.20](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk137592) starting from Take 187

If you choose not to upgrade, or encounter a similar issue with later versions, download and run the ***[osseWithoutDws.sh](https://supportcenter.checkpoint.com/supportcenter/portal/role/supportcenterUser/page/default.psml/media-type/html?action=portlets.DCFileAction&eventSubmit_doGetdcdetails=&fileid=109426)*** script to update the database.  

**Important:**

* Perform a backup or take a snapshot prior to executing the changes on the server.
* Be sure to disconnect **all users** from the server during the usage of the script!

<br />

Instructions:

1. Move the script osseWithoutDws.sh to the machine
2. Run: *# chmod +x osseWithoutDws.sh*
3. Run: *# dos2unix osseWithoutDws.sh*
4. Run: *# ./osseWithoutDws.sh*

---

# Agent Instructions

This content is from the Check Point Support Center (https://support.checkpoint.com), the official knowledge base for Check Point cybersecurity products.

## Navigating This Knowledge Base

- **Complete index**: [llms.txt](https://support.checkpoint.com/llms.txt)
- **All SK articles**: [SecureKnowledge Sitemap](https://support.checkpoint.com/sitemaps/secureknowledge-sitemap-index.xml)
- **SK article URL pattern**: `https://support.checkpoint.com/results/sk/{skId}`
- **Markdown responses**: AI bot User-Agents automatically receive `text/markdown` content
