OBIEE 11g - Spontaneous and Transient Failure when Executing Analysis "The requested column"..."does not exist in this table"
Last updated on APRIL 06, 2018
Applies to:Business Intelligence Server Enterprise Edition - Version 126.96.36.199.0 to 188.8.131.52.150714 [Release 11g]
Information in this document applies to any platform.
- Spontaneous and transient failure when executing analysis/report.
- Occasionally, a certain analysis spontaneously becomes unexecutable and displays the error message
- The requested column 20 [or some other number] does not exist in this table.
- Sometimes this phenomenon disappears as spontaneously as it appeared without intervention.
- The error can be overcome manually by purging both the cursor cache and the BI server cache.
- The problem is not database-related; the log tables and files show that no attempt is made to execute a real SQL.
- Once the erroneous state of the analysis is established one can copy the query from the analysis' "advanced" tab to the box in the "Issue SQL" admin page to reproduce the error.
- If then some minor textual changes are applied (e.g. changing a "nulls last" clause to "nulls first") the error goes away - although what part of the SQL it exactly is that has to be changed isn't consistent over time.
- Error Codes
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 59140] The evaluation of the index 19 expression on row count -1 failed. [nQSError: 59015] The requested column 20 does not exist in this table. (HY000)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms