SAP XI:database -level error reported by JDBC driver while executing statement

[Former Member]

Hi all,

this is a JDBC to PROXY scenario, It will run daily at 10 pm to 5 am.

some of the data will pass successfully and some will struct in sender adapter only.

why it will struct in RWB.

while running the interface i am getting below error.

Database -level error reported by JDBC driver while executing statement 'call serviceinvoiceentry_fi'. The JDBC driver returned the following error message: 'com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'v_irh_issued' at row 246'. Fpr details, contact your database server vendor.

please some body help out in this problem..

Regards,

rajireddy...

[Former Member]

Hi

Thank you all issue is resolved..

regards,

rajireddy

[former_member192343]

check the value for v_irh_issued at row 246, its length is more then column size

[Former Member]

Dear RajiReddy,

Please check the size of columns in Database Table . May be for particular column , you are sending bigger values (in size)  which cant be store in table.

Warm Regards,

Rudra