Error Records with Same Key

[Former Member]

I have posted this in other forum but no response. So doing it here.

Can anyone help me out with a master data load failure.

My request goes off red and the message looks somehow like "Record filtered in advance as error records with the same key exist", "Filter out new records with same key". I have already checked the duplicate handle record setting in DTP. Still why am i getting this error.

Would appreciate and award points if some one could suggest me in this.

[former_member187400]

Hi Shridevi,

I think it's caused there are records having same primary key.

Have you made your primary key unique ?

Since you're loading data to master data, have you tried to make compound primary key in master data ??

Compound primary key has meaning, that you have more than one primary key in that master data. So there will not be redundant data.

To make it,

1. RSA1.

2. Go to the master data info-object.

3. Go tab compound.

4. Define the attributes going to be compounded as primary key.

Hope it can helps you a lot.

Regards,

Niel.

(Many thanks for any points you choose to assign).

[former_member213240]

Hello Guys,

I also faced this error and was able to rectify it after lot of investigation.

This error is due to corrupted DTP. Please create a new DTP with the same conditons and try to load.

Once you are able to successfully load , delete the old DTP.

Regards

Dinesh

[Former Member]

hi shri devi,

after looking ino the detaitab u will get the info object which is throwing the eror please go to t-rsrv and give that info object and please check the maser data of that object

[Former Member]

Hi ,

i guess,This is because of the semantic group functionality incorporated in DTP functionality,

according to this with the selected key combination(as specified under semantic group section in DTP settings),if any one record fails rest all correct records for the same key combination will be pushed to error stack .

can you check what is that you have given under semantic group section...

try to correct the error in errorstack and schedule an Error DTP to push the data to the target

http://help.sap.com/saphelp_nw2004s/helpdata/en/42/fbd598481e1a61e10000000a422035/frameset.htm

cheers,

Swapna.G

[Former Member]

Hi Sridevi/ Vijay,

Have you resolved this issue. Can you plz give me the steps how you have solved the issue.

Many thanks in Advance,

Regards

PV

[mathew_muthalaly]

Hi,

1. Go to the Infopackage >> Update tab

2. Click on Error handling

3. Suggest that you select - Valid records update, reporting possible (request green)

4. Set a maximum nos. of errors depending on the nos. of error records encountered. Set it more than the errors expected.

5. On extraction you should have the correct records available for reporting

The error records should be checked in detail and action taken suitably.

Mathew.

[Former Member]

Hi Shridevi,

Even i am hitting with the same issue.I guess you might have got solution for now.Can you please tell me how you resolved it.

Thanks,

Vijay.

[Former Member]

If a previoud load of yours had error records they will be stored in the error stack. You will need to clear that error stack by fixing the "error" and then running the error DTP. Once finished you will be able to run future DTPs without a problem.