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

0EMPLOYEE -> Self-Transformation; duplicate records RSDMD 190

Hi BI experts

We have built a self-transformation from 0EMPLOYEE to 0EMPLOYEE.

While loading full data via DTP we get an error message RSDMD 190, duplicate records. When checking the error stack we can state that there are NO duplicate records.

We have maintained semantic groups with 0EMPLOYEE.

Do you have any idea about this behaviour?

Thanks

PC-12

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    Posted on May 21, 2013 at 07:58 AM

    check the base table (/BI0/PEMPLOYEE) of the master data to see if you have duplicate data.

    if you find any, act accordingly

    BR,

    M.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      As the data for this field is time dependent, you can not have same Zemployee valid for different dates.

      There should be two records in PSA which will have same value for Zemployee but different dates like Valid from and valid to.

      Edit or correct the dates as they are overlapping as it is time dependent master data.Then upload from PSA or correct in source.

      Regards

      Padmaja

  • Posted on May 21, 2013 at 07:41 AM

    Hi PC12,

    0EMPLOYEE is an infoobject, so a DTP to an infoobject will have the option to handle duplicate records. If this is chosen, then only the first record is considered in the request and all the duplicates are omitted. As Raman has suggested, please check this option and trigger the DTP to fix the issue.

    Also as the load is from 0EMPLOYEE to itself, the existence of the duplicate key itself is strange as masterdata cannot hold duplicate records. Kindly run the ACR first and activate the master data to eliminate duplicate records on the basis of field object version and then run the DTP as it is without the handle duplicate records and it will work.

    Hope this helps,

    Regards,

    Manohar. D

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 21, 2013 at 07:36 AM

    Hi Pc,

    At DTP level there will be an option(on Update tab) - Handle duplicate records key. select that options and try to load. that may resolve your issue.

    Error stack holds only erroneous records.

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi PC,

      While saying message you may see respective employee id record, if yes thru that you can check in 0employee master data, if its have doubled records then you can delete manually and run ACR.

      Later try to load. as my guess when you do self load in master data you may get duplicate records error, because your loading same records from same source to same target.

      Without duplicate records in your 0employee, you will get this error. is it mandatory to use self transformations?

      Thanks

  • author's profile photo Former Member
    Former Member
    Posted on May 21, 2013 at 09:37 AM

    select the option ignore duplicate records in the infopackage level.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 21, 2013 at 11:34 AM

    Hi,

    After reading your issue I may conclude that do the following things:

    1) Chack the dulicacy i.e. duplicate records in ZEMPLOYEE ( if you checked in 0EMPLOYEE earlier).

    2) During self transformation run the ACR for ZEMPLOYEE before run the DTP and after run the DTP.

    3) For the mentioned employee Ids check teh DATE TO and DATE FROM values. They might have some issue.

    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.