SQL Error -302 while inserting into database table

[former_member186608]

Dear community,

not sure if my concern is located correctly here, however I would like to have your comments on the following issue I am encountering on a SAP system.

The system is running on a DB6 database.

I have a database table and I want to insert a new tuple there. The work area used in the open SQL insert statement is typed as the database table. Hence from a data type perspective, the runtime environment should take care that all values in the work area correspond accordingly to the schema of the database table.

However, I am receiving a short dump stating the following:

sql error -302   performing INS on table DATABASE_TABLE_NAME               [dbtrtab#3770]

SQL0302N  The value of a host variable in the EXECUTE or OPEN statement is out of range for its corresponding use.  SQLSTATE=22003 row=1 [dbtrtab#3770]

I have investigated in the debugger whether this is a corrupt value or something similar, but was not able to find any suspicious field.

I have no clue how to proceed. Is there any possibility to examine which component of the work area causes the issue?

Thanks in advance and looking forward to a discussion with you all,

Marco

[S_Sriram]

Hi Marco

Kindly check this SAP Notes

1630161 - DB2 Error SQL0302N loading data - Data Services

1102641 - Consult: Dump during insert in PSA table due to incorr vals

Regards

Ram