My Oracle Support Banner

OrderDataUpdate Failed ORA-01422: exact fetch returns more than requested number of rows (Doc ID 1500706.1)

Last updated on SEPTEMBER 07, 2018

Applies to:

Oracle Communications Order and Service Management - Version 7.0.3 and later
Information in this document applies to any platform.
*** Currency checked on 11th Nov 2014***

Symptoms

OSM Order information update failed at OSM automation task.The task executes OrderDataUpdate at the task's automation but OrderUpdateException happens.

I also can see the next two logs are always generated when this error happens.

Error stack trace in OSM logs :

com.mslv.oms.compensation.TaskCompensationStartException:
  at com.mslv.oms.compensation.j.b(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
com.mslv.oms.handler.InternalErrorException: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "ORDERMGMT.OM_ROLLBACK_PKG", line 1157
ORA-06512: at "ORDERMGMT.OM_WF_API", line 9605
ORA-06512: at "ORDERMGMT.OM_WF_API", line 9658
ORA-06512: at "ORDERMGMT.OM_WF_API", line 5343
ORA-06512: at "ORDERMGMT.OM_WF_API", line 4312
ORA-06512: at "ORDERMGMT.OM_HANDLER_PKG", line 489
ORA-06512: at line 1
 : ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "ORDERMGMT.OM_ROLLBACK_PKG", line 1157
ORA-06512: at "ORDERMGMT.OM_WF_API", line 9605
ORA-06512: at "ORDERMGMT.OM_WF_API", line 9658
ORA-06512: at "ORDERMGMT.OM_WF_API", line 5343
ORA-06512: at "ORDERMGMT.OM_WF_API", line 4312
ORA-06512: at "ORDERMGMT.OM_HANDLER_PKG", line 489
ORA-06512: at line 1

  at com.mslv.oms.handler.a.processRequest(Unknown Source)
  at com.mslv.oms.compensation.j.b(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
java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "ORDERMGMT.OM_ROLLBACK_PKG", line 1157
ORA-06512: at "ORDERMGMT.OM_WF_API", line 9605
ORA-06512: at "ORDERMGMT.OM_WF_API", line 9658
ORA-06512: at "ORDERMGMT.OM_WF_API", line 5343
ORA-06512: at "ORDERMGMT.OM_WF_API", line 4312
ORA-06512: at "ORDERMGMT.OM_HANDLER_PKG", line 489
ORA-06512: at line 1

  at 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)

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.