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

# sk122412 - Global Domain assignment fails with "An Internal Error has occurred" error

| Property | Value |
|----------|-------|
| Solution ID | sk122412 |
| Date Created | 2018-01-22 |
| Last Modified | 2019-12-17 |
| Technical Level | Advanced |
| Products | Multi-Domain Security Management Server |
| Versions | R82.10, R81.20, R82 |
| OS | Gaia |

## Symptoms

- * `Global Domain Assignment Failed: An internal error has occurred` error on Global policy assignment failure.  

* The `cpm.elg` file shows:  

  `[DATE TIME] ERROR coresvc.internal.InterBeanNotificationSvcImpl [taskExecutor-34]: subscriber com.checkpoint.management.threat.IpsUpdateManager@f67e7824 has thrown an exception (CpmGeneralException{base='com.checkpoint.management.is.exceptions.CpmGeneralException: no stored dle session id found. `  
  `
  HINT: Make sure to propagate dle session id for this thread', errorCode='CP_ERR_UNSPECIFIED', errorFamily='null', messageForUser='null', message='no stored dle session id found. `  
  `
  HINT: Make sure to propagate dle session id for this thread'}) upon receiving notification com.checkpoint.management.coresvc.GlobalDomainAssignmentInternalNotification@425d64a4
  [DATE TIME] ERROR coresvc.internal.InterBeanNotificationSvcImpl [taskExecutor-34]: Notification error: 
  CpmGeneralException{base='com.checkpoint.management.is.exceptions.CpmGeneralException: no stored dle session id found. HINT: Make sure to propagate dle session id for this thread', errorCode='CP_ERR_UNSPECIFIED', errorFamily='null', messageForUser='null', message='no stored dle session id found. `  
  `
  HINT: Make sure to propagate dle session id for this thread'}
  [DATE TIME] ERROR coresvc.internal.GlobalDomainAssignmentSvcImpl [taskExecutor-19]: GlobalDomainAssignmentTask: caught exception.
  CpmGeneralException{base='com.checkpoint.management.is.exceptions.CpmGeneralException: An internal error has occurred.', errorCode='CP_ERR_UNSPECIFIED', errorFamily='null', messageForUser='null', message='An internal error has occurred.'}`  

* The `cpm.elg` file shows:  

  `Query: ReportQuery(name="GetDestObjIdBySourceIdAndFieldPathAndDomainIdAndObjectId" referenceClass=Link sql="SELECT DISTINCT t0.DESTINATIONOBJECTID FROM LINK t0 WHERE (((t0.LINKSCHEMAID IN (SELECT t1.objid FROM LINKSCHEMA t1 WHERE (t1.SOURCEFIELDSPATH IN ?)) AND (t0.SOURCEOBJECTID IN ?)) AND t0.SOURCEOBJECTID IN (SELECT t2.OBJID FROM DLEOBJECTDEREF t2 WHERE (t2.DOMAINID = ?))) AND (t0.DESTINATIONOBJECTID IN ?))"); `  
  `
  nested exception is javax.persistence.Persistence`  
  `
  Exception: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.0.v20140809-296a69f): org.eclipse.persistence.exceptions.DatabaseException
  Internal Exception: org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend.`  
  `
  Error Code: 0`  
  `
  Call: SELECT DISTINCT t0.DESTINATIONOBJECTID FROM LINK t0 WHERE (((t0.LINKSCHEMAID IN (SELECT t1.objid FROM LINKSCHEMA t1 WHERE (t1.SOURCEFIELDSPATH IN (?,?...?))) AND (t0.SOURCEOBJECTID IN (?,?,.........
  `

## Cause

Too many parameters (above MAX_SHORT) are passed to a IN clause in a query.

## 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