Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Error when running SSISDB Executions Report Expand / Collapse
Posted Friday, November 15, 2013 7:45 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, December 3, 2013 2:11 PM
Points: 54, Visits: 349
Whenever you connect to a database server that is running SQL 2012 integration services, then you right click on SSISDB, choose "Reports, then Standard Reports, then Executions" there is a display of each execution and options to drill down.
There is a particular execution that when I click to see "All Messages" I get a blank screen in SSMS with the following error: "Error: and error occurred during local report processing. --> An error has occurred during report processing. --> Exception of type 'System.OutOfMemoryException' was thrown."

Before I go add more memory to this SQL box, I need to understand how an out of the box, canned SSRS report such as this, which is built into Integration Services could produce this issue?
Post #1514733
Posted Friday, March 6, 2015 5:29 PM


Group: General Forum Members
Last Login: Thursday, October 22, 2015 4:29 PM
Points: 168, Visits: 105
This may be due to Verbose logging being turned on for SSISDB. Right click SSISDB under Integration Services Catalog and select properties. Change Verbose to Basic.
Post #1666397
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse