Home » Archived » BIRT » Can not load the report query: 160. Errors occurred when generating the report document for the repo(Error when running report from server.)
|
Re: Can not load the report query: 160. Errors occurred when generating the report document for the [message #693684 is a reply to message #693613] |
Thu, 07 July 2011 01:53 |
|
If you are using BIRT 3.7 that should be fine. If you are using a
previous version put it in the
web-inf/platform/plugins/org.eclipse.birt.report.data.oda.jdbc_version/drivers
directory
Jason
On 7/6/2011 5:26 PM, SGT. Smith wrote:
> I have developed a simple report and trying to deploy it to the server
> and run and I am getting the following error:
>
> The following items have errors:
>
> Table (id = 160):
> + Can not load the report query: 160. Errors occurred when generating
> the report document for the report element with ID 160. (Element ID:160)
> It works in the BIRT designer (Windows) but not on the
> Linux/Ubuntu/Tomcat6 machine.
>
> I believe it can not find: com.mysql.jdbc.Driver
> which is a class in : mysql-connector-java-5.1.0-bin.jar
>
> which I downloaded and added to the Windows machine and copied the jar to:
>
> /var/lib/tomcat6/webapps/birt/WEB-INF/lib/mysql-connector-java-5.1.0-bin.jar
>
>
> TIA for any pointers.
>
> The error in the log is:
>
>
> Jul 6, 2011 5:01:06 PM
> org.eclipse.birt.data.engine.odaconsumer.ConnectionManager openConnection
> SEVERE: Unable to open connection.
> org.eclipse.datatools.connectivity.oda.OdaException ;
> java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
> at
> org.eclipse.birt.report.data.oda.jdbc.dbprofile.impl.Connection.open(Connection.java:113)
>
> at
> org.eclipse.birt.report.data.oda.jdbc.dbprofile.impl.Connection.open(Connection.java:57)
>
> at
> org.eclipse.datatools.connectivity.oda.consumer.helper.OdaConnection.open(OdaConnection.java:250)
>
> at
> org.eclipse.birt.data.engine.odaconsumer.ConnectionManager.openConnection(ConnectionManager.java:165)
>
> at
> org.eclipse.birt.data.engine.executor.DataSource.newConnection(DataSource.java:224)
>
> at
> org.eclipse.birt.data.engine.executor.DataSource.open(DataSource.java:212)
> at
> org.eclipse.birt.data.engine.impl.DataSourceRuntime.openOdiDataSource(DataSourceRuntime.java:217)
>
> at
> org.eclipse.birt.data.engine.impl.QueryExecutor.openDataSource(QueryExecutor.java:409)
>
> at
> org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:319)
>
> at
> org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455)
>
> at
> org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)
>
> at
> org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)
>
> at
> org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:145)
>
> at
> org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:616)
>
> at
> org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152)
>
> at
> org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:80)
>
> at
> org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:265)
>
> at
> org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1897)
>
> at
> org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
>
> at
> org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)
>
> at
> org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
>
> at
> org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)
>
> at
> org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)
>
> at
> org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)
>
> at
> org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)
>
> at
> org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
>
> 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.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:249)
>
> at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:260)
> at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:85)
> at
> org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1317)
>
> at
> org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:158)
>
> at
> org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)
>
> at
> org.eclipse.birt.report.service.actionhandler.BirtGetPageActionHandler.__checkDocumentExists(BirtGetPageActionHandler.java:58)
>
> at
> org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.prepareParameters(AbstractGetPageActionHandler.java:119)
>
> at
> org.eclipse.birt.report.service.actionhandler.AbstractGetPageActionHandler.__execute(AbstractGetPageActionHandler.java:104)
>
> 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.handleGetPage(BirtDocumentProcessor.java:87)
>
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>
> at java.lang.reflect.Method.invoke(Method.java:616)
> 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(NativeMethodAccessorImpl.java:57)
>
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>
> at java.lang.reflect.Method.invoke(Method.java:616)
> 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:637)
> at
> org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)
>
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
> at
> org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>
> at
> org.eclipse.birt.report.filter.ViewerFilter.doFilter(ViewerFilter.java:68)
> at
> org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
>
> at
> org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
>
> at
> org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
>
> at
> org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
>
> at
> org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
>
> at
> org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
>
> at
> org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
>
> at
> org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
> at
> org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
> at
> org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
>
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
> at java.lang.Thread.run(Thread.java:679)
> Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
> at java.net.URLClassLoader$1.run(URLClassLoader.java:217)
> at java.security.AccessController.doPrivileged(Native Method)
> at java.net.URLClassLoader.findClass(URLClassLoader.java:205)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:321)
> at java.net.FactoryURLClassLoader.loadClass(URLClassLoader.java:615)
> at java.lang.ClassLoader.loadClass(ClassLoader.java:266)
> at
> org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(JDBCConnection.java:212)
>
> at
> org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.internalCreateConnection(JDBCConnection.java:140)
>
> at
> org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(JDBCConnection.java:96)
>
> at
> org.eclipse.datatools.enablement.internal.mysql.connection.JDBCMySQLConnectionFactory.createConnection(JDBCMySQLConnectionFactory.java:28)
>
> at
> org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
>
> at
> org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:359)
>
> at
> org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.initializeJDBCConnection(ConnectionInfoImpl.java:659)
>
> at
> org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionInfoImpl.<init>(ConnectionInfoImpl.java:644)
>
> at
> org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:38)
>
> at
> org.eclipse.datatools.connectivity.sqm.core.SQMConnectionFactory.createConnection(SQMConnectionFactory.java:45)
>
> at
> org.eclipse.datatools.connectivity.sqm.internal.core.connection.ConnectionFactory.createConnection(ConnectionFactory.java:59)
>
> at
> org.eclipse.datatools.connectivity.internal.ConnectionFactoryAdapterProvider.createConnection(ConnectionFactoryAdapterProvider.java:114)
>
> at
> org.eclipse.datatools.connectivity.internal.ManagedConnection.createConnection(ManagedConnection.java:163)
>
> at
> org.eclipse.datatools.connectivity.internal.CreateConnectionJob.run(CreateConnectionJob.java:56)
>
> at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)
>
>
> Report XML:
> <?xml version="1.0" encoding="UTF-8"?>
> <report xmlns="(error posting this about links...)" version="3.2.22"
> id="1">
> <property name="createdBy">Eclipse BIRT Designer Version 3.7.0.v20110602
> Build <3.7.0.v20110607-1526></property>
> <list-property name="userProperties">
> <structure>
> <property name="name">Data Cube - Data Set.Data Set.x</property>
> <property name="type">integer</property>
> <property name="isVisible">false</property>
> </structure>
> <structure>
> <property name="name">Data Cube - Data Set.Data Set.y</property>
> <property name="type">integer</property>
> <property name="isVisible">false</property>
> </structure>
> </list-property>
> <property name="Data Cube - Data Set.Data Set.x">135</property>
> <property name="Data Cube - Data Set.Data Set.y">80</property>
> <property name="units">in</property>
> <property name="iconFile">/templates/crosstab.gif</property>
> <property
> name="cheatSheet">org.eclipse.birt.report.designer.ui.cheatsheet.crosstab</property>
>
> <property name="bidiLayoutOrientation">ltr</property>
> <property name="imageDPI">96</property>
> <data-sources>
> <oda-data-source
> extensionID="org.eclipse.birt.report.data.oda.jdbc.dbprofile" name="Data
> Source" id="18">
> <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>true</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.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">xxxxx</property>
> <property name="username">xxxxxxxxxxxx</property>
> <encrypted-property name="password"
> encryptionID="base64">xxxxxxxxxxxxx</encrypted-property>
> <property name="URL">jdbc:mysql://10.226.9.150:3306/polk</property>
> <property name="driverClass">com.mysql.jdbc.Driver</property>
> <property
> name="jarList">mysql-connector-java-5.1.0-bin.jar;/var/lib/tomcat6/webapps/birt/WEB-INF/lib/mysql-connector-java-5.1.0-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="20">
> <list-property name="columnHints">
> <structure>
> <property name="columnName">Make</property>
> <property name="analysis">attribute</property>
> <text-property name="displayName">MAKE</text-property>
> <text-property name="heading">MAKE</text-property>
> </structure>
> <structure>
> <property name="columnName">Model</property>
> <property name="analysis">attribute</property>
> <text-property name="displayName">MODEL</text-property>
> <text-property name="heading">MODEL</text-property>
> </structure>
> <structure>
> <property name="columnName">COUNT</property>
> <property name="analysis">measure</property>
> <text-property name="displayName">COUNT</text-property>
> <text-property name="heading">COUNT</text-property>
> </structure>
> </list-property>
> <list-property name="parameters"/>
> <structure name="cachedMetaData">
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">Make</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">Model</property>
> <property name="dataType">string</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">COUNT</property>
> <property name="dataType">integer</property>
> </structure>
> </list-property>
> </structure>
> <property name="dataSource">Data Source</property>
> <list-property name="resultSet">
> <structure>
> <property name="position">1</property>
> <property name="name">Make</property>
> <property name="nativeName">Make</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">2</property>
> <property name="name">Model</property>
> <property name="nativeName">Model</property>
> <property name="dataType">string</property>
> <property name="nativeDataType">12</property>
> </structure>
> <structure>
> <property name="position">3</property>
> <property name="name">COUNT</property>
> <property name="nativeName">COUNT</property>
> <property name="dataType">integer</property>
> <property name="nativeDataType">-5</property>
> </structure>
> </list-property>
> <xml-property name="queryText"><![CDATA[SELECT MAKE, MODEL, COUNT(VIN)
> AS COUNT
> FROM `polk`.`data`
> GROUP BY MAKE, MODEL
> ]]></xml-property>
> <structure name="designerState">
> <property name="version">1.0</property>
> <property name="stateContentAsString"><?xml version="1.0"
> encoding="UTF-8"?>
> <SQLQueryBuilder editorInputType="SQLBuilderStorageEditorInput"
> name="Data Set" version="1.0">
> <SQLStatement>SELECT MAKE, MODEL, COUNT(VIN) AS COUNT
 FROM
> `polk`.`data`
 GROUP BY MAKE, MODEL
</SQLStatement>
> <connInfo>MySql_5.1:Transient.org.eclipse.datatools.enablement.mysql.connectionProfile:polk:ksmith</connInfo>
>
> <omitSchemaInfo>false:true:</omitSchemaInfo>
> <editorInputUsageOptions>useWindowState=true</editorInputUsageOptions>
> <windowState height="594" version="1.0" width="856">
> <control height="181" isHideable="true" isVisible="true"
> name="SQLSourceViewer" width="829"/>
> <control height="192" isHideable="true" isVisible="true"
> name="DesignViewer" width="842"/>
> <control height="183" isHideable="true" isVisible="true"
> name="GraphControl" width="834"/>
> <control height="187" isHideable="true" isVisible="false"
> name="OutlineViewer" width="156"/>
> </windowState>
> </SQLQueryBuilder></property>
> </structure>
> <xml-property name="designerValues"><![CDATA[<?xml version="1.0"
> encoding="UTF-8"?>
> <model:DesignValues xmlns:design="(error about post having links...)"
> xmlns:model="(error about post having links...)">
> <Version>2.0</Version>
> <design:ResultSets derivedMetaData="true">
> <design:resultSetDefinitions>
> <design:resultSetColumns>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>Dealer_State</design:name>
> <design:position>1</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>2</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> <design:uiHints>
> <design:displayName>DEALER_STATE</design:displayName>
> </design:uiHints>
> </design:attributes>
> <design:usageHints>
> <design:label>DEALER_STATE</design:label>
> <design:formattingHints>
> <design:displaySize>2</design:displaySize>
> </design:formattingHints>
> </design:usageHints>
> </design:resultColumnDefinitions>
> <design:resultColumnDefinitions>
> <design:attributes>
> <design:identifier>
> <design:name>Make</design:name>
> <design:position>2</design:position>
> </design:identifier>
> <design:nativeDataTypeCode>12</design:nativeDataTypeCode>
> <design:precision>128</design:precision>
> <design:scale>0</design:scale>
> <design:nullability>NotNullable</design:nullability>
> <design:uiHints>
> <design:displayName>MAKE</design:displayName>
> </design:uiHints>
> </design:attributes>
> Path: news.eclipse.org!not-for-mail
> From: jeyinul <forums-noreply@eclipse.org>
> Newsgroups: eclipse.birt
> Subject: =?utf-8?Q?Chart?=
> Date: Wed, 06 Jul 2011 07:16:16 -0400
> Organization: Eclipse Community Forums
> Lines: 2900
> Message-ID: <iv1fjs$7fu$1@news.eclipse.org>
> Reply-To: jeyinul <forums-noreply@eclipse.org>
> NNTP-Posting-Host: 172.30.206.107
> X-Trace: news.eclipse.org 1309950396 7678 172.30.206.107 (6 Jul 2011
> 11:06:36 GMT)
> X-Complaints-To: news@news.eclipse.org
> NNTP-Posting-Date: Wed, 6 Jul 2011 11:06:36 +0000 (UTC)
> X-FUDforum: c7ed4ca4d6a4ff3b73a07e2176df25fb <693383>
> User-Agent: FUDforum
> Xref: news.eclipse.org eclipse.birt:42656
>
> Hi All,
>
> i generate a report using cross tab and chart.
>
> But the count is different in cross tab and chart.
>
> In chart The count is not increasing more than 4.
>
> PFA.
>
> CROSS TAB IS IN FIRST PAGE.
> CHART IS IN SECOND PAGE.
>
> Please help me on this.
>
> Thanks,
> Jeyinul.
> begin 644 run.doc
> MT,\1X*&Q&N$`````````````````````/@`#`/[_"0`&```````````````"
> M````^```````````$```^@````$```#^____`````/8```#W````________
> M____________________________________________________________
> M____________________________________________________________
> M____________________________________________________________
> M____________________________________________________________
> M____________________________________________________________
> M____________________________________________________________
> M____________________________________________________________
> M____________________________________________________________
> M____________________________________________________________
> M_______________________LI<$`6X`)!```^!*_````````$```````"```
> MD`T```X`8FIB:JSZK/H````````````````````````)!!8`-,H``,Z0`0#.
> MD`$`904````````J``````````````````````````````#__P\`````````
> M``#__P\```````````#__P\``````````````````````+<``````.0%````
> M````Y`4``"<3````````)Q,````````G$P```````"<3````````)Q,``!0`
> M`````````````/____\`````.Q,````````[$P```````#L3```X````<Q,`
> M`$0```"W$P``M`(``#L3````````PQD``#`!``!K%@``*````),6````````
> MDQ8```````"3%@```````),6````````?A@```````!^&````````'X8````
> M````9AD```(```!H&0```````&@9````````:!D```````!H&0```````&@9
> M````````:!D```````#S&@``H@(``)4=``!&````:!D``!4`````````````
> M````````````)Q,```````!^&``````````````````````````````^&```
> M0````'X8````````?A@```````!^&````````&@9```````````````````G
> M$P```````"<3````````DQ8``````````````````),6``"K`0``?1D``!8`
> M```N&0```````"X9````````+AD```````!^&```6````"<3````````DQ8`
> M```````G$P```````),6````````9AD``````````````````"X9````````
> M````````````````````````````````````````````````````````````
> M````?A@```````!F&0``````````````````+AD``````````````````"X9
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````+AD```````"3%@``
> M`````/____\`````((Z1CLT[S`$``````````#L3````````UA@``%@````N
> M&0``````````````````4AD``!0```"3&0``,````,,9````````+AD`````
> M``#;'0```````"X9````````VQT````````N&0``````````````````````
> M````````````````````````````````````````````````````````````
> M`````````````````````-L=```````````````````G$P```````"X9```D
> M````?A@```````!^&````````"X9````````?A@```````!^&```````````
> M````````````````````````````````````````?A@```````!^&```````
> M`'X8````````:!D```````!H&0``````````````````````````````````
> M````````````````+AD`````````````````````````````````````````
> M`````````'X8````````?A@```````!^&````````,,9````````?A@`````
> M``!^&````````'X8````````?A@``````````````````/____\`````____
> M_P````#_____````````````````_____P````#_____`````/____\`````
> M_____P````#_____`````/____\`````_____P````#_____`````/____\`
> M````_____P````#_____`````/____\`````_____P````#_____`````-L=
> M````````?A@```````!^&````````'X8````````?A@```````!^&```````
> M`'X8````````````````````````````````````````````````````````
> M``````````````````````````!^&````````'X8````````?A@```````#D
> M!0``"0P``.T1```Z`0``!0`2`0``"00`````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M``````````````````````````````````````````````````````@3($E.
> M0TQ51$5024-455)%("!<9"`B=V]R9&UL.B\O-S4N<&YG(B!<*B!-15)'149/
> M4DU!5$E.150@%`$5#5!R;VIE8W0@3F%M90=*15E)3E5,(%-%0U522519(%-!
> M35!,12!415-424Y'!P<-1G)O;2!$871E(%-E;&5C=&5D!S`V+4IU;"TR,#$P
> M!U1O($1A=&4@4V5L96-T960',#8M2G5L+3(P,3$'!PU$969E8W0@36%N86=E
> M;65N="!297!O<G0@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@
> M("`@("`@(%!224]22519("`-("`@("`@("`@("`@("`@("`@("`@(%194$4@
> M("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@("`@
> M("`@("`@(%-405154P=#<FET:6-A;`=(:6=H!TQO=P=-961I=6T'5$]404P'
> M!P<'!P<'!P<M("T'0VQO<V5D!RT'+0<M!RT'+0<'!T1E9F5R<F5D!RT'+0<M
> M!RT'+0<'!T9I>&5D!RT'+0<M!RT'+0<'!TYE=P<Q!RT'+0<M!S$'!P=/<&5N
> M!RT'+0<M!RT'+0<'!U)E+6]P96X'+0<M!RT'+0<M!P<'4F5J96-T960'+0<M
> M!RT'+0<M!P<'3E5,3"`@5$]404P',0<M!RT'+0<Q!P=#=7-T;VUE<B!297!O
> M<G1E9"!$969E8W0'0VQO<V5D!RT',0<M!RT',0<'!T1E9F5R<F5D!RT'+0<M
> M!S$',0<'!T9I>&5D!RT'+0<M!RT'+0<'!TYE=P<M!RT',0<M!S$'!P=/<&5N
> M!RT'+0<Q!S$',@<'!U)E+6]P96X'+0<M!RT'+0<M!P<'4F5J96-T960'+0<M
> M!RT'+0<M!P<'0W5S=&]M97(@4F5P;W)T960@1&5F96-T(%1/5$%,!RT',0<R
> M!S('-0<'26YT97)N86P@4F5V:65W($1E9F5C=`=#;&]S960'+0<M!RT',0<Q
> M!P<'1&5F97)R960',0<M!RT'+0<Q!P<'1FEX960'+0<M!RT',@<R!P<'3F5W
> M!RT'+0<Q!S$',@<'!T]P96X'+0<M!RT',@<R!P<'4F4M;W!E;@<M!RT'+0<M
> M!RT'!P=296IE8W1E9`<M!RT'+0<M!RT'!P=);G1E<FYA;"!2979I97<@1&5F
> M96-T(%1/5$%,!S$'+0<Q!S8'.`<'26YT97)N86P@5&5S=&EN9R!$969E8W0'
> M0VQO<V5D!RT'+0<M!RT'+0<'!T1E9F5R<F5D!RT'+0<M!RT'+0<'!T9I>&5D
> M!RT'+0<M!RT'+0<'!TYE=P<M!S$'+0<M!S$'!P=/<&5N!RT'+0<M!RT'+0<'
> M!U)E+6]P96X'+0<M!RT'+0<M!P<'4F5J96-T960',0<M!RT'+0<Q!P<'26YT
> M97)N86P@5&5S=&EN9R!$969E8W0@5$]404P',0<Q!RT'+0<R!P=,96=A8WD@
> M1&5F96-T!T-L;W-E9`<M!RT'+0<M!RT'!P=$969E<G)E9`<M!RT'+0<M!RT'
> M!P=&:7AE9`<M!RT'+0<M!RT'!P=.97<',0<M!S$',0<S!P<'3W!E;@<M!RT'
> M+0<M!RT'!P=292UO<&5N!S0'+0<Q!RT'-0<'!U)E:F5C=&5D!RT'+0<M!RT'
> M+0<'!TQE9V%C>2!$969E8W0@5$]404P'-0<M!S(',0<X!P=43U1!3`<X!S('
> M-0<Y!S(T!P<($R!)3D-,541%4$E#5%5212`@7&0@(G=O<F1M;#HO+S<V+G!N
> M9R(@7"H@34521T5&3U)-051)3D54(!0!%0T##0T$#0T##0T$#0T'!PT-#4IU
> M;"`V+"`R,#$Q(#0Z-#`@4$T-#0<'#0T-````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M```(```""```.P@``#X(```_"```2P@``$P(``!K"```;0@``&X(``"`"```
> M@0@``(P(``"-"```G0@``)X(``"I"```JP@``*P(``#W"```^`@``$T)``!.
> M"0``5@D``%<)``!;"0``7`D``%\)``!@"0``9@D``&<)``!L"0``;@D``'0)
> M``!U"0``>`D``'D)``!_"0``@`D``($)``"""0``@PD``(0)``"%"0``A@D`
> M`(<)``"("0``B0D``(L)``","0``E`D``)4)``"6"0``EPD``)@)``"9"0``
> MF@D``/?S]_/<\]SSU]SSW//<\]SSU\3SQ/.Q\['SL?.Q\\3SU_.>\X[SCO..
> M\X[SCO..\]>.\X[SCO..'Q9H#R^A`$(J`4]*`P!02@,`44H#`%Y*`P!P:```
> M```E%F@/+Z$`-0B!0BH!3TH#`%!*`P!12@,`7`B!7DH#`'!H`````"46:`\O
> MH0`U"(%"*@U/2@,`4$H#`%%*`P!<"(%>2@,`<&B`````)19H#R^A`#4(@4(J
> M"$]*`P!02@,`44H#`%P(@5Y*`P!P:/___P`)%F@U5@$`/`B!+19H#R^A`#4(
> M@4(J"$-*%@!/2@,`4$H#`%%*`P!<"(%>2@,`84H6`'!H____``86:#56`0``
> M#P-J`````!9H-58!`%4(`0`X``@``#\(``!,"```;`@``&T(``!N"```@0@`
> M`(T(``">"```J@@``/T```````````````#W````````````````[@``````
> M`````````($```````````````#]````````````````]P``````````````
> M`.X```````````````#W````````````````[@``````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````;0``:V1Y$@``%B0!%R0!268!`````I9L``0T`0C6,``"E/]?!Y0=
> M``;+!P@!`0`(`0$`"`$!``@!`0``!C46"`$!``@!`0`(`0$`"`$!``G6!$`!
> M@`$*=```X`$2UA0```#_`("`````````_X``@````!3V`P`>%_8#```:U@@`
> M`````````!O6"```````````'-8(```````````=U@@``````````#36!@`!
> M!0,``#36!@`!"@-L`&'V`P``930!<-84````_P"`@````````/^``(`````)
> M```#)`$6)`%)9@$```!A)`$&```6)`%)9@$``````0````FJ"```JP@``*P(
> M``#X"```+P```````````````"T````````````````G````````````````
> M```````````````````````````````&```6)`%)9@$``````0``T```:V09
> M$P``%B0!%R0!268!`````I9L``0T`076&!`!`0`0`0$`$`$!`!`!`0``````
> M``````C67``$E/\M#&$41Q\?*0`&F0P(`0$`"`$!``@!`0`(`0$```8T"`@!
> M`0`(`0$`"`$!``@!`0``!N8*"`$!``@!`0`(`0$`"`$!```&V`D(`0$`"`$!
> M``@!`0`(`0$`"=8(0`&``4`!@`$*=```X`$2UB@```#_`("`````````_X``
> M@````````/\`@(````````#_@`"`````$]8P`````!`!````````$`$`````
> M```0`0```````!`!``````#_`````````/\`````%/8#BRD7]@,``!K6$```
> M```````````````````;UA``````````````````````'-80````````````
> M`````````!W6$``````````````````````TU@8``04#```TU@8``0H#;`!A
> M]@,``&4T`7#6*````/\`@(````````#_@`"`````````_P"`@````````/^`
> M`(```````_@(``!."0``5PD``%P)``!@"0``9PD``&T)``!N"0``;PD``'`)
> M``!Q"0``<@D``',)``!T"0``]0```````````````.P```````````````#L
> M````````````````[````````````````.P```````````````#:````````
> M````````U0```````````````,\```````````````#/````````````````
> MSP```````````````,\```````````````#/````````````````SP``````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M``````````````````````8``!8D`4EF`0`````$``!&9J45````$0```R0!
> M%B0!+42``4EF`0```$W&"@```/^``(````!A)`$)```#)`$6)`%)9@$```!A
> M)`$*```3I`H`%*0*`!8D`4EF`0`````-=`D``'4)``!Y"0``*```````````
> M`````!\````````````````````````````````````````````````)```#
> M)`$6)`%)9@$```!A)`$`U@``:V2_%P``%B0!%R0!268!`````I9L``,T`00T
> M`076&!`!`0`0`0$`$`$!`!`!`0````````````C6B``&E/\>*,PR>CTH2-92
> M9%P@!I<=$`$!`!`!`0`0`0$`$`$!```&RP<(`0$`"@$0``H!$``*`1````;+
> M!P@!`0`*`1``"@$0``H!$```!LL'"`$!``H!$``*`1``"@$0```&RP<(`0$`
> M"@$0``H!$``*`1````;Y!@H!$``*`1``"@$0``H!$``)U@)``0IT``#@`1+6
> M"@```/\`@(`````3UC``````$`$````````0`0```````!`!````````$`$`
> M`````/\`````````_P`````4]@/07!?V`P``&M88````````````````````
> M``````#,S,P`&]88`````,S,S`#,S,P`S,S,`,S,S`#,S,P`'-88`````,S,
> MS`#,S,P`S,S,`,S,S`#,S,P`'=88`````,S,S`#,S,P`S,S,`,S,S`#,S,P`
> M--8&``$%`P``--8&``$*`VP`8?8#``!E-`%PU@H```#_`("```````)Y"0``
> M@`D``(()``"$"0``A@D``(@)``"*"0``^0```````````````/``````````
> M``````#P````````````````\````````````````/````````````````#P
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M```````````````````````````````````)```#)`$6)`%)9@$```!A)`$&
> M```6)`%)9@$`````!HH)``"+"0``%P``````````````````````````````
> M``````````````````#H``!K9/@8```6)`$7)`%)9@$````"EFP``S0!!=88
> M$`$!`!`!`0`0`0$`$`$!````````````"-:>``>4_V81'BC,,GH]*$C64F1<
> M8`8"#0@!`0`(`0$`"`$!``@!`0``!I40"@$0``H!$``*`1``"`$!```&RP<*
> M`1``"@$0``H!$``*`1````;+!PH!$``*`1``"@$0``H!$```!LL'"@$0``H!
> M$``*`1``"@$0```&RP<*`1``"@$0``H!$``*`1````;Y!@H!$``*`1``"@$0
> M``H!$``)U@(``0IT``#@`1+6"@```/____\````3UC``````$`$````````0
> M`0```````!`!````````$`$``````/\`````````_P`````4]@/07!?V`P``
> M&M8<`````,S,S`#,S,P`S,S,`,S,S`#,S,P`S,S,`!O6'`````#,S,P`S,S,
> M`,S,S`#,S,P`S,S,`,S,S``<UAP`````S,S,`,S,S`#,S,P`S,S,`,S,S`#,
> MS,P`'=8<``````````#,S,P`S,S,`,S,S`#,S,P`S,S,`#36!@`!!0,``#36
> M!@`!"@-L`&'V`P``930!<-8*````_____P`````!BPD``(P)``"5"0``EPD`
> M`)D)``";"0``G0D``)\)``#Y````````````````^0```````````````/``
> M``````````````#P````````````````\````````````````/``````````
> M``````#P````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````"0```R0!%B0!268!````820!!@``%B0!268!````
> M``>:"0``FPD``)P)``"="0``G@D``*`)``"A"0``I@D``*<)``"H"0``J0D`
> M`*H)``"K"0``K`D``*T)``"N"0``KPD``+`)``"R"0``LPD``+8)``"W"0``
> MN`D``+D)``"Z"0``NPD``+P)``"]"0``O@D``+\)``#`"0``P@D``,,)``#'
> M"0``R`D``,D)``#*"0``RPD``,P)``#-"0``S@D``,\)``#0"0``T0D``-,)
> M``#4"0``VPD``-P)``#="0``W@D``-\)``#@"0``X0D``.()``#C"0``Y`D`
> M`.4)``#G"0``Z`D``/`)``#Q"0``\@D``/,)``#T"0``]0D``/8)``#W"0``
> M^`D``/D)``#Z"0``_`D``/T)```("@``"0H```H*```+"@``#`H```T*```.
> M"@``#PH``!`*```1"@``$@H``!0*``#\[/SL_.?L_.S\[/SL_.S\[/SG[/SL
> M_.S\[/SL_.S\Y^S\[/SL_.S\[/SL_.?L_.S\[/SL_.S\[/SG[/SL_.S\[/SL
> M_.S\Y]3\U/S4_-3\U/S4_```````)19H#R^A`#4(@4(J"$]*`P!02@,`44H#
> M`%P(@5Y*`P!P:/___P`)%F@U5@$`/`B!'Q9H#R^A`$(J`4]*`P!02@,`44H#
> M`%Y*`P!P:``````&%F@U5@$`4Y\)``"@"0``%P``````````````````````
> M``````````````````````````#H``!K9$0:```6)`$7)`%)9@$````"EFP`
> M`S0!!=88$`$!`!`!`0`0`0$`$`$!````````````"-:>``>4_V81'BC,,GH]
> M*$C64F1<(`8"#0@!`0`(`0$`"`$!``@!`0``!I40"@$0``H!$``*`1``"`$!
> M```&RP<*`1``"@$0``H!$``*`1````;+!PH!$``*`1``"@$0``H!$```!LL'
> M"@$0``H!$``*`1``"@$0```&RP<*`1``"@$0``H!$``*`1````;Y!@H!$``*
> M`1``"@$0``H!$``)U@(``0IT``#@`1+6"@```/____\````3UC``````$`$`
> M```````0`0```````!`!````````$`$``````/\`````````_P`````4]@/0
> M7!?V`P``&M8<`````,S,S`#,S,P`S,S,`,S,S`#,S,P`S,S,`!O6'`````#,
> MS,P`S,S,`,S,S`#,S,P`S,S,`,S,S``<UAP`````S,S,`,S,S`#,S,P`S,S,
> M`,S,S`#,S,P`'=8<``````````#,S,P`S,S,`,S,S`#,S,P`S,S,`#36!@`!
> M!0,``#36!@`!"@-L`&'V`P``930!<-8*````_____P`````!H`D``*$)``"G
> M"0``J0D``*L)``"M"0``KPD``+$)``#Y````````````````^0``````````
> M`````/````````````````#P````````````````\````````````````/``
> M``````````````#P````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> M````````````````````````````````````````````````````````````
> Path: news.eclipse.org!not-for-mail
> From: <forums-noreply@eclipse.org>
> Newsgroups: eclipse.birt
> Subject: =?utf-8?Q?Re:=20Compare=20value=20in=20detail=20row?=
> Date: Wed, 06 Jul 2011 05:39:19 -0400
> Organization: Eclipse Community Forums
> Lines: 3
> Message-ID: <iv19u3$td$1@news.eclipse.org>
> References: <iuv97g$ib$1@news.eclipse.org>
> Reply-To: <forums-noreply@eclipse.org>
> NNTP-Posting-Host: 172.30.206.106
> Content-Type: text/plain; charset=utf-8; format=flowed
> X-Trace: news.eclipse.org 1309944579 941 172.30.206.106 (6 Jul 2011
> 09:29:39 GMT)
> X-Complaints-To: news@news.eclipse.org
> NNTP-Posting-Date: Wed, 6 Jul 2011 09:29:39 +0000 (UTC)
> X-FUDforum: c7ed4ca4d6a4ff3b73a07e2176df25fb <693339>
> User-Agent: FUDforum
> Xref: news.eclipse.org eclipse.birt:42655
>
> Thank you!
> This is the solution, it works.
> :)
|
|
| | | |
Re: Can not load the report query: 160. Errors occurred when generating the report document for the [message #699404 is a reply to message #699209] |
Thu, 21 July 2011 13:52 |
|
Are you using the new 3.7 runtime? Did you update the runtime from an
earlier version or is this a new app? In the web.xml for the viewer you
can set the log level and log location. If you are using 3.7 runtime
viewer putting the driver in the web-inf/lib should work.
Jason
On 7/21/2011 1:16 AM, ToroTo wrote:
> Hi,
>
> I encounter the same problem in BIRT 3.7.
> My report works perfectely in Eclipse. But, when I deploy the
> report.rptdesign on the tomcat server, in the web-viewer directory, and
> then execute the report, I receive the following message :
> Can not load the report query: 9. Errors occurred when generating the
> report document for the report element with ID 9. (Element ID:9)
> The mysql-connector-java-bin.jar file is in the /WEB-INF/lib directory !!!
> I've removed/installed the connector a second time and deploy another
> report, but it doesn't fix my problem !!! :(
> Where can i find more informations ? Where are the BIRT logs ?
> Thank you.
|
|
|
Re: Can not load the report query: 160. Errors occurred when generating the report document for the [message #699612 is a reply to message #699404] |
Thu, 21 July 2011 22:47 |
ToroTo Messages: 2 Registered: July 2011 |
Junior Member |
|
|
Hi Jason,
Thanks for your reply.
I am using the Latest BIRT Runtime Release Build: 3.7.0, it's not an upgrade from an earlier version.
I finaly find the source of my trouble !
Tomcat and Mysql are installed in a virtualbox machine and Eclipse is installed on the host.
In order to access the database on the guest from Eclipse, I had configured the Nat of the VM like this :
Name Protocol Host IP Host Port Guest IP Guest Port
MySQL TCP 127.0.0.1 3306 10.0.2.15 3306
Tomcat TCP 127.0.0.1 8080 10.0.2.15 8080
where 10.0.2.15 is the IP address of my VM. But I also needed to change the parameter bind-address of the MySQL configuration file my.cnf with the ip address of the VM : 10.0.2.15.
As the report is now executed by the server, I change the bind-address parameter to 127.0.0.1 and the report runs perfectly.
Now, I have to find a way to access MySQL from both the host and the guest. It seems that the bind-address parameter does not support more than one address. but This is another question for another forum.
Thanks again
[Updated on: Thu, 21 July 2011 22:49] Report message to a moderator
|
|
|
Goto Forum:
Current Time: Sat Apr 27 07:04:20 GMT 2024
Powered by FUDForum. Page generated in 0.03730 seconds
|