topic Re: DBIF_RSQL_INVALID_RSQL Dump while insert in Application Development and Automation Discussions

DBIF_RSQL_INVALID_RSQL Dump while insert

Former Member — Tue, 13 Sep 2011 06:17:03 GMT

Hi All,

Am getting dump DBIF_RSQL_INVALID_RSQL while inserting data to a standard table.

Code below:

INSERT /cockpit/titemo FROM TABLE lt_item_org.

This code is in the standard FM /COCKPIT/OBJ_DATA_ORG_SAVE.

Please note the internal table is of type /cockpit/titemo.

Any inputs on this would be helpful.

Thanks,

John

Re: DBIF_RSQL_INVALID_RSQL Dump while insert

Former Member — Tue, 13 Sep 2011 06:38:56 GMT

Hi Jhon,

I am not sure but table /cockpit/titemo and function module /COCKPIT/OBJ_DATA_ORG_SAVE are not looking like as a standred table and function module respectively, please check whether /cockpit/ is a cunstomer namespace specialy assgned by SAP to your customer or your system.

After seeing the dump name, it looks like there is a possibility that table entry is already exist in table /cockpit/titemo and you are trying to insert values for same key fields in the table.

Also there is a possibility that you are trying to insert data from internal table lt_item_org, this statement is not looking so much effective.

INSERT /cockpit/titemo FROM TABLE lt_item_org.

If /COCKPIT/ is the customer namespace then you should be able to do changes and try to change avove query to

MODIFY /cockpit/titemo FROM TABLE lt_item_org.

Re: DBIF_RSQL_INVALID_RSQL Dump while insert

Former Member — Fri, 10 Jan 2014 12:28:19 GMT

This message was moderated.

Re: DBIF_RSQL_INVALID_RSQL Dump while insert

ThomasZloch — Fri, 10 Jan 2014 13:24:27 GMT

This message was moderated.

Re: DBIF_RSQL_INVALID_RSQL Dump while insert

RaymondGiuseppi — Fri, 10 Jan 2014 13:52:29 GMT

I'm not sure, because the dump was posted there more than 2 years ago...

Regards,

Raymond