Data Quality Services Error "Failed to Execute Parallel Process" resolution

Question

I tired the steps as instructed in this question to fix this problem but it did not work.
https://learn.microsoft.com/en-us/answers/questions/229512/has-anyone-solved-the-data-quality-services-error.html

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

Answer 1

Hi,

>The DELETE statement conflicted with the REFERENCE constraint "". The conflict occurred in database " ", table "", column "";

This error means that the data you want to delete is referenced by another table (foreign key). Creating foreign key constraints with the on delete cascade should be a solution.

>when I go back and look at the key its reverted back to its original state without the cascade delete.

Do you mean that you modified fk constraint on the table to add the on delete cascade, but this operation seems to be rolled back?

Please apply the latest cumulative update to the SQL Server instance to avoid any possible issue.