Duplicate records in APD

[former_member351936]

Hello Team,

I am trying to load data in to a Direct update DSO using an APD.

The job fails with the Error " Duplicate data when writing data to the DSO"

I have checked the Intermediate results , but there are no Duplicate Records.

Can you tell me if there is any other way to find the duplicate records?

[Loed]

Hi Shiv,

Try to check in the settings of the DSO if their is a HANDLE DUPLICATE RECORDS something..I think it's in the settings portion of DSO..

Regards,

Loed

[former_member351936]

Hello,

I am running the APD as per Dates.

So it worked fine for July 03 but when i run for July 04 it failed.

Also since it is a Direct update DSO..

i cannot handle Duplicacy there.

please suggest all possible ways to find the Duplicate records.

Thanks

Shivani

[abhishek_shanbhogue2]

I am sure you might have already tried it but this might be worth checking again

Try to display intermediate results for Jul 04, export to excel for all fileds and the try to identify/analyze  duplicates if any. You can also do it if the source ofr your APD is query (dont forget to disable the suppression as APD will not take this into consideration)

Thanks

Abhishek Shanbhogue

[former_member351936]

Hello Abhishek,

How to check about the suppression??

[abhishek_shanbhogue2]

Go to your query designer and in the query properties you will find row and column suppression so turn it off OR you can also do it from report output by context menu> query properties

Thanks

Abhishek Shanbhogue

[abhishek_shanbhogue2]

Hi Shiv

Have you set your key fields and data fileds correctly and are there any routines used in the data transfer process?

Thanks

Abhishek Shanbhogue

[fcorodriguezl]

Hi Shiv,

What is your source?

1) If is a Query, check result lines is off is characteristics.

2) Check add a object filter in apd before ods to del spaces.

I hope help you.