Announcing the Saviynt Knowledge Exchange unifying the Saviynt forums, documentation, training,
and more in a single search tool across platforms. Read the announcement here.

Coarse matching filter is throwing operations not allowed error in duplicate identity management

Padmavathi
Regular Contributor
Regular Contributor

Hi Team,

Admin > Global Configurations > Duplicate Identity Management, we are using the below query under Coarse Matching Filter's as per the document Configuring Intelligence (saviyntcloud.com)

((SOUNDEX(t1.FIRSTNAME)= SOUNDEX(t2.FIRSTNAME) and SOUNDEX(t1.LASTNAME)= SOUNDEX(t2.LASTNAME))) and t1.USERKEY <> t2.USERKEY

We are unable to save the configuration as we are getting the below error pop up.

Padmavathi_0-1712239923060.png

Can anyone help us to solve the issue.

Thanks in advance!

Padmavathi

 

2 REPLIES 2

Saathvik
All-Star
All-Star

@Padmavathi Looks like a bug or soundex function is not supported. Please open a ticket with support


Regards,
Saathvik
If this reply answered your question, please Accept As Solution and give Kudos to help others facing similar issue.

rushikeshvartak
All-Star
All-Star

Please try 

SUBSTRING(t1.FIRSTNAME,1,4) = SUBSTRING(t2.FIRSTNAME,1,4) and SUBSTRING(t1.LASTNAME,1,4) = SUBSTRING(t2.LASTNAME,1,4) and t1.USERKEY <> t2.USERKEY

rushikeshvartak_0-1712254241247.png

 


Regards,
Rushikesh Vartak
If you find the response useful, kindly consider selecting Accept As Solution and clicking on the kudos button.