
I have a duplicate detection rule on the primary column of a custom table that just detects exact match. We recently migrated the App and the data to a new environment and once I publish the rule it works but after a few hours the rule just stops working.
I can confirm it initially works as I cannot create a duplicate record as it prompts the record exists. After a while it will allow the creation of a duplicate record with no prompt. Disabling and re-enabling seems to fix it for a few hours.
I have tried the following:
Any help on this will be greatly appreciated.
Hi,
The following situations may cause Duplicate Detection Rule to stop.
1. Duplicate Detection Rules are not solution components, they are automatically unpublished whenever you publish a managed or unmanaged solution involving one of the entities referenced in the rule.
How to stop duplicate detection rules unpublishing in Dynamics CRM / 365 | XRM
2. System resources.
As there is no specific error message, we can't give more help, but you can open a ticket to Microsoft support for further help: