Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » BIRT runtime error (The cube result for crosstab is invalid(=null))
icon5.gif  BIRT runtime error [message #1220486] Thu, 12 December 2013 02:14 Go to next message
Sam Wu is currently offline Sam Wu
Messages: 7
Registered: October 2013
Junior Member
Hi, all,

I design a report and run very well with eclipse, but when I try to use BIRT Runtime to generate the report, I always got following error.both 3.7.2 and 4.3.1.

Any idea??

------------------------
F:\birt-run2\ReportEngine>genReport.bat -f pdf GEN3_SAT.rptdesign

F:\birt-run2\ReportEngine>ECHO off
2013-12-12 15:01:41 org.eclipse.birt.report.engine.executor.ExecutorManager$Exec
utorContext executeQuery
SEVERE: An exception occurred during processing. Please see the following message
for details:
exception.error
Error happens when create hierarchy:Group.NewTabularHierarchy.
org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred
during processing. Please see the following message for details:
exception.error
Error happens when create hierarchy:Group.NewTabularHierarchy.
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.exec
ute(DataRequestSessionImpl.java:644)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteCube(D
teDataEngine.java:233)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(Ab
stractDataEngine.java:272)
at org.eclipse.birt.report.engine.executor.ExecutorManager$ExecutorConte
xt.executeQuery(ExecutorManager.java:441)
at org.eclipse.birt.report.item.crosstab.core.re.executor.BaseCrosstabEx
ecutor.executeQuery(BaseCrosstabExecutor.java:122)
at org.eclipse.birt.report.item.crosstab.core.re.executor.CrosstabReport
ItemExecutor.execute(CrosstabReportItemExecutor.java:102)
at org.eclipse.birt.report.engine.executor.ExtendedItemExecutor.execute(
ExtendedItemExecutor.java:62)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicat
eItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportIt
emExecutor.execute(WrappedReportItemExecutor.java:46)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReport
ItemExecutor.execute(LocalizedReportItemExecutor.java:34)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layout
Nodes(HTMLBlockStackingLM.java:65)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChild
ren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTML
AbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resum
eLayout(HTMLInlineStackingLM.java:111)
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layou
tNodes(HTMLInlineStackingLM.java:160)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChild
ren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTML
AbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layout
Nodes(HTMLBlockStackingLM.java:70)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChild
ren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLTableLM.layoutChildren
(HTMLTableLM.java:132)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTML
AbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layout
Nodes(HTMLBlockStackingLM.java:70)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPage
LM.java:92)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.lay
out(HTMLReportLayoutEngine.java:100)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAnd
RenderTask.java:180)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRe
nderTask.java:77)
at org.eclipse.birt.report.engine.api.ReportRunner.runAndRenderReport(Re
portRunner.java:223)
at org.eclipse.birt.report.engine.api.ReportRunner.execute(ReportRunner.
java:163)
at org.eclipse.birt.report.engine.api.ReportRunner.main(ReportRunner.jav
a:122)
Caused by: org.eclipse.birt.data.engine.core.DataException: exception.error
Error happens when create hierarchy:Group.NewTabularHierarchy.
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.mate
rializeCube(DataRequestSessionImpl.java:773)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.exec
ute(DataRequestSessionImpl.java:633)
... 28 more
Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: Error happ
ens when create hierarchy:Group.NewTabularHierarchy.
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.popu
lateDimension(DataRequestSessionImpl.java:1466)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.popu
lateDimensions(DataRequestSessionImpl.java:1325)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.crea
teCube(DataRequestSessionImpl.java:824)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.mate
rializeCube(DataRequestSessionImpl.java:758)
... 29 more
Caused by: java.io.EOFException
at org.eclipse.birt.data.engine.olap.data.document.AbstractBufferedRando
mAccessObject.readFully(AbstractBufferedRandomAccessObject.java:578)
at org.eclipse.birt.data.engine.olap.data.document.AbstractBufferedRando
mAccessObject.readFully(AbstractBufferedRandomAccessObject.java:555)
at org.eclipse.birt.data.engine.olap.data.document.AbstractBufferedRando
mAccessObject.readInt(AbstractBufferedRandomAccessObject.java:230)
at org.eclipse.birt.data.engine.olap.data.document.FileDocumentManager.g
etNextBlock(FileDocumentManager.java:311)
at org.eclipse.birt.data.engine.olap.data.document.BlockRandomAccessObje
ct.<init>(BlockRandomAccessObject.java:49)
at org.eclipse.birt.data.engine.olap.data.document.FileDocumentManager.c
reateDocumentObject(FileDocumentManager.java:230)
at org.eclipse.birt.data.engine.olap.data.impl.dimension.Hierarchy.creat
eHierarchyDocumentObject(Hierarchy.java:248)
at org.eclipse.birt.data.engine.olap.data.impl.dimension.Hierarchy.creat
eAndSaveHierarchy(Hierarchy.java:118)
at org.eclipse.birt.data.engine.olap.data.api.cube.CubeMaterializer.crea
teHierarchy(CubeMaterializer.java:126)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.popu
lateDimension(DataRequestSessionImpl.java:1458)
... 32 more
2013-12-12 15:01:41 org.eclipse.birt.report.item.crosstab.core.re.executor.Cross
tabReportItemExecutor execute
SEVERE: The cube result for crosstab is invalid(=null).
F:\birt-run2\ReportEngine>
Re: BIRT runtime error [message #1220698 is a reply to message #1220486] Fri, 13 December 2013 02:36 Go to previous messageGo to next message
Sam Wu is currently offline Sam Wu
Messages: 7
Registered: October 2013
Junior Member
Thanks for check this topic, I try whole day today, even use the sample in eclipse help page, I still get the error:
http://help.eclipse.org/helios/index.jsp?topic=%2Forg.eclipse.birt.doc%2Fbirt%2Fcrosstab.17.2.html

I attach the rptdesign file with public data cube, please help me to have a look, thanks.


Regards,
Sam
Re: BIRT runtime error [message #1220703 is a reply to message #1220698] Fri, 13 December 2013 03:22 Go to previous messageGo to next message
Sam Wu is currently offline Sam Wu
Messages: 7
Registered: October 2013
Junior Member
anyone help me to try with my rptdegsin file on your runtime environment with following command and post me your result?:
genReport.bat -f pdf GEN3_SAT.rptdesign

Thanks you very much for your help.

Reagrds,
Sam
Re: BIRT runtime error [message #1220829 is a reply to message #1220703] Fri, 13 December 2013 17:21 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 1547
Registered: July 2009
Senior Member

So, you're executing this report with Java or with the viewer? If Java, can you attach the java class you're using to run the report, as well?

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Re: BIRT runtime error [message #1220909 is a reply to message #1220829] Mon, 16 December 2013 00:13 Go to previous messageGo to next message
Sam Wu is currently offline Sam Wu
Messages: 7
Registered: October 2013
Junior Member
Hi, Michael,

Thank you for your help, i did not executed the report with java, I just downlaod the runtime 3.7.2 and 4.3.1, try to use the reportengine on the runtime folder to generate the report with my rptdegisn file. I only add "mysql-connector-java-5.1.26-bin.jar" to the lib of runtime, because I use mysql as database of my data. please check attach

Regards,
Sam Wu
Re: BIRT runtime error [message #1220913 is a reply to message #1220486] Mon, 16 December 2013 01:42 Go to previous messageGo to next message
Sam Wu is currently offline Sam Wu
Messages: 7
Registered: October 2013
Junior Member
Hi, all,

Thanks for review this topic, if you have your runtime environment.
Plrease help me to have a run with my rptdesign file and pose me your result.

second attachment is basic on eclipse public database, you can always run it with internet.

Thanks.
Sam Wu
Re: BIRT runtime error [message #1220939 is a reply to message #1220486] Mon, 16 December 2013 04:30 Go to previous messageGo to next message
Sam Wu is currently offline Sam Wu
Messages: 7
Registered: October 2013
Junior Member
It is this runtime bug?

-------------
Dec 16, 2013, 5:27 PM
The following items have errors:

ReportDesign (id = 1):
- An exception occurred during processing. Please see the following message for details:
exception.error
Error happens when create hierarchy:Group.NewTabularHierarchy.
exception.error ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details:
exception.error
Error happens when create hierarchy:Group.NewTabularHierarchy.
at org.eclipse.birt.report.engine.executor.ExecutorManager$ExecutorContext.executeQuery(ExecutorManager.java:457)
at org.eclipse.birt.report.item.crosstab.core.re.executor.BaseCrosstabExecutor.executeQuery(BaseCrosstabExecutor.java:122)
at org.eclipse.birt.report.item.crosstab.core.re.executor.CrosstabReportItemExecutor.execute(CrosstabReportItemExecutor.java:102)
at org.eclipse.birt.report.engine.executor.ExtendedItemExecutor.execute(ExtendedItemExecutor.java:62)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)
at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:181)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
at org.eclipse.birt.report.engine.api.ReportRunner.runAndRenderReport(ReportRunner.java:245)
at org.eclipse.birt.report.engine.api.ReportRunner.execute(ReportRunner.java:168)
at org.eclipse.birt.report.engine.api.ReportRunner.main(ReportRunner.java:127)
Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred during processing. Please see the following message for details:
exception.error
Error happens when create hierarchy:Group.NewTabularHierarchy.
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:657)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteCube(DteDataEngine.java:233)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:280)
at org.eclipse.birt.report.engine.executor.ExecutorManager$ExecutorContext.executeQuery(ExecutorManager.java:447)
... 14 more
Caused by: org.eclipse.birt.data.engine.core.DataException: exception.error
Error happens when create hierarchy:Group.NewTabularHierarchy.
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.materializeCube(DataRequestSessionImpl.java:788)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:646)
... 17 more
Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: Error happens when create hierarchy:Group.NewTabularHierarchy.
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.populateDimension(DataRequestSessionImpl.java:1487)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.populateDimensions(DataRequestSessionImpl.java:1345)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.createCube(DataRequestSessionImpl.java:839)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.materializeCube(DataRequestSessionImpl.java:773)
... 18 more
Caused by: java.io.EOFException
at org.eclipse.birt.data.engine.olap.data.document.AbstractBufferedRandomAccessObject.readFully(AbstractBufferedRandomAccessObject.java:578)
at org.eclipse.birt.data.engine.olap.data.document.AbstractBufferedRandomAccessObject.readFully(AbstractBufferedRandomAccessObject.java:555)
at org.eclipse.birt.data.engine.olap.data.document.AbstractBufferedRandomAccessObject.readInt(AbstractBufferedRandomAccessObject.java:230)
at org.eclipse.birt.data.engine.olap.data.document.FileDocumentManager.getNextBlock(FileDocumentManager.java:311)
at org.eclipse.birt.data.engine.olap.data.document.BlockRandomAccessObject.<init>(BlockRandomAccessObject.java:49)
at org.eclipse.birt.data.engine.olap.data.document.FileDocumentManager.createDocumentObject(FileDocumentManager.java:230)
at org.eclipse.birt.data.engine.olap.data.impl.dimension.Hierarchy.createHierarchyDocumentObject(Hierarchy.java:248)
at org.eclipse.birt.data.engine.olap.data.impl.dimension.Hierarchy.createAndSaveHierarchy(Hierarchy.java:118)
at org.eclipse.birt.data.engine.olap.data.api.cube.CubeMaterializer.createHierarchy(CubeMaterializer.java:126)
at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.populateDimension(DataRequestSessionImpl.java:1479)
... 21 more
Re: BIRT runtime error [message #1222218 is a reply to message #1220939] Thu, 19 December 2013 18:10 Go to previous message
Michael Williams is currently offline Michael Williams
Messages: 1547
Registered: July 2009
Senior Member

I just ran the attached report above in 4.3.0 with no issues. What is your Java version?

Michael

Add interactivity, scheduling, sharing, live Excel export, and JS integration to your BIRT app with the new, free BIRT server, BIRT iHub F-Type.
Previous Topic:BIRT Report Viewer 4.3.1 won't run on Webshere 7
Next Topic:Deploying birt in tomcat
Goto Forum:
  


Current Time: Thu Jul 31 11:42:18 EDT 2014

Powered by FUDForum. Page generated in 0.01812 seconds