question

KimbroughGerrold-7366 avatar image
0 Votes"
KimbroughGerrold-7366 asked 65206286 commented

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

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Monalv-msft avatar image
1 Vote"
Monalv-msft answered 65206286 commented

Hi @KimbroughGerrold-7366 ,

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.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I tried to drop and create the B_INDEX_LEXICON_EXTENSION_B_INDEX_LEXICON_FK Key adding the on delete cascade using the code below. the key was altered.
But when I try to create a matching Policy I still get the error and when I go back and look at the key its reverted back to its original state without the cascade delete.

How can I fix this?

USE [DQS_PROJECTS]
GO

ALTER TABLE [KnowledgeManagement1000001].[B_INDEX_LEXICON_EXTENSION] DROP CONSTRAINT [B_INDEX_LEXICON_EXTENSION_B_INDEX_LEXICON_FK]
GO

ALTER TABLE [KnowledgeManagement1000001].[B_INDEX_LEXICON_EXTENSION] WITH NOCHECK ADD CONSTRAINT [B_INDEX_LEXICON_EXTENSION_B_INDEX_LEXICON_FK] FOREIGN KEY([TERM_ID])
REFERENCES [KnowledgeManagement1000001].[B_INDEX_LEXICON] ([ID]) On Delete Cascade
GO

ALTER TABLE [KnowledgeManagement1000001].[B_INDEX_LEXICON_EXTENSION] CHECK CONSTRAINT [B_INDEX_LEXICON_EXTENSION_B_INDEX_LEXICON_FK]
GO

0 Votes 0 ·