Hello Development Team, Please kindly assist
Issue : Dataset report doesnt aggregate up the heirarchy Simulated Steps 1. Ran the Analytics and datamart generator 2. Ensured the aggregation heirarchy levels are defined for each data element 3. Identified with ownership and type org unit set groups 4. All dataset are completed 5. Integrity check - Organisation units with cyclic references Technical result 1. The orgunitlevel table return rows as defined in the dhis2 orgunitlevel form 2. The analytics_20xx table returns NULL for uidlevel1,uidlevel2,uidlevel3,uidlevel4 but not uidlevel5 where the data is captured. Platform Tomcat 7, MySQL,DHIS2.11 (and upwards) Error from log: * INFO 2014-02-01 15:23:05,251 Completeness export process completed: 0:01:04.882 (Clock.java [taskScheduler-1]) * INFO 2014-02-01 15:23:05,251 [Level: INFO, category: DATAMART, time: Sat Feb 01 15:23:05 WAT 2014, message: Completeness process completed] (InMemoryNotifier.java [taskScheduler-1]) * WARN 2014-02-01 15:36:50,133 HHH000179: Narrowing proxy to class org.hisp.dhis.period.MonthlyPeriodType - this operation breaks == (StatefulPersistenceContext.java [http-apr-8080-exec-3]) * ERROR 2014-02-01 15:36:50,172 Error while executing action (ExceptionInterceptor.java [http-apr-8080-exec-3]) java.lang.NullPointerException at org.hisp.dhis.analytics.data.DefaultQueryPlanner.getLevelOrgUnitMap(DefaultQueryPlanner.java:631) at org.hisp.dhis.analytics.data.DefaultQueryPlanner.groupByOrgUnitLevel(DefaultQueryPlanner.java:450) at org.hisp.dhis.analytics.data.DefaultQueryPlanner.planQuery(DefaultQueryPlanner.java:209) at org.hisp.dhis.analytics.data.DefaultAnalyticsService.getAggregatedValueMap(DefaultAnalyticsService.java:532) at org.hisp.dhis.analytics.data.DefaultAnalyticsService.getAggregatedDataValueMap(DefaultAnalyticsService.java:495) at org.hisp.dhis.analytics.data.DefaultAnalyticsService.getAggregatedDataValues(DefaultAnalyticsService.java:274) at org.hisp.dhis.analytics.data.DefaultAnalyticsService.getAggregatedDataValueMapping(DefaultAnalyticsService.java:451) at org.hisp.dhis.datasetreport.jdbc.AnalyticsDataSetReportStore.getAggregatedValues(AnalyticsDataSetReportStore.java:97) at org.hisp.dhis.datasetreport.impl.DefaultDataSetReportService.getCustomDataSetReport(DefaultDataSetReportService.java:107) at org.hisp.dhis.reporting.dataset.action.GenerateDataSetReportAction.execute(GenerateDataSetReportAction.java:297) 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:450) at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:289) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:252) at org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPortalUserInterceptor.java:87) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) at org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWorkPortalModuleInterceptor.java:90) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) at org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPortalMenuInterceptor.java:96) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) at org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWorkPortalParamsInterceptor.java:118) at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:246) at org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:81)
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
