11 Replies Latest reply: Apr 1, 2013 12:21 AM by Rupesh Shelar RSS

    Usage Tracking: issue

    993327
      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
          Hi Sunil,

          Are you not saving the reports ?


          Thanks,
          saichand
          • 2. Re: Usage Tracking: issue
            998980
            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
              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
                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
                  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
                    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
                      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
                        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
                          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
                            Lol thats a good copy and paste !!! Keep up the good work :)
                            • 11. Re: Usage Tracking: issue
                              Rupesh Shelar
                              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