AnsweredAssumed Answered

Write using DB connector fails with 'Embedded message: String or binary data would be truncated' error

Question asked by raghuraj.govindaraj408448 on Jan 24, 2017
Latest reply on Jan 25, 2017 by Sjaak Overgaauw

Hi,

I'm trying to insert data into MS SQL DB using a database connector. Everything works fine in my boomi process until it reaches the DB connector.

When it gets to DB connector, I get this error message  'Embedded message: String or binary data would be truncated.' and the DB write action fails. 

When I checked the content type for columns in DB table, it looks reasonable enough for my data to be stored.

 

Please help, How to troubleshoot this error as I'm not able to single-out which column in the DB table has this issue.

 

Thanks.

 

Outcomes