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.

Your Answer

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

Browse other questions tagged or ask your own question.