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

# sk176464 - Global Domain assignment fails with "An internal error has occurred." error

| Property | Value |
|----------|-------|
| Solution ID | sk176464 |
| Date Created | 2021-11-22 |
| Last Modified | 2022-11-23 |
| Technical Level | General |
| Products | Multi-Domain Security Management Server |
| Versions | R81 (EOS), R81.10 (EOS), R81.20 |
| OS | Gaia |

## Symptoms

- * Global Domain assignment fails with "*An internal error has occurred.* " error.   

* cpm debug collected with:  

  `$MDS_FWDIR/scripts/cpm_debug.sh -t Assign_Global_Policy -s DEBUG `  
  `
  $MDS_FWDIR/scripts/cpm_debug.sh -c EclipseLinkExceptionHandler -s DEBUG`   

  contains:   

  `
  bind => [36300 parameters bound] `  
  `
  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 (t1.SOURCEOBJECTCLASSNAME NOT 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.PersistenceException: 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.
  `

## Cause

Postgres supports up to 32,768 parameters.

## Solution

This problem was fixed. The fix is included in:

* [Jumbo Hotfix Accumulator for R81.10](https://sc1.checkpoint.com/documents/Jumbo_HFA/R81.10/Default.htm) starting from Take 55
* [Jumbo Hotfix Accumulator for R81](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk170114) starting from Take 68
* [Jumbo Hotfix Accumulator for R80.40](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk165456) starting from Take 158
* [Jumbo Hotfix Accumulator for R80.30](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk153152) starting from Take 251
* [Jumbo Hotfix Accumulator for R80.20](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk137592) starting from Take 208

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://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=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