Retrieving Row Counts in OBIEE 11g Admin Tool Fails with Connection Error: "[nQSError: 17010] SQL statement preparation failed...ORA-00942: table or view does not exist"
(Doc ID 1539270.1)
Last updated on JUNE 28, 2017
Applies to:Oracle Exalytics Software - Version 220.127.116.11.0 and later
Business Intelligence Suite Enterprise Edition - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Checked for currency 28-AUG-2014.
Successfully used Oracle Business Intelligence Enterprise Edition (OBIEE) 11g Admin Tool to import a table and update row counts. When attempting to update row counts another time, it fails with error:
The connection has failed
The NQServer log shows additional errors:
[2013-03-21T13:05:21.000+00:00] [OracleBIServerComponent] [ERROR:1]   [ecid: 004q6pG_^BqDWb45zVs1yW0002^w0046gx] [tid: 43124940] [nQSError: 17010] SQL statement preparation failed. [[
[nQSError: 17001] Oracle Error code: 942, message: ORA-00942: table or view does not exist
at OCI call OCIStmtExecute.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!