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

# sk173813 - "IPS update failed on assign" error in SmartConsole during IPS or Application Control update

| Property | Value |
|----------|-------|
| Solution ID | sk173813 |
| Date Created | 2021-10-06 |
| Last Modified | 2024-02-27 |
| Technical Level | General |
| Products | Security Management Server, Multi-Domain Security Management Server |
| Versions | R81.10 (EOS), R81 (EOS), R81 (EOS), R81.10 (EOS) |

## Symptoms

- * "`IPS update failed on assign`" error in SmartConsole during IPS or Application Control update.

* After enabling the "`eclipselinkexceptionhandler`" debug, *$FWDIR/log/cpm.elg* shows lines like these (not the session number):

  `
  ERROR dleserver.internal.EclipseLinkExceptionHandler [taskExecutor-222]: Next Exception : ERROR: Updating record from session 1755 in table objectstoredomain_peerdomains_data with opid 7384549 which was already edited by session 1484`  
  `
  Where: PL/pgSQL function int_update_object_objectstoredomain_peerdomains(objectstoredomain_peerdomains_data,objectstoredomain_peerdomains_data,text,text) line 56 at RAISE`  
  `
  PL/pgSQL function update_object_objectstoredomain_peerdomains_data() line 43 at assignment`  
  `
  ERROR dleserver.internal.EclipseLinkExceptionHandler [taskExecutor-222]: org.postgresql.util.PSQLException: ERROR: Updating record from session 1755 in table objectstoredomain_peerdomains_data with opid 7384549 which was already edited by session 1484`  
  `
  Where: PL/pgSQL function int_update_object_objectstoredomain_peerdomains(objectstoredomain_peerdomains_data,objectstoredomain_peerdomains_data,text,text) line 56 at RAISE`  
  `
  PL/pgSQL function update_object_objectstoredomain_peerdomains_data() line 43 at assignment`  
  `
  ERROR dleserver.internal.EclipseLinkExceptionHandler [taskExecutor-222]
  `
* Querying the relevant "`dlesession`" from "`objectstoredomain_peerdomains_data`" shows that there is a deleted entry that is being edited as well by the "`dlesession`":

  ```
  
  cpm=# select * from objectstoredomain_peerdomains_data where dlesession=1484;
  -[ RECORD 1 ]-----------+-------------------------------------
  peerdomain              | a0bbbc99-adef-4ef8-bb6d-cebcebcebceb
  version                 | 72
  objectstoredomain_objid | 18189026-8670-4360-a8ea-0116efd49f7d
  opid                    | 7544212
  fromversion             |
  toversion               |
  dlesession              | 1484
  editingsession          | -1
  deleted                 | t
  domainid                | 18189026-8670-4360-a8ea-0116efd49f7d
  -[ RECORD 2 ]-----------+-------------------------------------
  peerdomain              | a0bbbc99-adef-4ef8-bb6d-cebcebcebceb
  version                 | 75
  objectstoredomain_objid | 18189026-8670-4360-a8ea-0116efd49f7d
  opid                    | 7544214
  fromversion             |
  toversion               |
  dlesession              | 1484
  editingsession          | -1
  deleted                 | f
  domainid                | 18189026-8670-4360-a8ea-0116efd49f7d 
  ```

* After discarding the relevant session, and retrying to update IPS/APPI, it fails again, and a new "`dlesession`" is now holding the relevant "`opid`" in "`objectstoredomain_peerdomain_data`".

## Cause

The session of the IPS/APPI update is not being created properly, and it holds the `dlesession` on the objects needed to perform another update.

## Solution

This problem was fixed. The fix is included starting from:

* [Check Point R81.20 (Titan)](https://support.checkpoint.com/results/sk/sk170416)
* [Jumbo Hotfix Accumulator for R81.10](https://sc1.checkpoint.com/documents/Jumbo_HFA/R81.10/Default.htm) starting from Take 79
* [Jumbo Hotfix Accumulator for R81](https://sc1.checkpoint.com/documents/Jumbo_HFA/R81.00/Default.htm) starting from Take 77

If you choose not to upgrade, 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.

**Hotfix installation instructions:**   
Refer to [sk168597 - How to install a Hotfix](https://support.checkpoint.com/results/sk/sk168597).

<br />

---

# 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