Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Errors generated in generating the report document(In Birt Viewer)
Errors generated in generating the report document [message #1662792] Tue, 10 March 2015 06:01 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)






My xml script:-



<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.23" id="1">
<property name="createdBy">Eclipse BIRT Designer Version 4.4.0.v201405191524 Build &lt;4.4.0.v20140606-1451></property>
<list-property name="propertyBindings">
<structure>
<property name="name">queryText</property>
<property name="id">371</property>
</structure>
</list-property>
<property name="units">in</property>
<property name="iconFile">/templates/blank_report.gif</property>
<property name="layoutPreference">fixed layout</property>
<property name="bidiLayoutOrientation">ltr</property>
<property name="imageDPI">96</property>
<parameters>
<scalar-parameter name="Select" id="372">
<text-property name="promptText">Emp Type</text-property>
<property name="valueType">static</property>
<property name="isRequired">true</property>
<property name="dataType">string</property>
<property name="distinct">true</property>
<list-property name="selectionList">
<structure>
<property name="value">Driver</property>
</structure>
<structure>
<property name="value">Employee</property>
</structure>
<structure>
<property name="value">Other</property>
</structure>
</list-property>
<property name="paramType">simple</property>
<property name="controlType">list-box</property>
<property name="mustMatch">true</property>
<property name="fixedOrder">true</property>
<structure name="format">
<property name="category">Unformatted</property>
</structure>
</scalar-parameter>
</parameters>
<data-sources>
<oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc.dbprofile" name="Data Source" id="370">
<list-property name="privateDriverProperties">
<ex-property>
<name>org.eclipse.datatools.connectivity.db.connectionProperties</name>
</ex-property>
<ex-property>
<name>org.eclipse.datatools.connectivity.oda.profile.db.provider.id</name>
<value>org.eclipse.datatools.enablement.mysql.connectionProfile</value>
</ex-property>
<ex-property>
<name>org.eclipse.datatools.connectivity.db.savePWD</name>
<value>false</value>
</ex-property>
<ex-property>
<name>org.eclipse.datatools.connectivity.drivers.defnType</name>
<value>org.eclipse.datatools.enablement.mysql.5_1.driverTemplate</value>
</ex-property>
<ex-property>
<name>org.eclipse.datatools.connectivity.driverDefinitionID</name>
<value>DriverDefn.org.eclipse.datatools.enablement.mysql.5_1.driverTemplate.MySQL JDBC Driver</value>
</ex-property>
<ex-property>
<name>org.eclipse.datatools.connectivity.db.version</name>
<value>5.1</value>
</ex-property>
<ex-property>
<name>org.eclipse.datatools.connectivity.db.vendor</name>
<value>MySql</value>
</ex-property>
</list-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:\Users\admin\workspace\mysql-connector-java-5.1.34\mysql-connector-java-5.1.34-bin.jar</property>
</oda-data-source>
</data-sources>
<data-sets>
<oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.dbprofile.sqbDataSet" name="Data Set" id="371">
<property name="nullsOrdering">nulls lowest</property>
<list-property name="columnHints">
<structure>
<property name="columnName">emp_id</property>
<property name="analysis">measure</property>
<text-property name="displayName">emp_id</text-property>
<text-property name="heading">emp_id</text-property>
</structure>
<structure>
<property name="columnName">emp_type</property>
<property name="analysis">dimension</property>
<text-property name="displayName">emp_type</text-property>
<text-property name="heading">emp_type</text-property>
</structure>
<structure>
<property name="columnName">emp_name</property>
<property name="analysis">dimension</property>
<text-property name="displayName">emp_name</text-property>
<text-property name="heading">emp_name</text-property>
</structure>
</list-property>
<list-property name="parameters">
<structure>
<property name="name">param_1</property>
<property name="paramName">Select</property>
<property name="nativeName"></property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
<property name="position">1</property>
<property name="isInput">true</property>
<property name="isOutput">false</property>
</structure>
</list-property>
<structure name="cachedMetaData">
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">emp_id</property>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">emp_type</property>
<property name="dataType">string</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">emp_name</property>
<property name="dataType">string</property>
</structure>
</list-property>
</structure>
<property name="dataSource">Data Source</property>
<list-property name="resultSet">
<structure>
<property name="position">1</property>
<property name="name">emp_id</property>
<property name="nativeName">emp_id</property>
<property name="dataType">integer</property>
<property name="nativeDataType">4</property>
</structure>
<structure>
<property name="position">2</property>
<property name="name">emp_type</property>
<property name="nativeName">emp_type</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
<structure>
<property name="position">3</property>
<property name="name">emp_name</property>
<property name="nativeName">emp_name</property>
<property name="dataType">string</property>
<property name="nativeDataType">12</property>
</structure>
</list-property>
<xml-property name="queryText"><![CDATA[SELECT `emp_id`, `emp_type`, `emp_name`
FROM `sdcc`.`employee_master`
WHERE EMP_TYPE = ?
]]></xml-property>
<structure name="designerState">
<property name="version">1.0</property>
<property name="stateContentAsString">&lt;?xml version="1.0" encoding="UTF-8"?>
&lt;SQLQueryBuilder editorInputType="SQLBuilderStorageEditorInput" name="Data Set" version="1.0">
&lt;SQLStatement>SELECT `emp_id`, `emp_type`, `emp_name`&amp;#x0A; FROM `sdcc`.`employee_master`&amp;#x0A; WHERE EMP_TYPE = ?&amp;#x0A;&lt;/SQLStatement>
&lt;connInfo>MySql_5.1:Transient.org.eclipse.datatools.enablement.mysql.connectionProfile:sdcc:admin&lt;/connInfo>
&lt;omitSchemaInfo>false:true:&lt;/omitSchemaInfo>
&lt;editorInputUsageOptions>useWindowState=true&lt;/editorInputUsageOptions>
&lt;windowState height="478" version="1.0" width="687">
&lt;control height="145" isHideable="true" isVisible="true" name="SQLSourceViewer" width="660"/>
&lt;control height="150" isHideable="true" isVisible="true" name="DesignViewer" width="673"/>
&lt;control height="145" isHideable="true" isVisible="true" name="GraphControl" width="665"/>
&lt;control height="149" isHideable="true" isVisible="false" name="OutlineViewer" width="198"/>
&lt;/windowState>
&lt;/SQLQueryBuilder></property>
</structure>
<xml-property name="designerValues"><![CDATA[<?xml version="1.0" encoding="UTF-8"?>
<model:DesignValues xmlns:design="http://www.eclipse.org/datatools/connectivity/oda/design" xmlns:model="http://www.eclipse.org/birt/report/model/adapter/odaModel">
<Version>2.0</Version>
<DataSetParameters>
<parameter>
<design:ParameterDefinition>
<design:inOutMode>In</design:inOutMode>
<design:attributes>
<design:identifier>
<design:name></design:name>
<design:position>1</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>20</design:precision>
</design:attributes>
</design:ParameterDefinition>
</parameter>
</DataSetParameters>
<design:ResultSets derivedMetaData="true">
<design:resultSetDefinitions>
<design:resultSetColumns>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>emp_id</design:name>
<design:position>1</design:position>
</design:identifier>
<design:nativeDataTypeCode>4</design:nativeDataTypeCode>
<design:precision>5</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>emp_id</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>emp_id</design:label>
<design:formattingHints>
<design:displaySize>5</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>emp_type</design:name>
<design:position>2</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>20</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>emp_type</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>emp_type</design:label>
<design:formattingHints>
<design:displaySize>20</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
<design:resultColumnDefinitions>
<design:attributes>
<design:identifier>
<design:name>emp_name</design:name>
<design:position>3</design:position>
</design:identifier>
<design:nativeDataTypeCode>12</design:nativeDataTypeCode>
<design:precision>50</design:precision>
<design:scale>0</design:scale>
<design:nullability>NotNullable</design:nullability>
<design:uiHints>
<design:displayName>emp_name</design:displayName>
</design:uiHints>
</design:attributes>
<design:usageHints>
<design:label>emp_name</design:label>
<design:formattingHints>
<design:displaySize>50</design:displaySize>
</design:formattingHints>
</design:usageHints>
</design:resultColumnDefinitions>
</design:resultSetColumns>
<design:criteria>
<design:rowOrdering/>
</design:criteria>
</design:resultSetDefinitions>
</design:ResultSets>
</model:DesignValues>]]></xml-property>
<list-property name="privateDriverProperties">
<ex-property>
<name>parameterMetaData</name>
</ex-property>
</list-property>
</oda-data-set>
</data-sets>
<styles>
<style name="report" id="4">
<property name="fontFamily">sans-serif</property>
<property name="fontSize">10pt</property>
</style>
<style name="crosstab" id="5">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
<style name="crosstab-cell" id="6">
<property name="borderBottomColor">#CCCCCC</property>
<property name="borderBottomStyle">solid</property>
<property name="borderBottomWidth">1pt</property>
<property name="borderLeftColor">#CCCCCC</property>
<property name="borderLeftStyle">solid</property>
<property name="borderLeftWidth">1pt</property>
<property name="borderRightColor">#CCCCCC</property>
<property name="borderRightStyle">solid</property>
<property name="borderRightWidth">1pt</property>
<property name="borderTopColor">#CCCCCC</property>
<property name="borderTopStyle">solid</property>
<property name="borderTopWidth">1pt</property>
</style>
</styles>
<page-setup>
<simple-master-page name="Simple MasterPage" id="2">
<page-footer>
<text id="3">
<property name="contentType">html</property>
<text-property name="content"><![CDATA[<value-of>new Date()</value-of>]]></text-property>
</text>
</page-footer>
</simple-master-page>
</page-setup>
<body>
<label id="32">
<property name="backgroundColor">#FF8080</property>
<property name="fontSize">50px</property>
<property name="textLineThrough">none</property>
<property name="textAlign">center</property>
<text-property name="text">All Employee Details As per Input</text-property>
</label>
<label id="84"/>
<table id="373">
<property name="dataSet">Data Set</property>
<list-property name="boundDataColumns">
<structure>
<property name="name">emp_id</property>
<text-property name="displayName">emp_id</text-property>
<expression name="expression" type="javascript">dataSetRow["emp_id"]</expression>
<property name="dataType">integer</property>
</structure>
<structure>
<property name="name">emp_type</property>
<text-property name="displayName">emp_type</text-property>
<expression name="expression" type="javascript">dataSetRow["emp_type"]</expression>
<property name="dataType">string</property>
</structure>
<structure>
<property name="name">emp_name</property>
<text-property name="displayName">emp_name</text-property>
<expression name="expression" type="javascript">dataSetRow["emp_name"]</expression>
<property name="dataType">string</property>
</structure>
</list-property>
<column id="392"/>
<column id="393"/>
<column id="394"/>
<header>
<row id="374">
<cell id="375">
<label id="376">
<text-property name="text">emp_id</text-property>
</label>
</cell>
<cell id="377">
<label id="378">
<text-property name="text">emp_type</text-property>
</label>
</cell>
<cell id="379">
<label id="380">
<text-property name="text">emp_name</text-property>
</label>
</cell>
</row>
</header>
<detail>
<row id="381">
<cell id="382">
<data id="383">
<property name="resultSetColumn">emp_id</property>
</data>
</cell>
<cell id="384">
<data id="385">
<property name="resultSetColumn">emp_type</property>
</data>
</cell>
<cell id="386">
<data id="387">
<property name="resultSetColumn">emp_name</property>
</data>
</cell>
</row>
</detail>
<footer>
<row id="388">
<cell id="389"/>
<cell id="390"/>
<cell id="391"/>
</row>
</footer>
</table>
</body>
</report>





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


so sir please give mi sollution please.............
  • Attachment: Untitled3.png
    (Size: 174.06KB, Downloaded 276 times)
Re: Errors generated in generating the report document [message #1663912 is a reply to message #1662792] Tue, 10 March 2015 16:58 Go to previous message
Jesse Freeman is currently offline Jesse FreemanFriend
Messages: 184
Registered: January 2015
Senior Member
I have replied to you on your original thread: https://www.eclipse.org/forums/index.php/t/1037160/
Previous Topic:How to generate html select option element
Next Topic:Can not open the report archive.
Goto Forum:
  


Current Time: Mon Jul 22 15:24:11 GMT 2024

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

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

Back to the top