Where to find subscription error log

Question

Post reply

Where to find subscription error log

rakesh_itcvrce

Mr or Mrs. 500

Points: 512
More actions
May 15, 2012 at 4:37 am

#392263

I want to see error log of my scheduled report. Below are the scenarios:
Scenario 1: Let’s consider on 14th May 2012, I have scheduled a report for 16th May 2012.
On 15th May 2012 my password expired. When the report will trigger on 16th it will give some error.
Scenario 2: I have scheduled a daily report. Yesterday my report executed successfully. Today before report schedule time, by mistake one report relevant table is got deleted from database, when report will trigger it will give some error.
In both the scenario error will occur. I want to know where I can see these error and reason of generated errors so that we can resolve the issue asap.

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

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

Suresh B. SSC-Insane Points: 22986 More actions · Answer 1

Try this:

select ItemID from reportserver..catalog

where name = 'Your Report Name'

select top 10 * from reportserver..ExecutionLogStorage

where ReportId = '86501BA5-5343-4669-A54E-F6A129E02BA5'

and Status <> 'rsSuccess'

order by TimeStart desc

Geoff A SSChampion Points: 11511 More actions · Answer 2

or this;

select *

From ReportServer.dbo.Subscriptions Subscriptions

where(LastStatus like '%[1-9] errors.'

or LastStatus like 'Error%'

or LastStatus like 'Failure%')

and LastRunTime >= GetDate() - 2

rakesh_itcvrce Mr or Mrs. 500 Points: 512 More actions · Answer 3

Thanks Suresh B. and Geoff A for the reply.

However unfortunately I didn’t get what I want.

Suresh B. : I have executed both the query, I got results but how to understand what is the reason of report failure?

Geoff A : I have executed the query, it didn’t return any record.

Please let me know if there is another way to know the exact error so that we can directly hit the problem and solve it.

Geoff A SSChampion Points: 11511 More actions · Answer 4

rakesh_itcvrce (5/15/2012)
Thanks Suresh B. and Geoff A for the reply.
However unfortunately I didn’t get what I want.
Suresh B. : I have executed both the query, I got results but how to understand what is the reason of report failure?
Geoff A : I have executed the query, it didn’t return any record.
Please let me know if there is another way to know the exact error so that we can directly hit the problem and solve it.

if my query returned no results, that means you have no subscription errors in the last 2 days.

you may comment out the "and LastRunTime >= GetDate() - 2" to see all errors, or change the "GetDate() - 2" to something like "GetDate() -7" to see errors from the last week.