dhis2-devs team mailing list archive

["Tran Chau (HISP Vietnam)" <tran.hispvietnam@xxxxxxxxx>]

Hi Simon,

The bug [1] is fixed in version 2.16, revision 16513. Please take a look at
it on your side.

For the bug [2], I did run on the demo server and my local server. It
doesn't show the same issue.
Maybe giving me the full log file instead of the partial log file will help
me to analyze the issue.
Note that even looking at the full log file might not give me information I
need, but let's try this first.

Best regards,
Tran

On Sat, Oct 11, 2014 at 7:53 PM, Simon Ndira <simon.ndira@xxxxxxxxx> wrote:

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