0 Replies Latest reply: Jun 19, 2013 4:15 PM by 978726 RSS

    OSM Order Cancel

    978726

      we are trying to cancel an Order from OSM task client .

      The compensation strategy for all tasks at the moment is set as "Do Nothing" (we want do add undo action later ) at cancel .

      The order gets cancelled after few tasks are progressed in Order but beyond a point it gives an exception as below.

      any pointers will be of great help .

      --->CEOS-Emulator: Validation Failed - OSM Order ID: 1887 - OSM Task: ADD_CEOS_OffnetServiceRequest

      --->CEOS-Emulator: created dir: ./messages_emulators/ppp051_ALL_000/1887/CEOS/ADD_CEOS_OffnetServiceRequest

      --->CEOS-Emulator: Validation Process Completed - OSM Order ID: 1887 - OSM Task: ADD_CEOS_OffnetServiceRequest

      <17-Jun-2013 6:28:46,243 BST AM> <INFO> <datanetworking-osm-provisioning-add.ADD_XNG_CreateCircuitShellResponse> <ExecuteThread: '14' for queue: 'oms.automation'> <Creating automation plugin [class oracle.communications.ordermanagement.automation.plugin.XQueryReceiver] jndi[ADD_XNG_CreateCircuitShellResponse.automatedtask.datanetworking-osm-provisioning-add.ADD_XNG_CreateCircuitShellResponse] built using SDK version [7.0.3.1020]>

      <17-Jun-2013 6:28:46,443 BST AM> <INFO> <datanetworking-osm-provisioning-add.ADD_XNG_CreateCircuitShellResponse> <ExecuteThread: '14' for queue: 'oms.automation'> <==== Task: ADD_XNG_CreateCircuitShell>

      <17-Jun-2013 6:28:46,444 BST AM> <INFO> <datanetworking-osm-provisioning-add.ADD_XNG_CreateCircuitShellResponse> <ExecuteThread: '14' for queue: 'oms.automation'> <==== XQuery: CreateCircuitShellResponse.xqy>

      <17-Jun-2013 6:28:46,444 BST AM> <INFO> <datanetworking-osm-provisioning-add.ADD_XNG_CreateCircuitShellResponse> <ExecuteThread: '14' for queue: 'oms.automation'> <==== OSM Order: 1887>

      <17-Jun-2013 6:28:46,445 BST AM> <INFO> <datanetworking-osm-provisioning-add.ADD_XNG_CreateCircuitShellResponse> <ExecuteThread: '14' for queue: 'oms.automation'> <==== Siebel Order: ppp051_ALL_000>

      <17-Jun-2013 6:28:46,446 BST AM> <INFO> <datanetworking-osm-provisioning-add.ADD_XNG_CreateCircuitShellResponse> <ExecuteThread: '14' for queue: 'oms.automation'> <==== XML:>

      <17-Jun-2013 6:28:46,447 BST AM> <INFO> <datanetworking-osm-provisioning-add.ADD_XNG_CreateCircuitShellResponse> <ExecuteThread: '14' for queue: 'oms.automation'> <<xng:createCircuitShellResponse xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

                                      xmlns:cse="http://www.colt.net/xml/ns/cse/v1"

                                      xmlns:xng="http://www.colt.net/xng/messages/v1"

                                      xsi:schemaLocation="http://www.colt.net/xng/messages/v1 file:/C:/Documents%20and%20Settings/ilittle/My%20Documents/COLT2/namit/XNG_XML_Messages_v1.2.xsd">

          <transactionID>104872</transactionID>

          <orderNumber>orderNumber0</orderNumber>

          <responseStatus>Success</responseStatus>

          <circuitIDInfo>

              <uimServiceID>300</uimServiceID>

              <circuitID>1887</circuitID>

          </circuitIDInfo>

          <circuitIDInfo>

              <uimServiceID>uimServiceID1</uimServiceID>

              <circuitID>0</circuitID>

          </circuitIDInfo>

          <circuitIDInfo>

              <uimServiceID>uimServiceID2</uimServiceID>

              <circuitID>1</circuitID>

          </circuitIDInfo>

      </xng:createCircuitShellResponse>>

      <17-Jun-2013 6:28:46,448 BST AM> <INFO> <datanetworking-osm-provisioning-add.ADD_XNG_CreateCircuitShellResponse> <ExecuteThread: '14' for queue: 'oms.automation'> <>

      <17-Jun-2013 6:28:46,448 BST AM> <INFO> <datanetworking-osm-provisioning-add.ADD_XNG_CreateCircuitShellResponse> <ExecuteThread: '14' for queue: 'oms.automation'> <>

      <17-Jun-2013 6:28:46,448 BST AM> <INFO> <datanetworking-osm-provisioning-add.ADD_XNG_CreateCircuitShellResponse> <ExecuteThread: '14' for queue: 'oms.automation'> <CREATE CIRCUIT SHELL RESPONSE ---Running--- >

      <17-Jun-2013 6:28:46,450 BST AM> <INFO> <datanetworking-osm-provisioning-add.ADD_XNG_CreateCircuitShellResponse> <ExecuteThread: '14' for queue: 'oms.automation'> <CREATE CIRCUIT SHELL RESPONSE ----Failure--- >

      <17-Jun-2013 6:28:55,526 BST AM> <INFO> <datanetworking-osm-provisioning-add.ADD_CEOS_OffnetServiceResponse> <ExecuteThread: '14' for queue: 'oms.automation'> <Creating automation plugin [class oracle.communications.ordermanagement.automation.plugin.XQueryReceiver] jndi[ADD_CEOS_OffnetServiceResponse.automatedtask.datanetworking-osm-provisioning-add.ADD_CEOS_OffnetServiceResponse] built using SDK version [7.0.3.1020]>

      <17-Jun-2013 6:28:55,563 BST AM> <INFO> <datanetworking-osm-provisioning-add.ADD_CEOS_OffnetServiceResponse> <ExecuteThread: '14' for queue: 'oms.automation'> <==== Task: ADD_CEOS_OffnetServiceRequest>

      <17-Jun-2013 6:28:55,563 BST AM> <INFO> <datanetworking-osm-provisioning-add.ADD_CEOS_OffnetServiceResponse> <ExecuteThread: '14' for queue: 'oms.automation'> <==== XQuery: CEOSResponseReceiver.xquery>

      <17-Jun-2013 6:28:55,564 BST AM> <INFO> <datanetworking-osm-provisioning-add.ADD_CEOS_OffnetServiceResponse> <ExecuteThread: '14' for queue: 'oms.automation'> <==== OSM Order: 1887>

      <17-Jun-2013 6:28:55,564 BST AM> <INFO> <datanetworking-osm-provisioning-add.ADD_CEOS_OffnetServiceResponse> <ExecuteThread: '14' for queue: 'oms.automation'> <==== Siebel Order: ppp051_ALL_000>

      <17-Jun-2013 6:28:55,565 BST AM> <INFO> <datanetworking-osm-provisioning-add.ADD_CEOS_OffnetServiceResponse> <ExecuteThread: '14' for queue: 'oms.automation'> <CEOSResponseReceiver XML:<boc:CreateOffnetTailResponse xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

                                    xmlns:ns1="http://www.colt.net/ bssoss/interfaces/ceos/v1"

                                    xmlns:sts="http://www.colt.net/xml/ns/cbe/cm/v1.0"

                                    xmlns:boc="http://www.colt.net/bssoss/interfaces/ceos/v1"

                                    xmlns:ent="http://www.colt.net/xml/ns/cbe/cdd/v1.9"

                                    xsi:schemaLocation="http://www.colt.net/bssoss/interfaces/ceos/v1 file:/C:/Documents%20and%20Settings/ilittle/My%20Documents/COLT2/HLD%20review/ceosv4.xsd">

          <boc:OSMRequestId>ColtSOM:1.0.0:ADD_CEOS_OffnetServiceRequest:1887:104876</boc:OSMRequestId>

          <boc:CEOSRequestId>18870</boc:CEOSRequestId>

          <boc:requestStatus>SUCCESS</boc:requestStatus>

      </boc:CreateOffnetTailResponse>>

      <17-Jun-2013 6:28:55,566 BST AM> <INFO> <datanetworking-osm-provisioning-add.ADD_CEOS_OffnetServiceResponse> <ExecuteThread: '14' for queue: 'oms.automation'> <Inside offnet response condition ...>

      <17-Jun-2013 6:28:55,567 BST AM> <WARN> <datanetworking-osm-provisioning-add.ADD_CEOS_OffnetServiceResponse> <ExecuteThread: '14' for queue: 'oms.automation'> <completing ADD_CEOS_OffnetServiceRequest with success for order 1887>

      <17-Jun-2013 06:28:55 o'clock BST> <Warning> <oms> <BEA-000000> <datanetworking-osm-provisioning-add.ADD_CEOS_OffnetServiceResponse: completing ADD_CEOS_OffnetServiceRequest with success for order 1887>

      <17-Jun-2013 6:28:56,130 BST AM> <INFO> <datanetworking-osm-provisioning-add.ADD_CEOS_OrderStatusUpdateRequest> <ExecuteThread: '14' for queue: 'oms.automation'> <Creating automation plugin [class oracle.communications.ordermanagement.automation.plugin.XQueryReceiver] jndi[ADD_CEOS_OrderStatusUpdate.automatedtask.datanetworking-osm-provisioning-add.ADD_CEOS_OrderStatusUpdateRequest] built using SDK version [7.0.3.1020]>

      <17-Jun-2013 6:28:56,155 BST AM> <INFO> <datanetworking-osm-provisioning-add.ADD_CEOS_OrderStatusUpdateRequest> <ExecuteThread: '14' for queue: 'oms.automation'> <********** Listening for taskId  ****ADD_CEOS_>

      <17-Jun-2013 6:28:56,155 BST AM> <INFO> <datanetworking-osm-provisioning-add.ADD_CEOS_OrderStatusUpdateRequest> <ExecuteThread: '14' for queue: 'oms.automation'> <********** correlationID:ADD_CEOS_1887104881>

      <17-Jun-2013 6:28:56,155 BST AM> <INFO> <datanetworking-osm-provisioning-add.ADD_CEOS_OrderStatusUpdateRequest> <ExecuteThread: '14' for queue: 'oms.automation'> <==== Task: ADD_CEOS_OrderStatusUpdate>

      <17-Jun-2013 6:28:56,155 BST AM> <INFO> <datanetworking-osm-provisioning-add.ADD_CEOS_OrderStatusUpdateRequest> <ExecuteThread: '14' for queue: 'oms.automation'> <==== XQuery: CEOS_Status_Update_Request.xqy>

      <17-Jun-2013 6:28:56,156 BST AM> <INFO> <datanetworking-osm-provisioning-add.ADD_CEOS_OrderStatusUpdateRequest> <ExecuteThread: '14' for queue: 'oms.automation'> <==== OSM Order: 1887>

      <17-Jun-2013 6:28:56,157 BST AM> <INFO> <datanetworking-osm-provisioning-add.ADD_CEOS_OrderStatusUpdateRequest> <ExecuteThread: '14' for queue: 'oms.automation'> <==== Siebel Order: ppp051_ALL_000>

      <17-Jun-2013 6:29:57,066 BST AM> <INFO> <impl.OrchestrationCascadingLRUPolicy> <Timer-2> <Evicted order /1887 from order cache due to cache entry expiry>

      <17-Jun-2013 6:30:06,330 BST AM> <INFO> <jboss.JBossOrderCacheManager> <ExecuteThread: '14' for queue: 'oms.web'> <Loading order /1887 into order cache.>

      <17-Jun-2013 6:30:09,860 BST AM> <INFO> <jboss.JBossOrderCacheManager> <ExecuteThread: '14' for queue: 'oms.web'> <Loading order /1887 into historical order cache.>

      <17-Jun-2013 6:30:11,120 BST AM> <ERROR> <core.logSQLException> <ExecuteThread: '14' for queue: 'oms.web'> <SQL Exception 1 : ORA-00001: unique constraint (ORDERMGMT.XPKOM_COORD_NODE_INSTANCE) violated

      ORA-06512: at "ORDERMGMT.OM_WF_API", line 8829

      ORA-06512: at "ORDERMGMT.OM_WF_API", line 9382

      ORA-06512: at line 1

      >

      java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ORDERMGMT.XPKOM_COORD_NODE_INSTANCE) violated

      ORA-06512: at "ORDERMGMT.OM_WF_API", line 8829

      ORA-06512: at "ORDERMGMT.OM_WF_API", line 9382

      ORA-06512: at line 1

       

       

              at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:85)

              at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)

              at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)

              at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1035)

              at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:191)

              at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:950)

              at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1224)

              at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3386)

              at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3487)

              at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:3858)

              at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)

              at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)

              at com.mslv.oms.dataaccesslayer.CallableProxy.executeStatement(Unknown Source)

              at com.mslv.oms.dataaccesslayer.AbstractProxy.execute(Unknown Source)

              at com.mslv.oms.compensation.p.a(Unknown Source)

              at com.mslv.oms.compensation.j.a(Unknown Source)

              at com.mslv.oms.compensation.t.a(Unknown Source)

              at com.mslv.oms.handler.order.cache.compensation.c.a(Unknown Source)

              at com.mslv.oms.handler.order.cache.compensation.c.executeIteration(Unknown Source)

              at com.mslv.oms.amendorder.l.a(Unknown Source)

              at com.mslv.oms.amendorder.l.a(Unknown Source)

              at com.mslv.oms.amendorder.l.a(Unknown Source)

              at com.mslv.oms.amendorder.l.a(Unknown Source)

              at com.mslv.oms.handler.cancelorder.CancelOrderHandlerEJB.a(Unknown Source)

              at com.mslv.oms.handler.cancelorder.CancelOrderHandlerEJB.process(Unknown Source)

              at com.mslv.oms.handler.a.processRequest(Unknown Source)

              at com.mslv.oms.jsp.processor.RequestProcessorSupport.a(Unknown Source)

              at com.mslv.oms.jsp.processor.RequestProcessorSupport.processRequest(Unknown Source)

              at com.mslv.oms.jsp.processor.RequestProcessorSupport.processRequest(Unknown Source)

              at com.mslv.oms.jsp.processor.RequestProcessorSupport.a(Unknown Source)

              at com.mslv.oms.jsp.processor.RequestProcessorSupport.a(Unknown Source)

              at com.mslv.oms.jsp.processor.CancelOrderProcessor.processRequest(Unknown Source)

              at com.mslv.oms.jsp.controller.RequestController.a(Unknown Source)

              at com.mslv.oms.jsp.controller.RequestController.processRequest(Unknown Source)

              at com.mslv.oms.jsp.controller.MainServlet.a(Unknown Source)

              at com.mslv.oms.jsp.controller.MainServlet.doProcess(Unknown Source)

              at com.mslv.oms.jsp.controller.MainServlet.doPost(Unknown Source)

              at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

              at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

              at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

              at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)

              at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)

              at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)

              at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

              at oracle.dms.wls.DMSServletFilter.doFilter(DMSServletFilter.java:330)

              at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

              at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.doIt(WebAppServletContext.java:3684)

              at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3650)

              at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

              at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)

              at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2268)

              at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2174)

              at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1446)

              at weblogic.work.ExecuteRequestAdapter.execute(ExecuteRequestAdapter.java:21)

              at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:145)

              at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:117)

      <17-Jun-2013 06:30:11 o'clock BST> <Error> <oms> <BEA-000000> <core.logSQLException: SQL Exception 1 : ORA-00001: unique constraint (ORDERMGMT.XPKOM_COORD_NODE_INSTANCE) violated

      ORA-06512: at "ORDERMGMT.OM_WF_API", line 8829

      ORA-06512: at "ORDERMGMT.OM_WF_API", line 9382

      ORA-06512: at line 1

       

       

      java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ORDERMGMT.XPKOM_COORD_NODE_INSTANCE) violated

      ORA-06512: at "ORDERMGMT.OM_WF_API", line 8829

      ORA-06512: at "ORDERMGMT.OM_WF_API", line 9382

      ORA-06512: at line 1

       

       

              at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:85)

              at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)

              at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)

              Truncated. see log file for complete stacktrace

      >

      <17-Jun-2013 6:30:11,167 BST AM> <ERROR> <core.logOMSException> <ExecuteThread: '14' for queue: 'oms.web'> <An OMS Exception has been thrown. Reason: com.mslv.oms.compensation.TaskCompensationStartException: >

      com.mslv.oms.compensation.TaskCompensationStartException:

              at com.mslv.oms.compensation.p.a(Unknown Source)

              at com.mslv.oms.compensation.j.a(Unknown Source)

              at com.mslv.oms.compensation.t.a(Unknown Source)

              at com.mslv.oms.handler.order.cache.compensation.c.a(Unknown Source)

              at com.mslv.oms.handler.order.cache.compensation.c.executeIteration(Unknown Source)

              at com.mslv.oms.amendorder.l.a(Unknown Source)

              at com.mslv.oms.amendorder.l.a(Unknown Source)

              at com.mslv.oms.amendorder.l.a(Unknown Source)

              at com.mslv.oms.amendorder.l.a(Unknown Source)

              at com.mslv.oms.handler.cancelorder.CancelOrderHandlerEJB.a(Unknown Source)

              at com.mslv.oms.handler.cancelorder.CancelOrderHandlerEJB.process(Unknown Source)

              at com.mslv.oms.handler.a.processRequest(Unknown Source)

              at com.mslv.oms.jsp.processor.RequestProcessorSupport.a(Unknown Source)

              at com.mslv.oms.jsp.processor.RequestProcessorSupport.processRequest(Unknown Source)

              at com.mslv.oms.jsp.processor.RequestProcessorSupport.processRequest(Unknown Source)

              at com.mslv.oms.jsp.processor.RequestProcessorSupport.a(Unknown Source)

              at com.mslv.oms.jsp.processor.RequestProcessorSupport.a(Unknown Source)

              at com.mslv.oms.jsp.processor.CancelOrderProcessor.processRequest(Unknown Source)

              at com.mslv.oms.jsp.controller.RequestController.a(Unknown Source)

              at com.mslv.oms.jsp.controller.RequestController.processRequest(Unknown Source)

              at com.mslv.oms.jsp.controller.MainServlet.a(Unknown Source)

              at com.mslv.oms.jsp.controller.MainServlet.doProcess(Unknown Source)

              at com.mslv.oms.jsp.controller.MainServlet.doPost(Unknown Source)

              at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

              at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

              at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

              at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)

              at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)

              at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)

              at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

              at oracle.dms.wls.DMSServletFilter.doFilter(DMSServletFilter.java:330)

              at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)

              at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.doIt(WebAppServletContext.java:3684)

              at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3650)

              at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

              at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)

              at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2268)

              at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2174)

              at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1446)

              at weblogic.work.ExecuteRequestAdapter.execute(ExecuteRequestAdapter.java:21)

              at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:145)

              at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:117)

      Caused by: com.mslv.oms.dataaccesslayer.ProxyException: ORA-00001: unique constraint (ORDERMGMT.XPKOM_COORD_NODE_INSTANCE) violated

      ORA-06512: at "ORDERMGMT.OM_WF_API", line 8829

      ORA-06512: at "ORDERMGMT.OM_WF_API", line 9382

      ORA-06512: at line 1

      Nested Exception: ORA-00001: unique constraint (ORDERMGMT.XPKOM_COORD_NODE_INSTANCE) violated

      ORA-06512: at "ORDERMGMT.OM_WF_API", line 8829

      ORA-06512: at "ORDERMGMT.OM_WF_API", line 9382

      ORA-06512: at line 1

      Nested Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ORDERMGMT.XPKOM_COORD_NODE_INSTANCE) violated

      ORA-06512: at "ORDERMGMT.OM_WF_API", line 8829

      ORA-06512: at "ORDERMGMT.OM_WF_API", line 9382

      ORA-06512: at line 1

       

       

              at com.mslv.oms.dataaccesslayer.AbstractProxy.execute(Unknown Source)

              ... 42 more

      Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ORDERMGMT.XPKOM_COORD_NODE_INSTANCE) violated

      ORA-06512: at "ORDERMGMT.OM_WF_API", line 8829

      ORA-06512: at "ORDERMGMT.OM_WF_API", line 9382

      ORA-06512: at line 1

       

       

              at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:85)

              at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)

              at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)

              at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1035)

              at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:191)

              at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:950)

              at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1224)

              at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3386)

              at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3487)

              at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:3858)

              at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)

              at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)

              at com.mslv.oms.dataaccesslayer.CallableProxy.executeStatement(Unknown Source)

              ... 43 more

      <17-Jun-2013 06:30:11 o'clock BST> <Error> <oms> <BEA-000000> <core.logOMSException: An OMS Exception has been thrown. Reason: com.mslv.oms.compensation.TaskCompensationStartException:

      com.mslv.oms.compensation.TaskCompensationStartException:

              at com.mslv.oms.compensation.p.a(Unknown Source)

              at com.mslv.oms.compensation.j.a(Unknown Source)

              at com.mslv.oms.compensation.t.a(Unknown Source)

              at com.mslv.oms.handler.order.cache.compensation.c.a(Unknown Source)

              at com.mslv.oms.handler.order.cache.compensation.c.executeIteration(Unknown Source)

              Truncated. see log file for complete stacktrace

       

       

      Caused By: com.mslv.oms.dataaccesslayer.ProxyException: ORA-00001: unique constraint (ORDERMGMT.XPKOM_COORD_NODE_INSTANCE) violated

      ORA-06512: at "ORDERMGMT.OM_WF_API", line 8829

      ORA-06512: at "ORDERMGMT.OM_WF_API", line 9382

      ORA-06512: at line 1

      Nested Exception: ORA-00001: unique constraint (ORDERMGMT.XPKOM_COORD_NODE_INSTANCE) violated

      ORA-06512: at "ORDERMGMT.OM_WF_API", line 8829

      ORA-06512: at "ORDERMGMT.OM_WF_API", line 9382

      ORA-06512: at line 1

      Nested Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ORDERMGMT.XPKOM_COORD_NODE_INSTANCE) violated

      ORA-06512: at "ORDERMGMT.OM_WF_API", line 8829

      ORA-06512: at "ORDERMGMT.OM_WF_API", line 9382

      ORA-06512: at line 1

       

       

              at com.mslv.oms.dataaccesslayer.AbstractProxy.execute(Unknown Source)

              at com.mslv.oms.compensation.p.a(Unknown Source)

              at com.mslv.oms.compensation.j.a(Unknown Source)

              at com.mslv.oms.compensation.t.a(Unknown Source)

              at com.mslv.oms.handler.order.cache.compensation.c.a(Unknown Source)

              Truncated. see log file for complete stacktrace

       

       

      Caused By: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ORDERMGMT.XPKOM_COORD_NODE_INSTANCE) violated

      ORA-06512: at "ORDERMGMT.OM_WF_API", line 8829

      ORA-06512: at "ORDERMGMT.OM_WF_API", line 9382

      ORA-06512: at line 1

       

       

              at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:85)

              at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)

              at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)

              Truncated. see log file for complete stacktrace