Question Re: ITAB_DUPLICATE_KEY in Technology Q&A

ITAB_DUPLICATE_KEY

Former Member — Thu, 29 Jan 2009 06:58:36 GMT

hi all

i ve designed one APD which extracts financial data. here i am storing query result in one ODS. this APD runs fine in development server but when i run it in live server it throws error : ITAB_DUPLICATE_KEY.

ShrtText

There is already a line with the same key.

What happened?

Error in ABAP application program.

The current ABAP program "CL_RSAN_RT2_DS_QUERY_RUNNER===CP" had to be

terminated because one of the

statements could not be executed.

This is probably due to an error in the ABAP program.

i am unable to understand how it runs fine in development but not in live? what could be the problem?

Re: ITAB_DUPLICATE_KEY

Former Member — Thu, 29 Jan 2009 07:10:23 GMT

Hi,

There can be duplicate records in the data,so its giving error. Use the statement

Delete Adjacent Duplicates itab. (check the syntax) before the result.

Regards,

anil

Re: ITAB_DUPLICATE_KEY

Former Member — Thu, 29 Jan 2009 07:14:04 GMT

Priyadarshini,

Due to Duplicate records.

Try to design query for required output(same as ODS keyfields and datafields) only and try.

Srini

Re: ITAB_DUPLICATE_KEY

Former Member — Thu, 29 Jan 2009 08:11:49 GMT

Due to duplicate records with report, try to get only required out put.

Hope it helps