Showing posts with label Error Stack. Show all posts
Showing posts with label Error Stack. Show all posts

Thursday, 15 March 2012

Error Stack in SAP NetWeaver BI Provides Improved Data Load Error Handling  

See two scenarios that explain how to improve data load error handling by using an error stack and data transfer process. Learn about the impact of semantic key definition on data integrity and data inconsistency for a DataStore object. 

Key Concept

In a data transfer process for a DataStore object (DSO) that has error handling enabled, the semantic key definition plays a critical role in maintaining the data consistency in the DSO.

The semantic key determines whether the system should load the data record to the data target or send it to the error stack.

Error Stack 

Definition

A request-based table (PSA table) into which erroneous data records from a data transfer process are written. The error stack is based on the data source, that is, records from the source are written to the error stack.

Use

At runtime, erroneous data records are written to an error stack if the error handling for the data transfer process is activated. You use the error stack to update the data to the target destination once the error is resolved.
 
Integration

In the monitor for the data transfer process, you can navigate to the PSA maintenance by choosing Error Stack in the toolbar, and display and edit erroneous records in the error stack.

With an error DTP, you can update the data records to the target manually or by means of a process chain. Once the data records have been successfully updated, they are deleted from the error stack. If there are any erroneous data records, they are written to the error stack again in a new error DTP request.

When a DTP request is deleted, the corresponding data records are also deleted from the error stack.

Error DTP

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.

  • Correct error stack by edit it.
  • Creating Error DTP from the update tab of standard DTP. 
  • A new DTP was created ,type is error DTP ,can navigate from standard DTP or from AWB tree.
  • Schedule the Error DTP from Execute tab.
  • After erro DTP run successfully the standard DTP also have a green status