My Oracle Support Banner

OBIEE 11g: Error: "[nQSError: 16015] SQL statement execution failed. [[ [nQSError: 16001] ODBC error state: S0002 code: -204 message: <DB> SQL0204N "SCHEMA.S_NQ_DB_ACCT" is an undefined name." in nQServer.log File (Doc ID 1496325.1)

Last updated on DECEMBER 18, 2019

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.6.2 BP1 and later
Business Intelligence Server Enterprise Edition - Version 11.1.1.6.2 BP1 and later
Information in this document applies to any platform.

Symptoms

You frequently see the following error message in nQServer.log file:

[YYYY-MM-DDTHH:MM:SS.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: <ECID>] [tid: c14] [nQSError: 16015] SQL statement execution failed. [[
[nQSError: 16001] ODBC error state: S0002 code: -204 message: <DB> SQL0204N "SCHEMA.S_NQ_DB_ACCT" is an undefined name. SQLSTATE=42704
.
]]

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.