Sync Package error Zoho to SQL Server, suspect destination column is to small.

  • 47Views
  • Last Post 20 August 2021
0
votes
Lonnie Chin posted this 19 August 2021

I have encountered an error while running one of my sync packages that syncs data from Zoho to a table in SQL Server.  The sync has run trouble free for a long time but I am now recieving this error in the log.

ThisId;"OtherId";"Operation";"Error" ;"4302804000000424334";"i";"String or binary data would be truncated. The statement has been terminated."

From the information presented in the log I am assuming that an entry at the source is to large for the desitnation column in SQL Server but that is hard to tell.  When I search for this entry in the source I do not see this string. Is there anyway in the package that I can allow it to truncate or a way that I can identify the  column from source or the intended destination to assist me in finding the bad data point?

 

This is the link to the package - https://app.skyvia.com/#/53117/objects?type=package&folder=0

0
votes
Nataliia Nikulina posted this 20 August 2021

Hello Lonnie,

 

Thank you for contacting Skyvia Support team.

 

We have sent a reply to your mailbox. Please check it and let us know if you need any further assistance

 

Best regards,

Nataliia,

Customer Support Engineer 

Close