Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Error Duplicate aggregation name: COUNT(Report with Chart is fine in Report Viewer but throws error in Report Engine)
Error Duplicate aggregation name: COUNT [message #759110] Sat, 26 November 2011 13:44 Go to next message
sonal Missing name is currently offline sonal Missing nameFriend
Messages: 2
Registered: November 2011
Junior Member
Hello All,
I am using Birt Report Engine version 3.7.1. I have created a report with one Table and one Chart with a Stored Procedure in backend for the dataset. The Database is MySQL. The report works fine in Report Viewer but when I export to HTML using Birt Engine, I get the exception shown below. This error is only seen when I add the Chart element to the Report. If I only have the Table element, the report works fine both in Viewer as well as in the Engine.

Exception is as follows:
The following items have errors:

Chart (id = 105):
- Duplicate aggregation name: COUNT. (Element ID:105)

Duplicate aggregation name: COUNT. ( 1 time(s) )
detail : org.eclipse.birt.report.engine.api.EngineException: Duplicate aggregation name: COUNT. (Element ID:105)
at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1214)
at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.visitExtendedItem(ReportQueryBuilder.java:693)
at org.eclipse.birt.report.engine.ir.ExtendedItemDesign.accept(ExtendedItemDesign.java:45)
at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.build(ReportQueryBuilder.java:256)
at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.visitCell(ReportQueryBuilder.java:1241)
at org.eclipse.birt.report.engine.ir.CellDesign.accept(CellDesign.java:202)
at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.build(ReportQueryBuilder.java:256)
at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.visitRow(ReportQueryBuilder.java:1207)
at org.eclipse.birt.report.engine.ir.RowDesign.accept(RowDesign.java:108)
at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.build(ReportQueryBuilder.java:256)
at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.handleListingBand(ReportQueryBuilder.java:1097)
at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.visitTableItem(ReportQueryBuilder.java:934)
at org.eclipse.birt.report.engine.ir.TableItemDesign.accept(TableItemDesign.java:53)
at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.build(ReportQueryBuilder.java:256)
at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.build(ReportQueryBuilder.java:237)
at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.prepare(AbstractDataEngine.java:180)
at org.eclipse.birt.report.engine.executor.ReportExecutor.execute(ReportExecutor.java:122)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:60)
at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplciateReportExecutor.execute(SuppressDuplciateReportExecutor.java:42)
at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:60)
at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(LocalizedReportExecutor.java:61)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:178)
at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
at com.figr.retailer.reports.action.ExportOptions.ReportExportedWithOption(ExportOptions.java:129)
at com.figr.retailer.reports.action.RunBirt.runReport(RunBirt.java:108)
at com.figr.retailer.reports.action.BirtStruts.execute(BirtStruts.java:32)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:452)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:291)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:254)
at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:176)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:263)
at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:207)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:207)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:190)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:243)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:270)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:145)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:176)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:190)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:187)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:498)
at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Unknown Source)
Caused by: org.eclipse.birt.chart.exception.ChartException: Duplicate aggregation name: COUNT.
at org.eclipse.birt.chart.reportitem.AbstractChartBaseQueryGenerator.addValueSeriesAggregateBindingForGrouping(AbstractChartBaseQueryGenerator.java:247)
at org.eclipse.birt.chart.reportitem.AbstractChartBaseQueryGenerator.addAggregateBindings(AbstractChartBaseQueryGenerator.java:624)
at org.eclipse.birt.chart.reportitem.AbstractChartBaseQueryGenerator.generateExtraBindings(AbstractChartBaseQueryGenerator.java:347)
at org.eclipse.birt.chart.reportitem.ChartBaseQueryHelper.createBaseQuery(ChartBaseQueryHelper.java:106)
at org.eclipse.birt.chart.reportitem.ChartReportItemQueryImpl.createQuery(ChartReportItemQueryImpl.java:163)
at org.eclipse.birt.chart.reportitem.ChartReportItemQueryImpl.createReportQueries(ChartReportItemQueryImpl.java:106)
at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.visitExtendedItem(ReportQueryBuilder.java:689)
... 89 more
Caused by: org.eclipse.birt.data.engine.core.DataException: Duplicate aggregation name: COUNT.
at org.eclipse.birt.data.engine.api.aggregation.AggregationManager.populateFactoryAggregations(AggregationManager.java:183)
at org.eclipse.birt.data.engine.api.aggregation.AggregationManager.populateAggregations(AggregationManager.java:153)
at org.eclipse.birt.data.engine.api.aggregation.AggregationManager.<init>(AggregationManager.java:123)
at org.eclipse.birt.data.engine.api.aggregation.AggregationManager.getInstance(AggregationManager.java:110)
at org.eclipse.birt.chart.reportitem.AbstractChartBaseQueryGenerator.setBindingExpressionDueToAggregation(AbstractChartBaseQueryGenerator.java:1050)
at org.eclipse.birt.chart.reportitem.AbstractChartBaseQueryGenerator.addValueSeriesAggregateBindingForGrouping(AbstractChartBaseQueryGenerator.java:207)
... 95 more



[Updated on: Sun, 27 November 2011 08:20]

Report message to a moderator

Re: Error Duplicate aggregation name: COUNT [message #759510 is a reply to message #759110] Mon, 28 November 2011 20:39 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

Can you reproduce this with the sample db so we can debug it?

Jason

On 11/26/2011 8:44 AM, sonal wrote:
> Hello All,
> I am using Birt Report Engine version 3.7.1. I have created a report with one Table and one Chart with a Stored Procedure in backend for the dataset. The Database is MySQL. The report works fine in Report Viewer but when I export to HTML using Birt Engine, I get the exception shown below. This error is only seen when I add the Chart element to the Report. If I only have the Table element, the report works fine both in Viewer as well as in the Engine.
>
> Exception is as follows:
> The following items have errors:
>
> Chart (id = 105):
> - Duplicate aggregation name: COUNT. (Element ID:105)
>
> Duplicate aggregation name: COUNT. ( 1 time(s) )
> detail : org.eclipse.birt.report.engine.api.EngineException: Duplicate aggregation name: COUNT. (Element ID:105)
> at org.eclipse.birt.report.engine.executor.ExecutionContext.addException(ExecutionContext.java:1214)
> at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.visitExtendedItem(ReportQueryBuilder.java:693)
> at org.eclipse.birt.report.engine.ir.ExtendedItemDesign.accept(ExtendedItemDesign.java:45)
> at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.build(ReportQueryBuilder.java:256)
> at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.visitCell(ReportQueryBuilder.java:1241)
> at org.eclipse.birt.report.engine.ir.CellDesign.accept(CellDesign.java:202)
> at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.build(ReportQueryBuilder.java:256)
> at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.visitRow(ReportQueryBuilder.java:1207)
> at org.eclipse.birt.report.engine.ir.RowDesign.accept(RowDesign.java:108)
> at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.build(ReportQueryBuilder.java:256)
> at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.handleListingBand(ReportQueryBuilder.java:1097)
> at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.visitTableItem(ReportQueryBuilder.java:934)
> at org.eclipse.birt.report.engine.ir.TableItemDesign.accept(TableItemDesign.java:53)
> at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.build(ReportQueryBuilder.java:256)
> at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder.build(ReportQueryBuilder.java:237)
> at org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.prepare(AbstractDataEngine.java:180)
> at org.eclipse.birt.report.engine.executor.ReportExecutor.execute(ReportExecutor.java:122)
> at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:60)
> at org.eclipse.birt.report.engine.internal.executor.dup.SuppressDuplciateReportExecutor.execute(SuppressDuplciateReportExecutor.java:42)
> at org.eclipse.birt.report.engine.internal.executor.wrap.WrappedReportExecutor.execute(WrappedReportExecutor.java:60)
> at org.eclipse.birt.report.engine.internal.executor.l18n.LocalizedReportExecutor.execute(LocalizedReportExecutor.java:61)
> at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.doRun(RunAndRenderTask.java:178)
> at org.eclipse.birt.report.engine.api.impl.RunAndRenderTask.run(RunAndRenderTask.java:77)
> at com.figr.retailer.reports.action.ExportOptions.ReportExportedWithOption(ExportOptions.java:129)
> at com.figr.retailer.reports.action.RunBirt.runReport(RunBirt.java:108)
> at com.figr.retailer.reports.action.BirtStruts.execute(BirtStruts.java:32)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
> at java.lang.reflect.Method.invoke(Unknown Source)
> at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:452)
> at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:291)
> at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:254)
> at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:176)
> at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
> at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
> at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:263)
> at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
> at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
> at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
> at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138)
> at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
> at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:207)
> at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
> at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
> at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:207)
> at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
> at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
> at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:190)
> at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
> at org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)
> at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
> at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94)
> at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
> at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:243)
> at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
> at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)
> at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
> at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)
> at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
> at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:270)
> at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
> at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:145)
> at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
> at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171)
> at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
> at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
> at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:176)
> at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
> at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
> at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
> at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:190)
> at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
> at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:187)
> at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
> at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
> at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:498)
> at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
> at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)
> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
> at java.lang.Thread.run(Unknown Source)
> Caused by: org.eclipse.birt.chart.exception.ChartException: Duplicate aggregation name: COUNT.
> at org.eclipse.birt.chart.reportitem.AbstractChartBaseQueryGenerator.addValueSeriesAggregateBindingForGrouping(AbstractChartBaseQueryGenerator.java:247)
> at org.eclipse.birt.chart.reportitem.AbstractChartBaseQueryGenerator.addAggregateBindings(AbstractChartBaseQueryGenerator.java:624)
> at org.eclipse.birt.chart.reportitem.AbstractChartBaseQueryGenerator.generateExtraBindings(AbstractChartBaseQueryGenerator.java:347)
> at org.eclipse.birt.chart.reportitem.ChartBaseQueryHelper.createBaseQuery(ChartBaseQueryHelper.java:106)
> at org.eclipse.birt.chart.reportitem.ChartReportItemQueryImpl.createQuery(ChartReportItemQueryImpl.java:163)
> at org.eclipse.birt.chart.reportitem.ChartReportItemQueryImpl.createReportQueries(ChartReportItemQueryImpl.java:106)
> at org.eclipse.birt.report.engine.data.dte.ReportQueryBuilder$QueryBuilderVisitor.visitExtendedItem(ReportQueryBuilder.java:689)
> ... 89 more
> Caused by: org.eclipse.birt.data.engine.core.DataException: Duplicate aggregation name: COUNT.
> at org.eclipse.birt.data.engine.api.aggregation.AggregationManager.populateFactoryAggregations(AggregationManager.java:183)
> at org.eclipse.birt.data.engine.api.aggregation.AggregationManager.populateAggregations(AggregationManager.java:153)
> at org.eclipse.birt.data.engine.api.aggregation.AggregationManager.<init>(AggregationManager.java:123)
> at org.eclipse.birt.data.engine.api.aggregation.AggregationManager.getInstance(AggregationManager.java:110)
> at org.eclipse.birt.chart.reportitem.AbstractChartBaseQueryGenerator.setBindingExpressionDueToAggregation(AbstractChartBaseQueryGenerator.java:1050)
> at org.eclipse.birt.chart.reportitem.AbstractChartBaseQueryGenerator.addValueSeriesAggregateBindingForGrouping(AbstractChartBaseQueryGenerator.java:207)
> ... 95 more
>
>
>
>
Re: Error Duplicate aggregation name: COUNT [message #808132 is a reply to message #759510] Mon, 27 February 2012 12:45 Go to previous messageGo to next message
Risto Urb is currently offline Risto UrbFriend
Messages: 4
Registered: February 2012
Junior Member
Hello,

I have the exact same problem with charts. Everything is totally cool in Eclipse, but in tomcat I get the "Duplicate aggregation name: COUNT" error for chart (not much more to go on by). For viewing a Table everything is ok. I'm adding screenshots, the report created from sample db, as well as my servlet code that I created to use the Engine in my project.

Call for servlet is as follows:

<birt:viewer id="birtViewer" reportDesign="countryview.rptdesign"
pattern="frameset"
height="750"
width="500"
format="html">
</birt:viewer>

I am not sure if this is a BIRT problem at all, hopefully my own misusage of the tool, but I would really appreciate any help pointing out, where my mistake is.

Thanks to everyone in advance.

[Updated on: Mon, 27 February 2012 12:48]

Report message to a moderator

Re: Error Duplicate aggregation name: COUNT [message #808516 is a reply to message #808132] Mon, 27 February 2012 21:41 Go to previous messageGo to next message
Jason Weathersby is currently offline Jason WeathersbyFriend
Messages: 9167
Registered: July 2009
Senior Member

I modified the attached sample to use the derby sample db. Can you run
it and see if you get the same issue?

Jason

On 2/27/2012 7:45 AM, Risto Urb wrote:
> Hello,
>
> I have the exact same problem with charts. Everything is totally cool in Eclipse, but in tomcat I get the "Duplicate aggregation name: COUNT" error for chart (not much more to go on by). For viewing a Table everything is ok. I'm adding screenshots, the report created from sample db, as well as my servlet code that I created to use the Engine in my project.
>
> Call for servlet is as follows:
>
> <birt:viewer id="birtViewer" reportDesign="countryview.rptdesign"
> pattern="frameset"
> height="750"
> width="500"
> format="html">
> </birt:viewer>
>
> I am not sure if this is a BIRT problem at all, hopefully my own misusage of the tool, but I would really appreciate any help pointing out, where my mistake is.
>
> Thanks to everyone in advance.
  • Attachment: sample.zip
    (Size: 5.20KB, Downloaded 160 times)
Re: Error Duplicate aggregation name: COUNT [message #808690 is a reply to message #808516] Tue, 28 February 2012 02:39 Go to previous messageGo to next message
sonal Missing name is currently offline sonal Missing nameFriend
Messages: 2
Registered: November 2011
Junior Member
Hi
The error message does'nt reflect problem correctly.
I have solved this problem by upgrading JDK to Sun JDK 1.6 on application server.
There can be few reasons

1. Check all datasource and their alias names.
2.Make sure datacubes are not generating error by creating cross-tab first. This way you can check your formulas.
3. Run in preview mode to make sure every thing working fine.
4.If problem still persists, pls check JDK version running on your application server. Preferred is sun JDK 1.6.

Thanks
Re: Error Duplicate aggregation name: COUNT [message #809251 is a reply to message #808690] Tue, 28 February 2012 16:36 Go to previous messageGo to next message
Risto Urb is currently offline Risto UrbFriend
Messages: 4
Registered: February 2012
Junior Member
Hi guys,

thank You for Your responses. Neither the changed report or jvm checking solved the problem. Though now its almost working as intended. What I did was to throw out all 3.7.1 libraries and replaced them with 3.7.2 libraries. And now it decided to work. Although now I have another little issue. The chart file gets nicely generated, but is not shown by the servlet. Img reference inside html that is generated by engine is as follows:

<img id="__bookmark_2" style=" width: 573pt; height: 130pt;display: block;" alt="" src="file:/C:/development/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp2/wtpwebapps/myproject/reports/images/custom1.jpg">

If I just copy paste it separately to browser like this:

file:///C:/development/workspace/.metadata/.plugins/org.eclipse.wst.server.core/tmp2/wtpwebapps/myproject/reports/images/custom1.jpg

the chart as a .jpg file is shown. Any ideas how to tell the engine/servlet that in windows it should use "file:///" not "file:/". Or is this some general Tomcat, servlet configuration issue.

My brain has gone to meltdown mode, so I apologize if the answer is trivial.

Once again, thank You so much for the answers.

[Updated on: Tue, 28 February 2012 16:39]

Report message to a moderator

Re: Error Duplicate aggregation name: COUNT [message #810083 is a reply to message #809251] Wed, 29 February 2012 17:08 Go to previous messageGo to next message
Risto Urb is currently offline Risto UrbFriend
Messages: 4
Registered: February 2012
Junior Member
Hi again,

now I think I have tried everything inside servlet I can possibly imagine, but I am unable to set the image url so that it does not have the "file:/" prefix. I have deployed my app to tomcat on linux machine and it generates the report chart .jpg file into an accessible directory but although direct reference in browser shows

htp://mydomain.com/images/custom1.jpg NO PROBLEMS


the report source generated has always "file:/" in front of it Sad


file:/tmp/tomcat6-temp/http:/mydomain.com/images/custom1.jpg



<img id="__bookmark_1" style=" width: 300pt; height: 360pt;" alt="Country Weight Limits" src="file:/htp://mydomain.com/images/custom1.jpg">


If I replace in browser


<img id="__bookmark_1" style=" width: 300pt; height: 360pt;" alt="Country Weight Limits" src="htp://mydomain.com/images/custom1.jpg">[/i] everything is exactly as it should be.


How Can I get rid of the "file:/" in front of src reference to the .jpg file of the engine generated report chart?


Has anyone encountered anything similar?

Thank You,

Risto

My Servlet currently has settings as follows:


design = birtEngine.openReportDesign(sc.getRealPath("/WEB-INF/reports") + "/" + reportDesign);
HTMLRenderOption options = new HTMLRenderOption();
options.setImageDirectory("htp://mydomain.com/images");
options.setBaseImageURL("htp://mydomain.com/images");
options.setOutputFormat(HTMLRenderOption.HTML);
options.setEmbeddable(true);
options.setOutputStream(response.getOutputStream());
IRunAndRenderTask task = birtEngine.createRunAndRenderTask(design);
task.setRenderOption(options);

task.run();
task.close();
Re: Error Duplicate aggregation name: COUNT [message #810662 is a reply to message #810083] Thu, 01 March 2012 11:53 Go to previous message
Risto Urb is currently offline Risto UrbFriend
Messages: 4
Registered: February 2012
Junior Member
Solved the problem by using filter for my Servlet. Thank you all, I like the tool and hope in the future I have some to contribute as well, not just ask:)

Risto
Previous Topic:Task PageHandler
Next Topic:ChartWizardLauncher Example - DND Function
Goto Forum:
  


Current Time: Mon Dec 06 12:36:34 GMT 2021

Powered by FUDForum. Page generated in 0.02171 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top