String or binary data would be truncated

[Former Member]

Hi Team,

My interface is FILE to JDBC, we are facing the below issue in the JDBC channel.

Unable to execute statement for table or stored procedure. 'SPName' (Structure 'StatementName_2') due to com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated

kindly provide the solution for this error.

Regards

Kiran

[JaySchwendemann · Accepted solution]

Please check field lengths of your input data and the corresponding column lengths of database table.

Cheers

Jens