Error BW "ITAB_DUPLICATE_KEY"

[Former Member]

Hi, when downloading data in the RSA1 error occurs in the system

Error in the ABAP Application Program |

The current ABAP program "SAPLRSAODS" had to be terminated because it has

come across a statement that unfortunately cannot be executed. An entry was to be entered into the table

"\FUNCTION=RSAR_ODS_GET\DATA=L_TH_ISOSMAP" (which should have

had a unique table key (UNIQUE KEY)).

However, there already existed a line with an identical key.

The insert-operation could have ocurred as a result of an INSERT- or

MOVE command, or in conjunction with a SELECT ... INTO.

The statement "INSERT INITIAL LINE ..." cannot be used to insert several

| initial lines into a table with a unique key. x

Best Regards,

EDRS

[Former Member · Accepted solution]

Hi,

Try to activate your DSO or reactivation of DSO resolved it.

Refer to below document which has explanation

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/a04c82eb-ec7c-2c10-7fae-ca6e764c4...

Thanks,

Arjun

[Former Member · Accepted solution]

Thanks for information Arjun, Now, run transacction RSAR_RSISOSMAP_REPAIR but show message error.

TSPREFIX for LOGBID001 not found

TSPREFIX for LOGBID001 not found

the name LOGBID001is logical system old.

Best Regards,

EDRS

[Former Member · Accepted solution]

Hi,

Do you have the Logical System Name - TSPREFIX in RSBASIDOC ?

1- Got to SE16 and enter table EDP21, take note to the entries.

2- Go to WE20 and check whether Partner profile is missing in LS type regarding to EDP21 content.

If there is any missing, just add Parnter profile with same and save.

Partner profile Name: LOGBID001 (In your case)

TYPE: LS

Give:

Ty: US

User: User Name

Lang: EN

and Save.

3- Again re-click on Partner Profile created.

you will see ,there will be some entries in Inbound & out Bound Tabs.

Delete the following from outbound:

1.RSRQST

Delete the following from inbound.

1.RSINFO

2.RSSEND

and save your partner profile.

3. now execute - RSA1, it will ask to active Workbench provide it and ReTry Again.

Check also the Solution 5 in the Note 140276 - Error in source system assignment

Thanks,

Arjun

[Former Member · Accepted solution]

Hi Arjun, apply your recommendations and this link: https://community.altiusconsulting.com/blogs/glenchambers/archive/2008/05/29/itab-duplicate-key-abap...

Best Regards,

EDRS