Error when attempting to add an new orgunit

Any ideas what might be causing this when attempting to add a new orgunit?

Build revision:
13688
Build date:
2014-01-10 11:39

  • ERROR 2014-01-14 00:29:27,558 HHH000352: Unable to release batch statement… (AbstractBatchImpl.java [http-bio-8080-exec-1])

  • ERROR 2014-01-14 00:29:27,559 HHH000246: SQLException escaped proxy (AbstractBatchImpl.java [http-bio-8080-exec-1])

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(NewProxyPreparedStatement.java:1703)

at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.releaseStatements(AbstractBatchImpl.java:163)

at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.release(AbstractBatchImpl.java:197)

at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.close(JdbcCoordinatorImpl.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(SessionFactoryUtils.java:105)

at org.springframework.orm.hibernate4.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:158)

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:224)

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:987)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

at java.lang.Thread.run(Thread.java:724)

Caused by: java.lang.NullPointerException

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.maybeDirtyTransaction(NewProxyPreparedStatement.java:2069)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.clearBatch(NewProxyPreparedStatement.java:1695)

… 28 more

Can you give the rest of the trace? should be something like
org.hisp.dhis....

···

On Tue, Jan 14, 2014 at 6:32 AM, Jason Pickering < jason.p.pickering@gmail.com> wrote:

Caused by: java.lang.NullPointerException
        at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.maybeDirtyTransaction(NewProxyPreparedStatement.java:2069)
        at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.clearBatch(NewProxyPreparedStatement.java:1695)

--
Morten

This turned out to be the result (it seems) of the hibernate_sequence being reset. After resetting the sequence to a “high” number, things worked fine. So, not a problem with DHIS2. :slight_smile:

Best regards,
Jason

···

On Tue, Jan 14, 2014 at 9:59 AM, Morten Olav Hansen mortenoh@gmail.com wrote:

On Tue, Jan 14, 2014 at 6:32 AM, Jason Pickering jason.p.pickering@gmail.com wrote:

Caused by: java.lang.NullPointerException

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.maybeDirtyTransaction(NewProxyPreparedStatement.java:2069)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.clearBatch(NewProxyPreparedStatement.java:1695)

Can you give the rest of the trace? should be something like org.hisp.dhis…


Morten

Great :slight_smile:

···


Morten

On Tue, Jan 14, 2014 at 9:31 AM, Jason Pickering jason.p.pickering@gmail.com wrote:

This turned out to be the result (it seems) of the hibernate_sequence being reset. After resetting the sequence to a “high” number, things worked fine. So, not a problem with DHIS2. :slight_smile:

Best regards,
Jason

On Tue, Jan 14, 2014 at 9:59 AM, Morten Olav Hansen mortenoh@gmail.com wrote:

On Tue, Jan 14, 2014 at 6:32 AM, Jason Pickering jason.p.pickering@gmail.com wrote:

Caused by: java.lang.NullPointerException

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.maybeDirtyTransaction(NewProxyPreparedStatement.java:2069)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.clearBatch(NewProxyPreparedStatement.java:1695)

Can you give the rest of the trace? should be something like org.hisp.dhis…


Morten