<p>I am using iHub trial version and I am currently having an issue with some reports only when I run them on "schedule".</p>
<p>I have run the same reports using "Run" and they came out perfectly with no errors. </p>
<p> </p>
<p>There seems to be a connection problem when the dataset is being generated.</p>
<p>The dataset is built with a beforeOpen command that takes the parameters selected when running the report and input them in a stored procedure as parameters as well.</p>
<p> </p>
<p>This is the before open text:</p>
<p> </p>
<p>this.queryText="call Billing_NEWFormat('"+params["DRParam_MediaPlanMultiple"].toString().replace(/,/g,',')+"','"+params["StartDate"].toString()+"','"+params["EndDate"].toString()+"');"</p>
<p> </p>
<p>Below you can see the error log:</p>
<p> </p>
<p> </p>
<div>There is an error in processing your request. Error code: 17070.com.actuate.reportapi.enginemanager.JREMException: There is an error in processing your request. Error code: 17070.</div>
<div>at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1245)</div>
<div>at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1224)</div>
<div>at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:96)</div>
<div>at org.eclipse.birt.report.engine.executor.TableItemExecutor.execute(TableItemExecutor.java:62)</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:273)</div>
<div>at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:115)</div>
<div>at com.actuate.reportapi.engine.birt.ReportGenerationTask.runTask(ReportGenerationTask.java:1126)</div>
<div>at com.actuate.reportapi.engine.birt.ReportGenerationTask.generateReport(ReportGenerationTask.java:207)</div>
<div>at com.actuate.reportapi.engine.ReportGenerationTaskBase.doTask(ReportGenerationTaskBase.java:153)</div>
<div>at com.actuate.reportapi.engine.Task.execute(Task.java:325)</div>
<div>at com.actuate.reportapi.enginemanager.ControlRunnable.runTask(ControlRunnable.java:84)</div>
<div>at com.actuate.reportapi.enginemanager.ControlRunnable.run(ControlRunnable.java:38)</div>
<div>at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)</div>
<div>at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)</div>
<div>at java.lang.Thread.run(Thread.java:745)</div>
<div>Caused by: org.eclipse.birt.report.engine.api.EngineException: An exception occurred during processing. Please see the following message for details:</div>
<div><span style="color:#ff0000;">Failed to prepare the query execution for the data set: Billing</span></div>
<div><span style="color:#ff0000;">Cannot get the result set metadata.</span></div>
<div><span style="color:#ff0000;">org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.</span></div>
<div><span style="color:#ff0000;">SQL error </span><span style="color:#ff0000;">#1:Communications</span><span style="color:#ff0000;"> link failure</span></div>
<div> </div>
<div>The last packet successfully received from the server was 3,466,297 milliseconds ago. The last packet sent successfully to the server was 933,264 milliseconds ago.</div>
<div>;</div>
<div>com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure</div>
<div> </div>
<div>The last packet successfully received from the server was 3,466,297 milliseconds ago. The last packet sent successfully to the server was 933,264 milliseconds ago.</div>
<div>... 24 more</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: Billing</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:Communications link failure</div>
<div> </div>
<div>The last packet successfully received from the server was 3,466,297 milliseconds ago. The last packet sent successfully to the server was 933,264 milliseconds ago.</div>
<div>;</div>
<div>com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure</div>
<div> </div>
<div>The last packet successfully received from the server was 3,466,297 milliseconds ago. The last packet sent successfully to the server was 933,264 milliseconds ago.</div>
<div>at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:671)</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:285)</div>
<div>at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1947)</div>
<div>at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)</div>
<div>... 21 more</div>
<div>Caused by: org.eclipse.birt.data.engine.core.DataException: Failed to prepare the query execution for the data set: Billing</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:Communications link failure</div>
<div> </div>
<div>The last packet successfully received from the server was 3,466,297 milliseconds ago. The last packet sent successfully to the server was 933,264 milliseconds ago.</div>
<div>;</div>
<div>com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure</div>
<div> </div>
<div>The last packet successfully received from the server was 3,466,297 milliseconds ago. The last packet sent successfully to the server was 933,264 milliseconds ago.</div>
<div>at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:353)</div>
<div>at org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:463)</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:179)</div>
<div>at org.eclipse.birt.report.data.adapter.impl.DataRequestSessionImpl.execute(DataRequestSessionImpl.java:651)</div>
<div>... 26 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:Communications link failure</div>
<div> </div>
<div>The last packet successfully received from the server was 3,466,297 milliseconds ago. The last packet sent successfully to the server was 933,264 milliseconds ago.</div>
<div>;</div>
<div>com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure</div>
<div> </div>
<div>The last packet successfully received from the server was 3,466,297 milliseconds ago. The last packet sent successfully to the server was 933,264 milliseconds ago.</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:688)</div>
<div>at org.eclipse.birt.data.engine.executor.DataSourceQuery.prepareColumns(DataSourceQuery.java:411)</div>
<div>at org.eclipse.birt.data.engine.executor.DataSourceQuery.prepare(DataSourceQuery.java:349)</div>
<div>at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:621)</div>
<div>at org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:349)</div>
<div>... 31 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:Communications link failure</div>
<div> </div>
<div>The last packet successfully received from the server was 3,466,297 milliseconds ago. The last packet sent successfully to the server was 933,264 milliseconds ago.</div>
<div>;</div>
<div>com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure</div>
<div> </div>
<div>The last packet successfully received from the server was 3,466,297 milliseconds ago. The last packet sent successfully to the server was 933,264 milliseconds ago.</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.Statement.executeQuery(Statement.java:481)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaUsingPolicy1(Statement.java:420)</div>
<div>at org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaData(Statement.java:316)</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:423)</div>
<div>at org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.getMetaData(OdaQuery.java:390)</div>
<div>at org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getRuntimeMetaData(PreparedStatement.java:407)</div>
<div>... 38 more</div>
<div>Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure</div>
<div> </div>
<div>The last packet successfully received from the server was 3,466,297 milliseconds ago. The last packet sent successfully to the server was 933,264 milliseconds ago.</div>
<div>at sun.reflect.GeneratedConstructorAccessor102.newInstance(Unknown Source)</div>
<div>at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)</div>
<div>at java.lang.reflect.Constructor.newInstance(Constructor.java:408)</div>
<div>at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)</div>
<div>at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1116)</div>
<div>at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3589)</div>
<div>at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3478)</div>
<div>at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4019)</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:477)</div>
<div>... 44 more</div>
<div>Caused by: java.net.SocketException: Connection timed out</div>
<div>at java.net.SocketInputStream.socketRead0(Native Method)</div>
<div>at java.net.SocketInputStream.read(SocketInputStream.java:150)</div>
<div>at java.net.SocketInputStream.read(SocketInputStream.java:121)</div>
<div>at com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:114)</div>
<div>at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:161)</div>
<div>at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:189)</div>
<div>at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:3036)</div>
<div>at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3489)</div>
<div>... 52 more$$$Result$$$</div>
<div>There is an error in processing your request. Error code: 17070.</div>
