Error Stack &Error DTP Definition
A request-based table (PSA table) into which erroneous data records from a data transfer process are written. Theerror 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 isactivated. 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
inthe 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. Oncethe data records have been successfully updated, they are deleted from the error stack. If there are any erroneousdata 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.
Introduction
Error Stack is a request-based table (PSA table) into which erroneous data records from a data transfer process(DTP) are written. The error stack is based on the data source (PSA, DSO or Info Cube), that is, records from thesource are written to the error stack.For a data transfer process (DTP), you can specify how you want the system to respond when data recordscontain errors. If you activate error handling, the records with errors are written to the error stack. You can use aspecial data transfer process, the error DTP, to update the records to the target.
Step5:Settings for Error Stack
Also the DTP Error Stack settings can be modified by clicking on the Goto Settings for DTP Temporary Storageof the DTP.The various options available in the Settings for Temporary Storage are as given below:1. Delete Temporary Storage ± To delete the records in the Error Stack as per below conditions:-
With Request Status Green
With Request Status Red
A request-based table (PSA table) into which erroneous data records from a data transfer process are written. Theerror 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 isactivated. 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
inthe 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. Oncethe data records have been successfully updated, they are deleted from the error stack. If there are any erroneousdata 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.
Introduction
Error Stack is a request-based table (PSA table) into which erroneous data records from a data transfer process(DTP) are written. The error stack is based on the data source (PSA, DSO or Info Cube), that is, records from thesource are written to the error stack.For a data transfer process (DTP), you can specify how you want the system to respond when data recordscontain errors. If you activate error handling, the records with errors are written to the error stack. You can use aspecial data transfer process, the error DTP, to update the records to the target.
Settings for Error Handling
For a data transfer process (DTP), you can specify how you want the system to respond when data recordscontain errors. If you activate error handling, the records with errors are written to a request-based database table(PSA table). This is the error stack. You can use a special data transfer process, the error DTP, to update therecords to the target.Temporary storage is available after each processing step of the DTP request. This allows you to find out whichprocessing step the error occurred in.
Step 1: Analyze Erroneous Records
Go to the Update tab of the DTP of the target where there are erroneous records. Error Stack is availableafter each processing step of the DTP request. This allows you to find out which processing step the error occurred in.
Examples of Incorrect Data Records
1.Field contains invalid characters or lowercase characters
2.Error during conversion
For a data transfer process (DTP), you can specify how you want the system to respond when data recordscontain errors. If you activate error handling, the records with errors are written to a request-based database table(PSA table). This is the error stack. You can use a special data transfer process, the error DTP, to update therecords to the target.Temporary storage is available after each processing step of the DTP request. This allows you to find out whichprocessing step the error occurred in.
Step 1: Analyze Erroneous Records
Go to the Update tab of the DTP of the target where there are erroneous records. Error Stack is availableafter each processing step of the DTP request. This allows you to find out which processing step the error occurred in.
Examples of Incorrect Data Records
1.Field contains invalid characters or lowercase characters
2.Error during conversion
3.Characteristic value is not found for master data
4.Duplicate data records with relation to keys
5.If no SID exists for the characteristic value
6.If no SID exists for the value of the navigation attribute
4.Duplicate data records with relation to keys
5.If no SID exists for the characteristic value
6.If no SID exists for the value of the navigation attribute
7.A routine returns a return code <> 0
Step 3:Enable Error Stack
Change the DTP to Edit Mode and on the Update tab of DTP; select the Error Handling mechanism based on howyou want system to respond to data records with errors.The various error handling mechanisms are explained as below:-
a).No update, no reporting (default) - If errors occur, the system terminates the update of the entiredata package. The request is not released for reporting. The system continues checking the recordshowever.
b).Update valid records, no reporting (request red) - This option allows you to update valid data.This data is only released for reporting after the administrator checks the incorrect records that havenot been updated and manually releases the request by setting the overall status on the
Status tabpage in the monitor (QM action).
c).Update valid records, reporting possible - Valid records can be reported immediately. Automaticfollow-up actions, such as adjusting the aggregates, are also carried out.
Step 3:Enable Error Stack
Change the DTP to Edit Mode and on the Update tab of DTP; select the Error Handling mechanism based on howyou want system to respond to data records with errors.The various error handling mechanisms are explained as below:-
a).No update, no reporting (default) - If errors occur, the system terminates the update of the entiredata package. The request is not released for reporting. The system continues checking the recordshowever.
b).Update valid records, no reporting (request red) - This option allows you to update valid data.This data is only released for reporting after the administrator checks the incorrect records that havenot been updated and manually releases the request by setting the overall status on the
Status tabpage in the monitor (QM action).
c).Update valid records, reporting possible - Valid records can be reported immediately. Automaticfollow-up actions, such as adjusting the aggregates, are also carried out.
Note: Specify the maximum number of incorrect data records allowed before the system terminates the transfer process. If you leave this blank, handling for incorrect data records is not activated, and the update is terminatedas soon as the first error occurs.
Step 4: Define Semantic Groups
Go to Extraction tab of the DTP and click on Semantic Groups to define the Semantic Groups to define the keyfields of error stack.This setting is only relevant if you are transferring data to Data Store objects (DSO) with data fields that areoverwritten. If errors occur, all subsequent data records with the same key are written to the error stack along withthe incorrect data record.This guarantees the serialization of the data records, and consistent data processing. The serialization of the datarecords and thus the explicit definition of key fields for the error stack are not relevant for targets that are notupdated by overwriting like Info Cube.The fields in the source can be enabled in the semantic group definition as per the below rules:
Go to Extraction tab of the DTP and click on Semantic Groups to define the Semantic Groups to define the keyfields of error stack.This setting is only relevant if you are transferring data to Data Store objects (DSO) with data fields that areoverwritten. If errors occur, all subsequent data records with the same key are written to the error stack along withthe incorrect data record.This guarantees the serialization of the data records, and consistent data processing. The serialization of the datarecords and thus the explicit definition of key fields for the error stack are not relevant for targets that are notupdated by overwriting like Info Cube.The fields in the source can be enabled in the semantic group definition as per the below rules:
By default, all fields in the source that are uniquely assigned to a key field of the target DSO in thetransformation are checked in the semantic group screen.
The fields whose assignment is not unique are not checked by default, but can be enabled.
The fields in source which are assigned to the data field in the target DSO cannot be checked.
The fields whose assignment is not unique are not checked by default, but can be enabled.
The fields in source which are assigned to the data field in the target DSO cannot be checked.
Step5:Settings for Error Stack
Also the DTP Error Stack settings can be modified by clicking on the Goto Settings for DTP Temporary Storageof the DTP.The various options available in the Settings for Temporary Storage are as given below:1. Delete Temporary Storage ± To delete the records in the Error Stack as per below conditions:-
With Request Status Green
With Request Status Red
After days2. Level of Detail - you specify how you want to track the transformation.3. Fill Temporary Storage - you specify the processing steps after which you want the system totemporarily store the DTP request (such as extraction, filtering, removing new records with the same key and transformation)
transformation)
Step 5:Execute the DTP load
Save and activate the DTP after the settings are completed. Execute the DTP to load the data from the PSA to thedata target. If there are erroneous records in the data load, they are collected in the error stack.You can access the error stack by clicking on the error stack on top of DTP.
Step6: Validate Erroneous records in Error Stack
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.Validate and correct the erroneous records similar to editing the PSA and save the records.
Step 7: Create and execute the Error DTP
Click on the Creating Error DTP on the Update tab of DTP to move data from error stack to the target. With anerror DTP, you can update the data records to the target manually or by means of a process chain. The error DTPuses the full update mode to extract data from the error stackOnce the data records have been successfully updated, they are deleted from the error stack. If there are anyerroneous 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.
Execute the Normal DTP From the below screen shot you can check that 4 records having incorrect data went into ERROR STACK and 2records got updated to DSO.
Check the Manage screen
Check theERROR STACK data
Below are the 4 erroneous records.
Correct the ERROR STACK data.
records.Correct the ERROR STACK data.
Execute ERROR DTP Load the corrected data from ERROT STACK to Data Target through executing ERROR DTP.
7. Activate the Request.
The two requests are available in manage of DSO one from Normal DTP, other with ERROR DTP.
Error DTP in the Administrator Workbench
The two requests are available in manage of DSO one from Normal DTP, other with ERROR DTP.
Error DTP in the Administrator Workbench
Result:
You can use the data transfer process to update the data to the target destination once the error is resolved.
No comments:
Post a Comment