This content has been marked as final. Show 3 replies
If you could give any more error messages or information, may be that can help. However, you may want to check the following.
1. The Connection pool has correct entries.
2. The username has write access in the database.
3. You are able to query the database using some other client from BI machine.
4. You can update row count on the usage tracking tables in the .rpd
Hope this helps.
Just keep it only below
PHYSICAL_TABLE_NAME = "usertracking"."dbo"."S_NQ_ACCT" ;
for example oracle default usage tracking setting in NQSconfig.ini file
PHYSICAL_TABLE_NAME = "OBI Usage Tracking"."Catalog"."dbo"."S_NQ_ACCT";
CONNECTION_POOL = "OBI Usage Tracking"."Usage Tracking Writer Connection Pool" ;
For more info refer :