Saturday, January 12, 2013

OBIEE 11g - table or view does not exist/invalid number Errors


Error 1:
A general error has occurred. [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)
Error2:
A general error has occurred. [nQSError: 17001] Oracle Error code: 1722, message: ORA-01722: ORA-01722: invalid number at OCI call OCIStmtExecute:[nQSError: 17011] SQL statement execution failed. (HY000)

Since I was the new to the project I had to check if the table exist in the database and if the connection was well in rpd and all. Finally I fixed both the errors changing the PERF_PREFER_INTERNAL_STITCH_JOIN to Yes in DBFeatures.INI file under the DATA_SOURCE_FEATURE = ORACLE_10g_R2 (because my database Oracle 10gR2).