Delta load fail
We have a daily delta load from R3 system to bw and last two days it is failing.
fist day I got the message says 'S:RD:145 RSC2_QOUT_CONFIRM_DATA
Errors in source system'. and to day also it failed, and giving the errors says 'Delta request REQU_47NL55DI7EYSVSR1R531HVT3H is incorrect in the
monitor. A repeat needs to be requested. Data target ZCOPA_1 still includes delta request REQU_47NL55DI7EYSVSR1R531HVT3H. ....
What I have to do? please help me
rajesh reddy replied
This is a PERFORMANCE related ISSUE with all the CO -Extractors.
As a part of sanity check -
1) Make sure that indexes 1 and 4 delivered by SAP on the database for the table COEP are active in the form delivered in the standard system. In the standard system, index 4 is not delivered as active and must be manually activated by the customer when using the CO Delta DataSources (see documentation on the InfoSource in the BW content).
2. Make sure that indexes defined by the customer do not interfere with the selection. The customer is responsible for these indices. Analysis and elimination of performance problems caused by these indexes is subject to a fee.
3. When you use the Oracle Cost-Based Optimizers:
Check whether current and precise statistics exist for tables COEP and COBK. It may be possible to solve the problem by refreshing the statistics.
Hope this helps.......