Skip to Content
0
Former Member
Jun 03, 2008 at 06:18 PM

Error stack is deleted before records are successfully processed.

154 Views

Problem: Error stack is deleted before records are successfully processed.

Description:

We are loading a regular cube using standard DTP. In case of error, the related records are getting transferred to the error stack. Now, we execute the regular DTP and subsequently error DTP to process the error requests. When the error stack is loaded to the cube some of the records are processed successfully but others remain in the error stack becuase they have again failed. If for any reason the request which loaded the error stack is deleted from the cube ALL of the error stack is deleted including the records that were never successfully processed.

Example:

DTP Load Request Id: 45,498 ---> Records transferred = 100 Records written to cube = 60 Records written to Error Stack Request 45,498 = 40

Error Stack Load Request: 45,499 --> Records transferred to cube = 20 records remaining in error stack = 20.

If request 45,499 gets deleted from cube....entire error stack is emptied.... however there are records that were never successfully processed. Now we have lost records.

Questions:

Why is entire error stack deleted even requests that were never sent to cube?

How can we recover the error stack?

Is there some method we could take to back up and recover the error stack in these cases?