Aggregation Fails on MySQL using DHIS 2.11

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)

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@gmail.com wrote:

Hello Development Team,

Please kindly assist

Issue : Dataset report doesnt aggregate up the heirarchy

Simulated Steps

  1. Ran the Analytics and datamart generator
  1. Ensured the aggregation heirarchy levels are defined for each data element
  1. Identified with ownership and type org unit set groups
  1. All dataset are completed
  1. Integrity check -

Organisation units with cyclic references

Technical result

  1. The orgunitlevel table return rows as defined in the dhis2 orgunitlevel form
  1. 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

Hello Lars,
I’m troubleshooting similar problem on aggregation query builder on test.dhis2.org for 2.14 revision 13755

I’ll get back to you soon.

ERROR LOG:

  • ERROR 2014-02-03 12:14:39,546 Exception occurred during processing request: Unable to instantiate Action, org.hisp.dhis.patient.action.caseaggregation.TestCaseAggregationConditionAction, defined for ‘testCaseAggregationCondition’ in namespace '/dhis-web-maintenance-patient’Error creating bean with name ‘org.hisp.dhis.patient.action.caseaggregation.TestCaseAggregationConditionAction’ defined in URL [jar:file:/home/dhis/tomcat-idsr/webapps/idsr/WEB-INF/lib/dhis-web-maintenance-patient-2.14.jar!/META-INF/dhis/beans.xml]: Error setting property values; nested exception is org.springframework.beans.NotWritablePropertyException: Invalid property ‘caseAggregationConditionService’ of bean class [org.hisp.dhis.patient.action.caseaggregation.TestCaseAggregationConditionAction]: Bean property ‘caseAggregationConditionService’ is not writable or has an invalid setter method. Does the parameter type of the setter match the return type of the getter? (CommonsLogger.java [http-bio-127.0.0.1-8080-exec-2])

Unable to instantiate Action, org.hisp.dhis.patient.action.caseaggregation.TestCaseAggregationConditionAction, defined for ‘testCaseAggregationCondition’ in namespace '/dhis-web-maintenance-patient’Error creating bean with name ‘org.hisp.dhis.patient.action.caseaggregation.TestCaseAggregationConditionAction’ defined in URL [jar:file:/home/dhis/tomcat-idsr/webapps/idsr/WEB-INF/lib/dhis-web-maintenance-patient-2.14.jar!/META-INF/dhis/beans.xml]: Error setting property values; nested exception is org.springframework.beans.NotWritablePropertyException: Invalid property ‘caseAggregationConditionService’ of bean class [org.hisp.dhis.patient.action.caseaggregation.TestCaseAggregationConditionAction]: Bean property ‘caseAggregationConditionService’ is not writable or has an invalid setter method. Does the parameter type of the setter match the return type of the getter?

at com.opensymphony.xwork2.DefaultActionInvocation.createAction(DefaultActionInvocation.java:316)

at com.opensymphony.xwork2.DefaultActionInvocation.init(DefaultActionInvocation.java:397)

at com.opensymphony.xwork2.DefaultActionProxy.prepare(DefaultActionProxy.java:194)

at org.apache.struts2.impl.StrutsActionProxy.prepare(StrutsActionProxy.java:63)

at org.apache.struts2.impl.StrutsActionProxyFactory.createActionProxy(StrutsActionProxyFactory.java:37)

at com.opensymphony.xwork2.DefaultActionProxyFactory.createActionProxy(DefaultActionProxyFactory.java:58)

at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:552)

at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)

at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:99)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)

at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)

at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:64)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:113)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)

at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:149)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:999)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)

at java.lang.Thread.run(Thread.java:722)

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘org.hisp.dhis.patient.action.caseaggregation.TestCaseAggregationConditionAction’ defined in URL [jar:file:/home/dhis/tomcat-idsr/webapps/idsr/WEB-INF/lib/dhis-web-maintenance-patient-2.14.jar!/META-INF/dhis/beans.xml]: Error setting property values; nested exception is org.springframework.beans.NotWritablePropertyException: Invalid property ‘caseAggregationConditionService’ of bean class [org.hisp.dhis.patient.action.caseaggregation.TestCaseAggregationConditionAction]: Bean property ‘caseAggregationConditionService’ is not writable or has an invalid setter method. Does the parameter type of the setter match the return type of the getter?

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1453)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1158)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:315)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)

at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1117)

at com.opensymphony.xwork2.spring.SpringObjectFactory.buildBean(SpringObjectFactory.java:151)

at com.opensymphony.xwork2.ObjectFactory.buildBean(ObjectFactory.java:171)

at com.opensymphony.xwork2.factory.DefaultActionFactory.buildAction(DefaultActionFactory.java:22)

at com.opensymphony.xwork2.ObjectFactory.buildAction(ObjectFactory.java:141)

at com.opensymphony.xwork2.DefaultActionInvocation.createAction(DefaultActionInvocation.java:297)

… 64 more

Caused by: org.springframework.beans.NotWritablePropertyException: Invalid property ‘caseAggregationConditionService’ of bean class [org.hisp.dhis.patient.action.caseaggregation.TestCaseAggregationConditionAction]: Bean property ‘caseAggregationConditionService’ is not writable or has an invalid setter method. Does the parameter type of the setter match the return type of the getter?

at org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrapperImpl.java:1042)

at org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrapperImpl.java:902)

at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:75)

at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:57)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1450)

… 75 more

···

On Mon, Feb 3, 2014 at 5:19 PM, Lars Helge Øverland larshelge@gmail.com 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


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


Regards,

Full name: John Francis Mukulu

Mobile Phone: +255717154006

Website: http://bongolinux.webs.com/

Social Coding: http://github.com/mukulu

Opensource Developer.

On Mon, Feb 3, 2014 at 11:26 AM, Yemi Awe j2yemi@gmail.com wrote:

Hello Development Team,

Please kindly assist

Issue : Dataset report doesnt aggregate up the heirarchy

Simulated Steps

  1. Ran the Analytics and datamart generator
  1. Ensured the aggregation heirarchy levels are defined for each data element
  1. Identified with ownership and type org unit set groups
  1. All dataset are completed
  1. Integrity check -

Organisation units with cyclic references

Technical result

  1. The orgunitlevel table return rows as defined in the dhis2 orgunitlevel form
  1. 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

Hi John,

this bug is not related - but thanks for reporting, it has been fixed in trunk and 2.14.

Lars

···

On Tue, Feb 4, 2014 at 7:27 AM, John Mukulu john.f.mukulu@gmail.com wrote:

Hello Lars,
I’m troubleshooting similar problem on aggregation query builder on test.dhis2.org for 2.14 revision 13755

I’ll get back to you soon.

ERROR LOG:

  • ERROR 2014-02-03 12:14:39,546 Exception occurred during processing request: Unable to instantiate Action, org.hisp.dhis.patient.action.caseaggregation.TestCaseAggregationConditionAction, defined for ‘testCaseAggregationCondition’ in namespace '/dhis-web-maintenance-patient’Error creating bean with name ‘org.hisp.dhis.patient.action.caseaggregation.TestCaseAggregationConditionAction’ defined in URL [jar:file:/home/dhis/tomcat-idsr/webapps/idsr/WEB-INF/lib/dhis-web-maintenance-patient-2.14.jar!/META-INF/dhis/beans.xml]: Error setting property values; nested exception is org.springframework.beans.NotWritablePropertyException: Invalid property ‘caseAggregationConditionService’ of bean class [org.hisp.dhis.patient.action.caseaggregation.TestCaseAggregationConditionAction]: Bean property ‘caseAggregationConditionService’ is not writable or has an invalid setter method. Does the parameter type of the setter match the return type of the getter? (CommonsLogger.java [http-bio-127.0.0.1-8080-exec-2])

Unable to instantiate Action, org.hisp.dhis.patient.action.caseaggregation.TestCaseAggregationConditionAction, defined for ‘testCaseAggregationCondition’ in namespace '/dhis-web-maintenance-patient’Error creating bean with name ‘org.hisp.dhis.patient.action.caseaggregation.TestCaseAggregationConditionAction’ defined in URL [jar:file:/home/dhis/tomcat-idsr/webapps/idsr/WEB-INF/lib/dhis-web-maintenance-patient-2.14.jar!/META-INF/dhis/beans.xml]: Error setting property values; nested exception is org.springframework.beans.NotWritablePropertyException: Invalid property ‘caseAggregationConditionService’ of bean class [org.hisp.dhis.patient.action.caseaggregation.TestCaseAggregationConditionAction]: Bean property ‘caseAggregationConditionService’ is not writable or has an invalid setter method. Does the parameter type of the setter match the return type of the getter?

at com.opensymphony.xwork2.DefaultActionInvocation.createAction(DefaultActionInvocation.java:316)

at com.opensymphony.xwork2.DefaultActionInvocation.init(DefaultActionInvocation.java:397)

at com.opensymphony.xwork2.DefaultActionProxy.prepare(DefaultActionProxy.java:194)

at org.apache.struts2.impl.StrutsActionProxy.prepare(StrutsActionProxy.java:63)

at org.apache.struts2.impl.StrutsActionProxyFactory.createActionProxy(StrutsActionProxyFactory.java:37)

at com.opensymphony.xwork2.DefaultActionProxyFactory.createActionProxy(DefaultActionProxyFactory.java:58)

at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:552)

at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)

at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:99)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)

at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)

at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:183)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(CustomAuthenticationFilter.java:64)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilter.java:113)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)

at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)

at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)

at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)

at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)

at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:149)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)

at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)

at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:999)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:565)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)

at java.lang.Thread.run(Thread.java:722)

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘org.hisp.dhis.patient.action.caseaggregation.TestCaseAggregationConditionAction’ defined in URL [jar:file:/home/dhis/tomcat-idsr/webapps/idsr/WEB-INF/lib/dhis-web-maintenance-patient-2.14.jar!/META-INF/dhis/beans.xml]: Error setting property values; nested exception is org.springframework.beans.NotWritablePropertyException: Invalid property ‘caseAggregationConditionService’ of bean class [org.hisp.dhis.patient.action.caseaggregation.TestCaseAggregationConditionAction]: Bean property ‘caseAggregationConditionService’ is not writable or has an invalid setter method. Does the parameter type of the setter match the return type of the getter?

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1453)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1158)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)

at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:315)

at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)

at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1117)

at com.opensymphony.xwork2.spring.SpringObjectFactory.buildBean(SpringObjectFactory.java:151)

at com.opensymphony.xwork2.ObjectFactory.buildBean(ObjectFactory.java:171)

at com.opensymphony.xwork2.factory.DefaultActionFactory.buildAction(DefaultActionFactory.java:22)

at com.opensymphony.xwork2.ObjectFactory.buildAction(ObjectFactory.java:141)

at com.opensymphony.xwork2.DefaultActionInvocation.createAction(DefaultActionInvocation.java:297)

… 64 more

Caused by: org.springframework.beans.NotWritablePropertyException: Invalid property ‘caseAggregationConditionService’ of bean class [org.hisp.dhis.patient.action.caseaggregation.TestCaseAggregationConditionAction]: Bean property ‘caseAggregationConditionService’ is not writable or has an invalid setter method. Does the parameter type of the setter match the return type of the getter?

at org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrapperImpl.java:1042)

at org.springframework.beans.BeanWrapperImpl.setPropertyValue(BeanWrapperImpl.java:902)

at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:75)

at org.springframework.beans.AbstractPropertyAccessor.setPropertyValues(AbstractPropertyAccessor.java:57)

at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1450)

… 75 more

On Mon, Feb 3, 2014 at 5:19 PM, Lars Helge Øverland larshelge@gmail.com 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


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

Regards,

Full name: John Francis Mukulu

Mobile Phone: +255717154006

Website: http://bongolinux.webs.com/

Social Coding: http://github.com/mukulu

Opensource Developer.

On Mon, Feb 3, 2014 at 11:26 AM, Yemi Awe j2yemi@gmail.com wrote:

Hello Development Team,

Please kindly assist

Issue : Dataset report doesnt aggregate up the heirarchy

Simulated Steps

  1. Ran the Analytics and datamart generator
  1. Ensured the aggregation heirarchy levels are defined for each data element
  1. Identified with ownership and type org unit set groups
  1. All dataset are completed
  1. Integrity check -

Organisation units with cyclic references

Technical result

  1. The orgunitlevel table return rows as defined in the dhis2 orgunitlevel form
  1. 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

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@gmail.com 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@gmail.com 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@gmail.com wrote:

Hello Development Team,

Please kindly assist

Issue : Dataset report doesnt aggregate up the heirarchy

Simulated Steps

  1. Ran the Analytics and datamart generator
  1. Ensured the aggregation heirarchy levels are defined for each data element
  1. Identified with ownership and type org unit set groups
  1. All dataset are completed
  1. Integrity check -

Organisation units with cyclic references

Technical result

  1. The orgunitlevel table return rows as defined in the dhis2 orgunitlevel form
  1. 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