I am installing usage tracking in OBIEE for that created a database called usertracking using the sample tables provided in OBIEE 10g. everything is fine, but while configuring the NQSConfig.INI (like, PHYSICAL_TABLE_NAME = "usertracking"."dbo"."S_NQ_ACCT" ; where usertracking is the database ) file I am getting the error called : Error 1067 : The process terminated unexpectedly.
Please help me by your precious suggestions.
Edited by: Jagadeesh on Apr 15, 2012 9:55 PM
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.
I can update rowcount in Admin Tool. I m getting this error only when I uncomment this linr in config file.
PHYSICAL_TABLE_NAME = "usertracking"."dbo"."S_NQ_ACCT" ; ; // Or "<Database>"."<Schema>"."<Table>" ;
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 :