My Oracle Support Banner

Unable To Delete NI Records After 7.2.4 Upgrade (Doc ID 1930235.1)

Last updated on NOVEMBER 14, 2023

Applies to:

Oracle Communications Network Integrity - Version 7.2.4 and later
Information in this document applies to any platform.

Symptoms


Problem Summary
---------------------------------------------------
Unable to delete NI records after a 7.2.4 upgrade. 

Problem Description
---------------------------------------------------
After upgrading to 7.2.4 results or scans cannot be deleted.

 

Business Impact

----------------------

This issue is stopping the import.  Customer is experiencing an 'OptimisticLockException' when JDBC batching is enabled against an Oracle 11.2.0.3 database using Eclipselink 2.3.2 :

Below are the errors seen during both operations:

While trying to delete the scan:

####<Aug 7, 2014 10:11:20 AM CDT> <Warning> <oracle.communications.integrity.util.CIMTreeCleaner> <orclcentos6> <AdminServer> <ACTIVE ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'> <ni_user> <BEA1-295B57A5CFA2E77A97FF> <38f135493990b4b4:56553192:147ae9b374f:-8000-000000000000afa4> <1407424280862> <BEA-000000> <Exception in deleting result model (Exception: OptimisticLockException)>
####<Aug 7, 2014 10:11:22 AM CDT> <Error> <oracle.communications.integrity.engine> <orclcentos6> <AdminServer> <ACTIVE ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'> <ni_user> <BEA1-295B57A5CFA2E77A97FF> <38f135493990b4b4:56553192:147ae9b374f:-8000-000000000000afa4> <1407424282510> <BEA-000000> <Cannot delete the configuration (Exception: EJBTransactionRolledbackException, Base Exception: OptimisticLockException)>
####<Aug 7, 2014 10:11:27 AM CDT> <Error> <oracle.communications.integrity.configuration.ui.ConfigurationView> <orclcentos6> <AdminServer> <ACTIVE ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'> <ni_user> <38f135493990b4b4:56553192:147ae9b374f:-8000-000000000000afa4> <1407424287383> <BEA-000000> <Error in Delete Configurationoracle.communications.integrity.exceptions.IntegrityException: PROFILE_DELETED_BY_DIFF_USER>

 While trying to delete the result:

####<Aug 7, 2014 10:13:06 AM CDT> <Error> <oracle.communications.integrity.engine> <orclcentos6> <AdminServer> <ACTIVE ExecuteThread: '7' for queue: 'weblogic.kernel.Default (self-tuning)'> <ni_user> <BEA1-299C57A5CFA2E77A97FF> <38f135493990b4b4:56553192:147ae9b374f:-8000-000000000000b046> <1407424386298> <BEA-000000> <Exception while deleting scanruns (Exception: EJBTransactionRolledbackException, Base Exception: OptimisticLockException)>
####<Aug 7, 2014 10:13:06 AM CDT> <Error> <oracle.communications.integrity.scanrun.ScanRunBean> <orclcentos6> <AdminServer> <ACTIVE ExecuteThread: '7' for queue: 'weblogic.kernel.Default (self-tuning)'> <ni_user> <38f135493990b4b4:56553192:147ae9b374f:-8000-000000000000b046> <1407424386327> <BEA-000000> <Error while deleting DisScanRun (Exception: EJBException, Base Exception: OptimisticLockException)>
####<Aug 7, 2014 10:13:30 AM CDT> <Error> <oracle.communications.integrity.engine> <orclcentos6> <AdminServer> <ACTIVE ExecuteThread: '7' for queue: 'weblogic.kernel.Default (self-tuning)'> <ni_user> <BEA1-29A557A5CFA2E77A97FF> <38f135493990b4b4:56553192:147ae9b374f:-8000-000000000000b06e> <1407424410588> <BEA-000000> <Exception while deleting scanruns (Exception: EJBTransactionRolledbackException, Base Exception: OptimisticLockException)>
####<Aug 7, 2014 10:13:30 AM CDT> <Error> <oracle.communications.integrity.scanrun.ScanRunBean> <orclcentos6> <AdminServer> <ACTIVE ExecuteThread: '7' for queue: 'weblogic.kernel.Default (self-tuning)'> <ni_user> <38f135493990b4b4:56553192:147ae9b374f:-8000-000000000000b06e> <1407424410615> <BEA-000000> <Error while deleting DisScanRun (Exception: EJBException, Base Exception: OptimisticLockException)>

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
 Goal
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.