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)

tip

This is a bug in version 4.1.9 and it's fixed from version 4.3.0beta and beyond.

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

  • OSM7 COM cartridge with automated task
    via by Bharathi,
  • Debug « Middleware Magic
    via by Unknown author,
  • Debug « WebLogic
    via by Unknown author,
  • JDBC « WebLogic
    via by Unknown author,
  • Closed Connection Error on weblogic connection pool
    via by Suneesh Raman-Oracle,
    • 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(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:1034) 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:1223) 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:98) at com.mslv.oms.dataaccesslayer.CallableProxy.executeStatement(Unknown Source) at com.mslv.oms.dataaccesslayer.a.execute(Unknown Source) at com.mslv.oms.dataaccesslayer.CallableProxy.execute(Unknown Source) at com.mslv.oms.automation.plugin.AutomationDispatcherImpl.getClusterRequestContext(Unknown Source) at oracle.communications.ordermanagement.cluster.message.ClusterMessageHandlerBean.onMessage(Unknown Source) at weblogic.ejb.container.internal.MDListener.execute(MDListener.java:466) at weblogic.ejb.container.internal.MDListener.transactionalOnMessage(MDListener.java:371) at weblogic.ejb.container.internal.MDListener.onMessage(MDListener.java:327) at weblogic.jms.client.JMSSession.onMessage(JMSSession.java:4585) at weblogic.jms.client.JMSSession.execute(JMSSession.java:4271) at weblogic.jms.client.JMSSession.executeMessage(JMSSession.java:3747) at weblogic.jms.client.JMSSession.access$000(JMSSession.java:114) at weblogic.jms.client.JMSSession$UseForRunnable.run(JMSSession.java:5096) at weblogic.work.ExecuteRequestAdapter.execute(ExecuteRequestAdapter.java:21) at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:145) at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:117)

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    balintn
    balintn11 times, last one,
    Cafecanudo
    Cafecanudo2 times, last one,
    15 more bugmates