Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 11.1.1.7 Usage Tracking

Received Response
1
Views
1
Comments
3249392
3249392 Rank 1 - Community Starter
edited Aug 13, 2024 6:16PM in Oracle Analytics Cloud and Server

We upgraded obiee 10g to 11g recently. After the upgrade we changed the Connection Pool settings for UsageTracking subject area to point to Dev_BIPlatform schema S_NQ_ACCT table.

And made all the necessary changes in EM. After restarting the services the S_NQ_ACCT table is not populated in the database.

I looked in the nqserver.log I see this message.

[tid: ac195700]  [59049] Usage Tracking not started due to non-existent Usage Tracking table "Datawh1 Usage Tracking"."Usage Tracking Connection Pool"."S_NQ_ACCT".

Thanks

Answers

  • Andrew Fomin.
    Andrew Fomin. Rank 6 - Analytics Lead

    Are you sure that "Datawh1 Usage Tracking"."Usage Tracking Connection Pool"."S_NQ_ACCT" is a correct table name? Not something like "Datawh1 Usage Tracking"."Usage tracking schema"."S_NQ_ACCT"?