dhis2-devs team mailing list archive

[Yemi Awe <j2yemi@xxxxxxxxx>]

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)