Handling Data Records with Errors

Using the Error Handling function on the Update Parameters tab page in the Scheduler, you have the option of controlling the behavior of the BW system if incorrect data records occur in the data flow with 3.x objects (use of transfer and update rules) when you are loading data using the PSA.

The system checks for incorrect data records:

in the transfer rules
in the update rules
when data is updated into the master data, text, or hierarchy tables
when data is updated to the InfoCube
when checking for referential integrity within an InfoObject against the master data tables or DataStore objects on the communication structure level.

Features

Incorrect records arising in transfer rules, update rules, when updating to a data target, or when checking for referential integrity, are highlighted and returned to the error handler. The error handler locates the original PSA records and writes the corresponding log. This function is as yet unavailable for updating to DataStore objects.

You can control how the system responds to incorrect data records using the Error Handling function on the Update Parameters tab page in the Scheduler.

Activities

Define how the system should react to incorrect data records:
a. No update, no reporting (default)

If errors occur, the system terminates the update of the entire data package. The request is not released for reporting. However, the system continues to check the records.

b. Update valid records, no reporting (request red)

This option allows you to update valid data. However, this data is only released for reporting after the administrator checks the incorrect records that are not updated and manually releases the request (by a QM action; that is, setting the Overall status on the Status tab page in the monitor).

c. Update valid records, reporting possible

Valid records can be reported immediately. Automatic follow-up actions, such as adjusting the aggregates, are also carried out.

Note

With option a) the incorrect records are marked in red in the PSA maintenance. You can display the relevant error messages amodally, edit the records, and update the request manually. If it was not possible to write into the PSA (hierarchy or transfer method IDoc), an application log is written instead.

With options b) and c) a new request that is only read into the PSA is formed from the incorrect records. Here you can edit the records of the new request in the PSA and start the update manually.

If errors arise when an InfoCube is updated, new requests are generated for incorrect records for each InfoCube combination. Among these requests, the incorrect records are updated to the PSA. These new requests have the InfoCubes for which there were incorrect records as their data targets. If, for example, a record was updated to two InfoCubes by mistake, a request is generated for this record that contains both InfoCubes as data targets. In the PSA tree, the requests appear as successfully updated to the PSA. These new requests can then be updated to the InfoCubes again.

End of the note.
Specify the maximum number of incorrect data records that are allowed before the system terminates the load process. You can display the errors arising up to that point in the PSA. If you do not enter after how many incorrect records termination should occur, the handling of incorrect data records is not active and the update will terminate after the first error.
Select how the BW system should react when the number of data records received by the BW does not match the number of data records updated in the BW.
There can be a difference between the number of records received and updated. This can occur
- in the transfer rules
- in the update rules
- when updating.
Records are sorted, aggregated, or added.

If you set the No Aggregation Permitted indicator, the request is evaluated as incorrect if the number of records received does not match the number of records updated.

Note

Independently of this indicator, an error arises when the number of records selected does not match the number of records received in BW.

End of the note.

Result

The monitor notifies the user of the relevant error case and enables a direct navigation into the PSA or the respective error request.

If you want to continue processing the incorrect data records in a program that you have written yourself, you can use the method GET_ERRORS of class CL_RSSM_ERROR_HANDLER. How to use this method is documented in program RS_ERRORLOG_EXAMPLE.