This discussion is archived
11 Replies Latest reply: Mar 31, 2013 10:21 PM by Rupesh Shelar RSS

Usage Tracking: issue

993327 Newbie
Currently Being Moderated
Hi,

I am seeing for long Usage Tracking is not tracking all those reports, who were in Catalog.
I want to know why BI is not able to track those reports.

Some Times we run the report and then we are saving them.
And I am not counting these reports.

So why Usage Tracking is not able to Track all the reports.

NB:
I found that if a report is used as subquery then that report will not be tracked in Usage Tracking


Thanks,
Sunil

Edited by: 990324 on Apr 10, 2013 3:28 AM
  • 1. Re: Usage Tracking: issue
    SaichandVaranasi Guru
    Currently Being Moderated
    Hi Sunil,

    Are you not saving the reports ?


    Thanks,
    saichand
  • 2. Re: Usage Tracking: issue
    998980 Explorer
    Currently Being Moderated
    Are you able to track anything at all? If not check you configuration settings:

    http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/biee/r1013/usage_tracking/usage_tracking.htm
  • 3. Re: Usage Tracking: issue
    993327 Newbie
    Currently Being Moderated
    Hi,

    I am saving my reports and usage tracking is tracking them.
    But Usage Tracking is not tracking 100% all the data.
    Why this is happening.
    Why it is missing some reports and what is the reason behind this issue.

    Thanks,
    Sunil
  • 4. Re: Usage Tracking: issue
    SaichandVaranasi Guru
    Currently Being Moderated
    Hi Sunil,

    Please elaborate a bit whether you are not seeing any report entry or SQL is missing ?
    But Usage Tracking is not tracking 100% all the data.
    Thanks,
    Saichand
  • 5. Re: Usage Tracking: issue
    993327 Newbie
    Currently Being Moderated
    Sometimes there will be no entry for some reports.
    As far as I know, it is a common issue in Usage Tracking.
  • 6. Re: Usage Tracking: issue
    vidyas Explorer
    Currently Being Moderated
    990324 wrote:
    Some Times we run the report and then we are saving them.
    And I am not counting these reports.
    990324 wrote:I am saving my reports and usage tracking is tracking them.
    990324 wrote:Sometimes there will be no entry for some reports.
    As far as I know, it is a common issue in Usage Tracking.
    LoL :) Whats happening here ??
  • 7. Re: Usage Tracking: issue
    998980 Explorer
    Currently Being Moderated
    Do you mean, tracking tracks a report some times but not at other times? Or do you mean tracking tracks some reports but not others?

    Edited by: A. Kumar on Mar 28, 2013 2:42 PM
  • 8. Re: Usage Tracking: issue
    SunilSharma Expert
    Currently Being Moderated
    Usage Tracking is a functionality of BI Server to trace the execution of a Logical SQL in a log database table.

    NqQuery.log file shows Physical SQL Query, logical execution plan where Usage tracking does not have this information.

    Read through this you will some better understanding http://docs.oracle.com/cd/E14571_01/bi.1111/e10541/usage_track.htm#CEGFBCCE

    If you dont run the reports how can you expect the usgae tracking to collect data for all reports or dashboards which are there in.

    Thanks,
    RM
  • 9. Re: Usage Tracking: issue
    Kasyap Explorer
    Currently Being Moderated
    Couple of instances when usage tracking fails to insert records..

    - when query text column size is 1024 characters in database and RPD, and logical sql has more than 1024 characters. In this case increase column size to 4000 characters. Again this may not solve the issue if the logical sql is longer than 4000 characters, there seems to be a bug

    - another instance is if query is not successfully completed and killed with in bi server/presentation layers

    - in general look into NQSServer.log file for any usage tracking insert failures, you need to tweak usage tracking buffer size and interval to perform inserts.

    hope this helps..
  • 10. Re: Usage Tracking: issue
    vidyas Explorer
    Currently Being Moderated
    Lol thats a good copy and paste !!! Keep up the good work :)
  • 11. Re: Usage Tracking: issue
    Rupesh Shelar Explorer
    Currently Being Moderated
    Hi,

    just tell me onething weather catlog reports are from same rpd?if yes then browse the reports then check in the tables,if not then check weather any other report gets tracked


    thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points