Solution : https://service.sap.com/sap/support/notes/873694 (SAP Service marketplace login required)
Summary :
SAP Note clarifies handling delta and repeat requests in SAP BW systems to manage data load operations effectively. Repeat requests can lead to duplicates when the prior delta request failed, as evidenced by a red status in the load monitor. The note specifies workflows depending on whether the failure occurs during extraction or monitoring processes. Critical steps involve validating the status of the last delta using QM action, checking messages from the extractor, and confirming request entries in the ROOSPRMSC table. It outlines procedural corrections when the finished deltas haven't completed, ensuring the accuracy and sequence of data load into the data targets like ODS.
Key words :
data mart update process, datasource source system combination, datasource/source system combination, source data mart exists, datasource/target system combination, red delta request terminated, green delta/repeat request, data mart indicator, delta update terminates, prerequisites consulting solution
Related Notes :
| 1607601 | FAQ: Delta Errors |
| 902584 | P30:P7:MON: DM status check before setting request to GREEN |
| 836439 | SAPBWNews BW Support Package 14 NW'04 Stack 14 RIN |
| 783253 | SAPBWNews BW 3.1 Content Support Package 23 |
| 783251 | SAPBWNews BW 3.0B Support Package 29 |
| 380078 | FAQ: BW delta queue (RSA7): Questions and answers |