dhis2-devs team mailing list archive

Thread
Date

Re: [Dhis2-users] Error prune period

To: Jason Pickering <jason.p.pickering@xxxxxxxxx>
From: <rin.channara@xxxxxxxxx>
Date: Thu, 31 Jul 2014 04:33:47 +0000
Cc: DHIS 2 Users list <dhis2-users@xxxxxxxxxxxxxxxxxxx>, DHIS 2 Developers list <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
Importance: Normal
In-reply-to: <CADsNmhvVJ7ZrghjgAramg1kSN4S1ge36LvhcWBzys6XYJ1-Nww@mail.gmail.com>

HI Jason,
I am using 
-DHIS2 v2.16 
-Build revision: 16253
-Java version: jre7
-Database: PostgreSQL
-OS: windows 8

plz check attached file.


thanks

channara








From: Jason Pickering
Sent: ‎Thursday‎, ‎July‎ ‎31‎, ‎2014 ‎11‎:‎16‎ ‎Morning
To: channara rin
Cc: DHIS 2 Users list, DHIS 2 Developers list





Hi Channara,
It will  help if you could send the output of the console when you execute the command, along with the usual (DHIS2 version, Java version, OS). 




Best regards,

Jason







On Thu, Jul 31, 2014 at 4:50 AM, <rin.channara@xxxxxxxxx> wrote:




Hi all developers,

when I go to services→maintenance, then I checked run “prune period”, I always got the error in console. DO you know how can I solve this problem?




thank you

CHANNARA


_______________________________________________
Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
        at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.inter
cept(StaticParametersInterceptor.java:191)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
        at org.hisp.dhis.interceptor.ExceptionInterceptor.intercept(ExceptionInt
erceptor.java:110)
        at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionI
nvocation.java:246)
        at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.j
ava:54)
        at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.jav
a:562)
        at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(Exec
uteOperations.java:77)
        at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter
.doFilter(StrutsPrepareAndExecuteFilter.java:99)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:208)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:330)
        at org.springframework.security.web.access.intercept.FilterSecurityInter
ceptor.invoke(FilterSecurityInterceptor.java:118)
        at org.springframework.security.web.access.intercept.FilterSecurityInter
ceptor.doFilter(FilterSecurityInterceptor.java:84)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at org.springframework.security.web.access.ExceptionTranslationFilter.do
Filter(ExceptionTranslationFilter.java:113)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at org.springframework.security.web.session.SessionManagementFilter.doFi
lter(SessionManagementFilter.java:103)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at org.springframework.security.web.authentication.AnonymousAuthenticati
onFilter.doFilter(AnonymousAuthenticationFilter.java:113)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at org.springframework.security.web.servletapi.SecurityContextHolderAwar
eRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)
        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.BasicAuthenticati
onFilter.doFilter(BasicAuthenticationFilter.java:150)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at org.springframework.security.web.authentication.AbstractAuthenticatio
nProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at org.springframework.security.web.authentication.AbstractAuthenticatio
nProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at org.hisp.dhis.security.filter.CustomAuthenticationFilter.doFilter(Cus
tomAuthenticationFilter.java:64)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at org.springframework.security.web.authentication.logout.LogoutFilter.d
oFilter(LogoutFilter.java:110)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at org.hisp.dhis.security.filter.AutomaticAccessFilter.doFilter(Automati
cAccessFilter.java:113)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at org.springframework.security.web.context.request.async.WebAsyncManage
rIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
equestFilter.java:106)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at org.springframework.security.web.context.SecurityContextPersistenceFi
lter.doFilter(SecurityContextPersistenceFilter.java:87)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.
doFilter(FilterChainProxy.java:342)
        at org.springframework.security.web.FilterChainProxy.doFilterInternal(Fi
lterChainProxy.java:192)
        at org.springframework.security.web.FilterChainProxy.doFilter(FilterChai
nProxy.java:160)
        at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(D
elegatingFilterProxy.java:343)
        at org.springframework.web.filter.DelegatingFilterProxy.doFilter(Delegat
ingFilterProxy.java:260)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:208)
        at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.do
FilterInternal(OpenSessionInViewFilter.java:151)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
equestFilter.java:106)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:208)
        at org.springframework.web.filter.CharacterEncodingFilter.doFilterIntern
al(CharacterEncodingFilter.java:88)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
equestFilter.java:106)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:208)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:220)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:122)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:501)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:171)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
950)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:116)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:408)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp
11Processor.java:1040)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(
AbstractProtocol.java:607)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoin
t.java:316)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskTh
read.java:61)
        at java.lang.Thread.run(Unknown Source)
Caused by: org.hibernate.exception.ConstraintViolationException: could not execu
te statement
        at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(S
QLStateConversionDelegate.java:128)
        at org.hibernate.exception.internal.StandardSQLExceptionConverter.conver
t(StandardSQLExceptionConverter.java:49)
        at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlException
Helper.java:125)
        at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlException
Helper.java:110)
        at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(
ResultSetReturnImpl.java:136)
        at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(
NonBatchingBatch.java:58)
        at org.hibernate.persister.entity.AbstractEntityPersister.delete(Abstrac
tEntityPersister.java:3333)
        at org.hibernate.persister.entity.AbstractEntityPersister.delete(Abstrac
tEntityPersister.java:3536)
        at org.hibernate.action.internal.EntityDeleteAction.execute(EntityDelete
Action.java:100)
        at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:362)
        at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:
354)
        at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:
280)
        at org.hibernate.event.internal.AbstractFlushingEventListener.performExe
cutions(AbstractFlushingEventListener.java:328)
        at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(Defaul
tFlushEventListener.java:52)
        at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1233)
        at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:403)

        at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.before
TransactionCommit(JdbcTransaction.java:101)
        at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(A
bstractTransactionImpl.java:175)
        at org.springframework.orm.hibernate4.HibernateTransactionManager.doComm
it(HibernateTransactionManager.java:552)
        ... 114 more
Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "
period" violates foreign key constraint "mapview_periods_periodid_fkey" on table
 "mapview_periods"
  Detail: Key (periodid)=(427) is still referenced from table "mapview_periods".

        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryEx
ecutorImpl.java:2161)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutor
Impl.java:1890)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.ja
va:255)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stat
ement.java:560)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(Abstract
Jdbc2Statement.java:417)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdb
c2Statement.java:363)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewP
roxyPreparedStatement.java:105)
        at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(
ResultSetReturnImpl.java:133)
        ... 128 more
* ERROR 2014-07-31 11:31:24,189 HHH000352: Unable to release batch statement...
(AbstractBatchImpl.java [http-bio-8080-exec-8])
* ERROR 2014-07-31 11:31:24,190 HHH000246: SQLException escaped proxy (AbstractB
atchImpl.java [http-bio-8080-exec-8])
java.sql.SQLException: You can't operate on a closed Statement!!!
        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
        at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.clearBatch(NewProx
yPreparedStatement.java:1703)
        at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.releaseSta
tements(AbstractBatchImpl.java:163)
        at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.release(Ab
stractBatchImpl.java:197)
        at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.close(JdbcCoor
dinatorImpl.java:174)
        at org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl.
close(TransactionCoordinatorImpl.java:277)
        at org.hibernate.internal.SessionImpl.close(SessionImpl.java:353)
        at org.springframework.orm.hibernate4.SessionFactoryUtils.closeSession(S
essionFactoryUtils.java:105)
        at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.do
FilterInternal(OpenSessionInViewFilter.java:160)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
equestFilter.java:106)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:208)
        at org.springframework.web.filter.CharacterEncodingFilter.doFilterIntern
al(CharacterEncodingFilter.java:88)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
equestFilter.java:106)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:241)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:208)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:220)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:122)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
torBase.java:501)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:171)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:102)
        at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:
950)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:116)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:408)
        at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp
11Processor.java:1040)
        at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(
AbstractProtocol.java:607)
        at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoin
t.java:316)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskTh
read.java:61)
        at java.lang.Thread.run(Unknown Source)
Caused by: java.lang.NullPointerException
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.maybeDirtyTransact
ion(NewProxyPreparedStatement.java:2069)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.clearBatch(NewProx
yPreparedStatement.java:1695)
        ... 29 more
Jul 31, 2014 11:31:36 AM com.hazelcast.util.HealthMonitor
INFO: [10.11.57.39]:5701 [dev] [3.2.1] memory.used=202.2M, memory.free=45.8M, me
mory.total=248.1M, memory.max=248.1M, memory.used/total=81.53%, memory.used/max=
81.53%, load.process=6.00%, load.system=14.00%, load.systemAverage=-100.00%, thr
ead.count=51, thread.peakCount=51, event.q.size=0, executor.q.async.size=0, exec
utor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0, exec
utor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0, executo
r.q.operation.size=0, executor.q.priorityOperation.size=0, executor.q.response.s
ize=0, operations.remote.size=0, operations.running.size=0, proxy.count=195, cli
entEndpoint.count=0, connection.active.count=0, connection.count=0
Jul 31, 2014 11:32:10 AM com.hazelcast.util.HealthMonitor
INFO: [10.11.57.39]:5701 [dev] [3.2.1] memory.used=202.9M, memory.free=45.1M, me
mory.total=248.1M, memory.max=248.1M, memory.used/total=81.80%, memory.used/max=
81.80%, load.process=0.00%, load.system=3.00%, load.systemAverage=-100.00%, thre
ad.count=51, thread.peakCount=51, event.q.size=0, executor.q.async.size=0, execu
tor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0, execu
tor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0, executor
.q.operation.size=0, executor.q.priorityOperation.size=0, executor.q.response.si
ze=0, operations.remote.size=0, operations.running.size=0, proxy.count=195, clie
ntEndpoint.count=0, connection.active.count=0, connection.count=0
Jul 31, 2014 11:32:40 AM com.hazelcast.util.HealthMonitor
INFO: [10.11.57.39]:5701 [dev] [3.2.1] memory.used=208.4M, memory.free=39.7M, me
mory.total=248.1M, memory.max=248.1M, memory.used/total=84.01%, memory.used/max=
84.01%, load.process=0.00%, load.system=3.00%, load.systemAverage=-100.00%, thre
ad.count=51, thread.peakCount=51, event.q.size=0, executor.q.async.size=0, execu
tor.q.client.size=0, executor.q.operation.size=0, executor.q.query.size=0, execu
tor.q.scheduled.size=0, executor.q.io.size=0, executor.q.system.size=0, executor
.q.operation.size=0, executor.q.priorityOperation.size=0, executor.q.response.si
ze=0, operations.remote.size=0, operations.running.size=0, proxy.count=195, clie
ntEndpoint.count=0, connection.active.count=0, connection.count=0

Follow ups

Re: [Dhis2-users] Error prune period
From: Jason Pickering, 2014-07-31

References

Error prune period
From: rin.channara, 2014-07-31
Re: [Dhis2-users] Error prune period
From: Jason Pickering, 2014-07-31