Voyager Issue

prakashsivaraj · Forum Member Joined: 17 Nov 2011 Posts: 16

We are facing a stability issues around Voyager when we try to view the cube data specifically when we try to apply the filter on the dimensions. The error message says as below

"The MDAS server encountered an error. (VYC00041)

Failed to create QueryResults instance. Failed to query cube view [CubeView]. SOFA error occured"

To be more specific, the error seems to occur when apply a filter or select the members from the dimension.

Environment details
BOE XI 3.1 SP4
Cubes in Oracle OLAP 11.2.0.1
Simba MDX Provider as the driver between Oracle OLAP and BO Vayager

Pls can you advise on the solution.

prakashsivaraj · Forum Member Joined: 17 Nov 2011 Posts: 16

The issue has been resolved after applying OLAP Patch B - 10130392

Marek Chladny · Posted: Tue Jan 17, 2012 9:38 am Post subject: Re: Voyager Issue

[Moderator Note: Moved from General Discussion to Other Products]

Grant_SA · Forum Member Joined: 28 May 2012 Posts: 1

Good Day,
I too am facing an issue in Analysis for OLAP workspace development, i tried finding the most relevant topic to voice my issue, and this one seemed most appropriate.
Im running BOBJ 4.0 SP2 Patch 10 and creating Analysis (for OLAP) Workspace's on a BEx Query (based in BW 7.1 patch 10).
On creation I am able to navigate to the query (which is based on a multiprovider) and then select and run it. The prompt appears, and after after entering the prompt variables I am able to execute the report and a result set appears. All looks as it should and everything (including data) has pulled through correctly. The error i get appears as soon as i try and pull in a free characteristic into either the rows or columns. it gives me the following message, "The requested operation could not be performed because it puts the query into an invalid state." (screenshot attached). I looked through the Error Documentation on the service portal and that message is said to suggest that there is a issue with the Hierarchies im pulling into the Rows/Columns, another document suggested that im trying to pull all the dimensions into one axis. Both of these "causes" do not apply to my scenario as I havent got any Free Characteristics/Dimensions with hierarchies on it, and I am definitely not pulling in all the dimensions into one axis (as seen in the screen shot). The query runs in BEx analyzer and works perfectly, and even if i strip the query to its bare minimum, the same issue occurs.

I AM STUMPED....

PLease could you assist.