I tired the steps as instructed in this question to fix this problem but it did not work.
https://docs.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
