Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

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
2
Views
1
Comments
3249392
3249392 Rank 1 - Community Starter
edited Aug 13, 2024 6:16PM in Oracle Analytics Forum

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 & AI 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"?