dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Thanks Yemi.

Are you able to upgrade to a later DHIS version (2.13 or 2.14) ? I am
pretty sure it will work there.

Lars



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

> Thank you lars..this was already defined in dhis2 and select
> name,level,uid,code from orgunitlevel order by level returns
> +-----------------------+-------+-------------+------+
> | name                  | level | uid         | code |
> +-----------------------+-------+-------------+------+
> | National              |     1 | bXydX22AcL8 | NULL |
> | State                 |     2 | FYTVVQoHBxC | NULL |
> | Local Government Area |     3 | klipWRCsi0g | NULL |
> | Ward                  |     4 | Luq4hZbxjvS | NULL |
> | Facility              |     5 | fGjDrDfJpJ1 | NULL |
> +-----------------------+-------+-------------+------+
> 5 rows in set (0.16 sec)
>
>
>
>
> On Mon, Feb 3, 2014 at 3:19 PM, Lars Helge Øverland <larshelge@xxxxxxxxx>wrote:
>
>> 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
>>>
>>>
>>
>