dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #27941
Re: Aggregation Fails on MySQL using DHIS 2.11
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@xxxxxxxxx> 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@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
>>>
>>>
>>
>> _______________________________________________
>> 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
>>
>>
>
>
> --
> *Regards,*
> *Full name: *John Francis Mukulu
> *Mobile Phone:* +255717154006
> *Website:* http://bongolinux.webs.com/
> *Social Coding:* http://github.com/mukulu
> *Opensource Developer.*
>
References
