<div>Hi,</div>
<div> </div>
<div><strong>Designer Professional version:</strong> 4.4</div>
<div><strong>iHub</strong> : 3</div>
<div> </div>
<div>I have created a report using the data model as the source. The report has a cascading parameter group consisting of three parameters.</div>
<div> </div>
<div>When i am running this report locally using report viewer, it works fine. But, when i deployed it to the server, after the parameters are entered, the report is not running. it is throwing an exception saying "Report generation failed: Error happened while running the report".</div>
<div> </div>
<div>I am unable to figure out the cause. But, one thing i observed is, the value in "Caused by: java.lang.ArrayIndexOutOfBoundsException: 62" changes with different parameter selections.</div>
<div> </div>
<div>Please help. Thanks in advance.</div>
<div> </div>
<div><strong>Below is the log generated: </strong></div>
<div>hn:ACT1|pid:5392|prod:iHub|Task startup time: Wed May 27 10:20:12 IST 2015</div>
<div>User name: administrator</div>
<div>Request type: </div>
<div>hn:ACT1|pid:5392|prod:iHub|Request ID: ACT1--2015-05-27 10:20:12--390</div>
<div>Volume name: Default Volume</div>
<div>authid:2cwqOnGzNy5R1r6MudiQUjBrBhSWtT58pXo8+cfnCIJlZnMJTciKE3GqeAXWKN/ENJvcpio1ld+lbl3socR6HsW8FMXiV0LcYlKECbHVyQr+XY+WLFnjcv8n+7VRp85lhXBVKjLuSv6Ucn85TcEfvYpXPggMqUh+YZgrmUYKgYPP9eWJCwwwrC6Iuv9nmST7ysPOYACbCD8MscAktvpGxamCV36WkFLbqrP6IHA6IJo=</div>
<div>serverURI:<a data-ipb='nomediaparse' href='
http://ACT1:11100'>http://ACT1:11100</a></div>
<div>MaxDuration:0com.actuate.reportapi.enginemanager.JREMException: Report generation failed. Cause: Error happened while running the report.</div>
<div>at org.eclipse.birt.report.engine.api.impl.EngineTask.handleFatalExceptions(EngineTask.java:2376)</div>
<div>at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:280)</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:1094)</div>
<div>at com.actuate.reportapi.engine.birt.ReportGenerationTask.generateReport(ReportGenerationTask.java:206)</div>
<div>at com.actuate.reportapi.engine.ReportGenerationTaskBase.doTask(ReportGenerationTaskBase.java:157)</div>
<div>at com.actuate.reportapi.engine.Task.execute(Task.java:318)</div>
<div>at com.actuate.reportapi.enginemanager.ThreadPool$ControlRunnable.run(ThreadPool.java:808)</div>
<div>at java.lang.Thread.run(Thread.java:744)</div>
<div>Caused by: org.eclipse.birt.report.engine.api.EngineException: Error happened while running the report.</div>
<div>... 9 more</div>
<div>Caused by: java.lang.ArrayIndexOutOfBoundsException: 62</div>
<div>at com.actuate.birt.data.linkeddatamodel.impl.MergeJoinBasedJoinDataSetColumnGetter.get(MergeJoinBasedJoinDataSetColumnGetter.java:81)</div>
<div>at com.actuate.birt.data.linkeddatamodel.impl.DataSet.getColumnData(DataSet.java:668)</div>
<div>at com.actuate.birt.data.linkeddatamodel.api.AliasDataSet.getColumnData(AliasDataSet.java:90)</div>
<div>at com.actuate.birt.data.linkeddatamodel.impl.BaseIteratableColumn.<init>(BaseIteratableColumn.java:50)</div>
<div>at com.actuate.birt.data.linkeddatamodel.impl.RandomAccessColumn.<init>(RandomAccessColumn.java:53)</div>
<div>at com.actuate.birt.data.linkeddatamodel.impl.RandomAccessColumn.<init>(RandomAccessColumn.java:49)</div>
<div>at com.actuate.birt.data.linkeddatamodel.api.ColumnFactory.createRandomAccessColumn(ColumnFactory.java:43)</div>
<div>at com.actuate.birt.data.linkeddatamodel.api.ColumnFactory.createRandomAccessColumn(ColumnFactory.java:70)</div>
<div>at com.actuate.birt.data.linkeddatamodel.impl.JoinNodePopulator.populateJoinNode(JoinNodePopulator.java:210)</div>
<div>at com.actuate.birt.data.linkeddatamodel.impl.JoinNodePopulator.populateJoinNode(JoinNodePopulator.java:136)</div>
<div>at com.actuate.birt.data.linkeddatamodel.impl.TabularQueryExecutor.execute(TabularQueryExecutor.java:152)</div>
<div>at com.actuate.birt.data.linkeddatamodel.api.LinkedDataModelQueryExecutor.executeFlatQuery(LinkedDataModelQueryExecutor.java:59)</div>
<div>at com.actuate.birt.data.linkeddatamodel.service.tabular.query.QueryResults.getResultIterator(QueryResults.java:247)</div>
<div>at org.eclipse.birt.report.engine.data.dte.QueryResultSet.<init>(QueryResultSet.java:98)</div>
<div>at org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:168)</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:275)</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>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.executor.ReportExtensionExecutor$ReportExtensionItemExecutor.execute(ReportExtensionExecutor.java:69)</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.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:258)</div>
<div>at org.eclipse.birt.report.engine.api.impl.RunTask.doRun(RunTask.java:272)</div>
<div>... 7 more</div>
<div> </div>
<div> </div>
<div>Divyani.</div>