OBIEE 11g: ORA Error is Not Logged in the NQSERVER.LOG (Doc ID 2117121.1)

Last updated on AUGUST 01, 2016

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.150120 to 11.1.1.7.160719 [Release 11g]
Information in this document applies to any platform.

Symptoms

ORA Error, such as ORA-12514,ORA-942,ORA-1652, is NOT logged in the nqserver.log once applied Boundle Patch 11.1.1.7150714.

[2016-01-04T15:48:21.000+09:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 005A7m1kyBYFW7a5tNk3yX00057X0000Ol,0:1:1:9:6] [tid: 46b6a940] [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.

In the case of the following versions, ORA error IS logged in the nqserver.log. ($INSTANCE_HOME/diagnostics/logs/OracleBIServerComponent/coreapplication_obis1/nqserver.log)

This problem occurs from version 11.1.1.7.150120.

Changes

 Apply the bundle patch 11.1.1.7.150714.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms