3 Replies Latest reply: Apr 16, 2012 12:41 AM by user248025 RSS

    Problem while installing Usage Tracking in OBIEE 10g

    808195
      Hi all,

      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.

      Thanking you,
      Jagadeesha

      Edited by: Jagadeesh on Apr 15, 2012 9:55 PM
        • 1. Re: Problem while installing Usage Tracking in OBIEE 10g
          Dhar
          Hi,

          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.

          Thank you,
          Dhar
          • 2. Re: Problem while installing Usage Tracking in OBIEE 10g
            808195
            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>" ;
            • 3. Re: Problem while installing Usage Tracking in OBIEE 10g
              user248025
              Hi,

              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 :

              http://obiee101.blogspot.com/2008/08/obiee-setting-up-usage-tracking.html

              http://www.obieetalk.com/obiee11g-setting-usage-tracking

              http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/biee/r1013/usage_tracking/usage_tracking.htm

              http://oraclebizint.wordpress.com/2007/08/14/usage-tracking-in-obi-ee/

              Thanks
              Deva