Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS history Expand / Collapse
Author
Message
Posted Sunday, November 3, 2013 4:09 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 5:47 PM
Points: 522, Visits: 615
The reports being run by SSRS are not being logged in the ExecutionLog table correctly any more. It used to log every report execution but approx three months ago it stopped logging all reports and now only logs those reports run by scheduled job. I have checked the equivalent non production installation whoch should be configured the same but it works fine. I assume that some miscreant has made a change that has stopped it working, but now I need to find the change and make it go again. I have checked everything that I can think of but have come up blank Can anyone please point me in the right direction?

Cheers,
Blair
Post #1510939
Posted Sunday, November 3, 2013 6:47 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 1:01 PM
Points: 1,166, Visits: 1,191
Blair McKeever (11/3/2013)
The reports being run by SSRS are not being logged in the ExecutionLog table correctly any more. It used to log every report execution but approx three months ago it stopped logging all reports and now only logs those reports run by scheduled job. I have checked the equivalent non production installation whoch should be configured the same but it works fine. I assume that some miscreant has made a change that has stopped it working, but now I need to find the change and make it go again. I have checked everything that I can think of but have come up blank Can anyone please point me in the right direction?

I don't have a 2005 box to check, but take a look at this link: http://technet.microsoft.com/en-us/library/ms159110(v=sql.90).aspx

You can turn report execution logging on or off by selecting options in Report Manager on the Site Settings page. On this page, you can also specify how long you want to keep log entries. By default, this value is 60 days. Entries that exceed this date are removed at 2:00 A.M. every day.

Though when I look at the Site Settings on my SSRS 2008 R2 box, nothing jumps out at me where you'd specify this.

Good luck,
Rob
Post #1510955
Posted Tuesday, November 5, 2013 9:05 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 5:47 PM
Points: 522, Visits: 615
Hi Robert,
Thanks for your reply. After much digging (and cursing) I have found out what is going on. A number of months ago someone migrated SSRS to a new SQL 2008 server (excluding a handful of scheduled reports and my RS history database and scripts). So now the RS history is only reporting on the few scheudled reports left behind and is blissfully ignorant of what's going on on the new server. I need to re-create my RS history setup and point the reports to the new server, but there is now a sizable hole in the history data

Cheers,
Blair
Post #1511706
Posted Tuesday, November 5, 2013 9:07 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 5:47 PM
Points: 522, Visits: 615
Oh yes, this topic can now be closed..
Post #1511707
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse