Skip to Content
author's profile photo Former Member
Former Member

Is there a way to know what report is being processed ?

In XI R2 / Webi Report Server, or XI 3.x / Webi Processing Server, is there a way to know what object is being processed ?

For example currently, I can see thru system tool like "Process Explorer" that "wireportserver.exe" has been using a lot of CPU and increasing memory for several minutes. I feel that a report is too large or complicated, but which one ?

In audit database, I can only see events like "document read", but no "begin of refresh process".

So, do I have to wait for the process to be finished to find a "document refreshed" and know what was going on ?

Moreover, at least in R2, if user cancels his refresh request (by closing his browser for example), of if request takes too much time and reaches timeout, no audit event corresponding to this refresh request will ever be recorded. In this case, I have no information at all about what report was making the report server taking so much CPU and RAM. It has just a "read" event, but so have a lot of other reports having been read during the same period of time.

Ideally, I would just have to select the latest "begin of refresh" events without "end of refresh" to know which report are currently being processed. But unfortunately the first one doesn't exist.

Has anyone an idea to get this information anyway ?

Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jul 26, 2013 at 09:51 AM

    Maybe "begin of sql" and "end of sql" parameters can help you. These two parameters can be found under universe designer>parameters>parameter.

    U can define universe name, reportname, username as a comment line on the sql script which the reports creates.

    for detail:

    http://www.dallasmarks.org/blog/2011/10/tips-and-tricks-identifying-business-objects-queries-using-end_sql/

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 30, 2009 at 01:55 PM

    Hi,

    well for XI 3.x you have the instance manager. But there you could only see running reports which as scheduled and not on- demand reports.

    Hop that helps a bit.

    Regards

    -Seb.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.