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

# sk172246 - Security Management upgrade fails on import after using "delete_object.sh" script

| Property | Value |
|----------|-------|
| Solution ID | sk172246 |
| Date Created | 2021-02-28 |
| Last Modified | 2021-03-02 |
| Technical Level | General |
| Products | Security Management Server |
| Versions | R81 (EOS) |
| OS | Gaia |

## Symptoms

- Upgrade of Security Management fails on import with error in $FWDIR/log/CPM.elg, after deleting a Gateway object using the 'delete_object.sh' script:  

`
[DATE TIME] INFO upgrade.ngmImport.ImportTask [taskExecutor-34]: applying upgrade rule class com.checkpoint.management.upgradeRules.GatewayStaticProfilesConfigurationUpgradeRule 
on domain LOCALDOMAIN : 41e821a0-3720-11e3-aa6e-0800200c9fde`  
`
java.lang.ClassCastException: org.domain_name.tao.DataIntegrityViolationException incompatible with com.checkpoint.management.is.exceptions.CpmGeneralException`  
`
at com.checkpoint.management.upgrade.ngmImport.ImportTask.handleStatisticsWhenImportFails(ImportTask.java:892)`  
`
at com.checkpoint.management.upgrade.ngmImport.ImportTask.doImport(ImportTask.java:1568)`  
`
at com.checkpoint.management.upgrade.ngmImport.ImportTask.runTask(ImportTask.java:1885)`  
`
at com.checkpoint.management.upgrade.common.impl.VersionIndependentUnattendedTask.run(VersionIndependentUnattendedTask.java:11)`  
`
at com.checkpoint.management.coresvc.CPRunnable.run(CPRunnable.java:2)`  
`
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1160)`  
`
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635)`  
`
at java.lang.Thread.run(Thread.java:820)`  
`
....`  
`
[DATE TIME] ERROR upgrade.ngmImport.ImportTask [taskExecutor-34]: org.domain_name.tao.DataIntegrityViolationException: Expected single result for object with uid c4c0186c-057c-431d-9576-152173c78a78, got: 0
org.domain_name.tao.DataIntegrityViolationException: Expected single result for object with uid c4c0186c-057c-431d-9576-152173c78a78, got: 0
`

## Cause

Reference objects are still persistent in the tables: "ip_range_internal_search_data" and "gatewaystaticprofilesconfiguration_data".

## Solution

[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](https://supportcenter.checkpoint.com/supportcenter/portal?eventSubmit_doGoviewsolutiondetails=&solutionid=sk92739) files from the Security Management 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).

---

# 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