New parameter change in existing report getting the invalid dataset column issue

Sunil Kancharla

Hi All, I am currently facing the nvalid dataset column 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

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

report.png

report1.PNG

report2.PNG

report3.PNG