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]

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.