My Oracle Support Banner

Unable to Delete a Network Element/Component from a Network System and Save the Design - ORA-02292 Integrity Constraint Violated Errors Against the "ASAP.FK_DE_GL_AS_SE__NS_NS_CO2" and "ASAP.FK_DE_GL_AS_SE__NS_NS_CO" Foreign Keys (Doc ID 2900517.1)

Last updated on MARCH 10, 2023

Applies to:

Oracle Communications MetaSolv Solution - Version 6.3.1 and later
Information in this document applies to any platform.

Symptoms

Unable to save Network System design changes after deleting two Network Elements/Components due to an "ORA-02292: integrity constraint (ASAP.FK_DE_GL_AS_SE__NS_NS_CO2) violated" error. Below is the complete error text details when saving the design.


Error Text

A data-related error occurred. Please use the detail button for more information.

The server encountered the following Exception:
java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint
(ASAP.FK_DE_GL_AS_SE__NS_NS_CO2) violated - child record found
            at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
            at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
            at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
            at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)
            at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268)
            at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
            at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270)
            at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91)
            at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970)
            at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205)
            at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666)
            at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426)
            at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:3756)
            at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3736)
            at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1063)
            at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:170)
            at com.metasolv.jdbc.MSVPreparedStatement.executeUpdate(MSVPreparedStatement.java:98)
            at MetaSolv.persistent.jdbc.JDSC.delete(JDSC.java:328)
            at MetaSolv.persistent.jdbc.JDSC.delete(JDSC.java:270)
            at com.mslv.core.api.internal.netmgmt.design.control.handlers.ModelEventHandler.perform(ModelEventHandler.java:123)
            at com.mslv.core.api.internal.netmgmt.design.control.EventController.handleEvent(EventController.java:61)
            at com.mslv.core.api.internal.netmgmt.delegate.pbpackage.ns.InvProcessNetworkDesign.processDeletes(InvProcessNetworkDesign.java:1079)
            at com.mslv.core.api.internal.netmgmt.delegate.pbpackage.ns.InvProcessNetworkDesign.processRequest(InvProcessNetworkDesign.java:206)
            at com.mslv.core.api.internal.netmgmt.delegate.pbpackage.ns.InvNetworkDesignRoot.process(InvNetworkDesignRoot.java:106)
            at MetaSolv.utilities.powerbuilder.BusinessObject.processRequest(BusinessObject.java:67)
            at com.mslv.webapp.pblistener.PBListener.invokeClass(PBListener.java:640)
            at com.mslv.webapp.pblistener.PBListener.doPost(PBListener.java:431)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
            at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:295)
            at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260)
            at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137)
            at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:353)
            at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:250)
            at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3796)
            at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3763)
            at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:344)
            at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:197)
            at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203)
            at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71)
            at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2451)
            at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2299)
            at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2277)
            at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1710)
            at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1670)
            at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:272)
            at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352)
            at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337)
            at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57)
            at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
            at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:655)
            at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)
            at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)
Caused by: Error : 2292, Position : 0, Sql = DELETE ASAP.NS_NS_COMP where NS_COMP_ID = :1 AND NS_NS_COMP_SEQ = :2 , OriginalSql = DELETE ASAP.NS_NS_COMP where NS_COMP_ID = ? AND NS_NS_COMP_SEQ = ?, Error Msg = ORA-02292: integrity constraint (ASAP.FK_DE_GL_AS_SE__NS_NS_CO2) violated - child record found


            at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)
            ... 52 more


Miscellaneous error: MetaSolv.utilities.powerbuilder.d_netdes_ns_ns_comp.
The server encountered the following Exception: Miscellaneous error: MetaSolv.utilities.powerbuilder.d_netdes_ns_ns_comp.
            at com.mslv.core.global.MSLVException.createMSLVException(MSLVException.java:169)
            at com.mslv.core.global.ErrorHandler.logFatalError(ErrorHandler.java:236)
            at com.mslv.core.global.ErrorHandler.logFatalError(ErrorHandler.java:194)
            at com.mslv.core.api.internal.netmgmt.delegate.pbpackage.ns.InvProcessNetworkDesign.processDeletes(InvProcessNetworkDesign.java:1082)
            at com.mslv.core.api.internal.netmgmt.delegate.pbpackage.ns.InvProcessNetworkDesign.processRequest(InvProcessNetworkDesign.java:206)
            at com.mslv.core.api.internal.netmgmt.delegate.pbpackage.ns.InvNetworkDesignRoot.process(InvNetworkDesignRoot.java:106)
            at MetaSolv.utilities.powerbuilder.BusinessObject.processRequest(BusinessObject.java:67)
            at com.mslv.webapp.pblistener.PBListener.invokeClass(PBListener.java:640)
            at com.mslv.webapp.pblistener.PBListener.doPost(PBListener.java:431)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
            at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:295)
            at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260)
            at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137)
            at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:353)
            at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:250)
            at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3796)
            at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3763)
            at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:344)
            at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:197)
            at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203)
            at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71)
            at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2451)
            at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2299)
            at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2277)
            at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1710)
            at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1670)
            at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:272)
            at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352)
            at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337)
            at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57)
            at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
            at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:655)
            at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)
            at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)

 

The nearly identical integrity constraint (FK_DE_GL_AS_SE__NS_NS_CO versus FK_DE_GL_AS_SE__NS_NS_CO2) below has also been reported when attempting to accomplish the same process of deleting a Network Element/Component from a Network System and saving the design.


Error Text

A data-related error occurred. Please use the detail button for more information.

The server encountered the following Exception:
java.sql.SQLIntegrityConstraintViolationException: ORA-02292: integrity constraint
(ASAP.FK_DE_GL_AS_SE__NS_NS_CO) violated - child record found
            at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509)
            at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461)
            at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104)
            at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)
            at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268)
            at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
            at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270)
            at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91)
            at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:970)
            at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1205)
            at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666)
            at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426)
            at oracle.jdbc.driver.OraclePreparedStatement.executeLargeUpdate(OraclePreparedStatement.java:3756)
            at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3736)
            at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1063)
            at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:170)
            at com.metasolv.jdbc.MSVPreparedStatement.executeUpdate(MSVPreparedStatement.java:98)
            at MetaSolv.persistent.jdbc.JDSC.delete(JDSC.java:328)
            at MetaSolv.persistent.jdbc.JDSC.delete(JDSC.java:270)
            at com.mslv.core.api.internal.netmgmt.design.control.handlers.ModelEventHandler.perform(ModelEventHandler.java:123)
            at com.mslv.core.api.internal.netmgmt.design.control.EventController.handleEvent(EventController.java:61)
            at com.mslv.core.api.internal.netmgmt.delegate.pbpackage.ns.InvProcessNetworkDesign.processDeletes(InvProcessNetworkDesign.java:1083)
            at com.mslv.core.api.internal.netmgmt.delegate.pbpackage.ns.InvProcessNetworkDesign.processRequest(InvProcessNetworkDesign.java:206)
            at com.mslv.core.api.internal.netmgmt.delegate.pbpackage.ns.InvNetworkDesignRoot.process(InvNetworkDesignRoot.java:107)
            at MetaSolv.utilities.powerbuilder.BusinessObject.processRequest(BusinessObject.java:67)
            at com.mslv.webapp.pblistener.PBListener.invokeClass(PBListener.java:640)
            at com.mslv.webapp.pblistener.PBListener.doPost(PBListener.java:431)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
            at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:295)
            at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:260)
            at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137)
            at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:353)
            at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:250)
            at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3799)
            at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3766)
            at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:344)
            at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:197)
            at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203)
            at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71)
            at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2454)
            at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2302)
            at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2280)
            at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1721)
            at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1681)
            at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:272)
            at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352)
            at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337)
            at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57)
            at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
            at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:655)
            at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)
            at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)
Caused by: Error : 2292, Position : 0, Sql = DELETE ASAP.NS_NS_COMP where NS_COMP_ID = :1 AND NS_NS_COMP_SEQ = :2 , OriginalSql = DELETE ASAP.NS_NS_COMP where NS_COMP_ID = ? AND NS_NS_COMP_SEQ = ?, Error Msg = ORA-02292:
integrity constraint (ASAP.FK_DE_GL_AS_SE__NS_NS_CO) violated -child record found


            at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:513)
            ... 52 more


Miscellaneous error: MetaSolv.utilities.powerbuilder.d_netdes_ns_ns_comp.
The server encountered the following Exception: Miscellaneous error: MetaSolv.utilities.powerbuilder.d_netdes_ns_ns_comp.
            at com.mslv.core.global.MSLVException.createMSLVException(MSLVException.java:169)
            at com.mslv.core.global.ErrorHandler.logFatalError(ErrorHandler.java:236)
            at com.mslv.core.global.ErrorHandler.logFatalError(ErrorHandler.java:194)
            at com.mslv.core.api.internal.netmgmt.delegate.pbpackage.ns.InvProcessNetworkDesign.processDeletes(InvProcessNetworkDesign.java:1086)
            at com.mslv.core.api.internal.netmgmt.delegate.pbpackage.ns.InvProcessNetworkDesign.processRequest(InvProcessNetworkDesign.java:206)
            at com.mslv.core.api.internal.netmgmt.delegate.pbpackage.ns.InvNetworkDesignRoot.process(InvNetworkDesignRoot.java:107)
            at MetaSolv.utilities.powerbuilder.BusinessObject.processRequest(BusinessObject.java:67)
            at com.mslv.webapp.pblistener.PBListener.invokeClass(PBListener.java:640)
            at com.mslv.webapp.pblistener.PBListener.doPost(PBListener.java:431)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
            at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:295)
            at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecu rityHelper.java:260)
            at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:137)
            at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:353)
            at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:250)
            at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3799)
            at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3766)
            at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:344)
            at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:197)
            at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:203)
            at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:71)
            at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2454)
            at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2302)
            at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2280)
            at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1721)
            at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1681)
            at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:272)
            at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:352)
            at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:337)
            at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:57)
            at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41)
            at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:655)
            at weblogic.work.ExecuteThread.execute(ExecuteThread.java:420)
            at weblogic.work.ExecuteThread.run(ExecuteThread.java:360)

 

 

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
References


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