When Alphabetic Presentation Variable Is Used In Column Formula OBIEE 11g Dashboard Fails With Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P (Doc ID 1635961.1)

Last updated on APRIL 11, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.131017 and later
Oracle Exalytics Software - Version 1.0.0.3.0 and later
Information in this document applies to any platform.
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P

Symptoms

Encountering error when using OBIEE 11.1.1.7.131017 on an Oracle Exalytics (PS3) server and using a dashboard page prompt based on a presentation variable page prompt (Test_Prompt_2).
The Test_Prompt_2 prompt uses a presentation variable (Variab_1) which is just a list of values that a user may select from. The list of values includes values like "1", "2", "3" and "A".

An OBIEE analysis that selects 3 columns (“Var_1", "Tipo_file" and "User") references the variable. The Var_1 column definition is the value of presentation variable “Variab_1” (set by prompt “Test_prompt_2”).
When the dashboard prompt uses the default value of "7", or any other numeric value, the results are successfully displayed (single row). If an alphabetic character (i.e. "A") is selected in the prompt, an error occurs:

Odbc driver returned an error (SQLExecDirectW).
 Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 27005] Unresolved column: "A". (HY000)
SQL Issued: {call NQSGetQueryColumnInfo('SELECT A FROM "MBC"')}
SQL Issued: SELECT A FROM "MBC"

Cause

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