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

Usage Tracking Issue:Usage Tracking not started due to non-existent Usage Tracking table

Question
1
Views
0
Comments
joljess
joljess Rank 1 - Community Starter
edited Aug 13, 2024 5:23PM in Oracle Analytics Cloud and Server

Hi Guys，

OBIEE Version: 11.1.1.7.0

MySQL Version: 5.6.20

Physical Layer :

Physical layer.png

MySql Connector and Connection pool are work will, so I can get data from answer.

Answer :

answer select.png

MySql Client:

mysql select.png

NQSConfig.INI:

PHYSICAL_TABLE_NAME = "Usage Tracking"."crc000_log"."s_nq_acct";

CONNECTION_POOL = "Usage Tracking"."UT Connection Pool Mysql";

NQSConfig.PNG

After restart BI System Components, Usage Tracking does not work, and I get this notification from nqserver.log:

[2016-07-27T15:55:03.000+08:00] [OracleBIServerComponent] [NOTIFICATION:1] [] [] [ecid: ab2a18b89175ca7c:3634a1be:1561c15a901:-8000-000000000001e037] [tid: 908ed940]  [59049] Usage Tracking not started due to non-existent Usage Tracking table "Usage Tracking"."crc000_log"."s_nq_acct".


Why the system can not find the table? How to solve this problem?

Any suggestions on the best way to implement this. Please let me know.

Best Regards