I have setup a job to cleanup SSISDB with predefined storeprocedure "[SSISDB].[internal].[cleanup_server_retention_window]" but sometimes i get following error. After that i have to do manual cleanup then job runs fine. After couple of weeks i get the same error again.
Executed as user: ##MS_SSISServerCleanupJobLogin##. The DELETE statement conflicted with the REFERENCE constraint "FK_EventMessagecontext_Operations". The conflict occurred in database "SSISDB", table "internal.event_message_context", column 'operation_id'. [SQLSTATE 23000] (Error 547). NOTE: The step was retried the requested number of times (3) without succeeding. The step failed.