BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi experts,

I am new to the SAS tool. I am working with SAS Web OLAP Viewer. I have successfully created a cube using SAS OLAP Cube Studio. But, i could not able to browse the cube in the SAS Web OLAP Viewer. It is throwing me the following error,


1. Cause:
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.servlet.tbeans.dataexplorer.html.DataViewer.getOLAPBusinessQueryAdapter(DataViewer.java:2990)
at com.sas.servlet.tbeans.dataexplorer.html.VisualDataExplorerMenuBar.setFilterAttributes(VisualDataExplorerMenuBar.java:167)
at com.sas.servlet.tbeans.dataexplorer.html.VisualDataExplorerMenuBar.writeMenuBar(VisualDataExplorerMenuBar.java:530)
at com.sas.servlet.tbeans.dataexplorer.html.VisualDataExplorerMenuBar.write(VisualDataExplorerMenuBar.java:507)
at com.sas.util.SimpleTemplateToPrintWriter.writeValue(SimpleTemplateToPrintWriter.java:294)
at com.sas.util.SimpleTemplateToPrintWriter.writeToken(SimpleTemplateToPrintWriter.java:259)
at com.sas.util.SimpleTemplateToPrintWriter.writeVar(SimpleTemplateToPrintWriter.java:318)
at com.sas.util.SimpleTemplateToPrintWriter.writeToken(SimpleTemplateToPrintWriter.java:275)
at com.sas.util.SimpleTemplateToPrintWriter.writeText(SimpleTemplateToPrintWriter.java:335)
at com.sas.util.SimpleTemplateToPrintWriter.write(SimpleTemplateToPrintWriter.java:355)
at com.sas.util.SimpleTemplateToPrintWriter.write(SimpleTemplateToPrintWriter.java:389)
at com.sas.util.SimpleTemplateToPrintWriter.write(SimpleTemplateToPrintWriter.java:364)
at com.sas.servlet.tbeans.TemplateSupport.writeTemplate(TemplateSupport.java:211)
at com.sas.servlet.tbeans.BaseCompositeTransformation.writeTemplate(BaseCompositeTransformation.java:268)
at com.sas.servlet.tbeans.BaseActionCompositeTransformation.writeTemplate(BaseActionCompositeTransformation.java:291)
at com.sas.servlet.tbeans.dataexplorer.html.VisualDataExplorer.write(VisualDataExplorer.java:1555)
at com.sas.webapp.dataexplorer.VisualDataExplorerAction.execute(VisualDataExplorerAction.java:414)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:465)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1422)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:505)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176)
at java.security.AccessController.doPrivileged(AccessController.java:-2)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172)
at com.sas.webapp.dataexplorer.AuthenticationFilter.doFilter(AuthenticationFilter.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176)
at java.security.AccessController.doPrivileged(AccessController.java:-2)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172)
at com.sas.servlet.filters.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:62)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176)
at java.security.AccessController.doPrivileged(AccessController.java:-2)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530)
at java.lang.Thread.run(Thread.java:534)

Which was caused by: 2. Cause:
Exception occurred while attempting to access data.

at com.sas.iquery.dataretrieval.SimpleQueryConnector.retrieveQueryResultMap(null:119)
at com.sas.iquery.dataretrieval.SimpleQueryConnector.retrieveQueryResultMap(null:139)
at com.sas.storage.iquery.BusinessQueryToOLAPDataSetAdapter.buildOLAPDataSet(BusinessQueryToOLAPDataSetAdapter.java:1167)
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.servlet.tbeans.dataexplorer.html.DataViewer.getOLAPBusinessQueryAdapter(DataViewer.java:2990)
at com.sas.servlet.tbeans.dataexplorer.html.VisualDataExplorerMenuBar.setFilterAttributes(VisualDataExplorerMenuBar.java:167)
at com.sas.servlet.tbeans.dataexplorer.html.VisualDataExplorerMenuBar.writeMenuBar(VisualDataExplorerMenuBar.java:530)
at com.sas.servlet.tbeans.dataexplorer.html.VisualDataExplorerMenuBar.write(VisualDataExplorerMenuBar.java:507)
at com.sas.util.SimpleTemplateToPrintWriter.writeValue(SimpleTemplateToPrintWriter.java:294)
at com.sas.util.SimpleTemplateToPrintWriter.writeToken(SimpleTemplateToPrintWriter.java:259)
at com.sas.util.SimpleTemplateToPrintWriter.writeVar(SimpleTemplateToPrintWriter.java:318)
at com.sas.util.SimpleTemplateToPrintWriter.writeToken(SimpleTemplateToPrintWriter.java:275)
at com.sas.util.SimpleTemplateToPrintWriter.writeText(SimpleTemplateToPrintWriter.java:335)
at com.sas.util.SimpleTemplateToPrintWriter.write(SimpleTemplateToPrintWriter.java:355)
at com.sas.util.SimpleTemplateToPrintWriter.write(SimpleTemplateToPrintWriter.java:389)
at com.sas.util.SimpleTemplateToPrintWriter.write(SimpleTemplateToPrintWriter.java:364)
at com.sas.servlet.tbeans.TemplateSupport.writeTemplate(TemplateSupport.java:211)
at com.sas.servlet.tbeans.BaseCompositeTransformation.writeTemplate(BaseCompositeTransformation.java:268)
at com.sas.servlet.tbeans.BaseActionCompositeTransformation.writeTemplate(BaseActionCompositeTransformation.java:291)
at com.sas.servlet.tbeans.dataexplorer.html.VisualDataExplorer.write(VisualDataExplorer.java:1555)
at com.sas.webapp.dataexplorer.VisualDataExplorerAction.execute(VisualDataExplorerAction.java:414)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:465)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1422)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:505)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176)
at java.security.AccessController.doPrivileged(AccessController.java:-2)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172)
at com.sas.webapp.dataexplorer.AuthenticationFilter.doFilter(AuthenticationFilter.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176)
at java.security.AccessController.doPrivileged(AccessController.java:-2)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172)
at com.sas.servlet.filters.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:62)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176)
at java.security.AccessController.doPrivileged(AccessController.java:-2)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530)
at java.lang.Thread.run(Thread.java:534)

Which was caused by: 3. Cause:
Exception occurred when retrieving the ResultSet.

at com.sas.iquery.dataretrieval.QueryExecutor.execute(null:37)
at com.sas.iquery.dataretrieval.SimpleQueryConnector.processIQI(null:150)
at com.sas.iquery.dataretrieval.QueryConnector.processIQI(null:70)
at com.sas.iquery.dataretrieval.SimpleQueryConnector.retrieveQueryResultMap(null:109)
at com.sas.iquery.dataretrieval.SimpleQueryConnector.retrieveQueryResultMap(null:139)
at com.sas.storage.iquery.BusinessQueryToOLAPDataSetAdapter.buildOLAPDataSet(BusinessQueryToOLAPDataSetAdapter.java:1167)
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.servlet.tbeans.dataexplorer.html.DataViewer.getOLAPBusinessQueryAdapter(DataViewer.java:2990)
at com.sas.servlet.tbeans.dataexplorer.html.VisualDataExplorerMenuBar.setFilterAttributes(VisualDataExplorerMenuBar.java:167)
at com.sas.servlet.tbeans.dataexplorer.html.VisualDataExplorerMenuBar.writeMenuBar(VisualDataExplorerMenuBar.java:530)
at com.sas.servlet.tbeans.dataexplorer.html.VisualDataExplorerMenuBar.write(VisualDataExplorerMenuBar.java:507)
at com.sas.util.SimpleTemplateToPrintWriter.writeValue(SimpleTemplateToPrintWriter.java:294)
at com.sas.util.SimpleTemplateToPrintWriter.writeToken(SimpleTemplateToPrintWriter.java:259)
at com.sas.util.SimpleTemplateToPrintWriter.writeVar(SimpleTemplateToPrintWriter.java:318)
at com.sas.util.SimpleTemplateToPrintWriter.writeToken(SimpleTemplateToPrintWriter.java:275)
at com.sas.util.SimpleTemplateToPrintWriter.writeText(SimpleTemplateToPrintWriter.java:335)
at com.sas.util.SimpleTemplateToPrintWriter.write(SimpleTemplateToPrintWriter.java:355)
at com.sas.util.SimpleTemplateToPrintWriter.write(SimpleTemplateToPrintWriter.java:389)
at com.sas.util.SimpleTemplateToPrintWriter.write(SimpleTemplateToPrintWriter.java:364)
at com.sas.servlet.tbeans.TemplateSupport.writeTemplate(TemplateSupport.java:211)
at com.sas.servlet.tbeans.BaseCompositeTransformation.writeTemplate(BaseCompositeTransformation.java:268)
at com.sas.servlet.tbeans.BaseActionCompositeTransformation.writeTemplate(BaseActionCompositeTransformation.java:291)
at com.sas.servlet.tbeans.dataexplorer.html.VisualDataExplorer.write(VisualDataExplorer.java:1555)
at com.sas.webapp.dataexplorer.VisualDataExplorerAction.execute(VisualDataExplorerAction.java:414)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:465)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1422)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:505)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176)
at java.security.AccessController.doPrivileged(AccessController.java:-2)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172)
at com.sas.webapp.dataexplorer.AuthenticationFilter.doFilter(AuthenticationFilter.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176)
at java.security.AccessController.doPrivileged(AccessController.java:-2)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172)
at com.sas.servlet.filters.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:62)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176)
at java.security.AccessController.doPrivileged(AccessController.java:-2)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530)
at java.lang.Thread.run(Thread.java:534)

Which was caused by: 4. Cause:
Unable to execute query.

at com.sas.iquery.strategies.sas.oma.AbstractStrategy.prepareData(null:169)
at com.sas.iquery.strategies.sas.oma.AbstractStrategy.retrieveQueryResultMap(null:69)
at com.sas.iquery.strategies.sas.oma.AbstractStrategy.retrieveResultSet(null:98)
at com.sas.iquery.dataretrieval.QueryExecutor.execute(null:35)
at com.sas.iquery.dataretrieval.SimpleQueryConnector.processIQI(null:150)
at com.sas.iquery.dataretrieval.QueryConnector.processIQI(null:70)
at com.sas.iquery.dataretrieval.SimpleQueryConnector.retrieveQueryResultMap(null:109)
at com.sas.iquery.dataretrieval.SimpleQueryConnector.retrieveQueryResultMap(null:139)
at com.sas.storage.iquery.BusinessQueryToOLAPDataSetAdapter.buildOLAPDataSet(BusinessQueryToOLAPDataSetAdapter.java:1167)
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.servlet.tbeans.dataexplorer.html.DataViewer.getOLAPBusinessQueryAdapter(DataViewer.java:2990)
at com.sas.servlet.tbeans.dataexplorer.html.VisualDataExplorerMenuBar.setFilterAttributes(VisualDataExplorerMenuBar.java:167)
at com.sas.servlet.tbeans.dataexplorer.html.VisualDataExplorerMenuBar.writeMenuBar(VisualDataExplorerMenuBar.java:530)
at com.sas.servlet.tbeans.dataexplorer.html.VisualDataExplorerMenuBar.write(VisualDataExplorerMenuBar.java:507)
at com.sas.util.SimpleTemplateToPrintWriter.writeValue(SimpleTemplateToPrintWriter.java:294)
at com.sas.util.SimpleTemplateToPrintWriter.writeToken(SimpleTemplateToPrintWriter.java:259)
at com.sas.util.SimpleTemplateToPrintWriter.writeVar(SimpleTemplateToPrintWriter.java:318)
at com.sas.util.SimpleTemplateToPrintWriter.writeToken(SimpleTemplateToPrintWriter.java:275)
at com.sas.util.SimpleTemplateToPrintWriter.writeText(SimpleTemplateToPrintWriter.java:335)
at com.sas.util.SimpleTemplateToPrintWriter.write(SimpleTemplateToPrintWriter.java:355)
at com.sas.util.SimpleTemplateToPrintWriter.write(SimpleTemplateToPrintWriter.java:389)
at com.sas.util.SimpleTemplateToPrintWriter.write(SimpleTemplateToPrintWriter.java:364)
at com.sas.servlet.tbeans.TemplateSupport.writeTemplate(TemplateSupport.java:211)
at com.sas.servlet.tbeans.BaseCompositeTransformation.writeTemplate(BaseCompositeTransformation.java:268)
at com.sas.servlet.tbeans.BaseActionCompositeTransformation.writeTemplate(BaseActionCompositeTransformation.java:291)
at com.sas.servlet.tbeans.dataexplorer.html.VisualDataExplorer.write(VisualDataExplorer.java:1555)
at com.sas.webapp.dataexplorer.VisualDataExplorerAction.execute(VisualDataExplorerAction.java:414)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:465)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1422)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:505)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176)
at java.security.AccessController.doPrivileged(AccessController.java:-2)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172)
at com.sas.webapp.dataexplorer.AuthenticationFilter.doFilter(AuthenticationFilter.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176)
at java.security.AccessController.doPrivileged(AccessController.java:-2)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172)
at com.sas.servlet.filters.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:62)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176)
at java.security.AccessController.doPrivileged(AccessController.java:-2)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530)
at java.lang.Thread.run(Thread.java:534)

Which was caused by: 5. Cause:
Exception while executing MDX query.

at com.sas.iquery.execution.instructions.OLAPDataSetFactory.getDataSet(null:132)
at com.sas.iquery.execution.instructions.MDXInstruction.execute(null:66)
at com.sas.iquery.execution.ExecutionProcessor.execute(null:60)
at com.sas.iquery.strategies.sas.oma.AbstractStrategy.prepareData(null:161)
at com.sas.iquery.strategies.sas.oma.AbstractStrategy.retrieveQueryResultMap(null:69)
at com.sas.iquery.strategies.sas.oma.AbstractStrategy.retrieveResultSet(null:98)
at com.sas.iquery.dataretrieval.QueryExecutor.execute(null:35)
at com.sas.iquery.dataretrieval.SimpleQueryConnector.processIQI(null:150)
at com.sas.iquery.dataretrieval.QueryConnector.processIQI(null:70)
at com.sas.iquery.dataretrieval.SimpleQueryConnector.retrieveQueryResultMap(null:109)
at com.sas.iquery.dataretrieval.SimpleQueryConnector.retrieveQueryResultMap(null:139)
at com.sas.storage.iquery.BusinessQueryToOLAPDataSetAdapter.buildOLAPDataSet(BusinessQueryToOLAPDataSetAdapter.java:1167)
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.servlet.tbeans.dataexplorer.html.DataViewer.getOLAPBusinessQueryAdapter(DataViewer.java:2990)
at com.sas.servlet.tbeans.dataexplorer.html.VisualDataExplorerMenuBar.setFilterAttributes(VisualDataExplorerMenuBar.java:167)
at com.sas.servlet.tbeans.dataexplorer.html.VisualDataExplorerMenuBar.writeMenuBar(VisualDataExplorerMenuBar.java:530)
at com.sas.servlet.tbeans.dataexplorer.html.VisualDataExplorerMenuBar.write(VisualDataExplorerMenuBar.java:507)
at com.sas.util.SimpleTemplateToPrintWriter.writeValue(SimpleTemplateToPrintWriter.java:294)
at com.sas.util.SimpleTemplateToPrintWriter.writeToken(SimpleTemplateToPrintWriter.java:259)
at com.sas.util.SimpleTemplateToPrintWriter.writeVar(SimpleTemplateToPrintWriter.java:318)
at com.sas.util.SimpleTemplateToPrintWriter.writeToken(SimpleTemplateToPrintWriter.java:275)
at com.sas.util.SimpleTemplateToPrintWriter.writeText(SimpleTemplateToPrintWriter.java:335)
at com.sas.util.SimpleTemplateToPrintWriter.write(SimpleTemplateToPrintWriter.java:355)
at com.sas.util.SimpleTemplateToPrintWriter.write(SimpleTemplateToPrintWriter.java:389)
at com.sas.util.SimpleTemplateToPrintWriter.write(SimpleTemplateToPrintWriter.java:364)
at com.sas.servlet.tbeans.TemplateSupport.writeTemplate(TemplateSupport.java:211)
at com.sas.servlet.tbeans.BaseCompositeTransformation.writeTemplate(BaseCompositeTransformation.java:268)
at com.sas.servlet.tbeans.BaseActionCompositeTransformation.writeTemplate(BaseActionCompositeTransformation.java:291)
at com.sas.servlet.tbeans.dataexplorer.html.VisualDataExplorer.write(VisualDataExplorer.java:1555)
at com.sas.webapp.dataexplorer.VisualDataExplorerAction.execute(VisualDataExplorerAction.java:414)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:465)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1422)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:505)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176)
at java.security.AccessController.doPrivileged(AccessController.java:-2)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172)
at com.sas.webapp.dataexplorer.AuthenticationFilter.doFilter(AuthenticationFilter.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176)
at java.security.AccessController.doPrivileged(AccessController.java:-2)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172)
at com.sas.servlet.filters.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:62)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176)
at java.security.AccessController.doPrivileged(AccessController.java:-2)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530)
at java.lang.Thread.run(Thread.java:534)

Which was caused by: 6. Cause:
Metadata error - The specified metadata repository or schema does not define any cubes

at com.sas.storage.olap.sasmdx.OLAPDataSet.executeQuery(OLAPDataSet.java:341)
at com.sas.storage.olap.sasmdx.OLAPDataSet.executeQuery(OLAPDataSet.java:415)
at com.sas.iquery.execution.instructions.OLAPDataSetFactory.getDataSet(null:126)
at com.sas.iquery.execution.instructions.MDXInstruction.execute(null:66)
at com.sas.iquery.execution.ExecutionProcessor.execute(null:60)
at com.sas.iquery.strategies.sas.oma.AbstractStrategy.prepareData(null:161)
at com.sas.iquery.strategies.sas.oma.AbstractStrategy.retrieveQueryResultMap(null:69)
at com.sas.iquery.strategies.sas.oma.AbstractStrategy.retrieveResultSet(null:98)
at com.sas.iquery.dataretrieval.QueryExecutor.execute(null:35)
at com.sas.iquery.dataretrieval.SimpleQueryConnector.processIQI(null:150)
at com.sas.iquery.dataretrieval.QueryConnector.processIQI(null:70)
at com.sas.iquery.dataretrieval.SimpleQueryConnector.retrieveQueryResultMap(null:109)
at com.sas.iquery.dataretrieval.SimpleQueryConnector.retrieveQueryResultMap(null:139)
at com.sas.storage.iquery.BusinessQueryToOLAPDataSetAdapter.buildOLAPDataSet(BusinessQueryToOLAPDataSetAdapter.java:1167)
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.servlet.tbeans.dataexplorer.html.DataViewer.getOLAPBusinessQueryAdapter(DataViewer.java:2990)
at com.sas.servlet.tbeans.dataexplorer.html.VisualDataExplorerMenuBar.setFilterAttributes(VisualDataExplorerMenuBar.java:167)
at com.sas.servlet.tbeans.dataexplorer.html.VisualDataExplorerMenuBar.writeMenuBar(VisualDataExplorerMenuBar.java:530)
at com.sas.servlet.tbeans.dataexplorer.html.VisualDataExplorerMenuBar.write(VisualDataExplorerMenuBar.java:507)
at com.sas.util.SimpleTemplateToPrintWriter.writeValue(SimpleTemplateToPrintWriter.java:294)
at com.sas.util.SimpleTemplateToPrintWriter.writeToken(SimpleTemplateToPrintWriter.java:259)
at com.sas.util.SimpleTemplateToPrintWriter.writeVar(SimpleTemplateToPrintWriter.java:318)
at com.sas.util.SimpleTemplateToPrintWriter.writeToken(SimpleTemplateToPrintWriter.java:275)
at com.sas.util.SimpleTemplateToPrintWriter.writeText(SimpleTemplateToPrintWriter.java:335)
at com.sas.util.SimpleTemplateToPrintWriter.write(SimpleTemplateToPrintWriter.java:355)
at com.sas.util.SimpleTemplateToPrintWriter.write(SimpleTemplateToPrintWriter.java:389)
at com.sas.util.SimpleTemplateToPrintWriter.write(SimpleTemplateToPrintWriter.java:364)
at com.sas.servlet.tbeans.TemplateSupport.writeTemplate(TemplateSupport.java:211)
at com.sas.servlet.tbeans.BaseCompositeTransformation.writeTemplate(BaseCompositeTransformation.java:268)
at com.sas.servlet.tbeans.BaseActionCompositeTransformation.writeTemplate(BaseActionCompositeTransformation.java:291)
at com.sas.servlet.tbeans.dataexplorer.html.VisualDataExplorer.write(VisualDataExplorer.java:1555)
at com.sas.webapp.dataexplorer.VisualDataExplorerAction.execute(VisualDataExplorerAction.java:414)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:465)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1422)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:505)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176)
at java.security.AccessController.doPrivileged(AccessController.java:-2)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172)
at com.sas.webapp.dataexplorer.AuthenticationFilter.doFilter(AuthenticationFilter.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176)
at java.security.AccessController.doPrivileged(AccessController.java:-2)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172)
at com.sas.servlet.filters.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:62)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176)
at java.security.AccessController.doPrivileged(AccessController.java:-2)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530)
at java.lang.Thread.run(Thread.java:534)

Which was caused by: 7. Cause:
Metadata error - The specified metadata repository or schema does not define any cubes

at com.sas.iom.SASIOMDefs.GenericErrorHelper.read(null:-1)
at com.sas.iom.SASIOMDefs.GenericErrorHelper.extract(null:-1)
at com.sas.iom.SASMDX._portable_stub_ISession.MDXQuery(null:-1)
at com.sas.storage.olap.sasmdx.OLAPDataSet.executeQuery(OLAPDataSet.java:325)
at com.sas.storage.olap.sasmdx.OLAPDataSet.executeQuery(OLAPDataSet.java:415)
at com.sas.iquery.execution.instructions.OLAPDataSetFactory.getDataSet(null:126)
at com.sas.iquery.execution.instructions.MDXInstruction.execute(null:66)
at com.sas.iquery.execution.ExecutionProcessor.execute(null:60)
at com.sas.iquery.strategies.sas.oma.AbstractStrategy.prepareData(null:161)
at com.sas.iquery.strategies.sas.oma.AbstractStrategy.retrieveQueryResultMap(null:69)
at com.sas.iquery.strategies.sas.oma.AbstractStrategy.retrieveResultSet(null:98)
at com.sas.iquery.dataretrieval.QueryExecutor.execute(null:35)
at com.sas.iquery.dataretrieval.SimpleQueryConnector.processIQI(null:150)
at com.sas.iquery.dataretrieval.QueryConnector.processIQI(null:70)
at com.sas.iquery.dataretrieval.SimpleQueryConnector.retrieveQueryResultMap(null:109)
at com.sas.iquery.dataretrieval.SimpleQueryConnector.retrieveQueryResultMap(null:139)
at com.sas.storage.iquery.BusinessQueryToOLAPDataSetAdapter.buildOLAPDataSet(BusinessQueryToOLAPDataSetAdapter.java:1167)
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.servlet.tbeans.dataexplorer.html.DataViewer.getOLAPBusinessQueryAdapter(DataViewer.java:2990)
at com.sas.servlet.tbeans.dataexplorer.html.VisualDataExplorerMenuBar.setFilterAttributes(VisualDataExplorerMenuBar.java:167)
at com.sas.servlet.tbeans.dataexplorer.html.VisualDataExplorerMenuBar.writeMenuBar(VisualDataExplorerMenuBar.java:530)
at com.sas.servlet.tbeans.dataexplorer.html.VisualDataExplorerMenuBar.write(VisualDataExplorerMenuBar.java:507)
at com.sas.util.SimpleTemplateToPrintWriter.writeValue(SimpleTemplateToPrintWriter.java:294)
at com.sas.util.SimpleTemplateToPrintWriter.writeToken(SimpleTemplateToPrintWriter.java:259)
at com.sas.util.SimpleTemplateToPrintWriter.writeVar(SimpleTemplateToPrintWriter.java:318)
at com.sas.util.SimpleTemplateToPrintWriter.writeToken(SimpleTemplateToPrintWriter.java:275)
at com.sas.util.SimpleTemplateToPrintWriter.writeText(SimpleTemplateToPrintWriter.java:335)
at com.sas.util.SimpleTemplateToPrintWriter.write(SimpleTemplateToPrintWriter.java:355)
at com.sas.util.SimpleTemplateToPrintWriter.write(SimpleTemplateToPrintWriter.java:389)
at com.sas.util.SimpleTemplateToPrintWriter.write(SimpleTemplateToPrintWriter.java:364)
at com.sas.servlet.tbeans.TemplateSupport.writeTemplate(TemplateSupport.java:211)
at com.sas.servlet.tbeans.BaseCompositeTransformation.writeTemplate(BaseCompositeTransformation.java:268)
at com.sas.servlet.tbeans.BaseActionCompositeTransformation.writeTemplate(BaseActionCompositeTransformation.java:291)
at com.sas.servlet.tbeans.dataexplorer.html.VisualDataExplorer.write(VisualDataExplorer.java:1555)
at com.sas.webapp.dataexplorer.VisualDataExplorerAction.execute(VisualDataExplorerAction.java:414)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:465)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1422)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:505)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176)
at java.security.AccessController.doPrivileged(AccessController.java:-2)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172)
at com.sas.webapp.dataexplorer.AuthenticationFilter.doFilter(AuthenticationFilter.java:89)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176)
at java.security.AccessController.doPrivileged(AccessController.java:-2)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172)
at com.sas.servlet.filters.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:62)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
at org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFilterChain.java:98)
at org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterChain.java:176)
at java.security.AccessController.doPrivileged(AccessController.java:-2)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:172)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2415)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:223)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:432)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:386)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:534)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:530)
at java.lang.Thread.run(Thread.java:534)



Help me to solve this issue.

Regards,
Sujeev
2 REPLIES 2
Tim_SAS
Barite | Level 11
Sujeevb, this is a forum for questions about ODS and the Base reporting procedures. The folks who frequent this forum are unlikely to be able to help you. I suggest that you call Tech Support with your question. You can also ask Tech Support a question by scrolling to the bottom of this page and clicking the link that says "software issues that require SAS action."

Good luck!
deleted_user
Not applicable
Hi Tim,

Thanks for your guidance.

Regards,
Sujeev

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 710 views
  • 0 likes
  • 2 in conversation