Usage Tracking Table Does Not Populate

dilek

Hi,

I try to set usage tracking subject area, so that change the NQSCONFIG.INI file parameters as required. After making changes, restart the bi server. However, table S_NQ_ACCT is still empty   What can be the possible problem here? Can you help me. Thx.

Here it is;

[ USAGE_TRACKING ]

ENABLE = YES;

DIRECT_INSERT = YES;

#==============================================================================

1. Parameters used for inserting data into a table (i.e. DIRECT_INSERT = YES).
   #
   PHYSICAL_TABLE_NAME = "Usage Tracking"."PROD1_BIPLATFORM"."S_NQ_ACCT" ; # Or "<Database>"."<Schema>"."<Table>" ;
   CONNECTION_POOL = "Usage Tracking"."Usage Tracking Connection Pool" ;
   BUFFER_SIZE = 250 MB ;
   BUFFER_TIME_LIMIT_SECONDS = 5 ;
   NUM_INSERT_THREADS = 5 ;
   MAX_INSERTS_PER_TRANSACTION = 1 ;
   #
   #==============================================================================

Thomas Dodds

Here's the configuration document:  https://docs.oracle.com/cd/E28280_01/bi.1111/e10541/usage_track.htm#BIESG3758

It's hard to tell from what you've posted which steps you've followed or not ...

dilek

I've already followed that document and make changes step by step.

[Deleted User]

dileraco wrote:

PHYSICAL_TABLE_NAME = "Usage Tracking"."PROD1_BIPLATFORM"."S_NQ_ACCT"
CONNECTION_POOL = "Usage Tracking"."Usage Tracking Connection Pool" ; 

Are you 100% sure that these are the actual, precise fully-qualified object names in the RPD?

dilek

Here is the repository scr;

Thomas Dodds

Does the user in the connpool have access to write data to those tables?

[Deleted User]

That would have been my next question...

rmoff

Check your nqserver.log - it'll tell you either Usage Tracking started successfully, or give you the error as to why it couldn't.

rmoff

And, how did you update NQSConfig - through the MBeans browser, or manually? If you did the latter and didn't unset it from being centrally managed your changes will have been lost on restart.

dilek

I run the following query. It is inserted, no privilege issue :S

INSERT INTO s_nq_acct

(id, user_name)

VALUES

(1, 'Test');

[Deleted User]

Not you. The BI Server throguh the connection pool. As Robin said the log should contain the error it's throwing.