dhis2-devs team mailing list archive

Thread
Date
Re: generate table error

To: Wilfred Senyoni <senyoni@xxxxxxxxx>
From: <rin.channara@xxxxxxxxx>
Date: Wed, 23 Jul 2014 03:12:09 +0000
Cc: DHIS 2 Users list <dhis2-users@xxxxxxxxxxxxxxxxxxx>, DHIS 2 Developers list <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
Importance: Normal
In-reply-to: <CAKeifh2KDpoboNCjKzrcVX2W6yF3c53OYV=anrn5NNOEGNQ8FQ@mail.gmail.com>
Hi Wilfred,

I tried delete period that doesn’t relate to datavalue, mapview and eventreport. But when I ticked “PRUNE PERIOD” to process. I still got the error on console. DO you know this problem below?

--------------------------

* ERROR 2014-07-23 10:11:30,951 HHH000352: Unable to release batch statement...
(AbstractBatchImpl.java [http-bio-8080-exec-3])
* ERROR 2014-07-23 10:11:30,952 HHH000246: SQLException escaped proxy (AbstractB
atchImpl.java [http-bio-8080-exec-3])
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:158)
        at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerR
equestFilter.java:107)
        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:107)
        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

--------------------------


thank you

CHANNARA





From: Wilfred Senyoni
Sent: ‎Wednesday‎, ‎July‎ ‎23‎, ‎2014 ‎12‎:‎23‎ ‎Morning
To: channara rin
Cc: DHIS 2 Users list, DHIS 2 Developers list





thus great Channara.



the prune period feature cleans your period table by removing all periods which have no registered data values. more information on the maintenance module is here




Cheers



Wilfred F. Senyoni
Computer Science and Engineering Department 
College of Information and Communication Technologies
University of Dar es salaam



On Tue, Jul 22, 2014 at 6:47 PM, <rin.channara@xxxxxxxxx> wrote:




YES now I can delete duplicate that occurred error. now it work fine, when I generate table.

BUT WHEN I TICK “PRUNE PERIOD” IN maintenance section. I got the console error. I don’t know what prune period mean?




thank you

channara





From: Wilfred Senyoni
Sent: ‎Tuesday‎, ‎July‎ ‎22‎, ‎2014 ‎4‎:‎32‎ ‎Evening


To: channara rin
Cc: DHIS 2 Users list, DHIS 2 Developers list







Hello channara
look at the log files (catalina.out) and see which table the duplicate period is referred to. You will need to delete the periods which are duplicates before you can proceed.




Cheers



Wilfred F. Senyoni
Computer Science and Engineering Department 
College of Information and Communication Technologies
University of Dar es salaam



On Tue, Jul 22, 2014 at 11:41 AM, <rin.channara@xxxxxxxxx> wrote:




hi Wilfred,

when I clicked “Prune periods”, in the console got the error too.




* ERROR 2014-07-22 15:42:23,133 HHH000352: Unable to release batch statement...
(AbstractBatchImpl.java [http-bio-8080-exec-16])
* ERROR 2014-07-22 15:42:23,134 HHH000246: SQLException escaped proxy (AbstractB
atchImpl.java [http-bio-8080-exec-16])
java.sql.SQLException: You can't operate on a closed Statement!!!











From: Wilfred Senyoni
Sent: ‎Tuesday‎, ‎July‎ ‎22‎, ‎2014 ‎2‎:‎11‎ ‎Evening
To: channara rin
Cc: DHIS 2 Users list, DHIS 2 Developers list







Hello Channara
You need to clean your periods by going to the System Administration -> Maintenance -> Prune periods.

You will also need to observer the logs as some periods might require you to delete them manually.




Cheers



Wilfred F. Senyoni
Computer Science and Engineering Department 
College of Information and Communication Technologies
University of Dar es salaam



On Tue, Jul 22, 2014 at 6:47 AM, channara rin <rin.channara@xxxxxxxxx> wrote:



Hi all user, and developers,



When i click generate table i got this below error. DO YOU KNOW HOW TO SOLVE THIS PROBLEM?


NOTE: 

DHIS2 version: 2.15

Build revision: 15195

Database: PostgreSQL




 Inline image 1 

_______________________________________________
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
References

generate table error
From: channara rin, 2014-07-22
Re: generate table error
From: Wilfred Senyoni, 2014-07-22
Re: generate table error
From: rin.channara, 2014-07-22
Re: generate table error
From: Wilfred Senyoni, 2014-07-22
Re: generate table error
From: rin.channara, 2014-07-22
Re: generate table error
From: Wilfred Senyoni, 2014-07-22