FN_EIC_REPLACE in MODIFYUSERDATAJSON - Table 'ssminlp.DATASET_VALUES' doesn't exist

[adriencosson]

Hi,

Following the below documentation, I want to replace special characters from existing data in UserImport Job, using MODIFYUSERDATAJSON and leveraging FN_EIC_REPLACE() method :

Reference : Database Functions (saviyntcloud.com)

The query to be run is the below : 

UPDATE NEWUSERDATA a SET a.CUSTOMPROPERTY30 = FN_EIC_REPLACE(a.CUSTOMPROPERTY30,null)

 I update the "REPLACE_MAPPING" dataset to include the update to perform on special characters.

When testing the same in Analytics QUERY, it works as date is transformed from "charles.névès" into "charles.neves" :

However, when running the UserImportJob that contains the above PREPROCESSQUERY, the job fails and gives this error : 

Error in Users Import - Error while processing data: Table 'ssminlp.DATASET_VALUES' doesn't exist

I see this issue was reported here without any working solution :

https://forums.saviynt.com/t5/identity-governance/facing-issue-while-using-database-functions-fn-eic...

Please advise.

[AmitM]

HI @adriencosson , It for us working using below syntax and it used to work before as you have mentioned above and as mentioned in the doc. But we recently migrated to 23.10 and are using below syntax 

"UPDATE NEWUSERDATA SET FIRSTNAME=saviyntv5.FN_EIC_REPLACE(FIRSTNAME,null)",

For you , you need to find out if the function schema is saviyntv5 and append that. Mostly its saviyntv5 so you can give that a try.

Kind Regards,

Amit

If helped, consider ACCEPTING SOLUTION

[nvachhani]

Where can we find function schema? saviyntv5 did not work for us

[AmitM]

you can ask Saviynt via freshdesk , try saviyntaws also meanwhile

[rushikeshvartak]

https://docs.saviyntcloud.com/bundle/EIC-Admin-v2022x/page/Content/Chapter02-Identity-Repository/Dat... 

Schema details you need to contact Support team

[rushikeshvartak]

It seems you have syntax issue in MODIFYUSERDATAJSON  

Please share MODIFYUSERDATAJSON