Can any one explain this error?

[Dragunov]

Hi all,

I am using BIRT 2.1.2 with RAD. My report have 2 datasets which is joined together in a joint data set, which i am using to display the data. In preview report the report is showing fine with no errors. but when i try to run the report i am getting strange error. Couldnt understand any thing

If any one encountered this error please give me some help.

Data (id = 350):
+ A report document error occurred when loading: Subquery
A report document error occurred when loading: Result Class
data.engine.LoadReportDocumentError ( 1 time(s) )
detail : org.eclipse.birt.data.engine.core.DataException: A report document error occurred when loading: SubqueryA report document error occurred when loading: Result Class at org.eclipse.birt.data.engine.impl.document.ResultIterator.getSecondaryIterator(Unknown Source) at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.doExecuteSubQuery(Unknown Source) at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(Unknown Source) at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(Unknown Source) at org.eclipse.birt.report.engine.internal.executor.doc.AbstractReportReader.openQuery(Unknown Source) at org.eclipse.birt.report.engine.internal.executor.doc.ReportItemReader.initializeContent(Unknown Source) at org.eclipse.birt.report.engine.internal.executor.doc.ReportItemReader.execute(Unknown Source) at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(Unknown Source) at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(Unknown Source) at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(Unknown Source) at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(Unknown Source) at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(Unknown Source) at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(Unknown Source) at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(Unknown Source) at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(Unknown Source) at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(Unknown Source) at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(Unknown Source) at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(Unknown Source) at org.eclipse.birt.report.engine.internal.document.v3.ReportContentLoaderV3.loadPage(Unknown Source) at org.eclipse.birt.report.engine.internal.document.ReportContentLoader.loadPage(Unknown Source) at org.eclipse.birt.report.engine.api.impl.RenderTask.doRender(Unknown Source) at org.eclipse.birt.report.engine.api.impl.RenderTask$PageRender.render(Unknown Source) at org.eclipse.birt.report.engine.api.impl.RenderTask.render(Unknown Source) at org.eclipse.birt.report.service.ReportEngineService.renderReport(Unknown Source) at org.eclipse.birt.report.service.ReportEngineService.renderReport(Unknown Source) at org.eclipse.birt.report.service.BirtViewerReportService.getPage(Unknown Source) at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.doExecution(Unknown Source) at org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(Unknown Source) at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(Unknown Source) at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(Unknown Source) at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(Unknown Source) at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleGetPage(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(Unknown Source) at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(Unknown Source) at sun.reflect.GeneratedMethodAccessor74.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.axis.providers.java.RPCProvider.invokeMethod(Unknown Source) at org.apache.axis.providers.java.RPCProvider.processMessage(Unknown Source) at org.apache.axis.providers.java.JavaProvider.invoke(Unknown Source) at org.apache.axis.strategies.InvocationStrategy.visit(Unknown Source) at org.apache.axis.SimpleChain.doVisiting(Unknown Source) at org.apache.axis.SimpleChain.invoke(Unknown Source) at org.apache.axis.handlers.soap.SOAPService.invoke(Unknown Source) at org.apache.axis.server.AxisServer.invoke(Unknown Source) at org.apache.axis.transport.http.AxisServlet.doPost(Unknown Source) at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(Unknown Source) at javax.servlet.http.HttpServlet.service(Unknown Source) at org.apache.axis.transport.http.AxisServletBase.service(Unknown Source) at javax.servlet.http.HttpServlet.service(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source) at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source) at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source) at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source) at org.apache.catalina.core.ContainerBase.invoke(Unknown Source) at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source) at org.apache.catalina.valves.CertificatesValve.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source) at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source) at org.apache.catalina.core.ContainerBase.invoke(Unknown Source) at org.apache.catalina.core.StandardContext.invoke(Unknown Source) at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source) at org.eclipse.tomcat.internal.EclipseErrorReportValve.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source) at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source) at org.apache.catalina.core.ContainerBase.invoke(Unknown Source) at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(Unknown Source) at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source) at org.apache.catalina.core.ContainerBase.invoke(Unknown Source) at org.apache.coyote.tomcat4.CoyoteAdapter.service(Unknown Source) at org.apache.coyote.http11.Http11Processor.process(Unknown Source) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Unknown Source) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(Unknown Source) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Unknown Source) at java.lang.Thread.run(Unknown Source)Caused by: org.eclipse.birt.data.engine.core.DataException: A report document error occurred when loading: Result Class at org.eclipse.birt.data.engine.executor.ResultClass.<init>(Unknown Source) at org.eclipse.birt.data.engine.impl.document.RDLoad.loadResultClass(Unknown Source) at org.eclipse.birt.data.engine.impl.document.RDLoad.loadResultMetaData(Unknown Source) at org.eclipse.birt.data.engine.impl.document.QueryResults.getResultMetaData(Unknown Source) at org.eclipse.birt.data.engine.impl.document.ResultIterator.getResultMetaData(Unknown Source) ... 85 moreCaused by: java.io.EOFException at java.io.DataInputStream.readUnsignedShort(Unknown Source) at java.io.DataInputStream.readUTF(Unknown Source) at java.io.DataInputStream.readUTF(Unknown Source) at org.eclipse.birt.core.util.IOUtil.readString(Unknown Source) ... 90 more

Data(id=359)
+ A report document error occured when loading:Subquery
Areport document error occured when loading: Result Class


Data(id=360)
+ A report document error occured when loading:Subquery
Areport document error occured when loading: Result Class

Data(id=361)
+ A report document error occured when loading:Subquery
Areport document error occured when loading: Result Class

[mwilliams]

Hi Dragunov,

Can you attach your report design?

[Dragunov]

Hi williams,

Thanks for your helping hand, but I am using BIRT to develop report for maximo for my client. I wont be able to attach the design file here due to confidentiality.

[Dragunov]

hi all,

I had found the cause of error. As i said ,this error seemed to be strange, its cause also seemed to be strange.

I was using 2 datasets joined together in a joint dataset. In each dataset i was fetching values using 2 queries ( i used a main query to fetch some result and based on that i was fetching another set of result by writing a function inside my fetch method).

All the Queries where having some column aliases.
like
select count(entered_timesheet_no) as enteredcount .
and in the fetch method i would use
row["count"]=dataSet.getInteger("enteredcount");
this was working fine when the report runs from a single data set, but when i joined the 2 datasets to create a joint data set and use that to show data in my report, this alias name in the query was the causing the problem.

it took me lot of research to find out the exact cause
i removed the aliases from query and modified all my code like

select count(entered_timesheet_no)
row["count"]=dataSet.getInteger("count(entered_timesheet_no)");
and every thing was fine.

still have no idea why the alias name was causing error.

ny way thanks for all who tried to help.

[SonalD]

Hi All,

I am too getting the same error , tried removing aliases but that dint work.Can anyone help me on this?