Skip to Content
Author's profile photo Former Member

How To Solve Error stack Dtp

/wp-content/uploads/2014/12/1_611607.png

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

/wp-content/uploads/2014/12/2_611608.png

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.

/wp-content/uploads/2014/12/3_611651.png

This is where we are going to load data.

Run infopackage, load data to PSA of Datasource.

/wp-content/uploads/2014/12/4_611652.png

While configuring DTP, give Error handling as “update valid records”

Activate and Execute DTP.

/wp-content/uploads/2014/12/5_611653.png

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

/wp-content/uploads/2014/12/6_611654.png

click on Error stack

/wp-content/uploads/2014/12/7_611655.png

/wp-content/uploads/2014/12/8_611656.png

Now correct the errors and save.

/wp-content/uploads/2014/12/9_611657.png

Now create Error DTP.

/wp-content/uploads/2014/12/10_611659.png

/wp-content/uploads/2014/12/11_611660.png

Activate and Execute Error DTP.

/wp-content/uploads/2014/12/12_611661.png

Corrected records are now moved from Error Stack to Cube

let us display data of cube


/wp-content/uploads/2014/12/13_611662.png

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Very nicely explained! Simple enough for anyone to understand..