ERRORS FOUND RETRIEVING DATA FROM BPC REPORT DURING LIGHT OPTIMIZATION
My understanding is that Lite Optimization doesn’t take the system offline, and can be scheduled during normal business activity (e.g. after a data load). So my expectation is that users can run reports on a cube/application even if a light optimization is running on that cube e.g. I thought I read something about temp tables created behind the scenes by BPC during the light optimization / compressions to make the light optimization process transparent to the end users.
We are on BW 73005 and BPC NW 7.50.12 and when running a report with EVDRE during BPC LIGHT optimization we get error message "BPC ERRORS FOUND RETRIEVING DATA". The application log also shows an MDX statement error:"Due to cube /CPMB/xxx being locked, query cannot be executed"
Is is standard/expected behavior that BPC users cannot run/expand a report (with EVDRE) during a BPC light optimization ?
- If yes, are there any workarounds (other than not scheduling the light optimization during business hours) ?
- If not, any suggestions to resolve/prevent this error.
We opened an OSS Message with SAP and heard back from SAP with OSS note 1649749 - Poor performance or data sent or retrieved incorrectly (attached):
"When an optimization is in progress for a BPC application, you face one or more of the below issues:
- Fail to post data to the application;
- Data is incorrectly retrieved;
- Poor Performance when excuting some BPC functions, for example, Input Schedule or Report;
- Loading data to the cube via Data Manager Package ends with error.
Reason and Prerequisites
When the optimization is in progress for the application, the real-time mode is changed and writing data to the cube is not allowed. Also other complex processes are being performed (like Compress, Update statistics etc.) and reading data from the cube is slow, even worse it may get incorrect result.
Solution: Please wait until the optimization finishes, and then do the Input Schedule, Report and data loading. Generally, we recommend the optimization being scheduled to run when system is free (for example, in the evening), which is commonly used in business scenarios."