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

# sk181139 - "unexpected error" when trying to revert a Security Management Database

| Property | Value |
|----------|-------|
| Solution ID | sk181139 |
| Date Created | 2023-08-02 |
| Last Modified | 2023-08-03 |
| Technical Level | Advanced |
| Products | Security Management Server |
| Versions | R81.20, R81.10 (EOS) |
| OS | Gaia |
| Platform | VMWare ESX |

## Symptoms

- * "unexpected error" is received when reverting to a previous database revision on Security Management.

* Similar logs in the file *$FWDIR/log/cpm.elg* :  


  `[DATE TIME],576 ERROR coresvc.internal.RevisionsSvcImpl$RevertToRevisionTask [taskExecutor-7]: `**Revert post procedures phase ended with failure**   

  `
  org.springframework.orm.jpa.JpaSystemException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20140809-296a69f): org.eclipse.persistence.exceptions.DatabaseException`  

  `
  Internal Exception: org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "`**nextsyncnodiff_pkey** `"`  

  `
  Detail: Key (peerid, machine, domainid)=(1f3ab5a3-0cfe-4adf-ae7c-83c9073199d8, 8e684c4b-d483-4e39-816d-979b4ab5c123, 41e821a0-3720-11e3-aa6e-0800200c9fde) already exists.`

## Cause

A corruption in the database.

## Solution

This solution requires authentication. Please log in to view the full solution.

---

# 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
