dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Hi Yemi,

I am not 100% sure but I believe this:

- You need to define your organisation unit levels first - go to
organisation unit module > org unit levels, name your levels and click save.
- This has been fixed in 2.12 in the sense that it does not crash rather
gives you an indication in the logs about the problem.

regards,

Lars






On Mon, Feb 3, 2014 at 11:26 AM, Yemi Awe <j2yemi@xxxxxxxxx> wrote:

> 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@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>