topic Re: program dump at INSERT stmt. in Application Development and Automation Discussions

program dump at INSERT stmt.

Former Member — Tue, 07 Oct 2008 14:37:02 GMT

I need help ...My program is dumping at the below statment.

INSERT zadi_m_tibinvadj.

I don't understand why ?

Below are some of the reason of short dump :

Short text

Invalid request.

What happened?

The current ABAP/4 program terminated due to

an internal error in the database interface.

Error analysis

An invalid request was made to the SAP database interface in a statement

in which the table "ZADI_M_TIBINVADJ " was accessed.

How to correct the error

Start the work process involved and repeat the action that lead to the

error.

If the error position is in a program that you can change, you can try

to create preliminary solution: Reformulate the database command by

varying the properties such as individual record access instead of

input/output via internal tables, the structure of the selection

conditions (WHERE clause), nested SELECT loops instead of FOR ALL

ENTRIES and other such variations.

Please check the entries in the system log (Transaction SM21).

Check the entries in the developer trace of the work process involved

(transaction ST11).

If the error occures in a non-modified SAP program, you may be able to

find an interim solution in an SAP Note.

If you have access to SAP Notes, carry out a search with the following

keywords:

"DBIF_RSQL_INVALID_REQUEST" " "

"SAPLZADI_TIB_ZBUS2017_INBOUND" or "Z_TIB_ZBUS2017_COMM_INB_FORMS"

"UPDATE_LOG_INVADJ"

THANKS IN ADV

Re: program dump at INSERT stmt.

Former Member — Tue, 07 Oct 2008 14:40:37 GMT

Hello,

See this: .

Regards.

Re: program dump at INSERT stmt.

Former Member — Tue, 07 Oct 2008 14:43:47 GMT

i think it is coming from select.? show the code once.

Re: program dump at INSERT stmt.

Former Member — Tue, 07 Oct 2008 16:44:25 GMT

Share all the SQL Statements(SELECT/INSERT)..............Dump is talking about a Database SELECTION and not INSERTION

Re: program dump at INSERT stmt.

Former Member — Wed, 08 Oct 2008 03:28:00 GMT

check the fields in the SELECT statement and your internal table fields are same or you entered any wrong fields name in the SELECT.

Rgds,

Jey

Re: program dump at INSERT stmt.

madan_ullasa — Wed, 08 Oct 2008 03:32:37 GMT

hi,

Try using 'modify' ....

Re: program dump at INSERT stmt.

former_member278689 — Wed, 08 Apr 2015 09:57:18 GMT

Hi,

In my opinion Modify is not a good practice. It must be replaced with READ and INSERT / UPDATE.

Regards,

Laurent