<div>My report goes against a stored procedure in Mysql. Some times( out of 10 times approximately 4 times) report fails while generating the document with this error. I checked the stored procedure and not seeing any non valid characters. Have any one seen this? Thanks.</div>
<div> </div>
<div>Description<span> </span>Resource<span> </span>Path<span> </span>Location<span> </span>Type</div>
<div>org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details:</div>
<div>Failed to prepare the query execution for the data set: 01-tbl_score_natl_performance</div>
<div>Cannot get the result set metadata.</div>
<div> org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.</div>
<div>SQL error #1:Invalid utf8 character string: 'ˆ'</div>
<div> ;</div>
<div> java.sql.SQLException: Invalid utf8 character string: 'ˆ' (Element ID:26138)</div>
<div>at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1237)</div>
<div>at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1216)</div>
<div>at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:96)</div>
<div>at org.eclipse.birt.report.engine.executor.GridItemExecutor.execute(GridItemExecutor.java:65)</div>
<div>at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)</div>
<div>at org.eclipse.birt.report.engine.internal.executor.emitter.ReportItemEmitterExecutor.execute(ReportItemEmitterExecutor.java:46)</div>
<div>at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplicateItemExecutor.execute(SuppressDuplicateItemExecutor.java:43)</div>
<div>at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportItemExecutor.execute(WrappedReportItemExecutor.java:46)</div>
<div>at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportItemExecutor.execute(LocalizedReportItemExecutor.java:34)</div>
<div>at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)</div>
<div>at org.eclipse.birt.report.engine.layout.html.HTMLPageLM.layout(HTMLPageLM.java:92)</div>
<div>at org.eclipse.birt.report.engine.layout.html.HTMLReportLayoutEngine.layout(HTMLReportLayoutEngine.java:100)</div>
<div>at org.eclipse.birt.report.engine.presentation.ReportDocumentBuilder.build(ReportDocumentBuilder.java:249)</div>
<div>at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:262)</div>
<div>at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:86)</div>
<div>at org.eclipse.birt.report.service.ReportEngineService.runReport(ReportEngineService.java:1317)</div>
<div>at org.eclipse.birt.report.service.BirtViewerReportService.runReport(BirtViewerReportService.java:158)</div>
<div>at org.eclipse.birt.report.service.actionhandler.BirtRunReportActionHandler.__execute(BirtRunReportActionHandler.java:81)</div>
<div>at org.eclipse.birt.report.service.actionhandler.BirtChangeParameterActionHandler.runReport(BirtChangeParameterActionHandler.java:58)</div>
<div>at org.eclipse.birt.report.service.actionhandler.AbstractChangeParameterActionHandler.__execute(AbstractChangeParameterActionHandler.java:53)</div>
<div>at org.eclipse.birt.report.service.actionhandler.AbstractBaseActionHandler.execute(AbstractBaseActionHandler.java:90)</div>
<div>at org.eclipse.birt.report.soapengine.processor.AbstractBaseDocumentProcessor.__executeAction(AbstractBaseDocumentProcessor.java:47)</div>
<div>at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.executeAction(AbstractBaseComponentProcessor.java:143)</div>
<div>at org.eclipse.birt.report.soapengine.processor.BirtDocumentProcessor.handleChangeParameter(BirtDocumentProcessor.java:100)</div>
<div>at sun.reflect.GeneratedMethodAccessor82.invoke(Unknown Source)</div>
<div>at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)</div>
<div>at java.lang.reflect.Method.invoke(Unknown Source)</div>
<div>at org.eclipse.birt.report.soapengine.processor.AbstractBaseComponentProcessor.process(AbstractBaseComponentProcessor.java:112)</div>
<div>at org.eclipse.birt.report.soapengine.endpoint.BirtSoapBindingImpl.getUpdatedObjects(BirtSoapBindingImpl.java:66)</div>
<div>at sun.reflect.GeneratedMethodAccessor81.invoke(Unknown Source)</div>
<div>at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)</div>
<div>at java.lang.reflect.Method.invoke(Unknown Source)</div>
<div>at org.apache.axis.providers.java.RPCProvider.invokeMethod(RPCProvider.java:397)</div>
<div>at org.apache.axis.providers.java.RPCProvider.processMessage(RPCProvider.java:186)</div>
<div>at org.apache.axis.providers.java.JavaProvider.invoke(JavaProvider.java:323)</div>
<div>at org.apache.axis.strategies.InvocationStrategy.visit(InvocationStrategy.java:32)</div>
<div>at org.apache.axis.SimpleChain.doVisiting(SimpleChain.java:118)</div>
<div>at org.apache.axis.SimpleChain.invoke(SimpleChain.java:83)</div>
<div>at org.apache.axis.handlers.soap.SOAPService.invoke(SOAPService.java:454)</div>
<div>at org.apache.axis.server.AxisServer.invoke(AxisServer.java:281)</div>
<div>at org.apache.axis.transport.http.AxisServlet.doPost(AxisServlet.java:699)</div>
<div>at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.doPost(BirtSoapMessageDispatcherServlet.java:265)</div>
<div>at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)</div>
<div>at org.apache.axis.transport.http.AxisServletBase.service(AxisServletBase.java:327)</div>
<div>at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)</div>
<div>at org.eclipse.birt.report.servlet.BirtSoapMessageDispatcherServlet.service(BirtSoapMessageDispatcherServlet.java:122)</div>
<div>at org.eclipse.equinox.http.registry.internal.ServletManager$ServletWrapper.service(ServletManager.java:180)</div>
<div>at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)</div>
<div>at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126)</div>
<div>at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:60)</div>
<div>at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)</div>
<div>at org.eclipse.equinox.http.jetty.internal.HttpServerManager$InternalHttpServiceServlet.service(HttpServerManager.java:317)</div>
<div>at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)</div>
<div>at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:390)</div>
<div>at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)</div>
<div>at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)</div>
<div>at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)</div>
<div>at org.mortbay.jetty.Server.handle(Server.java:326)</div>
<div>at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)</div>
<div>at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:939)</div>
<div>at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)</div>
<div>at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)</div>
<div>at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)</div>
<div>at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:409)</div>
<div>at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)</div>
<div>Caused by: org.eclipse.birt.report.data.adapter.api.AdapterException: An exception occurred during processing. Please see the following message for details:</div>
<div>Failed to prepare the query execution for the data set: 01-tbl_score_natl_performance</div>
<div>Cannot get the result set metadata.</div>
<div> org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.</div>
<div>SQL error #1:Invalid utf8 character string: 'ˆ'</div>
<div> ;</div>
<div> java.sql.SQLException: Invalid utf8 character string: 'ˆ'</div>
<div>at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:644)</div>
<div>at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:152)</div>
<div>at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:83)</div>
<div>at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:267)</div>
<div>at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1939)</div>
<div>at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)</div>
<div>... 62 more</div>
<div>Caused by: org.eclipse.birt.data.engine.core.DataException: Failed to prepare the query execution for the data set: 01-tbl_score_natl_performance</div>
<div>Cannot get the result set metadata.</div>
<div> org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.</div>
<div>SQL error #1:Invalid utf8 character string: 'ˆ'</div>
<div> ;</div>
<div> java.sql.SQLException: Invalid utf8 character string: 'ˆ'</div>
<div>at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:345)</div>
<div>at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:455)</div>
<div>at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.produceQueryResults(PreparedDataSourceQuery.java:190)</div>
<div>at org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:178)</div>
<div>at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:145)</div>
<div>at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:624)</div>
<div>... 67 more</div>
<div>Caused by: org.eclipse.birt.data.engine.odaconsumer.OdaDataException: Cannot get the result set metadata.</div>
<div> org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.</div>
<div>SQL error #1:Invalid utf8 character string: 'ˆ'</div>
<div> ;</div>
<div> java.sql.SQLException: Invalid utf8 character string: 'ˆ'</div>
<div>at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.newException(ExceptionHandler.java:52)</div>
<div>at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.throwException(ExceptionHandler.java:108)</div>
<div>at org.eclipse.birt.data.engine.odaconsumer.ExceptionHandler.throwException(ExceptionHandler.java:84)</div>
<div>at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getRuntimeMetaData(PreparedStatement.java:414)</div>
<div>at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getProjectedColumns(PreparedStatement.java:377)</div>
<div>at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.declareCustomColumn(PreparedStatement.java:1223)</div>
<div>at org.eclipse.birt.data.engine.executor.DataSourceQuery.addCustomFields(DataSourceQuery.java:650)</div>
<div>at org.eclipse.birt.data.engine.executor.DataSourceQuery.prepareColumns(DataSourceQuery.java:374)</div>
<div>at org.eclipse.birt.data.engine.executor.DataSourceQuery.prepare(DataSourceQuery.java:323)</div>
<div>at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:442)</div>
<div>at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:341)</div>
<div>... 72 more</div>
<div>Caused by: org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.</div>
<div>SQL error #1:Invalid utf8 character string: 'ˆ'</div>
<div> ;</div>
<div> java.sql.SQLException: Invalid utf8 character string: 'ˆ'</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery(Statement.java:464)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaUsingPolicy1(Statement.java:403)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaData(Statement.java:303)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.bidi.BidiStatement.getMetaData(BidiStatement.java:56)</div>
<div>at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.doGetMetaData(OdaQuery.java:412)</div>
<div>at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.getMetaData(OdaQuery.java:379)</div>
<div>at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getRuntimeMetaData(PreparedStatement.java:407)</div>
<div>... 79 more</div>
<div>Caused by: java.sql.SQLException: Invalid utf8 character string: 'ˆ'</div>
<div>at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)</div>
<div>at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096)</div>
<div>at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)</div>
<div>at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)</div>
<div>at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)</div>
<div>at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2683)</div>
<div>at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2144)</div>
<div>at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2310)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery(Statement.java:460)</div>
<div>... 85 more</div>
<div>Performance_Grid_SCORE_Natl_4_29.rptdesign<span> </span>/ScoreReporting/Reports<span> </span>line 4843<span> </span>BIRT Viewer Problem</div>
<div> </div>
