Hi Folks,
I have created a simple dynamic cube with 2 dimension (Product, Location) and one measure and I am trying to access it using the Analysis studio but I am getting this error
XQE-GEN-0002 An unexpected exception occurred: JVMVRFY036 stack underflow; class=com/cognos/xqe/runtree/olap/mdx/rolapprovider/ROLAPQueryStrategy, method=executeAndFetchFromStore(Lcom/cognos/xqe/runtree/olap/mdx/interpreter/CrossJoinedSet;Lcom/cognos/xqe/runtree/olap/mdx/interpreter/IResultSet;Lcom/cognos/xqe/metadata/ICube;)V, pc=580
I am using Cognos 10.2.1 FP 1 and I have set the report execution mode to 64 bit in the Cognos Configuration, I have also added the dynamic cube in the query service and I have started it and it shows as available.
Has anybody faced such issue?
Regards
Ravi Ahuja.
Hard to tell with so little data, but let's give it a go anyway.
The error you're getting indicates to me that there's something wring with the underlying datasource. Here's a few things to check:
1. Did you define relationships properly in Dynamic Cube Designer? When you test the different cube component in cube designer, do you get any errors?
2. When you test the data source using DQM, do you get any errors?
3. Try to query the same elements relationaly in both CQM and DQM (Create a relational package over the datasource with the same dims/measure, and publish it once in CQM and once in DQM). Are there any errors?
4. Can you run a simple Report Studio report based on the Dynamic Cube?