Skip to Content
author's profile photo Former Member
Former Member

APD process chain fails due to duplicate records

Hi,

I am using APD PROCESS as below.

query >routine >aggregate-->Direct DSO.

the process chain fails due to duplicate records.this process chain was failed last few days on wards previously it was working fine.

i am new to APD concept.

may i know how to find duplicate records in Direct DSO?

How to avoid this fail in process chain?

provide the step by step solutions if you know.

thanks & regards,

mallikarjuna

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 18, 2012 at 05:15 AM

    Hi,

    In DTP there is a option for checking the duplicate records. Please check the option and carry out data load again.

    Repeat the PC and APD process from that point.

    Also refer link might be helpful

    Thanks,

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 18, 2012 at 05:17 AM

    Hi,

    You have to delete existing records before loading the new /latest request records..

    see if u need to make full load..

    Duplicate records in Direct update DSO

    see if DSO setting unique record check is there,please remove that as well and try first..then follow steps above or follow the thread..attached here

    also see if you can do sorting of records may be from active and new data table and delete adjacent duplicate records in routine..

    Thanks and regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 18, 2012 at 05:20 AM

    I guess it is not possible to handle duplicate keys in direct update DSO as u are using APD. Try to avoid duplicates in code which is used to fill direct update DSO or in the query.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 18, 2012 at 05:31 AM

    Hi,

    in the routine SORT the internal table using the keys and then use DELETE ADJACENT DUPLICATES COMPARING <sort keys>

    to remove duplicate records.

    Regards,

    Neeraj.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 19, 2012 at 05:53 AM

    Hi,

    Please check Aggregation process included in the APD & compare the grouping fields used there with the Key fields of the target direct update DSO. If the aggregation is happening on higher granularity level & DSO key fields are at lower granularity level then there will be duplicate records error.

    This is becuse you are trying to insert multiple records in the DSO which have same key.

    Regards,

    Viraj Dhopavkar.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 19, 2012 at 06:11 AM

    Hi,

    In your APD flow there is already existing routine, at the end of the routine processing you should filter the e_t_data or the output table.

    You can simply sort that table and delete the duplicate entries by comparing all the fields as suggested earlier.

    Regards,

    Durgesh.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.