Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
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
Find more posts tagged with
Comments
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?
