Question Re: String or binary data would be truncated in Technology Q&A

String or binary data would be truncated

Former Member — Wed, 17 Sep 2014 07:19:04 GMT

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

Re: String or binary data would be truncated

JaySchwendemann — Wed, 17 Sep 2014 11:35:21 GMT

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

Cheers

Jens

Re: String or binary data would be truncated

Former Member — Wed, 17 Sep 2014 15:26:36 GMT

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.

Re: String or binary data would be truncated

Former Member — Thu, 18 Sep 2014 03:48:01 GMT

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