2 Replies Latest reply: Oct 15, 2012 1:18 AM by 967959 RSS

    OSM Error:unique constraint (OSMORDERMGMT1.XPKOM_AUTOMATION_CTX) violated

    967959
      Hi,

      I am getting this error in OSM log when an order is submitted. I am using OSM 7.0.3.

      <Oct 12, 2012 2:27:21 AM EDT> <Error> <oms> <BEA-000000> <0.0/CommunicationsServicesProvisioningOrderUpdateSITask/do_redo: [ order ID=22757 hist. ID=231260 task mnemonic=CommunicationsServicesProvisioningOrderUpdateSITask] Exception thrown while running Script resource [osmmodel:///CommunicationsProvisioningOrderFulfillmentPIP/1.0.0/resources/InitiateWaitforServiceProvisioningResponse.xqy]; exception location: ; SystemID: module with no systemId; Line#: 119; Column#: -1
      net.sf.saxon.trans.XPathException: Exception in extension function com.mslv.oms.dataaccesslayer.ProxyException: ORA-00001: unique constraint (OSMORDERMGMT1.XPKOM_AUTOMATION_CTX) violated
      ORA-06512: at "OSMORDERMGMT1.OM_AUTOMATION_PKG", line 167
      ORA-01403: no data found
      ORA-06512: at line 1
      Nested Exception: ORA-00001: unique constraint (OSMORDERMGMT1.XPKOM_AUTOMATION_CTX) violated
      ORA-06512: at "OSMORDERMGMT1.OM_AUTOMATION_PKG", line 167
      ORA-01403: no data found
      ORA-06512: at line 1
      Nested Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (OSMORDERMGMT1.XPKOM_AUTOMATION_CTX) violated
      ORA-06512: at "OSMORDERMGMT1.OM_AUTOMATION_PKG", line 167
      ORA-01403: no data found
      ORA-06512: at line 1

      at net.sf.saxon.functions.ExtensionFunctionCall.call(ExtensionFunctionCall.java:368)
      at net.sf.saxon.functions.ExtensionFunctionCall.iterate(ExtensionFunctionCall.java:224)
      at net.sf.saxon.expr.Expression.evaluateItem(Expression.java:352)
      at net.sf.saxon.expr.Expression.process(Expression.java:461)
      at net.sf.saxon.instruct.UserFunction.process(UserFunction.java:374)
      Truncated. see log file for complete stacktrace
      com.mslv.oms.dataaccesslayer.ProxyException: ORA-00001: unique constraint (OSMORDERMGMT1.XPKOM_AUTOMATION_CTX) violated
      ORA-06512: at "OSMORDERMGMT1.OM_AUTOMATION_PKG", line 167
      ORA-01403: no data found
      ORA-06512: at line 1
      Nested Exception: ORA-00001: unique constraint (OSMORDERMGMT1.XPKOM_AUTOMATION_CTX) violated
      ORA-06512: at "OSMORDERMGMT1.OM_AUTOMATION_PKG", line 167
      ORA-01403: no data found
      ORA-06512: at line 1
      Nested Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (OSMORDERMGMT1.XPKOM_AUTOMATION_CTX) violated
      ORA-06512: at "OSMORDERMGMT1.OM_AUTOMATION_PKG", line 167
      ORA-01403: no data found
      ORA-06512: at line 1

      at com.mslv.oms.dataaccesslayer.a.execute(Unknown Source)
      at com.mslv.oms.dataaccesslayer.CallableProxy.execute(Unknown Source)
      at com.mslv.oms.automation.d.a(Unknown Source)
      at com.mslv.oms.automation.d.add(Unknown Source)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      Truncated. see log file for complete stacktrace
      java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (OSMORDERMGMT1.XPKOM_AUTOMATION_CTX) violated
      ORA-06512: at "OSMORDERMGMT1.OM_AUTOMATION_PKG", line 167
      ORA-01403: no data found
      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


      Could anyone please help me out.

      Thanks,
      Bhanita
        • 1. Re: OSM Error:unique constraint (OSMORDERMGMT1.XPKOM_AUTOMATION_CTX) violated
          pavan reddy - oracle
          I think [osmmodel:///CommunicationsProvisioningOrderFulfillmentPIP/1.0.0/resources/InitiateWaitforServiceProvisioningResponse.xqy"  query is having some problem as it it throwing unique constraint error. Please correct it.                                                                                                                                                                                                                                                                                                                                                                                                                                                           
          • 2. Re: OSM Error:unique constraint (OSMORDERMGMT1.XPKOM_AUTOMATION_CTX) violated
            967959
            Thanks for your reply. It was working fine earlier. From last 1 week I am getting this error.

            Edited by: 964956 on Oct 14, 2012 11:17 PM