topic Re: Reg: RSQL error 13 in Application Development and Automation Discussions

Reg: RSQL error 13

Former Member — Tue, 17 Feb 2009 17:48:31 GMT

Moderator message: do not offer points

Hello All,

I am getting RSQL error 13 runtime error when I am inserting records into the database table from the internal table of the same structure.

"Insert ZPAY_TABLE form table GT_PAY_TABLE accepting duplicate keys"

I tried even Modify and Update statements Modify is giving 'Invalid Request' error.

Please tell me the reason for the error and how to rectify it.

<<text removed>>

Thanks in advance

Regards,

Suganya.

Edited by: Matt on Feb 18, 2009 8:29 AM

Re: Reg: RSQL error 13

Former Member — Tue, 17 Feb 2009 18:04:18 GMT

I would imagine it has something to do with those duplicate keys - try looping & modifying ZPAY_TABLE from GT_PAY_TABLE .

Re: Reg: RSQL error 13

former_member156446 — Tue, 17 Feb 2009 18:18:20 GMT

Hi Welcome to SDN,

if you can hit a F1 on Insert statement, there is a link called prerequisites check that or ..

Prior to Release 6.10, this raises an exception that cannot be handled; as of Release 6.10, this raises the exception that can be handled CX_SY_OPEN_SQL_DB.

Re: Reg: RSQL error 13

mvoros — Tue, 17 Feb 2009 22:37:23 GMT

Hi,

this error usually means that you hit the limit for a size of the SQL query. SAP system rewrites your OpenSQL command into SQL query and sends it to DB. The problem is that there is a limit for the size of the SQL query. Hence in some cases SAP system generates larger query than this limit. If you check ABAP documentation for your SQL query then you can find the following sentence there.


Mass insert: Inserts all lines of table itab in a single operation.

SO I assume that SAP rewrites it into one big INSERT command. So haw many lines does your table have? If there are too many lines you can try to split it into smaller chunks. You can read more about SQL size restriction in this OSS note 635318.

Cheers