Skip to Content

With this blog I am trying to explain the new concept of handling data records with errors using ‘Error DTP’.

Check this link for types of possible data record errors.

In this blog I am considering simple case of data records that contains invalid characters. Scenario could be any this is just for the explanation of concept.

While loading data records using DTP, error records get updated into Error Stack of DTP. Error Stack is physically a type of PSA table, we correct errors in Error Stack, and then we create Error DTP to load changed data from Error Stack to Data Target.

Below are the steps that need to perform to handle data records with errors:

  • image
    Failed status of DTP in DTP Process Monitor because of invalid character in records.

  • By clicking on Error Stack we can check error records.

    image
    Total of 3 records with error in source data.

  • Correcting erroneous records in Error Stack by clicking edit button on top left.

    image

  • Creating Error DTP from the update tab of standard DTP.

    image

    image

    Once Error DTP gets created, we can check the status of Standard DTP which is changed from create to display, and can also check the Error DTP under the Object for which we created the standard DTP.

    image

    Here is Error DTP:
    image

  • Schedule the Error DTP from Execute tab.

    image

  • In the Error DTP process monitor it’s showing 3 records that we corrected in Error Stack in earlier steps.

    image

  • We can also check the status of Standard DTP, it’s also Green now (without errors).

    image

  • You can also check the records updated status of Standard and Error DTP in the manage tab of data target.

    image

Error DTP concept is more useful when source of DTP is some InfoProvider (DSO, InfoCube). Try to explore more on Error DTP, and see how it works for you.

To report this post you need to login first.

11 Comments

You must be Logged on to comment or reply to a post.

  1. Dieu fr
    Hi,
    I executed my Error DTP, missing a correction, and it failed, and the records have been added to the error stack.
    Now it fails because of duplicates (in spite of the option ‘Handle duplicates’).

    How to delete these duplicates  ?

    Thanks in advance !

    (0) 

Leave a Reply