dhis2-users team mailing list archive

[Jason Pickering <jason.p.pickering@xxxxxxxxx>]

How many data elements/indicators do you have? This might explain the
error. Basically, there is a restriction put into place to prevent DHIS2
from returning "too much" data to the browser, and to prevent anyone from
completely bring the system to its knees with a very large request for
data. Try to break up your table into smaller pieces if possible. You can
also change the number of records which can be returned by the analytics to
something larger than 50,000 i Settings->General Settings->Maximum number
of analytics records, but this should be used with great care.

Regards,
Jason


On Thu, Nov 27, 2014 at 10: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.
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Jason P. Pickering
email: jason.p.pickering@xxxxxxxxx
tel:+46764147049