My Oracle Support Banner

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 later
Information 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 = ?


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


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