cancel
Showing results for 
Search instead for 
Did you mean: 

ERRORS FOUND RETRIEVING DATA FROM BPC REPORT DURING LIGHT OPTIMIZATION

Former Member
0 Kudos

Good morning:

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.

 

Thank you,

Catherine

Accepted Solutions (1)

Accepted Solutions (1)

former_member210696
Active Contributor
0 Kudos

Hi Catherine,

The simple reason which I can think of is that during lite optimization, records are being compressed (if at all multiple records for same key exists) plus there are other things like deletion of infocube statistics, movement of records from E to F table, etc. So, when you execute a report/input shedule at the same time, the system is unable to retrieve data.

Not sure about workarounds, I doubt there is one except that schedule optimization during non-business hours.

Hope it helps!!

Former Member
0 Kudos

Hi Ashish:

Thank you for your response. Technically speaking I understand the need for database table locks during the optimization process.

Still have my doubts about the behavior being expected/normal:

1. Why does SAP market that light optimization doesn’t take the system offline and can be scheduled during normal business activity. That is misleading and there is documentation of the limitation e.g. no reporting available during light optimization.

2. You would think that SAP would have developed a workaround in the BPC code e.g. I could be mistaking but thought I read about some temp tables created behind the scenes by BPC during the light optimization / compressions to make the light optimization process transparent to the end users.

3. Light optimization can be construed as counterproductive by the BPC user; you want to optimize BPC but may not be able to run a query or take the risk to lose the planning data that you entered. Not to mention the error message (errors found retrieving data) which may lead the users to believe that BPC is "broken". At least the message could be more user friendly and explicit e.g. "BPC is being optimized, please try your queries again and do not attempt to enter planning data to avoid potential loss of data".

1. Within BPC I am not sure there is user messages like there is in SAP to warn them that optimization is running and that queries may not be available and data input may be lost?

2. Anybody knows if this limitation will be adressed in future service packs or versions? May be BPC version 10?

Thank you,

Catherine

former_member210696
Active Contributor
0 Kudos

Hi Catherine,

I have access to BPC 7.5 NW SP12, and BPC 10 NW Sp06 systems.

I tested that during lite optimization, I was able to create reports/open existing reports without any error message. And, the reports were giving me the correct data.

So, I can not surely say that if there is actually any such limitation or not. What I suggest is that you raise an OSS note with SAP probably to get clear understanding if you don't find enough information here on net.

Hope it helps!!

Former Member
0 Kudos

Good morning Ashish:

Thank you for taking the time to replicate and test this scenario in both of your BPC systems.

I opened an OSS note with SAP and will let you know if/when I have an update by adding to this post.

Thank you again for your help and taking time out of your day to work on my question,

Catherine

Former Member
0 Kudos

Good morning:

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."

former_member210696
Active Contributor
0 Kudos

Many thanks for sharing.

Former Member
0 Kudos

Good morning Ashish:

Good to hear form you again and following up on this issue til closure.

By the way, I forgot to include from the same note that "If you are using Oracle DB based BW system, there may be no above issues, please refer below link for details:

http://help.sap.com/saphelp_bw30b/helpdata/en/ca/aa6437e7a4080ee10000009b38

f842/content.htm

That would explain why I (on SQL DB) am experiencing the issue and you are not (I assume you are on Oracle DB).

Hope that our paths cross again,

Catherine

Former Member
0 Kudos

Hi Catherine

We have the same problem.  Having come from the MS environment where this isn't the case it is very frustrating.  Did you get a satifactory answer from SAP?

Thanks

Gayle

Answers (0)