Post reply

how to find how a long a report ran from Reportmanger

  • February 26, 2010 at 12:46 pm

    #139132

    Hi,

    We have SQL Server 2005 reporting services in Server A & it's databases in Server B. We the ORACLE datasource. i.e the reports bring the data from Oracle database. Last day our oracle database is hung and we came to know that it was the connection coming from Reportserver and there was a report running all day. I know the report name but how can I find how long that report has ran from Report manager?

    thanks

  • February 26, 2010 at 4:04 pm

    #1125863

    Hi,

    I ran the below query to know report which is taking long time to run and I found one report took 40798568 (~11hrs). I did not understand why that report took 11 hrs even though we set the report execution time as 30 mins.

    Limit report execution to the following number of seconds 1800 seconds (30 mins). So after 30 mins, the report should give Timeout error and it should end there.In my case, it's still running and we manually killed that session from oracle end.

    Select name,TimeStart, TimeEnd, TimeDataRetrieval,Timeprocessing,ReportID,TimeRendering, Status, ByteCount FROM ExecutionLog EL

    INNER JOIN Catalog C ON EL.ReportID = C.ItemID

    order by TimeStart desc

    name TimeStartTimeEnd TimeDataRetrieval ReportID TimeRendering Status ByteCount

    RSDraftNumbers2010-02-25 23:34:12.957 2010-02-26 10:54:11.243040798568 74FA563A-8E0C-4FF9-B161-92220 rsInternalError 0

    please help me to find the reason for running a report for 11 hrs.

    thanks

  • February 26, 2010 at 6:00 pm

    #1125880

    name TimeStart TimeEnd TimeDataRetrieval ReportID TimeRendering Status ByteCount

    RSDraftNumbers 2010-02-25 23:34:12.957 2010-02-26 10:54:11.243 0 40798568 74FA563A-8E0C-4FF9-B161-9222 0 rsInternalError 0

    here between time 2010-02-25 23:34:12.957 & 2010-02-26 10:54:11.243 (this is the end time , we killed the ssrs session at Oracle side), where can we check what Internal error was occurred (because the status shows as rsInternalError )

    We got the attached dumpfile in report server logs, when we killed the session at Oracle side.

    thanks

  • February 28, 2010 at 2:20 pm

    #1126315

    Could you please give me some inputs!!

    thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply