Eclipse Community Forums: BIRT » Errors occurred when generating the report document

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 07:15

Eclipse User

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 15:04

Eclipse User

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 01:53

Eclipse User

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 681 times)

[Updated on: Tue, 10 March 2015 01:54] by Moderator

Re: Errors occurred when generating the report document [message #1663687 is a reply to message #1662775]

Tue, 10 March 2015 10:47

Eclipse User

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 07:40

Eclipse User

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

Attachment: mysql-connector-java-5.1.18-bin.jar
(Size: 771.37KB, Downloaded 243 times)
Attachment: Untitled5.png
(Size: 142.17KB, Downloaded 479 times)

Re: Errors occurred when generating the report document [message #1666253 is a reply to message #1665778]

Wed, 11 March 2015 12:01

Eclipse User

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 08:13

Eclipse User

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 585 times)
Attachment: 6.png
(Size: 233.88KB, Downloaded 603 times)
Attachment: 14.png
(Size: 274.62KB, Downloaded 622 times)

Re: Errors occurred when generating the report document [message #1668695 is a reply to message #1668283]

Thu, 12 March 2015 11:58

Eclipse User

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 02:05

Eclipse User

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

Attachment: Screenshots.zip
(Size: 2.27MB, Downloaded 282 times)

Re: Errors occurred when generating the report document [message #1671949 is a reply to message #1670267]

Fri, 13 March 2015 16:35

Eclipse User

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 01:02

Eclipse User

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:

-=] Back to Top [=-

Current Time: Wed Mar 12 00:41:23 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter