After working with OBIEE 11g for some months, I had to work in a project where OBISE 10.1.3.2.1 version where I got the following two errors.
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)
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).
You can also check it in the repository(.rpd), double clicking on Database connection in the physical layer under the Features tab.
Till next time