Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 215 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Enable Usage_Tracking, only Weblogic's user data inserted

DongxiYU
Rank 2 - Community Beginner
NQSConfig.INI
[USAGE_TRACKING]ENABLE = YES; #==============================================================================# Parameters used for writing data to a flat file (i.e. DIRECT_INSERT = NO).## Note that the directory should be relative to the instance directory.# In general, we prefer directo insert to flat files. If you are working in# a cluster, it is strongly recommended you use direct insert. If there is# only one Oracle BI Server instance, then you may use flat file data.# The directory is then assumed relative to the process instance. For# example, "UTData" is resolved to # "$(ORACLE_INSTANCE)/bifoundation/OracleBIServerComponent/<instance_name>/UTDataSTORAGE_DIRECTORY = "<directory path>"; CHECKPOINT_INTERVAL_MINUTES = 5; FILE_ROLLOVER_INTERVAL_MINUTES = 30; CODE_PAGE = "ANSI"; # ANSI, UTF8, 1252, etc.##==============================================================================DIRECT_INSERT = YES; #==============================================================================# Parameters used for inserting data into a table (i.e. DIRECT_INSERT = YES).## Init-Block Tracking Options are commented out and and as a result disabled.# To enable Init-Block Tracking Feature, define the two parameters for# Init-Block, INIT_BLOCK_TABLE_NAME and INIT_BLOCK_CONNECTION_POOL.#PHYSICAL_TABLE_NAME = "DSL_SYSTEM_DB"."Usage_tracking"."S_NQ_ACCT" ;CONNECTION_POOL = "DSL_SYSTEM_DB"."Ora_bidw_connpoll_log"; INIT_BLOCK_TABLE_NAME = "DSL_SYSTEM_DB"."Usage_tracking"."S_NQ_INITBLOCK" ;INIT_BLOCK_CONNECTION_POOL = "DSL_SYSTEM_DB"."Ora_bidw_connpoll_log" ;BUFFER_SIZE = 250 MB; BUFFER_TIME_LIMIT_SECONDS = 5; NUM_INSERT_THREADS = 5; MAX_INSERTS_PER_TRANSACTION = 5; JOBQUEUE_SIZE_PER_INSERT_THREADPOOL_THREAD = 100; # default is 100 while 0 means unlimited.THROW_INSERT_WHEN_JOBQUEUE_FULL = NO; # Default is no.##==============================================================================
Any help is appreciated!
0
Answers
-
Have you put permissions on that init block so that other application roles are forbidden to use it?! First time I ever hear of such a behaviour.
0 -
Can you try a different Connection Pool to test this?
0