/scripts/ahub.form.attachments.js
0

AOC00041 When query doesn't return cells

Dec 11, 2016 at 01:19 PM

86

avatar image
Former Member

Hello everybody,

We use MS Analysis Services 2012 as our reporting DB.

Evertime an user modify an Olap and inputs bad filter options, we get an AOC00041 error.

For instance, the user is browsing data from the user "Jhonny" in "2012".

When he changes to see the data from user "Lyla" in "2012" the error AOC00041 appears, because Lyla wasn't working before "2013" and the query returns null.

This is very frustating for the user, because everytime it looks like there is a problem in the server, when in fact he should just see an empty screen.

Here's the complete error messagem:

An error occurred in the MDAS service while processing a request from Analysis, edition for OLAP. Try the operation again. If the problem persists, please contact your administrator. (AOC00041)
Details
Failed to get representation: RuntimeException occurred : java.lang.NullPointerException: while trying to invoke the method com.businessobjects.multidimensional.data.provider.queryview.resultset.export.data.WindowData.getTuple(int, int) of a null object returned from com.businessobjects.multidimensional.data.provider.queryview.resultset.export.OdaProviderResultSetMx.getWindowData()

And here's what the user gets:

erro-sap.png (98.3 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Tammy Powlas
Dec 11, 2016 at 08:11 PM
0

Hi - it looks like you to need to apply some patches per SAP Note https://launchpad.support.sap.com/#/notes/2377758/E

Share
10 |10000 characters needed characters left characters exceeded
Skip to Content