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

[Former Member]

Hi Kiran,

As maintaind by jen and kumar, this is data related issue, please check with DB team and field length of your input data.

Regards

Srinivas