Reason for duplicity of records in Direct Update DSO

[Former Member]

Hello guys,

We have been facing an error in Process chain since a few days. Let me explain briefly about this. There is a PC with APD as a process step and its target is a Direct Update DSO. We are facing an issue with message 'Duplicate data records when writing data to DataStore object <DSO_Name>'.

We have identified the duplicate records by sorting the data with the primary keys of the DSO. And have manually deleted the interim results of this APD and then deleted the duplicate records by creating a temporary APD and added one Routine step just before DSO which will delete adjacent duplicates from the result set on the basis of DSO key fields.

Though I have went through many threads but not sure how to proceed about identification for cause of duplicity of records. Usually duplication is based on primary keys of DSO. As I have not used APD before, so was wondering how do we identify the cause?

Any advice would be greatly appreciated. Thanks in advance.

Regards,

Sambit

[former_member184494]

In the APD - you can have an aggregation step which can be used to sum up the records thereby avoiding the duplicate record issue.

If you put the aggregation step before writing to the DSO in the APD - you can handle this in the APD itself and the APD will not fail.

[former_member185132]

Please check the source of the APD. This is where the duplicates are getting generated. Usually the source is a BEx query - if so, please ensure that all characteristics used in the Bex query are present as Key fields of the target DSO.

[Former Member]

Hi Suhas,

The Sources are all Standard DSOs and not a BEx query. In this case, what can be the probable reasons?

Also can you please let me know, if I want to calculate intermediate results at each step either by 'Calculate Direct or Schedule' option to check data at each step in order to identify duplicity, then will it be a problem when the process chain will run next time? Or this can be used for testing without actually saving results in any temporary table? FYI. I am checking in production system.

Regards,

Sambit

[former_member185132]

I'll need to see how the APD is defined, in order to understand what could be the problem.

Intermediate results should not cause any problems for regular PC runs.

[former_member227168]

Hi Dash,

Please try activate DSO again,

kindly update unique selection otion in DSO settings ( Unique selection ),

might may be resolve the problem.

Thanks,

Rams

[Former Member]

Hi Ram,

Thanks for the reply.

DSO is activated the last day but still we faced the same issue. And this is a direct update DSO, so there is no option for unique selection in the settings.

Regards,

Sambit