You need to sign in to do that
Don't have an account?
Matching Rule returns too many duplicates but there are none..
Hi,
We are trying to activate the below Mathing Rule in our test environment:
Account: Identity EXACT MatchBlank = FALSE
and we've cleaned up all instances where the Identity field in Account is duplicate, there are none left, or they are blank. Nonetheless, when we try to activate the matching rule, we are still getting the error:
You tried to activate the matching rule Identity No. Matching Rule for identifying duplicate records. However, we can't activate the rule because it defines an unusually large number of records as possible duplicates.
What could be the explanation for this?
Thanks,
David
In my case, I also added the country of origin to the equation, which must always be populated and if not populated can be omit the whole record from the set. In practise it did not change the semantics of the rule, but Salesforce allowed me to completed the acivation and turn on the rule, which is now working well.
All Answers
I found the below document which states that "matching rule activation is blocked when the sum of all sets of 100+ identical match key values exceeds 2% of the number of total match keys." Can you check this once and for reference please find the link to the article below:
>> https://help.salesforce.com/articleView?id=000317265&language=en_US&type=1&mode=1
I hope this helps and in case if it does can you please choose this as the best answer so that it can be used by others in the future.
Regards,
Anutej
In my case, I also added the country of origin to the equation, which must always be populated and if not populated can be omit the whole record from the set. In practise it did not change the semantics of the rule, but Salesforce allowed me to completed the acivation and turn on the rule, which is now working well.