Reg: RSQL error 13

[Former Member]

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

[Former Member]

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

[Former Member]

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

[former_member156446]

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.

[mvoros]

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