dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #10309
Re: [Bug 715175] [NEW] data-pruning-fails
Removed references to this table and some others in r2836. Let me know next
time you test..
On Tue, Feb 8, 2011 at 3:19 PM, jason.p.pickering <715175@xxxxxxxxxxxxxxxxxx
> wrote:
> Public bug reported:
>
> 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
>
> ** Affects: dhis2
> Importance: Undecided
> Status: New
>
> --
> You received this bug notification because you are a member of DHIS 2
> coordinators, which is the registrant for DHIS.
> https://bugs.launchpad.net/bugs/715175
>
> Title:
> data-pruning-fails
>
> Status in DHIS 2 - District Health Information Software:
> New
>
> 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
>
>
>
--
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:
New
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
