dhis2-users team mailing list archive

[Moses Marimo <marimo@xxxxxxxxx>]

This error is on DHIS 2.14

On Thu, Nov 27, 2014 at 11:12 AM, Moses Marimo <marimo@xxxxxxxxx> wrote:

> I get this error when I run a report which only has 7 columns and less
> than 30 Facilities. What causes this error???
>
> org.hisp.dhis.analytics.IllegalQueryException: Table exceeds max number of cells: 50000 (51792)
> 	org.hisp.dhis.analytics.data.DefaultQueryPlanner.validate(DefaultQueryPlanner.java:150)
> 	org.hisp.dhis.analytics.data.DefaultQueryPlanner.planQuery(DefaultQueryPlanner.java:195)
> 	org.hisp.dhis.analytics.data.DefaultAnalyticsService.getAggregatedValueMap(DefaultAnalyticsService.java:568)
> 	org.hisp.dhis.analytics.data.DefaultAnalyticsService.getAggregatedDataValueMap(DefaultAnalyticsService.java:531)
> 	org.hisp.dhis.analytics.data.DefaultAnalyticsService.getAggregatedDataValues(DefaultAnalyticsService.java:235)
> 	org.hisp.dhis.analytics.data.DefaultAnalyticsService.getAggregatedDataValueMapping(DefaultAnalyticsService.java:474)
> 	org.hisp.dhis.analytics.data.DefaultAnalyticsService.getAggregatedDataValueMapping(DefaultAnalyticsService.java:518)
> 	org.hisp.dhis.reporttable.impl.DefaultReportTableService.getReportTableGrid(DefaultReportTableService.java:130)
> 	sun.reflect.GeneratedMethodAccessor1050.invoke(Unknown Source)
> 	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> 	java.lang.reflect.Method.invoke(Method.java:606)
>
>
> --
> ICT Warehouse (Pvt) Ltd - "The Stockist of *e*-nnovation"
> 7 Chelmsford Belgravia, Harare
> Tel: +263-8644-102349
> Cell: +263-772-268353
> Website: *www.ict.co.zw <http://www.ict.co.zw>*
>
>
> Innovative solutions in Web Design and E-Commerce, Software Engineering,
> Mobile and Bulk SMS Solutions, Graphic Design and Printing, General ICT
> Solutions and Consultancy.
>



-- 
ICT Warehouse (Pvt) Ltd - "The Stockist of *e*-nnovation"
7 Chelmsford Belgravia, Harare
Tel: +263-8644-102349
Cell: +263-772-268353
Website: *www.ict.co.zw <http://www.ict.co.zw>*


Innovative solutions in Web Design and E-Commerce, Software Engineering,
Mobile and Bulk SMS Solutions, Graphic Design and Printing, General ICT
Solutions and Consultancy.