The SAS Output Delivery System and reporting techniques

Information Maps with Cubes are failing

Reply
Frequent Contributor
Posts: 115

Information Maps with Cubes are failing

I created some information maps that feed off some cubes.
They were working but today they all return this error:

Exception while executing MDX query. [ com.sas.storage.olap.OLAPException: Insufficient memory [ org.omg.CORBA.NO_MEMORY: Insufficient memory ] ] ] ] ]

Any Ideas?

Below is the complete error.



com.sas.iquery.dataretrieval.DataRetrievalException: Exception occurred while attempting to access data. [ com.sas.iquery.dataretrieval.DataRetrievalException: Exception occurred when retrieving the ResultSet. [ com.sas.iquery.dataretrieval.DataRetrievalException: Unable to execute query. [ com.sas.iquery.execution2.ExecutionException: Exception while executing MDX query. [ com.sas.storage.olap.OLAPException: Insufficient memory [ org.omg.CORBA.NO_MEMORY: Insufficient memory ] ] ] ] ]
at com.sas.iquery.dataretrieval.SimpleQueryConnector.retrieveQueryResultMap(Unknown Source)
at com.sas.iquery.dataretrieval.SimpleQueryConnector.retrieveQueryResultMap(Unknown Source)
at com.sas.storage.iquery.BusinessQueryToOLAPDataSetAdapter.buildOLAPDataSet(BusinessQueryToOLAPDataSetAdapter.java:1167)
at com.sas.storage.iquery.BusinessQueryToOLAPDataSetAdapter.init(BusinessQueryToOLAPDataSetAdapter.java:1377)

Exception occurred while attempting to access data.

java.lang.IllegalStateException: Exception occurred while attempting to access data.
at com.sas.storage.iquery.BusinessQueryToOLAPDataSetAdapter.buildOLAPDataSet(BusinessQueryToOLAPDataSetAdapter.java:1192)
at com.sas.storage.iquery.BusinessQueryToOLAPDataSetAdapter.init(BusinessQueryToOLAPDataSetAdapter.java:1377)
at com.sas.storage.iquery.BusinessQueryToOLAPDataSetAdapter.setModel(BusinessQueryToOLAPDataSetAdapter.java:247)
at com.sas.storage.iquery.BusinessQueryToOLAPDataSetAdapter.(BusinessQueryToOLAPDataSetAdapter.java:191)
at com.sas.storage.iquery.BusinessQueryToOLAPDataSetAdapter.(BusinessQueryToOLAPDataSetAdapter.java:167)
at com.sas.apps.mapStudio.visuals.testQuery.Test.makeTableWidget(Test.java:226)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)
at com.sas.apps.mapStudio.visuals.util.ProgressThread$TaskThread.run(ProgressThread.java:286)
SAS Super FREQ
Posts: 8,745

Re: Information Maps with Cubes are failing

Hi:
Information maps and cubes have little or nothing to do with ODS and Base SAS Reporting. Your best bet for help with this is to open a track with Tech Support.

cynthia
Ask a Question
Discussion stats
  • 1 reply
  • 157 views
  • 0 likes
  • 2 in conversation