Data truncation: Data too long for column CUSTOMPROPERTY54

[Suresh1]

Hello All, 

I am facing an issue while importing the data from Workday to Saviynt through a REST connector. Getting an Error-error while processing data:
java.sql.BatchUpdateException: Data truncation: Data too long for column 'CUSTOMPROPERTY54' at row 1.

Unfortunately we have exhausted all other CP's and we only have cp54 available now. 

Logs:

Below is my ImportUserJSON :

{
"connection": "acctAuth",
"url": "URL",
"httpMethod": "GET",
"httpContentType": "application/json",
"httpHeaders": {
"Accept": "application/json",
"Authorization": "${access_token}"
},
"userResponsePath": "Report_Entry",
"colsToPropsMap": {
"username": "Employee_ID~#~char",
"employeeid": "Employee_ID~#~char",
"statuskey": "Active_Status~#~int",
"firstname": "Legal_Name_-_First_Name~#~char",
"lastname": "Legal_Name_-_Last_Name~#~char",
"CUSTOMPROPERTY5": "Address~#~char",
"CITY": "city~#~char",
"CUSTOMPROPERTY8": "Coalition~#~char",
"COMPANYNAME": "Company~#~char",
"COSTCENTER": "Cost_Center~#~char",
"CUSTOMPROPERTY16": "Cost_Center_Code~#~char",
"DISPLAYNAME": "CF_Name_in_General_Display_Format~#~char",
"CUSTOMPROPERTY18": "Email_-_Primary_Home~#~char",
"STARTDATE": "Hire_Date~#~date",
"JOBCODEDESC": "Job_Family~#~char",
"JOBCODE": "Job_Profile_ID~#~char",
"CUSTOMPROPERTY17": "Leave_of_Absence_Flag~#~char",
"CUSTOMPROPERTY45": "Location_Ref_ID~#~char",
"CUSTOMPROPERTY54": "All_Worker_s_Managers_in_Management_Chain~#~char"
}
}

Below is the sample value that we are trying to store in CP54 Basically it is a manager hierarchy attribute.

Tom Waldronw (100463); Ezio Garciamendqz (868181); Scott Baxter (433803); Roger Denis (464377); Alex Vasquez (111799); Miguel Alatorre Cantu (403652); Sergio Murillo Fallas (100627); Maria Romano (616757); Piero Vento (111390)

I would like to know if there is a way that we can trim these value and have something shorter like below or any other way to get this done ?

(100463);(868181);(433803);(464377);(111799);(403652);(100627);(616757);(111390)

Appreciate your help on this.

Regards,

Suresh V.

[CR]

@Suresh1  you can use inline prcoccsers to trim and save data in cp

[Suresh1]

@CR ,Thank you for you reply.

I'm trying that as well, but still getting same error. Could you please confirm, the temp table which gets created while calling modify userdata json is a replica of actual user's table right ? If i check NEWUSERDATA.customproperty60 which means data is temporarily storing in cp60 hence its an issue again with data truncation error.

Correct me if my understanding is wrong here

Regards,

Suresh V.

[rushikeshvartak]

Use any customproperty between 60 to 65 which are longtext in size

{
"connection": "acctAuth",
"url": "URL",
"httpMethod": "GET",
"httpContentType": "application/json",
"httpHeaders": {
"Accept": "application/json",
"Authorization": "${access_token}"
},
"userResponsePath": "Report_Entry",
"colsToPropsMap": {
"username": "Employee_ID~#~char",
"employeeid": "Employee_ID~#~char",
"statuskey": "Active_Status~#~int",
"firstname": "Legal_Name_-_First_Name~#~char",
"lastname": "Legal_Name_-_Last_Name~#~char",
"CUSTOMPROPERTY5": "Address~#~char",
"CITY": "city~#~char",
"CUSTOMPROPERTY8": "Coalition~#~char",
"COMPANYNAME": "Company~#~char",
"COSTCENTER": "Cost_Center~#~char",
"CUSTOMPROPERTY16": "Cost_Center_Code~#~char",
"DISPLAYNAME": "CF_Name_in_General_Display_Format~#~char",
"CUSTOMPROPERTY18": "Email_-_Primary_Home~#~char",
"STARTDATE": "Hire_Date~#~date",
"JOBCODEDESC": "Job_Family~#~char",
"JOBCODE": "Job_Profile_ID~#~char",
"CUSTOMPROPERTY17": "Leave_of_Absence_Flag~#~char",
"CUSTOMPROPERTY45": "Location_Ref_ID~#~char",
"CUSTOMPROPERTY64": "All_Worker_s_Managers_in_Management_Chain~#~char"
}
}

[Suresh1]

Hi @rushikeshvartak ,

I have tried with CP's 60 to 64 but still no luck. 

[CR]

yes, correct you can try above long char cp60 to cp65 value saving also one option 

[SumathiSomala]

@Suresh1 Try with  customproperty 60 to 65 ( longtext )

[Suresh1]

Hi @SumathiSomala  ,

I have tried with CP's 60 to 64 but still no luck.