BW Gurus,
I need your help on this, as this is a Production issue.
Deltas for an ODS were running fine until last Sunday. Our BASIS team has applied SP12, and one of the delta for an ODS failed on sunday and monday night. We saw the below error message in production while navigating thru the issue.
Diagnosis: DataSource xxx_DO01 does not have the same status as the source system in the Business Information Warehouse.
The time stamp in the source system is xx.xx.2007 xx:xx:xx (some numbers)
The time stamp in the BW system is yy.yy.2007 yy:yy:yy. (The timestamps are not same).
System Response: The load process has been terminated.
Procedure: Copy the DataSource again and then activate the transfer rules that belong to it. You have to activate the transfer rules in every case, even if they are stilll active after teh DataSource has been copied.
I have deleted the 2 RED requests in ODS, and did repeat delta, and it brougt 0 records and changed the request to RED status. I deleted this request too.
My plan is to do to full load with repair request and after that hoping that deltas will work fine. I checked all the datafileds to be in Overwrite mode in ODS, so guessing to run FULL load with repair request. There are abour 6-7million records in R/3, and does my Fullload with repair request brings all these records into BW? or Is there a better way to handle this issue
This ODS later needs to update 2 ODSs and 2Infocubes. Can someone please help me up with this issue?
Thanks in advance!