5 Replies Latest reply on Aug 14, 2015 6:32 PM by rmoff

    Usage tracking started but no data being inserted into the S_NQ_ACCT table

    2812186

      Hello Gurus,

       

      We have a weird issue in couple of OBIEE instances(11.1.1.7.150120).

       

      We enabled usage tracking from EM and we could see that it is started

       

      From NQServer.log: [2015-08-13T17:25:54.000-07:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: 8020a30b3665b7f8:-74b71047:14f29708fde:-8000-0000000000001344,0:1:18] [tid: a2952700]  [59055] Usage Tracking started.

       

      When the users login there is no data being inserted into the table S_NQ_ACCT.

       

      Settings from NQSConfig.INI:


      [USAGE_TRACKING]

       

       

      ENABLE = YES;  # This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control

       

       

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

      # 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>/UTData

      STORAGE_DIRECTORY = "<directory path>";

      CHECKPOINT_INTERVAL_MINUTES = 5;

      FILE_ROLLOVER_INTERVAL_MINUTES = 30;

      CODE_PAGE = "ANSI";  # ANSI, UTF8, 1252, etc.

      #

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

       

       

      DIRECT_INSERT = YES;  # This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control

       

       

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

      #  Parameters used for inserting data into a table (i.e. DIRECT_INSERT = YES).

      #

      BUFFER_SIZE = 250 MB;

      BUFFER_TIME_LIMIT_SECONDS = 5;

      NUM_INSERT_THREADS = 5;

      MAX_INSERTS_PER_TRANSACTION = 1;

      #

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

       

       

      SUMMARY_STATISTICS_LOGGING = NO;  # This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control

      SUMMARY_ADVISOR_TABLE_NAME = "<Database>"."<Catalog>"."<Schema>"."<Table>";  # Or "<Database>"."<Schema>"."<Table>" ; - This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control

      PHYSICAL_TABLE_NAME = "APCC Usage Tracking"."APCC Usage Tracking Schema"."S_NQ_ACCT";  # This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control

      CONNECTION_POOL = "APCC Usage Tracking"."APCC_Usage_Tracking";  # This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control

       

       

      Appreciate your help.

       

      Thanks,
      Anil