Oracle Analytics Cloud and Server

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

Received Response
1
Views
2
Comments
DongxiYU
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!

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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.

  • Joel
    Joel Rank 8 - Analytics Strategist

    Can you try a different Connection Pool to test this?