|
Re: Cube doesnt exist [message #362710 is a reply to message #362063] |
Wed, 21 May 2008 22:25 |
Eclipse User |
|
|
|
Originally posted by: edouard.guerin.smile.fr
Hi,
I have the same problem, does anyone found a solution ?
Regards,
Edouard Guérin
Rafal Wojtowicz a écrit :
> Hi,
> Since BIRT22 I have problem with displaying reports with crosstabs on
> server. Everytime a report has crosstab, although it works fine in
> report designer, when i put it onto my tomcat server, I get this error:
>
>
>
>
> Crosstab (id = 18):
> - /olap/cube_Data Cube doesnt exist
> /olap/cube_Data Cube doesnt exist
>
> /olap/cube_Data Cube doesnt exist
> /olap/cube_Data Cube doesn't exist ( 1 time(s) )
> detail : org.eclipse.birt.report.engine.api.EngineException:
> /olap/cube_Data Cube doesnt exist
> /olap/cube_Data Cube doesnt exist
> at
> org.eclipse.birt.report.engine.executor.ExecutionContext.add Exception(ExecutionContext.java:1097)
>
> at
> org.eclipse.birt.report.engine.executor.ExecutionContext.add Exception(ExecutionContext.java:1061)
>
> at
> org.eclipse.birt.report.engine.internal.document.v4.Extended ItemExecutor.executeQuery(ExtendedItemExecutor.java:261)
>
> at
> org.eclipse.birt.report.engine.internal.document.v4.Extended ItemExecutor.doExecute(ExtendedItemExecutor.java:226)
>
> at
> org.eclipse.birt.report.engine.internal.document.v4.Extended ItemExecutor.execute(ExtendedItemExecutor.java:180)
>
> at
> org.eclipse.birt.report.engine.internal.document.v4.Containe rExecutor.prepareChildExecutor(ContainerExecutor.java:227)
>
> at
> org.eclipse.birt.report.engine.internal.document.v4.Containe rExecutor.hasNextChild(ContainerExecutor.java:110)
>
> at
> org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportItemExecutor.hasNextChild(WrappedReportItemExecutor.j ava:85)
>
> at
> org.eclipse.birt.report.engine.internal.executor.wrap.Wrappe dReportItemExecutor.hasNextChild(WrappedReportItemExecutor.j ava:85)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutNodes(HTMLBlockStackingLM.java:60)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.la youtChildren(HTMLStackingLM.java:27)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:133)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLInlineStackin gLM.resumeLayout(HTMLInlineStackingLM.java:104)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLInlineStackin gLM.layoutNodes(HTMLInlineStackingLM.java:153)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.la youtChildren(HTMLStackingLM.java:27)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:133)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutNodes(HTMLBlockStackingLM.java:68)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.la youtChildren(HTMLStackingLM.java:27)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layou tChildren(HTMLTableLM.java:76)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.la yout(HTMLAbstractLM.java:133)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLBlockStacking LM.layoutNodes(HTMLBlockStackingLM.java:68)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout (HTMLPageLM.java:89)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutE ngine.layout(HTMLReportLayoutEngine.java:101)
>
> at
> org.eclipse.birt.report.engine.api.impl.RenderTask$PageRange Render.render(RenderTask.java:523)
>
> at
> org.eclipse.birt.report.engine.api.impl.RenderTask.render(Re nderTask.java:221)
>
> at
> org.eclipse.birt.report.service.ReportEngineService.renderRe port(ReportEngineService.java:1228)
>
> at
> org.eclipse.birt.report.service.ReportEngineService.renderRe port(ReportEngineService.java:1057)
>
> at
> org.eclipse.birt.report.service.BirtViewerReportService.getP age(BirtViewerReportService.java:186)
>
> at
> org.eclipse.birt.report.service.actionhandler.AbstractGetPag eActionHandler.doExecution(AbstractGetPageActionHandler.java :235)
>
> at
> org.eclipse.birt.report.service.actionhandler.AbstractGetPag eActionHandler.__execute(AbstractGetPageActionHandler.java:1 05)
>
> at
> org.eclipse.birt.report.service.actionhandler.AbstractBaseAc tionHandler.execute(AbstractBaseActionHandler.java:89)
>
> at
> org.eclipse.birt.report.soapengine.processor.AbstractBaseDoc umentProcessor.__executeAction(AbstractBaseDocumentProcessor .java:47)
>
> at
> org.eclipse.birt.report.soapengine.processor.AbstractBaseCom ponentProcessor.executeAction(AbstractBaseComponentProcessor .java:159)
>
> at
> org.eclipse.birt.report.soapengine.processor.BirtDocumentPro cessor.handleGetPage(BirtDocumentProcessor.java:87)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.java:39)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:25)
>
> at java.lang.reflect.Method.invoke(Method.java:585)
> at
> org.eclipse.birt.report.soapengine.processor.AbstractBaseCom ponentProcessor.process(AbstractBaseComponentProcessor.java: 111)
>
> at
> org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingI mpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce ssorImpl.java:39)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe thodAccessorImpl.java:25)
>
> at java.lang.reflect.Method.invoke(Method.java:585)
> at
> org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCP rovider.java:397)
>
> at
> org.apache.axis.providers.java.RPCProvider.processMessage(RP CProvider.java:186)
>
> at
> org.apache.axis.providers.java.JavaProvider.invoke(JavaProvi der.java:323)
> at
> org.apache.axis.strategies.InvocationStrategy.visit(Invocati onStrategy.java:32)
>
> at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
> at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
> at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService .java:453)
> at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281 )
> at org.apache.axis.transport.http.AxisServlet.doPost(AxisServle t.java:699)
> at
> org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherSer vlet.doPost(BirtSoapMessageDispatcherServlet.java:219)
>
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
> at
> org.apache.axis.transport.http.AxisServletBase.service(AxisS ervletBase.java:327)
>
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
> at
> org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherSer vlet.service(BirtSoapMessageDispatcherServlet.java:109)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:252)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
>
> at
> org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerF ilter.java:68)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFi lter(ApplicationFilterChain.java:202)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(App licationFilterChain.java:173)
>
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(Standar dWrapperValve.java:213)
>
> at
> org.apache.catalina.core.StandardContextValve.invoke(Standar dContextValve.java:178)
>
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHo stValve.java:126)
>
> at
> org.jstripe.tomcat.probe.Tomcat55AgentValve.invoke(Tomcat55A gentValve.java:20)
>
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorRepo rtValve.java:105)
>
> at
> org.apache.catalina.valves.AccessLogValve.invoke(AccessLogVa lve.java:541)
> at
> org.apache.catalina.core.StandardEngineValve.invoke(Standard EngineValve.java:107)
>
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAd apter.java:148)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Proce ssor.java:869)
> at
> org.apache.coyote.http11.Http11BaseProtocol$Http11Connection Handler.processConnection(Http11BaseProtocol.java:664)
>
> at
> org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(Poo lTcpEndpoint.java:527)
>
> at
> org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt( LeaderFollowerWorkerThread.java:80)
>
> at
> org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.ru n(ThreadPool.java:684)
>
> at java.lang.Thread.run(Thread.java:595)
> Caused by: org.eclipse.birt.data.engine.core.DataException:
> /olap/cube_Data Cube doesnt exist
> /olap/cube_Data Cube doesn't exist
> at
> org.eclipse.birt.data.engine.olap.impl.query.CubeQueryResult s.getCubeCursor(CubeQueryResults.java:108)
>
> at
> org.eclipse.birt.report.engine.data.dte.CubeResultSet.<init >(CubeResultSet.java:86)
>
> at
> org.eclipse.birt.report.engine.data.dte.DataPresentationEngi ne.doExecuteCube(DataPresentationEngine.java:194)
>
> at
> org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.e xecute(AbstractDataEngine.java:252)
>
> at
> org.eclipse.birt.report.engine.executor.ExecutionContext.exe cuteQuery(ExecutionContext.java:1660)
>
> at
> org.eclipse.birt.report.engine.internal.document.v4.Extended ItemExecutor.executeQuery(ExtendedItemExecutor.java:254)
>
> ... 74 more
> Caused by: javax.olap.OLAPException: /olap/cube_Data Cube doesn't exist
> at
> org.eclipse.birt.data.engine.olap.query.view.BirtCubeView.ge tCubeCursor(BirtCubeView.java:112)
>
> at
> org.eclipse.birt.data.engine.olap.impl.query.CubeQueryResult s.getCubeCursor(CubeQueryResults.java:84)
>
> ... 79 more
> Caused by: java.io.IOException: /olap/cube_Data Cube doesn't exist
> at
> org.eclipse.birt.core.archive.compound.ArchiveReader.getStre am(ArchiveReader.java:98)
>
> at
> org.eclipse.birt.data.engine.olap.data.document.RADocumentMa nager.openDocumentObject(RADocumentManager.java:70)
>
> at org.eclipse.birt.data.engine.olap.data.impl.Cube.load(Cube.j ava:130)
> at
> org.eclipse.birt.data.engine.olap.data.api.CubeQueryExecutor Helper.loadCube(CubeQueryExecutorHelper.java:149)
>
> at
> org.eclipse.birt.data.engine.olap.query.view.QueryExecutor.l oadCube(QueryExecutor.java:353)
>
> at
> org.eclipse.birt.data.engine.olap.query.view.QueryExecutor.e xecute(QueryExecutor.java:82)
>
> at
> org.eclipse.birt.data.engine.olap.query.view.BirtCubeView.ge tCubeCursor(BirtCubeView.java:108)
>
> ... 80 more
>
>
>
>
> All reports without crosstabs work fine on server. What can be the problem?
>
> Thanks,
> Rafal
|
|
|
|
Re: Cube doesnt exist [message #966663 is a reply to message #362063] |
Thu, 01 November 2012 06:02 |
Karan Mehta Messages: 1 Registered: November 2012 Location: Mumbai |
Junior Member |
|
|
Hi ,
I am getting the same kind of error which is as follows
BIRT Version :- 3.2.6
The following items have errors:
Crosstab (id = 144):
- /olap/cube_Data Cube
/olap/cube_Data Cube
/olap/cube_Data Cube ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: /olap/cube_Data Cube
/olap/cube_Data Cube
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1195)
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1174)
at org.eclipse.birt.report.engine.internal.document.v4.ExtendedItemExecutor.executeQuery(ExtendedItemExecutor.java:267)
at org.eclipse.birt.report.engine.internal.document.v4.ExtendedItemExecutor.doExecute(ExtendedItemExecutor.java:232)
at org.eclipse.birt.report.engine.internal.document.v4.ExtendedItemExecutor.execute(ExtendedItemExecutor.java:181)
at org.eclipse.birt.report.engine.internal.document.v4.ContainerExecutor.prepareChildExecutor(ContainerExecutor.java:226)
at org.eclipse.birt.report.engine.internal.document.v4.ContainerExecutor.hasNextChild(ContainerExecutor.java:110)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.hasNextChild(WrappedReportItemExecutor.java:86)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.hasNextChild(WrappedReportItemExecutor.java:86)
at org.eclipse.birt.report.engine.api.impl.RenderTask$ReportExecutorWrapper.hasNextChild(RenderTask.java:782)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM$1.hasNextChild(HTMLPageLM.java:68)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:62)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:90)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:99)
at org.eclipse.birt.report.engine.api.impl.RenderTask$PageRangeRender.render(RenderTask.java:662)
at org.eclipse.birt.report.engine.api.impl.RenderTask.render(RenderTask.java:284)
at org.eclipse.birt.report.service.ReportEngineService.renderReport(ReportEngineService.java:1537)
at org.eclipse.birt.report.service.BirtViewerReportService.getPage(BirtViewerReportService.java:204)
at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.doExecution(AbstractGetPageActionHandler.java:238)
at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(AbstractGetPageActionHandler.java:105)
at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)
at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPage(BirtDocumentProcessor.java:87)
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:597)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)
at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)
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:597)
at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.eclipse.birt.data.engine.core.DataException: /olap/cube_Data Cube
/olap/cube_Data Cube
at org.eclipse.birt.data.engine.olap.impl.query.CubeQueryResults.getCubeCursor(CubeQueryResults.java:202)
at org.eclipse.birt.report.engine.data.dte.CubeResultSet.<init>(CubeResultSet.java:78)
at org.eclipse.birt.report.engine.data.dte.DataPresentationEngine.doExecuteCube(DataPresentationEngine.java:225)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:270)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1876)
at org.eclipse.birt.report.engine.internal.document.v4.ExtendedItemExecutor.executeQuery(ExtendedItemExecutor.java:259)
... 60 more
Caused by: java.io.FileNotFoundException: /olap/cube_Data Cube
at org.eclipse.birt.core.archive.compound.ArchiveFileV3.openEntry(ArchiveFileV3.java:101)
at org.eclipse.birt.core.archive.compound.ArchiveFile.openEntry(ArchiveFile.java:351)
at org.eclipse.birt.core.archive.compound.ArchiveReader.getStream(ArchiveReader.java:91)
at org.eclipse.birt.data.engine.olap.data.document.RADocumentManager.openDocumentObject(RADocumentManager.java:74)
at org.eclipse.birt.data.engine.olap.data.impl.Cube.load(Cube.java:156)
at org.eclipse.birt.data.engine.olap.data.api.CubeQueryExecutorHelper.loadCube(CubeQueryExecutorHelper.java:165)
at org.eclipse.birt.data.engine.olap.impl.query.CubeQueryResults.loadCube(CubeQueryResults.java:343)
at org.eclipse.birt.data.engine.olap.impl.query.CubeQueryResults.createCursor(CubeQueryResults.java:267)
at org.eclipse.birt.data.engine.olap.impl.query.CubeQueryResults.getCubeCursor(CubeQueryResults.java:109)
... 65 more
Can someone provide me the solution as soon as possible
--
Thanks and Regards
Karan Mehta
+919022580262
|
|
|
Re: Cube doesnt exist [message #1011488 is a reply to message #966663] |
Tue, 19 February 2013 16:18 |
Sébastien atre Messages: 4 Registered: November 2011 |
Junior Member |
|
|
I don't know if this is the same problem as yours but I also got the same kind of exception on BIRT 2.6.1 and I managed to face the issue as follow:
It appears that this exception (/olap/cube_Data...) was in fact hidding another problem.
I changed the frameset BIRT context path that was used in my case to the run one and then it displayed the real error that was preventing the report to run.
In my case, it was a misconfiguration of the datasource. It was accessed through an user which didn't have the right to see a stored procedure. This database stored procedure was used in the cube's dataset. Therefore, the cube was unable to fetch the data...
I still don't understand the /olap/cube_Data... error, but it now works after correct configuration.
Hope it will help someone.
[Updated on: Tue, 19 February 2013 16:19] Report message to a moderator
|
|
|
Powered by
FUDForum. Page generated in 0.02268 seconds