topic Re: Error in inserting or changing rows in a sorted table in Application Development and Automation Discussions

Error in inserting or changing rows in a sorted table

Pavan_Golesar — Mon, 08 Feb 2016 06:45:28 GMT

Hello ABAPER,

I have already searched SCN for similar issue, (post)for related posts although my case seems little different as the line of the table type is a data element (an not a structure with fields).

Scenario:

I am trying to insert into sorted table but facing runtime error of ITAB_DUPLICATE_KEY.

please put some light on this if had similar problem.

For ref: I have attached a snapshot of runtime error from st22 log as below:

Regards,

pavan G

Message was edited by: Pavan Golesar

Re: Error in inserting or changing rows in a sorted table

RaymondGiuseppi — Mon, 08 Feb 2016 06:51:03 GMT

Did you declare the table key as UNIQUE or NON-UNIQUE?

Which statement syntax did you use for the insert?

Regards,

Raymond

Re: Error in inserting or changing rows in a sorted table

sabirshah1 — Mon, 08 Feb 2016 07:00:24 GMT

Hi ,

Just show your code , how u declared the table/Structure please .

Re: Error in inserting or changing rows in a sorted table

Pavan_Golesar — Mon, 08 Feb 2016 07:57:23 GMT

Thanks for quick reply,

Data Declaration of structure:

DATA lt_header_guid TYPE crmt_object_guid_tab.

**** Souce code*

insert wa to table it.

Regards,

Pavan G

Re: Error in inserting or changing rows in a sorted table

Pavan_Golesar — Mon, 08 Feb 2016 08:00:08 GMT

Thanks sabir,

As mentioned above, the table type crmt_object_guid_tab is based on a DATA ELEMENT.

In this case how to pass the NON-unique key condition to the abap statement below..


insert wa to it.

Thanks,

Pavan G

Re: Error in inserting or changing rows in a sorted table

SimoneMilesi — Mon, 08 Feb 2016 08:14:46 GMT

You got 2 simple choices based by Raymond question

Did you declare the table key as UNIQUE or NON-UNIQUE?

If you declared the table key as UNIQUE, before the insert, you have to read the internal table to check if key already exist and only if not exist, then insert (and i think you are in this condition).

If you declared NON-UNIQUE, you should have no problem.

Re: Error in inserting or changing rows in a sorted table

Pavan_Golesar — Mon, 08 Feb 2016 08:58:12 GMT

Absolutely,

I'm referring to standard table type which is of type sorted with non-unique key.

--PG

Re: Error in inserting or changing rows in a sorted table

Pavan_Golesar — Mon, 08 Feb 2016 09:01:17 GMT

Yes it a non-unique key based sorted table and line of error is as below:

--PG

Re: Error in inserting or changing rows in a sorted table

SimoneMilesi — Mon, 08 Feb 2016 09:05:58 GMT

Sorry for the silly question, i couldn't check myself since in my system i do not have that table type

Anyway, replace INSERT with APPEND and, magic!, it works

Check my below example program

Re: Error in inserting or changing rows in a sorted table

sabirshah1 — Mon, 08 Feb 2016 09:13:48 GMT

This message was moderated.

Re: Error in inserting or changing rows in a sorted table

Pavan_Golesar — Mon, 08 Feb 2016 13:04:24 GMT

Umm, I had tried it earlier hence I am pushed to use Insert statemet,

Ya, It would have helped only if table type was standard table and not the SORTED TABLE (as in my case)

Since the table type is have type as SORTED table, (as per SAP DUMP help) It will not accept the append condition...


 Error while inserting or changing rows in a sorted table

Regards,

PavanG

Re: Error in inserting or changing rows in a sorted table

Pavan_Golesar — Mon, 08 Feb 2016 13:09:42 GMT

This message was moderated.

Re: Error in inserting or changing rows in a sorted table

SuhaSaha — Mon, 08 Feb 2016 13:24:14 GMT

From the screenshot the table type CRMT_OBJECT_GUID_TAB is a standard table. Can you check the "secondary" keys tab? I think secondary keys are defined for this table type.

Can you please check & confirm?

Re: Error in inserting or changing rows in a sorted table

RaymondGiuseppi — Mon, 08 Feb 2016 13:27:05 GMT

Look at the definition of parameter et_orderadm_h in the FM which dumps, and not at your lt_header_guid internal table.


Exceptions 
Catchable Exceptions
CX_SY_ITAB_DUPLICATE_KEY

Cause: Duplicate key values in unique secondary key 
 Runtime Error: ITAB_DUPLICATE_KEY

  Non-Catchable Exceptions  

Cause: When inserting a set of rows, entries with an identical key were produced (the target table is defined by UNIQUE). 
 Runtime Error: ITAB_DUPLICATE_KEY 
Cause: Sort order violated when using an INSERT with index in a sorted table. 
Runtime Error:ITAB_ILLEGAL_SORT_ORDER
Cause: Invalid index value (<= 0) when FROM, TO, or INDEX specified 
Runtime Error:TABLE_INVALID_INDEX

Regards,

Raymond

Re: Error in inserting or changing rows in a sorted table

Pavan_Golesar — Tue, 09 Feb 2016 04:40:39 GMT

No, Below is screenshot from SAP:

Regards,

Pavan G

Re: Error in inserting or changing rows in a sorted table

Pavan_Golesar — Tue, 09 Feb 2016 05:09:02 GMT

Hence now If I jump back to insert statement I am able to push entries to the Sorted table:


insert l_crmt_object_guid inTO TABLE lt_header_guid

Although I get other issue saying below error with different line from standard FM CRM_ORDER_READ:


A row already exists with this key

--Pavan G

Message was edited by: Pavan Golesar

Re: Error in inserting or changing rows in a sorted table

matt — Tue, 09 Feb 2016 05:36:37 GMT

Your error occurs, according to the dump, in SAPLCRM_ORDER_ON. That's standard SAP code, which obviously you can't change. Have you search in service.sap.com

Are you reusing some SAP code? The problem could be you calling the SAP code with bad data, for example. As Raymond has pointed out, the issue is with et_orderadm_h - what is the data definition of that?

I think we need rather more context.

Re: Error in inserting or changing rows in a sorted table

Pavan_Golesar — Tue, 09 Feb 2016 06:04:31 GMT

Yes Matthew, Issue is with et_orderadm_h table (which is of type seen in below image)..

After I looked closely, Found that it is having a UNIQUE KEY GUID (Sorted Table)...

On Runtime time I check the contents of tables passed..

It does give the dump on row already exists with KEY..so I checked the contents of GUID (on Second iteration) and it is indeed Different.. then I wonder why the DUMP is occurring...

Regards,

Re: Error in inserting or changing rows in a sorted table

matt — Tue, 09 Feb 2016 06:48:01 GMT

Are you calling this SAP function module from your own code?

If not, unless you are the analyst working for SAP to fix this issue, you really should stop analysis now and report to SAP. Since this is SAP code you can't fix it yourself.

If you are, please post the relevant parts of your code.