ORA-01401: inserted value too large for column

[Former Member]

com.sap.aii.af.ra.ms.api.DeliveryException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'SAP_IMPORT_STOCK_ORDER' (structure 'Statement'): java.sql.SQLException: ORA-01401: inserted value too large for column

This is the error I am getting when passing records from SAP to DATABASE.

When passing two records it is working fine.

But failing when passing 980 records.

The above error is coming when response is coming back from Database to SAP.

Please reply ,if you know the answer.

[Former Member · Accepted solution]

Check the database for the field constraints. Generally the error in the JDBC adapter are because of the inconsistencies in the data being sent and the configuration of the tables.

reward if helpful,

Sarath.