SSIS Server Maintenance job fails
For most recent CUs of 2017 SQL the native SSIS Server Maintenance job Fails (for AlwaysOn at least). See notes here.
Manually modifying the proc if executes will fix the error but that isn't something end users should be changing.
Resolution: The cursor deallocate statement on line 175 of proc "ssisdb.internal.cleanupserverretention_window" needs to be moved two lines down.
I've noticed this issue in SQL 2017 CU15 when the number of rows to purge exceed 1K
William A commented
I have encountered this in SQL 2017 CU12
Phil Morrow commented
Error received is: "A cursor with the name 'execution_cursor' does not exist. [SQLSTATE 34000] (Error 16916)"