6 Replies Latest reply: Aug 6, 2014 4:58 PM by Christian Berg RSS

    table or view does not exist at OCI call OCIStmtExecute

    seanz

      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