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

Kimbrough, Gerrold 21 Reputation points
2021-01-13T16:44:53.963+00:00

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.;

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,462 questions
0 comments No comments
{count} votes

Accepted answer
  1. Monalv-MSFT 5,896 Reputation points
    2021-01-14T07:21:18.253+00:00

    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.

    2 people found this answer helpful.

0 additional answers

Sort by: Most helpful