Hi,

I added a new connection pool in rpd. I am able to view the data from new connection pool after the connection pool was built in the physical layer. After i deployed rpd file, i am only able to view the data from old connection pool in BI Analysis. I got error when i tried to view data from the new connection:

Odbc driver returned an error (SQLExecDirectW).

Error Details

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, "CLINTRIALS"."CLINICAL_STUDY"."STUDY_TYPE" s_1, "CLINTRIALS"."CLINICAL_STUDY"."NCT_ID_COUNT" s_2 FROM "CLINTRIALS" FETCH FIRST 65001 ROWS ONLY

I search on line and find similar question as this

table or view does not exist at OCI call OCIStmtExecute

Does anybody know what the problem is?

Thanks