OBIEE 11g: After Configuring Usage Tracking on MS SQL Server, Records Are Not Populated in S_NQ_ACCT.QUERY_BLOB Column

(Doc ID 2169602.1)

Last updated on AUGUST 10, 2016

Applies to:

Business Intelligence Suite Enterprise Edition - Version 11.1.1.9.5 and later
Generic Windows

Symptoms

On : 11.1.1.9.5 version, Analytics

Configured and enabled Usage Tracking on MS SQL Server per the documentation


After configure and enable Usage Tracking, S_NQ_ACCT, S_NQ_DB_ACCT, and S_NQ_INITBLOCK tables are populated. But we found that not all records are populated in QUERY_BLOB column in S_NQ_ACCT table. For the empty QUERY_BLOB column, we do see QUERY_TEXT column is always populated.



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