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

# sk176805 - API call "show-packages" with parameter "details-level full" fails with the error "Could not commit JPA transaction"

| Property | Value |
|----------|-------|
| Solution ID | sk176805 |
| Date Created | 2021-12-09 |
| Last Modified | 2022-05-26 |
| Technical Level | General |
| Products | Security Management Server, Multi-Domain Security Management Server |
| Versions | R81.10 (EOS), R81 (EOS), R81 (EOS), R81.10 (EOS) |
| OS | Gaia |

## Symptoms

- * The API call "`show-packages`" with the parameter "`details-level full`" fails with this error:

  "*Runtime error: Could not commit JPA transaction; nested exception is javax.persistence.RollbackException: Transaction rolled back because transaction was set to RollbackOnly.*
* The `$FWDIR/log/cpm.elg` file on the Management Server shows:

  `<DATE> <TIME>,<ID> ERROR management.object_store.ObjectStoreSessionImpl`  
  `
  [qtp503466515-95]: Failed to find all requested objects in database`  
  `
  <DATE> <TIME>,<ID> ERROR management.object_store.ObjectStoreSessionImpl`  
  `
  [qtp503466515-95]: Object with objid <> was requested but not found in database!`
* The `$FWDIR/log/api.elg` file on the Management Server shows:

  `<DATE> <TIME>,<ID> INFO com.checkpoint.management.web_api.core.handler.objects.rulebases.policy_package.v1_1.PolicyPackageReply.getInstallationTargetsOfInstallStatusesSingular:139 [qtp416493051-102] - Getting overview target uid : XXXX failed, will be removed from installStatuses list. failed cause: com.checkpoint.management.web_api_is.exceptions.WebApiObjectNotFoundException`  
  `
  <DATE> <TIME>,<ID> ERROR com.checkpoint.management.web_api.utils.WebApiCommandExceptionUtils.getErrorReply:232 [qtp416493051-102] -org.springframework.transaction.TransactionSystemException: Could not commit JPA transaction; nested exception is javax.persistence.RollbackException: Transaction rolled back because transaction was set to RollbackOnly.`

## Cause

The management database contains some installation statuses for a cluster member that do not exist.

## Solution

This problem was fixed. The fix is included in:

* [Jumbo Hotfix Accumulator for R81.10](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk175186) starting from Take 38
* [Jumbo Hotfix Accumulator for R81](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk170114) starting from Take 60
* [Jumbo Hotfix Accumulator for R80.40](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk165456) starting from Take 150
* [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