OBIEE 11g: S_NQ_DB_ACCT Usage Tracking Table is not Populated
Last updated on MAY 15, 2017
Applies to:Business Intelligence Suite Enterprise Edition - Version 188.8.131.52.0  to 184.108.40.206.140715 [Release 11g]
Business Intelligence Server Enterprise Edition - Version 220.127.116.11.0  to 18.104.22.168.140715 [Release 11g]
Information in this document applies to any platform.
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.
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