Data set issues only on scheduled jobs

victoria.gallerano

<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>

JFreeman

<p>Can you replicate this consistently using the exact same parameters for the scheduled job and transient run?</p>
<p>Does this happen with only this report?</p>
<p>Can you zip and attach the full log files from your iHub?</p>
<p> </p>
<p>I do not believe this will be related to the process of a scheduled the job versus running the job transiently.</p>

Sunil Kancharla

Hi All, I am currently facing the similar issue. after interduce the new parameter in report using analytics designer and trying to publish in iportal and schedule the report, while scheduling the report the below issue is popping up.

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.
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1254)
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1233)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:96)
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.executor.ReportExtensionExecutor$ReportExtensionItemExecutor.execute(ReportExtensionExecutor.java:69)
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.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:65)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.resumeLayout(HTMLInlineStackingLM.java:111)
at org.eclipse.birt.report.engine.layout.html.HTMLInlineStackingLM.layoutNodes(HTMLInlineStackingLM.java:160)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:71)
at org.eclipse.birt.report.engine.layout.html.HTMLStackingLM.layoutChildren(HTMLStackingLM.java:26)
at org.eclipse.birt.report.engine.layout.html.HTMLRepeatHeaderLM.layoutChildren(HTMLRepeatHeaderLM.java:46)
at org.eclipse.birt.report.engine.layout.html.HTMLAbstractLM.layout(HTMLAbstractLM.java:140)
at org.eclipse.birt.report.engine.layout.html.HTMLBlockStackingLM.layoutNodes(HTMLBlockStackingLM.java:71)
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:258)
at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:274)
at org.eclipse.birt.report.engine.api.impl.RunTask.run(RunTask.java:115)
at com.actuate.reportapi.engine.birt.ReportGenerationTask.runTask(ReportGenerationTask.java:1170)
at com.actuate.reportapi.engine.birt.ReportGenerationTask.generateReport(ReportGenerationTask.java:212)
at com.actuate.reportapi.engine.ReportGenerationTaskBase.doTask(ReportGenerationTaskBase.java:154)
at com.actuate.reportapi.engine.Task.execute(Task.java:345)
at com.actuate.reportapi.enginemanager.ControlRunnable.runTask(ControlRunnable.java:84)
at com.actuate.reportapi.enginemanager.ControlRunnable.run(ControlRunnable.java:38)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.eclipse.birt.report.engine.api.EngineException: Cannot execute query because: the query contains an invalid expression which references an invalid dataset column "Affluent".
... 35 more
Caused by: org.eclipse.birt.data.engine.core.DataException: Cannot execute query because: the query contains an invalid expression which references an invalid dataset column "Affluent".
at com.actuate.birt.data.linkeddatamodel.service.ColumnMetaCreationUtil.createColumnMetaOutOfAliasColumn(ColumnMetaCreationUtil.java:695)
at com.actuate.birt.data.linkeddatamodel.service.ColumnMetaCreationUtil.populateRefersForExpr(ColumnMetaCreationUtil.java:1255)
at com.actuate.birt.data.linkeddatamodel.service.ColumnMetaCreationUtil.populateReferredColumnMeta(ColumnMetaCreationUtil.java:1207)
at com.actuate.birt.data.linkeddatamodel.service.ColumnMetaCreationUtil.<init>(ColumnMetaCreationUtil.java:114)
at com.actuate.birt.data.linkeddatamodel.service.tabular.query.TabularQueryCreator.createQuery(TabularQueryCreator.java:82)
at com.actuate.birt.data.linkeddatamodel.service.tabular.query.PreparedLinkedDataSetQuery.getPreparedQuery(PreparedLinkedDataSetQuery.java:367)
at com.actuate.birt.data.linkeddatamodel.service.tabular.query.QueryResults.getResultIterator(QueryResults.java:413)
at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:98)
at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:167)
at org.eclipse.birt.report.engine.data.dte.DataGenerationEngine.doExecuteQuery(DataGenerationEngine.java:82)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:286)
at org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1956)
at org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQuery(QueryItemExecutor.java:80)
... 32 more$$$Result$$$
There is an error in processing your request. Error code: 17070.