Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Developing Analytics Applications
Editing old rptdesign to work in newer versions of birt
Migrateduser
<p>Hello everyone,</p><p> </p><p>I have report that ran on Birt version 2.0.1. I am trying to reconfigure that report to run on 3.7.2.</p><p> </p><p>I managed to configure report in Eclipse, so I can open it, but it has errors.</p><p> </p><div><span style="font-size:8px;">org.eclipse.birt.data.engine.core.DataException: Invalid Javascript expression: Total.count(row.CBCH_STATUS == "4", "CaseType").</span></div><div><span style="font-size:8px;">The group level in Aggregation: COUNT is invalid.</span></div><div><span style="font-size:8px;">at org.eclipse.birt.data.engine.expression.AbstractExpressionCompiler.compileExpression(AbstractExpressionCompiler.java:104)</span></div><div><span style="font-size:8px;">at org.eclipse.birt.data.engine.expression.ExpressionProcessor.compileBaseExpression(ExpressionProcessor.java:404)</span></div><div><span style="font-size:8px;">at org.eclipse.birt.data.engine.expression.ExpressionProcessor.hasAggregateExpr(ExpressionProcessor.java:265)</span></div><div><span style="font-size:8px;">at org.eclipse.birt.data.engine.executor.transform.pass.PassStatusController.hasAggregationsInComputedColumns(PassStatusController.java:184)</span></div><div><span style="font-size:8px;">at org.eclipse.birt.data.engine.executor.transform.pass.PassStatusController.<init>(PassStatusController.java:94)</span></div><div><span style="font-size:8px;">at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.prepareDataSetResultSet(PassManager.java:90)</span></div><div><span style="font-size:8px;">at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.pass(PassManager.java:134)</span></div><div><span style="font-size:8px;">at org.eclipse.birt.data.engine.executor.transform.pass.PassManager.populateResultSet(PassManager.java:74)</span></div><div><span style="font-size:8px;">at org.eclipse.birt.data.engine.executor.transform.ResultSetPopulator.populateResultSet(ResultSetPopulator.java:198)</span></div><div><span style="font-size:8px;">at org.eclipse.birt.data.engine.executor.transform.CachedResultSet.<init>(CachedResultSet.java:97)</span></div><div><span style="font-size:8px;">at org.eclipse.birt.data.engine.executor.DataSourceQuery.execute(DataSourceQuery.java:1025)</span></div><div><span style="font-size:8px;">at org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.executeOdiQuery(PreparedOdaDSQuery.java:428)</span></div><div><span style="font-size:8px;">at org.eclipse.birt.data.engine.impl.QueryExecutor.execute(QueryExecutor.java:1134)</span></div><div><span style="font-size:8px;">at org.eclipse.birt.data.engine.impl.ServiceForQueryResults.executeQuery(ServiceForQueryResults.java:232)</span></div><div><span style="font-size:8px;">at org.eclipse.birt.data.engine.impl.QueryResults.getResultIterator(QueryResults.java:177)</span></div><div><span style="font-size:8px;">at org.eclipse.birt.report.engine.api.impl.ExtractionResults.nextResultIterator(ExtractionResults.java:74)</span></div><div><span style="font-size:8px;">at org.eclipse.birt.report.designer.data.ui.dataset.DataSetPreviewer.preview(DataSetPreviewer.java:70)</span></div><div><span style="font-size:8px;">at org.eclipse.birt.report.designer.data.ui.dataset.ResultSetPreviewPage$5.run(ResultSetPreviewPage.java:337)</span></div><div><span style="font-size:8px;">at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)</span></div><div><span style="font-size:8px;">Caused by: org.eclipse.birt.data.engine.core.DataException: The group level in Aggregation: COUNT is invalid.</span></div><div><span style="font-size:8px;">at org.eclipse.birt.data.engine.impl.aggregation.AggrRegistry.newAggrExprInfo(AggrRegistry.java:252)</span></div><div><span style="font-size:8px;">at org.eclipse.birt.data.engine.impl.aggregation.AggrRegistry.registerExpression(AggrRegistry.java:127)</span></div><div><span style="font-size:8px;">at org.eclipse.birt.data.engine.impl.aggregation.AggrRegistry.register(AggrRegistry.java:110)</span></div><div><span style="font-size:8px;">at org.eclipse.birt.data.engine.expression.AggregationTablePopulator.populateAggregationTable(AggregationTablePopulator.java:59)</span></div><div><span style="font-size:8px;">at org.eclipse.birt.data.engine.expression.MultiPassExpressionCompiler.registerAggregate(MultiPassExpressionCompiler.java:720)</span></div><div><span style="font-size:8px;">at org.eclipse.birt.data.engine.expression.MultiPassExpressionCompiler.compileAggregateExpr(MultiPassExpressionCompiler.java:348)</span></div><div><span style="font-size:8px;">at org.eclipse.birt.data.engine.expression.AbstractExpressionCompiler.processChild(AbstractExpressionCompiler.java:298)</span></div><div><span style="font-size:8px;">at org.eclipse.birt.data.engine.expression.AbstractExpressionCompiler.processScriptTree(AbstractExpressionCompiler.java:206)</span></div><div><span style="font-size:8px;">at org.eclipse.birt.data.engine.expression.AbstractExpressionCompiler.compileExpression(AbstractExpressionCompiler.java:100)</span></div><div><span style="font-size:8px;">... 18 more</span></div><div> </div><p>I don't know why this error occurred. As I see it COUNT is standard Birt/Javascript function.</p><p> </p><p>In attachment you will find report. </p><p> </p><p>Tnx in advance,</p><p>Aleksandar</p>
Find more posts tagged with
Comments
There are no comments yet