Thursday, June 13, 2013

SAP BW 7.3 - New Feature: Automatically repeat red DTP requests in Process Chains

This is another cool nice feature in SAP BW 7.3. Sometimes DTP load fails with one off error messages like RFC connection error, missing packets, database connection issues etc. Usually these are resolved by repeating the failed DTP load. 
In BW 7.3 there is an option under execute tab which if you check will automatically repeat red requests in process chains. I think this is a cool feature and saves us time and effort in monitoring data loads. 

Below is F1 help on this option.

Automatically Repeat Red Requests in Process Chains

If a data transfer process (DTP) has produced a request containing errors during the previous run of a periodically scheduled process chain, this indicator is evaluated the next time the process chain is started.
If the indicator is set, the previous request that contains errors is automatically deleted and a new one is started.
If the indicator is not set, the DTP terminates and an error message appears explaining that no new request can be started until the previous request is either repaired or deleted.

Use

If you set the indicator, you reduce the administrative effort for process chains. Terminated process chains can repair themselves.

Dependencies

Note that if a delta update is carried out, the repaired request contains not only the data of the terminated request, but all data that has been added to the source since then. This can lead to both performance and consistency problems.

Example of a Consistency Problem:


A transfer that has the prerequisite that the data of only one day is transferred at a time, and that produces incorrect results, leads to consistency problems if, during the repair, the data of more than one day is to be transported at the same time.

No comments: