DTP Error Stack

Error stack DTP functionality:

 When know that as source may sends wrong data on daily/weekly cases, rather than reloading whole data into target. we use error stack which can hold error records and correct records will update to target.

 Check the error stack record and correct them at PSA and save it. then trigger the error stack DTP which can update corrected error stack records to target.

 At target level we may see the requests as:

one request loaded through normal DTP will be in red status, we can make it green once we loaded corrected records through error stack DTP. once you make this as green, data was available for reporting.

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 won’t 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 error records and save...

Now create Error DTP... 

Activate and execute the Error DTP

Corrected records are now moved from Error Stack to Cube

let us display data of cube