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; #============================================================================== * Parameters used for inserting data into a table (i.e. DIRECT_INSERT = YES). # PHYSICAL_TABLE_NAME = "Usage Tracking"."PROD1_BIPLATFORM"."S_NQ_ACCT" ; # Or " "." "." " ; 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 ; # #==============================================================================

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

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;

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

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 ;
#
#==============================================================================

Find more posts tagged with

Accepted answers

All comments

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.