Post DB upgrade-PC error
We are upgrading to BI 7.0. For this we upgraded our DB first to Oracle 10.2.0.2.0.
Post DB upgrade in production we are facing 2 errors in the process chains.
1. Process chain fails at step Roll up of aggregates
The actual aggregation happens in the cube and data load does not fail in the cube. Problem is in process chain at step roll up of aggregats. The step becomes RED and PC stops. Those PC are failing in which cubes having aggregates are used.
2. Delete Overlapping request.
When full load is done to a cube from the ODS, we delete the previous request. The PC chain is failing at step where the overlapping requests are deleted.
We are facing these errors post DB upgrade and the DB upgrade does not show any error logs and was successful.
Appreciate your input towards any pointers.