on 01-29-2014 3:36 PM
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
Dear Marco,
I have the same problem with DEC3_7 I have a function which returns the value of TB_YIELD but the value could be greater than 999.9999999 and if I store to datebase I got the same error.
Have you found a solution?
Regards
MArcus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Ram and Deepak,
thanks for your hints.
I had a look at the documentation and notes you provided and found the following strange issue in the ABAP debugger:
I have a component of a structure typed as the data element PEMKURS. The underlying domain is DEC3_7 which consists of at maximum three digits left of the comma.
However, at runtime my logic stores the value 1000.0000000 into this field. Afterwards while the INSERT statement the database error comes up.
From my perspective, this is a strange behaviour of the runtime environment and should lead to an exception while the value is given to that component.
Any ideas?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Marco,
Could you check the solution in link
http://publib.boulder.ibm.com/infocenter/cmx/v8r3m0/index.jsp?
topic=%2Fcom.ibm.sysadmin.hlp%2Ftrs20002.htm
Hope this helps.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.