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

[former_member182455]

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

[Former Member]

This is due to table column field length limitation, might be sending more no. of characters for particular field/column in PI.

use sub-string function  to limit the chars in PI and send to DB.