Integration Services 'All Execution Reports' Loads Forever

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:

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

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 1

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!