05/26/2023 04:36 AM
Hi Team,
I am trying to convert special characters using Normalizing the Identity Data Using the User Import Preprocessor. Tried both File import and Directory method(using schema user import method). But when i import the file i get error message
2023-05-26T16:16:27+05:30-ecm-{"log":"26-May-2023 10:46:27.002 WARNING [http-nio-8080-exec-78] groovy.sql.Sql.executeUpdate Failed to execute: UPDATE TEMPNEWUSERS_20054 SET firstname = FN_EIC_REPLACE(firstname,null) because: Table 'ssminlp.DATASET_VALUES' doesn't exist\n","stream":"stderr","time":"2023-05-26T10:46:27.002862511Z"}
and when i use the schema import method it's not able to find the schema file. Can someone help me asap?
05/26/2023 05:43 AM
Hi Sarthak,
The table DATASET_VALUES is not exposed to preprocessor. Hence you see the error.
05/26/2023 06:39 AM
Hi Ashish,
This is my json. is this the correct format?
05/26/2023 06:42 AM
07/28/2023 02:37 PM
Hi @SarthakChawla ,
I am running into the same issue. Were you able to solve the problem? Your syntax looks fine to me...
07/28/2023 03:02 PM
does saviynt default datasets exists ?
07/30/2023 08:25 PM
Please raise a support ticket with ask to use FN Replace function in modifyuserdata json.
08/29/2023 03:32 PM - edited 08/29/2023 03:32 PM
@nimitdave I also have the same issue in 23.8, raised an FD ticket. Does Devops need to do anything to enable this?
08/29/2023 03:55 PM
@shibinvpkvr , according to the information I was provided from support, this feature is on track to be fixed/re-released with 23.10