The createEntityByValueRequest XML API causes ORA-00001: unique constraint (ASAP.PK_NA_NET_LOC) error in a high volume threaded environment (Doc ID 1372533.1)

Last updated on NOVEMBER 18, 2011

Applies to:

Oracle Communications MetaSolv Solution - Version: 6.0.16 and later   [Release: 6.0.16 and later ]
Information in this document applies to any platform.

Symptoms

Executing the createEntityByValueRequest XML in a high volume threaded environment causes the following error after approximately 11 locations created:



####<Oct 17, 2011 4:25:35 PM GMT-06:00> <Info> <WLI-Core> <SRJIAWL1.admcablemas.net> <mslv01> <ExecuteThread: '12' for queue: 'weblogic.kernel.Default'> <> <BEA1-01AF0B4C9BEA5609C8D1> <BEA-489044> <ProcessControl invocation failed
com.metasolv.common.MSLVXMLApiException: Exception Thrown importing new service Location.
Message: ORA-00001: unique constraint (ASAP.PK_NA_NET_LOC) violated

at weblogic.rmi.internal.ServerRequest.sendReceive(ServerRequest.java:186)
at weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(ReplicaAwareRemoteRef.java:290)
at weblogic.rmi.cluster.ReplicaAwareRemoteRef.invoke(ReplicaAwareRemoteRef.java:248)
at com.metasolv.ejb.inventory.PSRServiceLocation_6bhe2h_EOImpl_815_WLStub.importNewServiceLocation(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.bea.wlw.runtime.core.control.EJBControlImpl$PrivilegedActionEJBInvoke.run(EJBControlImpl.jcs:911)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:147)
at weblogic.security.Security.runAs(Security.java:61)
at com.bea.wlw.runtime.core.control.EJBControlImpl.invoke(EJBControlImpl.jcs:697)
at com.bea.wlw.runtime.core.dispatcher.DispMethod.invoke(DispMethod.java:377)
at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:433)
at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:406)
at com.bea.wlw.runtime.jcs.container.JcsProxy.invoke(JcsProxy.java:388)
at $Proxy37.importNewServiceLocation(Unknown Source)
at com.metasolv.api.workflow.inventory.CreateEntitySync.pSRServiceLocationEJBImportNewServiceLocation(CreateEntitySync.jpd:153)
at com.metasolv.api.workflow.inventory.CreateEntitySync_wf$ImplControlSend6.invoke(CreateEntitySync_wf.java:54)
at com.bea.wli.bpm.runtime.Perform.execute(Perform.java:32)
at com.bea.wli.bpm.runtime.SyncReceive.messageDelivery(SyncReceive.java:45)
at com.bea.wli.bpm.runtime.Receive.messageDeliveryAction(Receive.java:71)
at com.bea.wli.bpm.runtime.ProcessState.processMessage(ProcessState.java:176)
at com.metasolv.api.workflow.inventory.CreateEntitySync_wf$_ProcessState.processMessage(CreateEntitySync_wf.java:309)
at com.metasolv.api.workflow.inventory.CreateEntitySync_wf.$__createEntityByValueRequest(CreateEntitySync_wf.java:288)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.bea.wlw.runtime.core.dispatcher.DispMethod.invoke(DispMethod.java:371)
at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:433)
at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:406)
at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:249)
at com.bea.wlw.runtime.core.bean.BaseContainerBean.invokeBase(BaseContainerBean.java:224)
at com.bea.wlw.runtime.core.bean.SLSBContainerBean.invoke(SLSBContainerBean.java:109)
at com.bea.wlwgen.CreateEntitySyncSLSBContImpl.createEntityByValueRequest(CreateEntitySyncSLSBContImpl.java:45)
at com.bea.wlwgen.StatelessContainer_79uokr_ELOImpl.createEntityByValueRequest(StatelessContainer_79uokr_ELOImpl.java:369)
at com.bea.wlwgen.CreateEntitySyncSLSBContAdpt.invokeOnBean(CreateEntitySyncSLSBContAdpt.java:69)
at com.bea.wlw.runtime.core.bean.BaseDispatcherBean.runAsInvoke(BaseDispatcherBean.java:153)
at com.bea.wlw.runtime.core.bean.BaseDispatcherBean.invoke(BaseDispatcherBean.java:54)
at com.bea.wlw.runtime.core.bean.SyncDispatcherBean.invoke(SyncDispatcherBean.java:168)
at com.bea.wlw.runtime.core.bean.SyncDispatcher_k1mrl8_EOImpl.invoke(SyncDispatcher_k1mrl8_EOImpl.java:100)
at com.bea.wlw.runtime.core.dispatcher.Dispatcher.remoteDispatch(Dispatcher.java:161)
at com.bea.wlw.runtime.core.dispatcher.ServiceHandleImpl.invoke(ServiceHandleImpl.java:436)
at com.bea.wlw.runtime.core.call.JavaCall.invoke(JavaCall.java:55)
at com.bea.wli.bpm.runtime.SubFlowCall.invoke(SubFlowCall.java:110)
at com.bea.wlw.runtime.core.control.ServiceControlImpl.invoke(ServiceControlImpl.jcs:1288)
at com.bea.control.ProcessControlImpl.invoke(ProcessControlImpl.jcs:442)
at com.bea.wlw.runtime.core.control.ServiceControlImpl.invoke(ServiceControlImpl.jcs:1155)
at com.bea.control.ProcessControlImpl.invoke(ProcessControlImpl.jcs:378)
at com.bea.wlw.runtime.core.dispatcher.DispMethod.invoke(DispMethod.java:377)
at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:433)
at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:406)
at com.bea.wlw.runtime.jcs.container.JcsProxy.invoke(JcsProxy.java:388)
at $Proxy16.createEntityByValueRequest(Unknown Source)
at com.metasolv.api.control.InventoryManagementImpl.createEntityByValueRequest(InventoryManagementImpl.jcs:147)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.bea.wlw.runtime.core.dispatcher.DispMethod.invoke(DispMethod.java:371)
at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:433)
at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:406)
at com.bea.wlw.runtime.jcs.container.JcsProxy.invoke(JcsProxy.java:381)
at $Proxy11.createEntityByValueRequest(Unknown Source)
at createServLoc.CreateServiceLocation.createServiceLocation(CreateServiceLocation.jpd:838)
at createServLoc.CreateServiceLocation_wf$ImplPerform22.invoke(CreateServiceLocation_wf.java:160)
at com.bea.wli.bpm.runtime.Perform.execute(Perform.java:32)
at com.bea.wli.bpm.runtime.Receive.messageDelivery(Receive.java:91)
at com.bea.wli.bpm.runtime.Receive.messageDeliveryAction(Receive.java:71)
at com.bea.wli.bpm.runtime.ProcessState.processMessage(ProcessState.java:176)
at createServLoc.CreateServiceLocation_wf$_ProcessState.processMessage(CreateServiceLocation_wf.java:635)
at createServLoc.CreateServiceLocation_wf.subscription(CreateServiceLocation_wf.java:615)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.bea.wlw.runtime.core.dispatcher.DispMethod.invoke(DispMethod.java:371)
at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:433)
at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:406)
at com.bea.wlw.runtime.core.container.Invocable.invoke(Invocable.java:249)
at com.bea.wlw.runtime.core.bean.BaseContainerBean.invokeBase(BaseContainerBean.java:224)
at com.bea.wlw.runtime.core.bean.BMPContainerBean.invoke(BMPContainerBean.java:2044)
at com.bea.wli.bpm.runtime.ProcessContainerBean.invoke(ProcessContainerBean.java:228)
at com.bea.wlwgen.CreateServiceLocationBMPContImpl.subscription(CreateServiceLocationBMPContImpl.java:35)
at com.bea.wlwgen.PersistentContainer_qtnoxf_ELOImpl.subscription(PersistentContainer_qtnoxf_ELOImpl.java:45)
at com.bea.wlwgen.CreateServiceLocationBMPContAdpt.invokeOnBean(CreateServiceLocationBMPContAdpt.java:89)
at com.bea.wlw.runtime.core.bean.BaseDispatcherBean.runAsInvoke(BaseDispatcherBean.java:153)
at com.bea.wlw.runtime.core.bean.BaseDispatcherBean.invoke(BaseDispatcherBean.java:54)
at com.bea.wlw.runtime.core.bean.AsyncDispatcherBean.onMessage(AsyncDispatcherBean.java:248)
at weblogic.ejb20.internal.MDListener.execute(MDListener.java:400)
at weblogic.ejb20.internal.MDListener.transactionalOnMessage(MDListener.java:333)
at weblogic.ejb20.internal.MDListener.onMessage(MDListener.java:298)
at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:2686)
at weblogic.jms.client.JMSSession.execute(JMSSession.java:2598)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:224)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:183)
Caused by: java.sql.SQLException: ORA-00001: unique constraint (ASAP.PK_NA_NET_LOC) violated

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:626)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:182)
at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:630)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1081)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2905)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:2977)
at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:147)
at MetaSolv.persistent.jdbc.JDSC.issueUpdate(JDSC.java:621)
at MetaSolv.persistent.jdbc.JDSC.issueInsert(JDSC.java:716)
at com.mslv.core.api.external.PSR.common.conversion.SvcLocJDBCConverter.processNAData(SvcLocJDBCConverter.java:639)
at com.mslv.core.api.external.PSR.common.conversion.SvcLocJDBCConverter.writeSNAData(SvcLocJDBCConverter.java:592)
at com.mslv.core.api.external.PSR.common.conversion.SvcLocJDBCConverter.writeNew(SvcLocJDBCConverter.java:160)
at com.mslv.core.api.external.PSR.modes.WriteNewSvcLocLogic.write(WriteNewSvcLocLogic.java:56)
at com.mslv.core.api.external.PSR.modes.WriteNewSvcLocLogic.writeNewSvcLoc(WriteNewSvcLocLogic.java:48)
at com.metasolv.ejb.inventory.PSRServiceLocationEJB.importNewServiceLocation(PSRServiceLocationEJB.java:135)
at com.metasolv.ejb.inventory.PSRServiceLocation_6bhe2h_EOImpl.importNewServiceLocation(PSRServiceLocation_6bhe2h_EOImpl.java:46)
at com.metasolv.ejb.inventory.PSRServiceLocation_6bhe2h_EOImpl_WLSkel.invoke(Unknown Source)
at weblogic.rmi.internal.ServerRequest.sendReceive(ServerRequest.java:166)
... 97 more

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms