5 Replies Latest reply on Sep 2, 2014 7:46 PM by G. SK

    OBIEE 11g: table or view does not exist at OCI call OCIStmtExecute

    srini9148

      HI,

      I am getting below error at report levele.

      I am able to see data in physical layer(RPD) and this table is available in database and am getting data in database also.

       

      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: 43119] Query Failed:

      [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)

       

       

      Regards,

      Srinivas.