BIRT Exchange Forum: Can any one explain this error? - BIRT Exchange Forum

Jump to content


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Can any one explain this error? Rate Topic: -----

#1 User is offline   Dragunov 

  • Junior Member
  • PipPip
  • Group: Members
  • Posts: 18
  • Joined: 27-June 09

Posted 30 June 2009 - 02:05 AM

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.(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
0

#2 User is offline   mwilliams 

  • BIRT Guru
  • Icon
  • View blog
  • Group: Administrators
  • Posts: 5565
  • Joined: 16-May 08

Posted 30 June 2009 - 10:55 AM

Hi Dragunov,

Can you attach your report design?
Regards,


Michael

http://twitter.com/mwilliams_actu
0

#3 User is offline   Dragunov 

  • Junior Member
  • PipPip
  • Group: Members
  • Posts: 18
  • Joined: 27-June 09

Posted 30 June 2009 - 09:14 PM

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.
0

#4 User is offline   Dragunov 

  • Junior Member
  • PipPip
  • Group: Members
  • Posts: 18
  • Joined: 27-June 09

Posted 01 July 2009 - 10:19 AM

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.
0

#5 User is offline   SonalD 

  • Junior Member
  • Pip
  • Group: Members
  • Posts: 1
  • Joined: 13-October 09

Posted 21 October 2009 - 01:14 AM

Hi All,

I am too getting the same error , tried removing aliases but that dint work.Can anyone help me on this?
0
Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users