← Back to team overview

dhis2-devs team mailing list archive

Re: [Bug 1378893] Re: Prune period and automated aggregation of tracker data fails in 2.16

 

Hi Thu Trun,
I am using this version:
Version:
2.16
Build revision:
16506
Build date:
2014-10-08 13:15

Regarding the issue. It has to do with Pruning periods and Tracker.

Pruning periods: When I go to 'Data Administration' -> 'Maintenance' -> Perform Maintenance -> 'only for prune period'. This hangs with errors further below.
Aggregation: When I go to 'Program / Attributes' -> 'Automated aggregation' -> 'Execute'. This also hangs with errors further below.

Please let me know if you have any further questions.
Thanks;
Simon.


-----Original Message-----
From: bounces@xxxxxxxxxxxxx [mailto:bounces@xxxxxxxxxxxxx] On Behalf Of Thu Tran
Sent: Saturday, October 11, 2014 12:35 PM
To: simon.ndira@xxxxxxxxx
Subject: [Bug 1378893] Re: Prune period and automated aggregation of tracker data fails in 2.16

Hi Simon,

Which revision do you use for testing ?

For 2nd issue, could you talk to me what is the functionality got this
issue ?

-- 
You received this bug notification because you are subscribed to the bug
report.
https://bugs.launchpad.net/bugs/1378893

Title:
  Prune period and automated aggregation of tracker data fails in 2.16

Status in DHIS 2:
  New

Bug description:
  I have upgraded my database to 2.16. Everything is working fine, apart
  from two critical functionalities:

  1. Automated aggregate in Programs / Attributes for tracked instances to aggregate data raises the following error:
          at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
          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: org.postgresql.util.PSQLException: ERROR: null value in column "periodid" violates not-null constraint
    Detail: Failing row contains (null, 1, 2013-10-08, 2013-10-08).
          at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
          at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
          at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
          at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:560)
          at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
          at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:395)
          at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)
          at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:421)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
          ... 29 more

  ********************************
  So the only way I can aggregate now is through manual aggregation in individual records. 

  2. I cannot execute prune periods as the script hangs with 28 more .....
   at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1001)
          at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
          at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
          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)
          ... 27 more

  *********************************

  Might someone have figured a way out of this?

  Thanks and looking forward.
  Simon.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1378893/+subscriptions

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

Title:
  Prune period and automated aggregation of tracker data fails in 2.16

Status in DHIS 2:
  New

Bug description:
  I have upgraded my database to 2.16. Everything is working fine, apart
  from two critical functionalities:

  1. Automated aggregate in Programs / Attributes for tracked instances to aggregate data raises the following error:
          at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:292)
          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: org.postgresql.util.PSQLException: ERROR: null value in column "periodid" violates not-null constraint
    Detail: Failing row contains (null, 1, 2013-10-08, 2013-10-08).
          at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
          at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
          at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
          at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:560)
          at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
          at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:395)
          at com.mchange.v2.c3p0.impl.NewProxyStatement.execute(NewProxyStatement.java:1006)
          at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:421)
          at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:396)
          ... 29 more

  ********************************
  So the only way I can aggregate now is through manual aggregation in individual records. 

  2. I cannot execute prune periods as the script hangs with 28 more .....
   at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1001)
          at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
          at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:312)
          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)
          ... 27 more

  *********************************

  Might someone have figured a way out of this?

  Thanks and looking forward.
  Simon.

To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1378893/+subscriptions


References