Integration Services ‘All Execution Reports’ Loads Forever

Posted on

Question :

I’m using SQL Server 2012 to run my Integration Services (SSIS) package by deploying it to the SSIS catalog.

Then an error happened in my packages, so I went to check what it is by opening:

Reports | All Executions | All Messages

However, it never actually opens and loads forever:

loads forever

And when I tried clicking the refresh button, this error showed up instead:

enter image description here

I don’t have any clue what’s going on, and I don’t remember it ever being like this before, so something (or someone) must have been changing things.

Where should I check on this?

Any advice would be greatly appreciated.

Answer :

It turns out my SSIS package was so ineffective that it heavily consumes memory, causing the sessionID of SSISDB SUSPENDED (figured it out by using sp_who2)

I kill all the problematic suspended sessions, and the SSIS Execution Report works again!

Leave a Reply

Your email address will not be published. Required fields are marked *