and more in a single search tool across platforms. Read the announcement here. |
10/26/2023 02:52 AM
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?
Solved! Go to Solution.
10/26/2023 03:12 AM
Hi @kolipakularavi,
We are checking on your requirement and we will keep you posted.
10/26/2023 03:16 AM
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.
10/26/2023 08:02 AM
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)
10/30/2023 03:19 AM
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.
10/30/2023 08:53 PM
@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.
10/30/2023 08:57 PM
@kolipakularavi thanks for your confirmation.
Please close this thread by clicking accept it as a solution.
Thank you