Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Errors occurred when generating the report document(In Birt Viewer)
Errors occurred when generating the report document [message #1660859] Mon, 09 March 2015 11:15 Go to next message
Kirankumar Gawade is currently offline Kirankumar GawadeFriend
Messages: 10
Registered: February 2015
Junior Member

i am download the jar file and place in

C:program files/apache software /tomcat/webapps/birt/WEB-INF/lib/mysql-connector-java-5.1.0-bin.jar


The following items have errors:


Table (id = 373):
+ Can not load the report query: 373. Errors occurred when generating the report document for the report element with ID 373. (Element ID:373)




The following items have errors:


Table (id = 373):
- Can not load the report query: 373. Errors occurred when generating the report document for the report element with ID 373. (Element ID:373)
Error.ReportQueryLoadingError2 ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: Can not load the report query: 373. Errors occurred when generating the report document for the report element with ID 373. (Element ID:373)
at org.eclipse.birt.report.engine.data.dte.DataPresentationEngine.doExecuteQuery(DataPresentationEngine.java:164)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1939)
at org.eclipse.birt.report.engine.internal.document.v4.ReportItemExecutor.executeQuery(ReportItemExecutor.java:412)
at org.eclipse.birt.report.engine.internal.document.v4.TableItemExecutor.doExecute(TableItemExecutor.java:72)
at org.eclipse.birt.report.engine.internal.document.v4.ReportItemExecutor.execute(ReportItemExecutor.java:294)
at org.eclipse.birt.report.engine.internal.document.v4.ContainerExecutor.prepareChildExecutor(ContainerExecutor.java:226)
at org.eclipse.birt.report.engine.internal.document.v4.ContainerExecutor.hasNextChild(ContainerExecutor.java:110)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.hasNextChild(WrappedReportItemExecutor.java:86)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.hasNextChild(WrappedReportItemExecutor.java:86)
at org.eclipse.birt.report.engine.api.impl.RenderTask$ReportExecutorWrapper.hasNextChild(RenderTask.java:780)
at org.eclipse.birt.report.engine.layout.html.HTMLPageLM$1.hasNextChild(HTMLPageLM.java:68)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:62)
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.RenderTask$PageRangeRender.render(RenderTask.java:661)
at org.eclipse.birt.report.engine.api.impl.RenderTask.render(RenderTask.java:294)
at org.eclipse.birt.report.service.ReportEngineService.renderReport(ReportEngineService.java:1555)
at org.eclipse.birt.report.service.BirtViewerReportService.getPage(BirtViewerReportService.java:204)
at org.eclipse.birt.report.service.actionhandler.BirtChangeParameterActionHandler.doRenderPage(BirtChangeParameterActionHandler.java:82)
at org.eclipse.birt.report.service.actionhandler.AbstractChangeParameterActionHandler.__execute(AbstractChangeParameterActionHandler.java:103)
at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)
at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)
at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleChangeParameter(BirtDocumentProcessor.java:100)
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(AbstractBaseComponentProcessor.java:112)
at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)
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.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)
at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)
at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)
at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)
at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)
at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)
at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)
at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)
at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)



The Datasource property:-

<property name="databaseName">sdcc</property>
<property name="username">admin</property>
<encrypted-property name="password" encryptionID="base64">c2RjY2FkbWluQDEyMw==</encrypted-property>
<property name="URL">jdbc:mysql://localhost:3306/sdcc</property>
<property name="driverClass">com.mysql.jdbc.Driver</property>
<property name="jarList">C:\program files/apache software /tomcat/webapps/birt/WEB-INF/lib/mysql-connector-java-5.1.0-bin.jar</property>
</oda-data-source>
Re: Errors occurred when generating the report document [message #1661699 is a reply to message #1660859] Mon, 09 March 2015 19:04 Go to previous messageGo to next message
Jesse Freeman is currently offline Jesse FreemanFriend
Messages: 184
Registered: January 2015
Senior Member
Does the report run successfully within the BIRT Designer before being deployed to tomcat?
Have you restarted tomcat after adding the JDBC jar to the WEB-INF/lib directory?
Re: Errors occurred when generating the report document [message #1662775 is a reply to message #1661699] Tue, 10 March 2015 05:53 Go to previous messageGo to next message
Kirankumar Gawade is currently offline Kirankumar GawadeFriend
Messages: 10
Registered: February 2015
Junior Member
hi Jesse Freeman

i am add the jar file in web-inf/lib directory and restart the tomcat so again same problem is arrise.

  • Attachment: Untitled3.png
    (Size: 174.06KB, Downloaded 543 times)

[Updated on: Tue, 10 March 2015 05:54]

Report message to a moderator

Re: Errors occurred when generating the report document [message #1663687 is a reply to message #1662775] Tue, 10 March 2015 14:47 Go to previous messageGo to next message
Jesse Freeman is currently offline Jesse FreemanFriend
Messages: 184
Registered: January 2015
Senior Member
Did the report run successfully within the BIRT Designer before being published to the tomcat?

It looks like you are using a JDBC Connection for Query Builder Data Source.
Could you try using a standard JDBC Data Source instead?
Re: Errors occurred when generating the report document [message #1665778 is a reply to message #1663687] Wed, 11 March 2015 11:40 Go to previous messageGo to next message
Kirankumar Gawade is currently offline Kirankumar GawadeFriend
Messages: 10
Registered: February 2015
Junior Member
Hii Jesse Freeman


Report Run successfully in eclipse but not display in the Birt Viewer which is show error is" Table (id = 373):
+ Can not load the report query: 373. Errors occurred when generating the report document for the report element with ID 373. (Element ID:373)
"

And the JDBC connection for data source
are as follow:-

Step for creation of data source:-
• Create from a data source type in the following list
(a) JDBC Database Connection For query Builder


When the above data source is create in the eclipse then display the preview result in eclipse but not display in the birt viewer .

• Create from a connection profile in the profile store
(a) JDBC Database Connection For query Builder


When the above data source is create in the eclipse then not display the preview result and show the error is"Error Occurred in Generating the report Document"in eclipse and also not display in the birt viewer .

• Create from a data source type in the following list
(a) JDBC Data Source


When the above data source is create in the eclipse then not display the preview result and show the error is"Error Occurred in Generating the report Document"in eclipse and also not display in the birt viewer .

• Create from a connection profile in the profile store
(a) JDBC Data Source


When the above data source is create in the eclipse then not display the preview result and show the error is"Error Occurred in Generating the report Document"in eclipse and also not display in the birt viewer .




Above create the different type of data source in different option in eclipse Data source property


So all this above four data sources to create in eclipse but the error is occured so please sir give me any suugestion to create the data source or any pdf document which u have used to develop the datasource.
and also i am use the below JDBC file to connect the database.

and the attachment is below which display the error
Re: Errors occurred when generating the report document [message #1666253 is a reply to message #1665778] Wed, 11 March 2015 16:01 Go to previous messageGo to next message
Jesse Freeman is currently offline Jesse FreemanFriend
Messages: 184
Registered: January 2015
Senior Member
When using a JDBC Data Source, you need to place the JDBC driver in the ".\eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_4.4.0.v201405191524\drivers" directory and restart the designer.
Then the mysql driver should appear in the list of available Driver Classes as "com.mysql.jdbc.Driver (v5.1)".

Could you please verify the driver has been added this way and then create a sample report with the data source using the "com.mysql.jdbc.Driver (v5.1)" Driver Class.
If this sample report also does not display and errors, please attach the sample report and the full stack trace received.
Re: Errors occurred when generating the report document [message #1668283 is a reply to message #1666253] Thu, 12 March 2015 12:13 Go to previous messageGo to next message
Kirankumar Gawade is currently offline Kirankumar GawadeFriend
Messages: 10
Registered: February 2015
Junior Member
Hiii Jesse Freeman

While i am placed theJDBC driver in eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_4.4.0.v201405191524\drivers this location and retart the eclipse and start the birt viewer and it works suucessfully.......... thank you sir

but error occured in the view report in eclipse.

I am creating the data source as you tell me that process which is place the jdbc driver in "\eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_4.4.0.v201405191524\drivers" .

And creating the data source which gives the ping is successfull.

But When i am creating the data sets and write the query and check the preview result that gives the error which is "Error Happened while running the Report"
  • Attachment: 5.png
    (Size: 237.92KB, Downloaded 559 times)
  • Attachment: 6.png
    (Size: 233.88KB, Downloaded 578 times)
  • Attachment: 14.png
    (Size: 274.62KB, Downloaded 593 times)
Re: Errors occurred when generating the report document [message #1668695 is a reply to message #1668283] Thu, 12 March 2015 15:58 Go to previous messageGo to next message
Jesse Freeman is currently offline Jesse FreemanFriend
Messages: 184
Registered: January 2015
Senior Member
Can you attach the full stack trace you are receiving when previewing the data set?
It is mostly cut off in the screenshot you attached.
Re: Errors occurred when generating the report document [message #1670267 is a reply to message #1668695] Fri, 13 March 2015 06:05 Go to previous messageGo to next message
Kirankumar Gawade is currently offline Kirankumar GawadeFriend
Messages: 10
Registered: February 2015
Junior Member
Hiii Jesse Freeman

Multiple screenshot is available of data sets but i am attach the important screenshot of data sets..

And U want the full attachment of screenshot as bellow
Re: Errors occurred when generating the report document [message #1671949 is a reply to message #1670267] Fri, 13 March 2015 20:35 Go to previous messageGo to next message
Jesse Freeman is currently offline Jesse FreemanFriend
Messages: 184
Registered: January 2015
Senior Member
What version of mysql are you attempting to connect to?
Re: Errors occurred when generating the report document [message #1672880 is a reply to message #1671949] Sat, 14 March 2015 05:02 Go to previous message
Kirankumar Gawade is currently offline Kirankumar GawadeFriend
Messages: 10
Registered: February 2015
Junior Member
hiii jesse Freeman

All installed software in my machine

Mysql Installer Comercial-5.6.13.0-win32-x86
Mysql workbench-5.2.47-win32-x86
php-5.3.26-win32-x86
Apache Tomcat 7.0.57-win32-x86
Apach HTTP Server-2.2.22-win32-x86
Microsoft .Net Framework 4.5.1-win32-x86
Birt Runtime 4_2_0
Eclipse-Reporting-Luna-R-win32
Previous Topic:Table Cell click
Next Topic:Eclipse BIRT Report
Goto Forum:
  


Current Time: Sun Jul 14 05:10:17 GMT 2024

Powered by FUDForum. Page generated in 0.04913 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top