Skip to main content


Eclipse Community Forums

      Home
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.)
Can not load the report query: 160. Errors occurred when generating the report document for the repo [message #693613] Wed, 06 July 2011 17:26 Go to next message
Eclipse UserFriend
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 &lt;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">&lt;?xml version="1.0" encoding="UTF-8"?>
&lt;SQLQueryBuilder editorInputType="SQLBuilderStorageEditorInput" name="Data Set" version="1.0">
&lt;SQLStatement>SELECT MAKE, MODEL, COUNT(VIN) AS COUNT&amp;#x0A;  FROM `polk`.`data`&amp;#x0A;  GROUP BY MAKE, MODEL&amp;#x0A;&lt;/SQLStatement>
&lt;connInfo>MySql_5.1:Transient.org.eclipse.datatools.enablement.mysql.connectionProfile:polk:ksmith&lt;/connInfo>
&lt;omitSchemaInfo>false:true:&lt;/omitSchemaInfo>
&lt;editorInputUsageOptions>useWindowState=true&lt;/editorInputUsageOptions>
&lt;windowState height="594" version="1.0" width="856">
&lt;control height="181" isHideable="true" isVisible="true" name="SQLSourceViewer" width="829"/>
&lt;control height="192" isHideable="true" isVisible="true" name="DesignViewer" width="842"/>
&lt;control height="183" isHideable="true" isVisible="true" name="GraphControl" width="834"/>
&lt;control height="187" isHideable="true" isVisible="false" name="OutlineViewer" width="156"/>
&lt;/windowState>
&lt;/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>
          <design:usageHints>
            <design:label>MAKE</design:label>
            <design:formattingHints>
              <design:displaySize>128</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
        <design:resultColumnDefinitions>
          <design:attributes>
            <design:identifier>
              <design:name>COUNT</design:name>
              <design:position>3</design:position>
            </design:identifier>
            <design:nativeDataTypeCode>-5</design:nativeDataTypeCode>
            <design:precision>21</design:precision>
            <design:scale>0</design:scale>
            <design:nullability>NotNullable</design:nullability>
            <design:uiHints>
              <design:displayName>COUNT</design:displayName>
            </design:uiHints>
          </design:attributes>
          <design:usageHints>
            <design:label>COUNT</design:label>
            <design:formattingHints>
              <design:displaySize>21</design:displaySize>
            </design:formattingHints>
          </design:usageHints>
        </design:resultColumnDefinitions>
      </design:resultSetColumns>
      <design:criteria>
        <design:rowOrdering/>
      </design:criteria>
    </design:resultSetDefinitions>
  </design:ResultSets>
</model:DesignValues>]]></xml-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-cell" 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" 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>
        <grid id="7">
            <column id="8"/>
            <row id="9">
                <cell id="10">
                    <label id="11">
                        <property name="fontSize">14pt</property>
                        <property name="fontWeight">bold</property>
                        <property name="textAlign">center</property>
                        <text-property name="text">Cross Tab</text-property>
                    </label>
                </cell>
            </row>
        </grid>
        <table id="160">
            <property name="dataSet">Data Set</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">Make</property>
                    <text-property name="displayName">MAKE</text-property>
                    <expression name="expression" type="javascript">dataSetRow["Make"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">Model</property>
                    <text-property name="displayName">MODEL</text-property>
                    <expression name="expression" type="javascript">dataSetRow["Model"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">COUNT</property>
                    <text-property name="displayName">COUNT</text-property>
                    <expression name="expression" type="javascript">dataSetRow["COUNT"]</expression>
                    <property name="dataType">integer</property>
                </structure>
            </list-property>
            <column id="173"/>
            <column id="174"/>
            <column id="175"/>
            <header>
                <row id="161">
                    <cell id="162">
                        <label id="176">
                            <text-property name="text">MAKE</text-property>
                        </label>
                    </cell>
                    <cell id="163">
                        <label id="178">
                            <text-property name="text">MODEL</text-property>
                        </label>
                    </cell>
                    <cell id="164">
                        <label id="180">
                            <text-property name="text">COUNT</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <detail>
                <row id="165">
                    <cell id="166">
                        <data id="177">
                            <property name="resultSetColumn">Make</property>
                        </data>
                    </cell>
                    <cell id="167">
                        <data id="179">
                            <property name="resultSetColumn">Model</property>
                        </data>
                    </cell>
                    <cell id="168">
                        <data id="181">
                            <property name="resultSetColumn">COUNT</property>
                        </data>
                    </cell>
                </row>
            </detail>
            <footer>
                <row id="169">
                    <cell id="170"/>
                    <cell id="171"/>
                    <cell id="172"/>
                </row>
            </footer>
        </table>
    </body>
</report>
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] Wed, 06 July 2011 21:53 Go to previous messageGo to next message
Eclipse UserFriend
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&#x0A; FROM
> `polk`.`data`&#x0A; GROUP BY MAKE, MODEL&#x0A;</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 #693702 is a reply to message #693684] Wed, 06 July 2011 23:29 Go to previous messageGo to next message
Eclipse UserFriend
It is BIRT 3.7.
Re: Can not load the report query: 160. Errors occurred when generating the report document for the [message #693785 is a reply to message #693702] Thu, 07 July 2011 04:12 Go to previous messageGo to next message
Eclipse UserFriend
Yesterday i have faced similar problem, then i remmoved the jar file from that location freshly copied. Agian i have defined new database connection. there u can test test connection. I hope this might help you.

Thank you.
Re: Can not load the report query: 160. Errors occurred when generating the report document for the [message #699209 is a reply to message #693613] Thu, 21 July 2011 01:16 Go to previous messageGo to next message
Eclipse UserFriend
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 !!! Sad

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 #699404 is a reply to message #699209] Thu, 21 July 2011 09:52 Go to previous messageGo to next message
Eclipse UserFriend
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 18:47 Go to previous message
Eclipse UserFriend
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. Very Happy

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 18:49] by Moderator

Previous Topic:Auto Drill-Through
Next Topic:Validate input parameter in script
Goto Forum:
  


Current Time: Tue Jul 22 14:28:57 EDT 2025

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly