java.sql.SQLException: ORA-20503: no current hist_seq_id found for given automation context. ORA-06512: at "ORDERMGMT.OM_AUTOMATION_PKG", line 27 ORA-06512: at "ORDERMGMT.OM_AUTOMATION_PKG", line 88 ORA-06512: at line 1at com.mslv.oms.dataaccesslayer.a.execute(Unknown Source)

Oracle Community | 497652 | 7 years ago
  1. 0

    Exception in OSM 7.0 when XSLT Automator received message from JMS

    Oracle Community | 7 years ago | 497652
    java.sql.SQLException: ORA-20503: no current hist_seq_id found for given automation context. ORA-06512: at "ORDERMGMT.OM_AUTOMATION_PKG", line 27 ORA-06512: at "ORDERMGMT.OM_AUTOMATION_PKG", line 88 ORA-06512: at line 1at com.mslv.oms.dataaccesslayer.a.execute(Unknown Source)
  2. 0

    Automator, JMS , QUEUE, ERROR "No transaction asociated with request"

    Oracle Community | 5 years ago | Lucas Andres Muñoz
    java.sql.SQLException: ORA-01422: la recuperaci¾n exacta devue lve un n•mero mayor de filas que el solicitado ORA-06512: en "ORDERMGMT.OM_AUTOMATION_PKG", lÝnea 53 ORA-06512: en lÝnea 1
  3. 0

    Exception in OSM 7.0 when XSLT Automator received message from JMS

    Oracle Community | 7 years ago | 497652
    java.sql.SQLException: ORA-20503: no current hist_seq_id found for given automation context. ORA-06512: at "ORDERMGMT.OM_AUTOMATION_PKG", line 27 ORA-06512: at "ORDERMGMT.OM_AUTOMATION_PKG", line 88 ORA-06512: at line 1at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    OSM7 COM cartridge with automated task

    Oracle Community | 5 years ago | Bharathi
    java.sql.SQLException: ORA-20006: Workflow thread does not exist. The order may have been moved by another user. Refresh your worklist and try again. order id = 10, hist_seq_id = 33 ORA-06512: at "OSM_DEV_ORDERMGMT.ERROR_MSG", line 8 ORA-06512: at "OSM_DEV_ORDERMGMT.OM_WF_API", line 5043 ORA-06512: at "OSM_DEV_ORDERMGMT.OM_WF_API", line 4225 ORA-06512: at "OSM_DEV_ORDERMGMT.OM_WF_API", line 4269 ORA-06512: at "OSM_DEV_ORDERMGMT.OM_ORD_INST_PKG", line 1019 ORA-06512: at "OSM_DEV_ORDERMGMT.OM_HANDLER_PKG", line 1240 ORA-06512: at "OSM_DEV_ORDERMGMT.OM_HANDLER_PKG", line 1302 ORA-06512: at line 1at com.mslv.oms.dataaccesslayer.a.execute(Unknown Source)
  6. 0

    OSM error while trying to create Xquery sender Receiver in Different Task

    Oracle Community | 6 years ago | 837549
    java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at "ORDERMGMT.OM_AUTOMATION_PKG", line 53 ORA-06512: at line 1at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      ORA-20503: no current hist_seq_id found for given automation context. ORA-06512: at "ORDERMGMT.OM_AUTOMATION_PKG", line 27 ORA-06512: at "ORDERMGMT.OM_AUTOMATION_PKG", line 88 ORA-06512: at line 1at com.mslv.oms.dataaccesslayer.a.execute(Unknown Source)

      at com.mslv.oms.dataaccesslayer.CallableProxy.execute()
    2. com.mslv.oms
      AutomationDispatcherImpl.getClusterRequestContext
      1. com.mslv.oms.dataaccesslayer.CallableProxy.execute(Unknown Source)
      2. com.mslv.oms.automation.plugin.AutomationDispatcherImpl.getClusterRequestContext(Unknown Source)
      2 frames
    3. oracle.communications.ordermanagement
      ClusterMessageHandlerBean.onMessage
      1. oracle.communications.ordermanagement.cluster.message.ClusterMessageHandlerBean.onMessage(Unknown Source)
      1 frame
    4. weblogic.ejb.container
      MDListener.execute
      1. weblogic.ejb.container.internal.MDListener.execute(MDListener.java:466)
      1 frame