Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

Duplicate Detection Rule - Not working

Posted on by 95

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:

  1. I have tried deleting and re-creating the rule.
  2. Re-creating it basing in on the first 20 characters (thats the character limit of this field)

Any help on this will be greatly appreciated.

  • Suggested answer
    Yuri ji Profile Picture
    Yuri ji on at
    RE: Duplicate Detection Rule - Not working

    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.

    (+) Duplicate Detection Rules have stopped working in Version 1612 - Microsoft Dynamics CRM Forum Community Forum

    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:

    https://admin.powerplatform.microsoft.com/support

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans