Error in mesage monitoring

[Former Member]

Iam getting this error in message monitoring

my sender is idoc and receiver is jdbc.

Unable to execute statement for table or stored procedure. 'EPMFA_ORD_HST' (Structure 'EPMFA_ORD_HST_Insert') due to java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]String or binary data would be truncated.

JDBC message processing failed; reason Error processing request in sax parser: Error when executing statement for table/stored proc. 'EPMFA_ORD_HST' (structure 'EPMFA_ORD_HST_Insert'): java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]String or binary data would be truncated....

[Former Member]

java.sql.SQLException means u have a problem with sql statement, u have to check "action " is INSERT or not , and also check in receiver commucation channel , u check JDBC DRIVERS AND CONNECTION , and user name and pwd are mentioned correctly or not .

[rajasekhar_reddy14]

Hi ,

Check your test data,the problem with data,the error could be because of the length of filed defined in data base is less than your test data filed length.

your database table has a colum named 'EPMFA_ORD_HST' of type VARCHAR(30),Now if you will try to insert a string of length greater than 30, the program will throw this type of exception.

Regards,

Raj

[Former Member]

Hi,

This is JDBC Drivers Problem, check once.

Thnx,

Siva.