Invalid Column Index error completing DD tasks for some ASR, ISR and EWO orders
(Doc ID 1359417.1)
Last updated on MARCH 29, 2019
Applies to:
Oracle Communications MetaSolv Solution - Version 6.0.15 and laterInformation in this document applies to any platform.
Symptoms
When attempting to complete the DD task of an ASR order, the application throws the following error.
Error Text
A database error has occurred. The error message is: Invalid column index
The SQL statement that caused the error is: SELECT sr.type_of_sr FROM serv_req
sr WHERE sr.document_number = ?
The SQL statement that caused the error is: SELECT sr.type_of_sr FROM serv_req
sr WHERE sr.document_number = ?
Error Screenshot
A SQL Spy session shows evidence of two values being passed for the SELECT statement that is failing (CIRCUIT_DESIGN_ID and DOCUMENT_NUMBER).
Changes
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 |
Changes |
Cause |
Solution |
References |