OBIEE 11g: S_NQ_DB_ACCT Usage Tracking Table is not Populated (Doc ID 1508006.1)

Last updated on MAY 15, 2017

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.5.0 [1308] to 11.1.1.7.140715 [Release 11g]
Business Intelligence Server Enterprise Edition - Version 11.1.1.5.0 [1308] to 11.1.1.7.140715 [Release 11g]
Information in this document applies to any platform.
Feb 2016

Symptoms

You have configured usage tracking by following chapter 9 of the Oracle® Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition 11g Release 1 (11.1.1) Part Number E10541-05

Usage tracking is writing to the S_NQ_ACCT table, you can see errors in the NQServer log about it not being able to write to the S_NQ_DB_ACCT table.  For example:

[2012-06-04T13:13:00.000+00:00] [OracleBIServerComponent] [ERROR:1] [] [] [ecid: 004kQ_vmFDmA1V05NzXBie0005aV000QWm] [tid: 42f46940] [nQSError: 17011] SQL statement execution failed. [[
[nQSError: 17001] Oracle Error code: 942, message: ORA-00942: table or view does not exist
at OCI call OCIStmtExecute: INSERT INTO S_NQ_DB_ACCT (ID,LOGICAL_QUERY_ID,QUERY_TEXT,QUERY_BLOB,TIME_SEC,ROW_COUNT,START_TS,START_DT,START_HOUR_MIN,END_TS,END_DT,END_HOUR_MIN) VALUES (:

This table exists and you have imported it into the repository.

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