DTP Error Stack

Posted by on



If 100 records are getting transferred to Target. and if there is error in 5 records, we don't want the entire 100 records to pulled back..

In this concept our 95 records will reach target.. and erroneous 5 records will be moved to error stack.
we can correct the errors in error stack and send it to target using an error DTP..

Now lets see this using an example



In our source data we are purposely giving some errors to see the functioning of Error Stack and Error DTP..

We entered two entries in small letters which the system wont accept in normal case...


This is where we are going to load data..

Run  infopackage and load data to PSA of Datasource..



While configuring DTP.. give Error handling as "update valid records"..

Activate and Execute DTP..


In this we can see... ^ records are updated... remaining 2 erroneous records are blocked..



click on Error stack





now correct the errors and save...



Now create Error DTP...





Activate and Execute Error DTP..


Corrected records are now moved from Error Stack to Cube

let us display data of cube















Comments

  1. UnknownSeptember 14, 2014 at 12:26 PM

    Good one Aslam.

    ReplyDelete
  2. Hemasri SubramaniamFebruary 27, 2015 at 4:50 PM

    Great Efforts Aslam!! Pls post for ABAP coding which will be helpful for BI perspective.

    ReplyDelete
  3. AnonymousJuly 8, 2016 at 6:20 AM

    Very nice document

    ReplyDelete
  4. AnonymousJanuary 30, 2017 at 8:24 PM

    nice one !!

    ReplyDelete
  5. UnknownJuly 16, 2018 at 11:44 PM

    we have to change the status of main dtp before run of error dtp or after run error dtp

    ReplyDelete
  6. UnknownJuly 5, 2019 at 4:04 AM

    Where should we update the 2 errors in flat file or in bi system ?if bi system how we can correct the errors .

    ReplyDelete
  7. MohammedSeptember 22, 2019 at 5:44 PM

    Hi All,
    I. Have an issue with the Load from dso to cube there is a special hex. char. Issue blocking 13recs from going to cube. The issue is occurring in a field that is having a field routine written from dso->cube and this field is not shown to be edited in error stack as its being calculated via routine. Please help how can I correct this error in error stack of Dtp from dropping to cube. This is very high priority and need to be resolved soon as its impacting our Qtrend reporting... Kindly help.. My mobile ±91-7780517368.any help is highly appreciated...


    Please can someone urgently help me????

    ReplyDelete

Post a Comment