Search code examples
sql-serverssisreportetlexecution

SSIS "Execution Report" error - 'Report invalid' -- intermittently comes up in SSMS - cause?


seems like every time in a blue moon, there will be a week straight where I can't view Execution reports for SSIS packages running in SQL Server. I will get a cryptic error message about:

The definition of the report is invalid

Here is a picture:

enter image description here

Assuming I can't figure out this cryptic error (maybe you can) -- what steps do I need to go through to ensure I can view Execution Reports for SSIS jobs? I have separate custom logging --- it's more for a "live look" of some running jobs. Thanks!


Solution

  • I was just having this very issue. The solution that worked for me was closing all SSMS windows and restarting Management Studios. I spent a few days failing to find a solution to the issue online before restarting the application so I hope this will save someone else that time.