OAS5.9: Some Answers Failed with ORA-00904 due to Double Quotation Around Column Names
(Doc ID 2826838.1)
Last updated on MARCH 01, 2022
Applies to:Oracle Analytics Server - Version 5.9.0 and later
Information in this document applies to any platform.
Some answer failed with ORA-00904. It was working in 12c.
View Display Error
Odbc driver returned an error (SQLExecDirectW).
Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 904, message: ORA-00904: "T31449"."Web訪問": invalid identifier at OCI call OCIStmtExecute. (HY000)
State: HY000. Code: 17010. [nQSError: 17010] SQL statement preparation failed. (HY000)
SQL Issued: SELECT 0 s_0, "SH"."SALES2"."PROD_ID" s_1, SUM("SH"."SALES2"."Web訪問") s_2 FROM "SH" FETCH FIRST 5000001 ROWS ONLY
Checked the physical queries in OAS5.9 and OBIEE 12c and found out that certain coumn names are quoted with double quotation in OAS5.9. And that seems to cause the issue.
The issue can be reproducible with the following conditions:
- Japanese is used as part of the column name
- Databse column name and RPD name is not exactly the same
(In this case, upper case character, WEB訪問, is the name of database column, and lower case character, Web訪問, is the name of the column configured in RPD.)
Upgrade to Oracle Analytics Server 5.9 from OBIEE 184.108.40.206.
Changes were implemented as a part of other issues that change the way of handling special characters.
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