Data truncation: Data too long for column 'CUSTOMPROPERTY1' at row 1

[kolipakularavi]

Hi Every,

When I am performing the Import of accounts(Reconcilation) I am getting the below error

Data truncation: Data too long for column 'CUSTOMPROPERTY1' at row 1.

Please suggest how to handle this?

[DixshantValecha]

Hi @kolipakularavi,

We are checking on your requirement and we will keep you posted.

[DixshantValecha]

Hi @kolipakularavi,

The error message “Data truncation: Data too long for column ‘CUSTOMPROPERTY1’ at row 1 in Saviynt” indicates that the data being imported is too long for the specified column .Please provide us a sample value that is being passed in CUSTOMPROPERTY1.

[SumathiSomala · Accepted solution]

@kolipakularavi 

It seems that the data is too long for cp1 which is of varchar type.

Can you try mapping cp31 instead of cp1. 

cp31 of the accounts profile is of type longtext.

cp57-60 is also of mediumtext type.

Database Schema Reference (saviyntcloud.com)

[DixshantValecha]

Hi @kolipakularavi,

As mentioned by @SumathiSomala, it would be beneficial to validate the shared approach . However, I would also appreciate the opportunity to gain insight into the sample values being passed in CUSTOMPROPERTY1. This additional information will aid in a more comprehensive understanding of the situation. Thank you for your assistance in this matter.

[kolipakularavi]

@SumathiSomala and saviynt team,

I passed the value in the customproperty31 which has solved my issue.

Thanks for providing guidance and information from your side.

[SumathiSomala]

@kolipakularavi thanks for your confirmation. 

Please close this thread by clicking accept it as a solution. 

Thank you