dhis2-users team mailing list archive

[Moses Marimo <marimo@xxxxxxxxx>]

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.