Eclipse Community Forums: BIRT » BIRT runtime error

Home

Home » Archived » BIRT » BIRT runtime error (The cube result for crosstab is invalid(=null))

BIRT runtime error [message #1220486]

Thu, 12 December 2013 02:14

Eclipse User

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>

Attachment: GEN3_SAT.rptdesign
(Size: 1.39MB, Downloaded 312 times)

Re: BIRT runtime error [message #1220698 is a reply to message #1220486]

Fri, 13 December 2013 02:36

Eclipse User

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

Attachment: GEN3_SAT_2.rptdesign
(Size: 17.80KB, Downloaded 470 times)

Re: BIRT runtime error [message #1220703 is a reply to message #1220698]

Fri, 13 December 2013 03:22

Eclipse User

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

Eclipse User

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?

Re: BIRT runtime error [message #1220909 is a reply to message #1220829]

Mon, 16 December 2013 00:13

Eclipse User

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

Attachment: mysql-connector-java-5.1.26-bin.jar
(Size: 835.89KB, Downloaded 207 times)

Re: BIRT runtime error [message #1220913 is a reply to message #1220486]

Mon, 16 December 2013 01:42

Eclipse User

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

Eclipse User

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

Eclipse User

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

Previous Topic:	BIRT Report Viewer 4.3.1 won't run on Webshere 7
Next Topic:	Deploying birt in tomcat

Goto Forum:

-=] Back to Top [=-

Current Time: Fri Jul 18 19:00:39 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter