← Back to team overview

dhis2-devs team mailing list archive

  1. dhis2-devs team
  2. Mailing list archive
  3. Message #27929

Re: Aggregation Fails on MySQL using DHIS 2.11

  Thread Previous • Date Previous • • Thread Next 
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.*

Follow ups

References

  Thread Previous • Date Previous • • Thread Next