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

# sk163116 - Not able to delete empty database revision rows

| Property | Value |
|----------|-------|
| Solution ID | sk163116 |
| Date Created | 2019-10-28 |
| Last Modified | 2023-04-06 |
| Technical Level | General |
| Products | SmartConsole |
| Versions | R82.10, R82, R81.20 |

## Symptoms

- * There are empty Database revision rows that cannot be deleted/purged.

  ![](https://sc1.checkpoint.com/sc/SolutionsStatics/NEW_SK_NOID1571329135959/empty_db1910170933.JPG)
* Running solr cure , from [sk140394](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk140394) finished successfully and all DB revisions have been purged, but the empty rows still exist.

* Similar errors are seen in cpm.elg when purging database:  
  `

  [DATE TIME] INFO coresvc.internal.RevisionsSvcImpl$PurgeOperation [taskExecutor-18]: Purging data for versions between 0 and 36266`  
  `
  [DATE TIME] INFO coresvc.internal.RevisionsSvcImpl$PurgeOperation [taskExecutor-18]: Purging data stage 1 - non-os data...`  
  `
  [DATE TIME] INFO dleserver.utils.LogSaverForFailedTasks [taskExecutor-18]: title.toLowerCase() is database purging_an error has occurred while performing revision purge operation. incident i
  d: f56e158e-4aeb-4b6c-8cfa-8ec54eb0d027`  
  `
  [DATE TIME] INFO dleserver.utils.LogSaverForFailedTasks [taskExecutor-18]: title before abbreviate and replace: Database Purging_An error has occurred while performing revision purge operation. Incident Id: f56e158e-4aeb-4b6c-8cfa-8ec54eb0d027`  
  `
  [DATE TIME] INFO dleserver.utils.LogSaverForFailedTasks [taskExecutor-18]: running command: $MDS_FWDIR/scripts/save_logs_when_task_fails.sh 10 Database_Purging_An_error_has_occurred_while_performing_revision_purge_operation__Incident_Id__f56e158e_4aeb_4b6c_8cfa_8ec54eb0d027 false NO_DOMAIN Other`

## Solution

This problem was fixed. The fix is included in:

* [Check Point R80.40](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk160736)
* [Jumbo Hotfix Accumulator for R80.30](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk153152) since Take 135
* [Jumbo Hotfix Accumulator for R80.20](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk137592) since Take 127
* [Jumbo Hotfix Accumulator for R80.10](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk116380) since Take 259

For **other [supported](http://www.checkpoint.com/support-services/support-life-cycle-policy/index.html) versions** , Check Point can supply a **Hotfix** . [Contact Check Point Support](https://www.checkpoint.com/support-services/contact-support/) to get a Hotfix for this issue.  
A Support Engineer will make sure the Hotfix is compatible with your environment before providing the Hotfix.  
For faster resolution and verification, please collect [CPinfo files](http://supportcontent.checkpoint.com/solutions?id=sk92739) from the Security Management Server and Security Gateways involved in the case.

---

# 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