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)

Oracle Community | 837549 | 6 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 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)
  2. 0

    Oracle SOA Suite 11g - Supported Databases??

    Oracle Community | 7 years ago | 737545
    java.sql.SQLException: ORA-06553: PLS-306: wrong number or types of arguments in call to 'EDN_DEQUEUE_OAOO_DELIVERY' + at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
  3. 0

    OSM 7.0: Error in custom plug-in for automation task

    Oracle Community | 6 years ago | user9289038
    java.sql.SQLException: ORA-20004: Starting position for the process is not defined. Call support. process id = 10128. ORA-06512: at "ORDERMGMT.ERROR_MSG", line 8 ORA-06512: at "ORDERMGMT.OM_WF_API", line 2445 ORA-06512: at "ORDERMGMT.OM_WF_API", line 2712 ORA-06512: at "ORDERMGMT.OM_WF_API", line 2882 ORA-06512: at "ORDERMGMT.OM_WF_API", line 10831 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 oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
  6. 0

    Debug « Middleware Magic

    middlewaremagic.com | 2 years ago
    java.sql.SQLException: Closed Connection
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-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)

    at oracle.jdbc.driver.DatabaseError.newSQLException()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.execute
    1. oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
    2. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
    3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    4. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
    5. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
    6. oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:191)
    7. oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:950)
    8. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1223)
    9. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3386)
    10. oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3487)
    11. oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:3858)
    12. oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
    12 frames
  3. weblogic.jdbc.wrapper
    PreparedStatement.execute
    1. weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:98)
    1 frame
  4. com.mslv.oms
    AutomationDispatcherImpl.getClusterRequestContext
    1. com.mslv.oms.dataaccesslayer.CallableProxy.executeStatement(Unknown Source)
    2. com.mslv.oms.dataaccesslayer.a.execute(Unknown Source)
    3. com.mslv.oms.dataaccesslayer.CallableProxy.execute(Unknown Source)
    4. com.mslv.oms.automation.plugin.AutomationDispatcherImpl.getClusterRequestContext(Unknown Source)
    4 frames
  5. oracle.communications.ordermanagement
    ClusterMessageHandlerBean.onMessage
    1. oracle.communications.ordermanagement.cluster.message.ClusterMessageHandlerBean.onMessage(Unknown Source)
    1 frame
  6. weblogic.ejb.container
    MDListener.onMessage
    1. weblogic.ejb.container.internal.MDListener.execute(MDListener.java:466)
    2. weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:371)
    3. weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:327)
    3 frames
  7. weblogic.jms.client
    JMSSession$UseForRunnable.run
    1. weblogic.jms.client.JMSSession.onMessage(JMSSession.java:4585)
    2. weblogic.jms.client.JMSSession.execute(JMSSession.java:4271)
    3. weblogic.jms.client.JMSSession.executeMessage(JMSSession.java:3747)
    4. weblogic.jms.client.JMSSession.access$000(JMSSession.java:114)
    5. weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5096)
    5 frames
  8. weblogic.work
    ExecuteRequestAdapter.execute
    1. weblogic.work.ExecuteRequestAdapter.execute(ExecuteRequestAdapter.java:21)
    1 frame
  9. weblogic.kernel
    ExecuteThread.run
    1. weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:145)
    2. weblogic.kernel.ExecuteThread.run(ExecuteThread.java:117)
    2 frames