Has anyone solved the Data Quality Services Error "Failed to Execute Parallel Process" ?

Question

I checked the DQS Main Log and see the following Information :

1/13/2021 11:26:57 AM|[]|19|ERROR|1964be93-d034-4ce2-822f-face9cd1d7e4|Microsoft.Ssdqs.Core.Flow.FlowExecuter|Flow ended with an application error.
Microsoft.Ssdqs.Core.Context.ResponseException: Failed to execute calibrator, or an error occurred during calibration. ---> System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "B_INDEX_LEXICON_EXTENSION_B_INDEX_LEXICON_FK". The conflict occurred in database "DQS_PROJECTS", table "KnowledgeManagement1000001.B_INDEX_LEXICON_EXTENSION", column 'TERM_ID'.;
The statement has been terminated.;

Answer 1

Hi @Kimbrough, Gerrold ,

The DELETE statement conflicted with the REFERENCE constraint "B_INDEX_LEXICON_EXTENSION_B_INDEX_LEXICON_FK".

Please refer to the following methods and links:
1.We can drop and re-add the constraint with the ON DELETE CASCADE.
2. We can disable constraints on the table. This usually not a great idea as you can end up with a bad data condition if you're messing with data that relates to other tables, but not know the full extent of your schema and it may suit your purposes.

The DELETE statement conflicted with the REFERENCE constraint

Commonly used SQL Server Constraints: FOREIGN KEY, CHECK and DEFAULT

Best Regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.