10 Replies Latest reply on Mar 18, 2016 3:57 PM by Christian Berg

    Usage Tracking Table Does Not Populate

    dileraco

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