0

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.

1 Answer 1

0

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!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.