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 <[email protected]> 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 : [email protected] > Unsubscribe : https://launchpad.net/~dhis2-users > More help : https://help.launchpad.net/ListHelp > > -- Jason P. Pickering email: [email protected] tel:+46764147049
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-users Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-users More help : https://help.launchpad.net/ListHelp
