and more in a single search tool across platforms. Read the announcement here. |
02/08/2024 08:12 AM
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 :
Please advise.
02/08/2024 08:46 AM - edited 02/08/2024 08:57 AM
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
02/21/2024 10:18 AM
Where can we find function schema? saviyntv5 did not work for us
02/21/2024 10:20 AM
you can ask Saviynt via freshdesk , try saviyntaws also meanwhile
02/21/2024 10:44 AM
Schema details you need to contact Support team
02/08/2024 08:30 PM
It seems you have syntax issue in MODIFYUSERDATAJSON
Please share MODIFYUSERDATAJSON