My Oracle Support Banner

ORA-01422 Importing DLR into ASR multiple times cause DD completion to fail (Doc ID 878978.1)

Last updated on DECEMBER 04, 2009

Applies to:

Oracle Communications MetaSolv Solution Module - ASR - Version: 37.0.0 to 38.0.0 - Release: 37.0 to 38.0
Information in this document applies to any platform.
Importing DLR into ASR

Symptoms

Users that had imported external DLRs into ASR multiple times were not able to complete the order, getting a data-related error message:

       java.sql.SQLException: ORA-01422: exact fetch returns more than requested
       number of rows|ORA-06512: at "ASAP.SP_CHANGE_CIRCUIT_STATUS", line
       2446|ORA-06512: at "ASAP.SP_COMPLETE_ASR", line 123|ORA-06512: at
       "ASAP.SP_TASK_COMPLETE", line 185|ORA-06512: at line 1|



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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.