Oracle Analytics and AI

3249392

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

Andrew Fomin.

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