Question:
Hi Bw Gurus,
Loading a new init (january 2004) into a ods object (with multiple inits) failed due to the delta queue was not empty. When trying to reverse the init the total status of the init load was faulty set to green instead of red in minitor. Another delta was requested but failed due to the init load was not in place. (It had been deleted from the ods)
We have now set the total status to red of that init load and requested a new delta from the source system, but it still fails during activation due to that the init has a smaller SID and your are asked to set it to red (it is) so that the system ignores the request.
We have tried different workarounds building new ods object and loading data form either the psa (reconstruct) or a full load form the old ods.
The first option fails when activated still due to the bad init of the old ods.
The second options we're not able to get initialised without having impact on the R/3 side and that we will try to avoid for the time being.
We have also emptied the deltaqueue (only into the psa) and tried to delete the initload on the infopackage, but it will only delete them all.
Our objective is to get back on track, which is running delta to this ods. Then run a new init for january after emptying the deltaqueue.
Any suggestions of what to do and does anyone now a quick backdoor with the tables involved in the checking process of init and deltas.
Regards,
Resjek
Answer:
Hi,
I'll share our solution, unfortunately it was not possible to revert the metadatamodel, so that Bw and R3 would discharge the initload that faulty was set to green, insted of red.
Due to the poor performance on the CRM (R3) side it takes 45 min. to load 5-7 days of data (we got 2 years), we wanted to avoid a new initialization and reload. We had focus on getting rid of the faulty initload. Since thats was not an option here is what we did:
Case: The initload (january) failed but was set to green and the data is lacking in BW. On the Crm (R3) side the delta queue is collection data on january.
1) Close for users on CRM.
2) Empty the deltaqueue to PSA.
3) Make a new ods equal to original
4) Full load the missing data for Januar from CRM (R3) into new ods.
4.1) Open for users on CRM
5) Change the updaterule of the original ods and so that it deletes january delta data (From the collected requests, between the init and the new full load (of january) ).
6) Make an init update from the new ods (full load january) to the original ods.
7) Reconstruct the deltaloads from between Init load and full load (in psa) into the original ods.
Change the delta infopackage to only update the original ods.
9) Turn off on the new ods automatic processing "Update data targets from ods object"
10) Delete all the data in related Cubes.
11) Make a new initialisation of the cube from the original ods.
12) Request a new delta.
Hope this will help someone, that likes a green light better than the red
Regards,
Resjek