String or binary data truncated

[Former Member]

Hi Experts,

I have a scenario called File to JDBC ,I am getting the following error in RWB as

Error processing request in sax parser: Error when executing statement for table/stored proc. 'XXXX' (structure 'STATEMENT'): com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated.

but in SXMB_MONI theres no error.

Kindly help on how to resolve.

Regards,

Kalpana.

[former_member184681 · Accepted solution]

Hi Kalpana,

Most probably you are trying to put into DB a value that is actually longer than the DB field. Make sure the values your mapping generates are in accordance with to the DB schema.

Regards,

Grzegorz

[Former Member · Accepted solution]

Hi Grzegorz

Thanks for your reply.The field length was mismatching.

Regards,

Kalpana.