OBIEE 11g Problem with Multiple Connection Pools Under a Single Database in the RPD
Last updated on JANUARY 26, 2016
Applies to:Business Intelligence Interactive Dashboard - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
- You have an RPD with two connection pools under a single database in the physical model.
- The connection details for both connection pools are different, each is connected to a different database on a different machine.
- There are multiple business models and subject areas, linked to that database.
- The reports corresponding to the second connection pools seem to be failing with errors like:
Odbc driver returned an error (SQLExecDirectW).
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 17001] Oracle Error code: 942, message: ORA-00942: table or view does not exist at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. (HY000)
SQL Issued: SELECT 0 s_0, "Test"."COM_APPLICATIONS"."ACTIVE_FLAG" s_1 FROM "Test" FETCH FIRST 65001 ROWS ONLY
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