My Oracle Support Banner

OBIEE 11g: Usage Tracking not Started due to Non-existent Usage Tracking Table (Doc ID 2139634.1)

Last updated on MARCH 19, 2018

Applies to:

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


Usage Tracking has been set up, however Usage Tracking data does not gather in S_NQ_ACCT when executing analysis.

The following error is logged in nqserver.log when starting Oracle BI Server.

[2016-04-15T14:09:39.000+09:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: fd8] nqsserver: Clustered Oracle BI Server (64-bit) started. Version:
[2016-04-15T14:09:42.000+09:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 00iZlLDGzNlFw00Fzzw0w00001ss00001t,0] [tid: 9f8] [43071] A connection with Cluster Controller hostname:9706 was established.
[2016-04-15T14:13:43.000+09:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 85f3dbd87ca210f8:14dd3b4f:154175ca137:-8000-0000000000003a5d,0:1:53] [tid: 1bfc] [59049] Usage Tracking not started due to non-existent Usage Tracking table "Usage Tracking"."DEV_BIPLATFORM"."S_NQ_ACCT".


To view full details, 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 a vibrant support community of peers and Oracle experts.