Data load not immediatly available even though requests are green
We are running BW 7.01 SP5 and DB6 without BWA.
We have been experiencing a strange problem the last while. Intermittently, when we load data to an Info Provider, the data would load successfully and the request status is green (and active for ODS) and aggregates rolled up where required. When we then use the data immediately afterwards for subsequent loads or reports, not all the data is included. When we run the same loads or reports (with no changes except the time it was run) a while later, all the data is included.
We have checked the loads and there are no problems. As this is an intermittent problem and we only realise it has happened after the fact, we cannot duplicate the problem. We initially identified the problem as only affecting ODS's. The problem now seem to be affecting Cubes as well. The problem also occurs in both process chains and manual loads. The impression we are getting is that BW thinks the load is complete, but it is almost like the data has not been completely committed to the database.
Has anyone experienced similar issues? If so, has anoyone been able to resolve the issues without putting a wait in process chains or waiting for a while after a manual load. Any ideas on what we can try to resolve this problem?