dhis2-devs team mailing list archive

Thread
Date
[Bug 715175] Re: data-pruning-fails

To: dhis2-devs@xxxxxxxxxxxxxxxxxxx
From: Lars Helge Øverland <larshelge@xxxxxxxxx>
Date: Sun, 20 Mar 2011 16:00:04 -0000
Reply-to: Bug 715175 <715175@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
** Changed in: dhis2
       Status: New => Fix Committed

-- 
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/715175

Title:
  data-pruning-fails

Status in DHIS 2 - District Health Information Software:
  Fix Committed

Bug description:
  37077, 37075, 36702, 37073, 37074, 36703, 37069, 36704, 5930, 5932, 10650);]; nested exce                                       ption is org.postgresql.util.PSQLException: ERROR: relation "excelgroup_associations" does                                        not exist
    Position: 13
          at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(                                       SQLErrorCodeSQLExceptionTranslator.java:233)
          at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translat                                       e(AbstractFallbackSQLExceptionTranslator.java:72)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:406)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:427)
          at org.hisp.dhis.dataprune.jdbc.JdbcDataPruneStore.deleteMultiOrganisationUnit(Jdbc                                       DataPruneStore.java:123)
          at org.hisp.dhis.dataprune.DefaultDataPruneService.pruneOrganisationUnit(DefaultDat                                       aPruneService.java:82)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav                                       a:43)
          at java.lang.reflect.Method.invoke(Method.java:616)
          at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils                                       .java:309)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(Ref                                       lectiveMethodInvocation.java:183)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveM                                       ethodInvocation.java:150)
          at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(Transa                                       ctionInterceptor.java:110)
          at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveM                                       ethodInvocation.java:172)
          at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.j                                       ava:202)
          at $Proxy25.pruneOrganisationUnit(Unknown Source)
          at org.hisp.dhis.dataadmin.action.dataprune.PruneOrganisationUnitAction.execute(Pru                                       neOrganisationUnitAction.java:83)
          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.jav                                       a:43)
          at java.lang.reflect.Method.invoke(Method.java:616)
          at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvoca                                       tion.java:441)
          at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionIn                                       vocation.java:280)
          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j                                       ava:243)
          at org.hisp.dhis.webportal.interceptor.XWorkPortalUserInterceptor.intercept(XWorkPo                                       rtalUserInterceptor.java:82)
          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j                                       ava:237)
          at org.hisp.dhis.webportal.interceptor.XWorkPortalModuleInterceptor.intercept(XWork                                       PortalModuleInterceptor.java:85)
          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j                                       ava:237)
          at org.hisp.dhis.webportal.interceptor.XWorkPortalMenuInterceptor.intercept(XWorkPo                                       rtalMenuInterceptor.java:91)
          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j                                       ava:237)
          at org.hisp.dhis.webportal.interceptor.XWorkPortalParamsInterceptor.intercept(XWork                                       PortalParamsInterceptor.java:117)
          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j                                       ava:237)
          at org.hisp.dhis.interceptor.ContextInterceptor.intercept(ContextInterceptor.java:7                                       0)
          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j                                       ava:237)
          at org.hisp.dhis.interceptor.StyleInterceptor.intercept(StyleInterceptor.java:107)
          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j                                       ava:237)
          at org.hisp.dhis.interceptor.SystemSettingInterceptor.intercept(SystemSettingInterc                                       eptor.java:93)
          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j                                       ava:237)
          at org.hisp.dhis.interceptor.DisplayPropertyInterceptor.intercept(DisplayPropertyIn                                       terceptor.java:90)
          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j                                       ava:237)
          at org.hisp.dhis.interceptor.SortOrderInterceptor.intercept(SortOrderInterceptor.ja                                       va:124)
          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j                                       ava:237)
          at org.hisp.dhis.security.intercept.XWorkSecurityInterceptor.intercept(XWorkSecurit                                       yInterceptor.java:98)
          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j                                       ava:237)
          at org.hisp.dhis.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:141)
          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j                                       ava:237)
          at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterc                                       eptor.java:126)
          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j                                       ava:237)
          at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(Parameters                                       Interceptor.java:195)
          at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilt                                       erInterceptor.java:87)
          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j                                       ava:237)
          at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(Static                                       ParametersInterceptor.java:179)
          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j                                       ava:237)
          at org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInterceptor.ja                                       va:98)
          at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.j                                       ava:237)
          at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
          at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)
          at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:39                                       5)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt                                       erChain.java:244)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.                                       java:210)
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(Fi                                       lterChainProxy.java:368)
          at org.hisp.dhis.security.filter.RequiredLoginFilter.doFilter(RequiredLoginFilter.j                                       ava:129)
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(Fi                                       lterChainProxy.java:380)
          at org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(AutomaticAccessFilt                                       er.java:112)
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(Fi                                       lterChainProxy.java:380)
          at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(Log                                       outFilter.java:105)
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(Fi                                       lterChainProxy.java:380)
          at org.springframework.security.web.authentication.AbstractAuthenticationProcessing                                       Filter.doFilter(AbstractAuthenticationProcessingFilter.java:187)
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(Fi                                       lterChainProxy.java:380)
          at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilt                                       er(SecurityContextPersistenceFilter.java:79)
          at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(Fi                                       lterChainProxy.java:380)
          at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java                                       :169)
          at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFi                                       lterProxy.java:237)
          at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterPr                                       oxy.java:167)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt                                       erChain.java:244)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.                                       java:210)
          at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInter                                       nal(OpenSessionInViewFilter.java:198)
          at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilte                                       r.java:76)
          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt                                       erChain.java:244)
          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.                                       java:210)
          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:2                                       40)
          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:1                                       61)
          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:164)
          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:100)
          at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:550)
          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118                                       )
          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:380)
          at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:284)
          at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http1                                       1AprProtocol.java:322)
          at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1684                                       )
          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:636)
  Caused by: org.postgresql.util.PSQLException: ERROR: relation "excelgroup_associations" doe                                       s not exist
    Position: 13
          at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.                                       java:2102)
          at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1                                       835)
          at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
          at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:                                       500)
          at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statem                                       ent.java:374)
          at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:                                       366)
          at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)
          at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStateme                                       nt(JdbcTemplate.java:420)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:395)
          ... 91 more
References

[Bug 715175] [NEW] data-pruning-fails
From: jason.p.pickering, 2011-02-08