Re: [Dhis2-devs] Bug when using ==NULL (is null ) in aggregate query builder
Adding Juan and Jose, who has dealt with similar situations. *Rodolfo Meliá* *Principal | *rme...@knowming.com Skype: rod.melia | +44 777 576 4090 | +1 708 872 7636 www.knowming.com On Fri, Oct 10, 2014 at 7:10 PM, Prosper BT wrote: > Using 2.16 demo server, build not specified, there is an error when > dealing with data elements and trying to aggregate when data elements are > null. > > ([DE:2005727.*.2005735] is null ) > > Can you check it works for !=NULL > > Regards > -- > Prosper Behumbiize, MPH > Phone:+256 414 320076 > Cell: +256 772 139037 > +256 752 751776 > > ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] Bug when using ==NULL (is null ) in aggregate query builder
Adding Juan and Jose, who has dealt with similar situations. > > > On Fri, Oct 10, 2014 at 7:10 PM, Prosper BT wrote: > >> Using 2.16 demo server, build not specified, there is an error when >> dealing with data elements and trying to aggregate when data elements are >> null. >> >> ([DE:2005727.*.2005735] is null ) >> >> Can you check it works for !=NULL >> >> Regards >> -- >> Prosper Behumbiize, MPH >> Phone:+256 414 320076 >> Cell: +256 772 139037 >> +256 752 751776 >> >> > > ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 17057: Removed unused dependency management definitions
revno: 17057 committer: Lars Helge Overland branch nick: dhis2 timestamp: Sat 2014-10-11 12:37:39 +0200 message: Removed unused dependency management definitions modified: dhis-2/dhis-services/dhis-service-dxf2/src/test/java/org/hisp/dhis/dxf2/gml/GmlImportServiceTest.java dhis-2/pom.xml -- lp:dhis2 https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk Your team DHIS 2 developers is subscribed to branch lp:dhis2. To unsubscribe from this branch go to https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription === modified file 'dhis-2/dhis-services/dhis-service-dxf2/src/test/java/org/hisp/dhis/dxf2/gml/GmlImportServiceTest.java' --- dhis-2/dhis-services/dhis-service-dxf2/src/test/java/org/hisp/dhis/dxf2/gml/GmlImportServiceTest.java 2014-10-10 22:52:25 + +++ dhis-2/dhis-services/dhis-service-dxf2/src/test/java/org/hisp/dhis/dxf2/gml/GmlImportServiceTest.java 2014-10-11 10:37:39 + @@ -37,7 +37,6 @@ import java.util.HashMap; import org.hisp.dhis.DhisSpringTest; -import org.hisp.dhis.DhisTest; import org.hisp.dhis.dxf2.metadata.MetaData; import org.hisp.dhis.organisationunit.OrganisationUnit; import org.junit.Test; === modified file 'dhis-2/pom.xml' --- dhis-2/pom.xml 2014-10-10 19:10:19 + +++ dhis-2/pom.xml 2014-10-11 10:37:39 + @@ -818,29 +818,6 @@ 2.6.12 -org.codehaus.woodstox -woodstox-core-asl -4.1.3 - - -org.codehaus.woodstox -stax2-api -3.1.1 -jar - - -stax -stax-api -1.0.1 - - -javax.xml.stream -stax-api -1.0-2 -test -jar - - xpp3 xpp3 1.1.3.4.O ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 17058: Removed ConfigurationManager. Removed xstream dependency.
revno: 17058
committer: Lars Helge Overland
branch nick: dhis2
timestamp: Sat 2014-10-11 13:23:15 +0200
message:
Removed ConfigurationManager. Removed xstream dependency.
removed:
dhis-2/dhis-services/dhis-service-importexport/src/main/java/org/hisp/dhis/importexport/IbatisConfiguration.java
dhis-2/dhis-support/dhis-support-external/src/main/java/org/hisp/dhis/external/configuration/
dhis-2/dhis-support/dhis-support-external/src/main/java/org/hisp/dhis/external/configuration/DefaultConfigurationManager.java
modified:
dhis-2/dhis-services/dhis-service-importexport/src/main/java/org/hisp/dhis/importexport/IbatisConfigurationManager.java
dhis-2/dhis-services/dhis-service-importexport/src/main/java/org/hisp/dhis/importexport/dhis14/file/configuration/DefaultIbatisConfigurationManager.java
dhis-2/dhis-services/dhis-service-importexport/src/main/resources/META-INF/dhis/beans.xml
dhis-2/dhis-support/dhis-support-external/pom.xml
dhis-2/dhis-support/dhis-support-external/src/main/resources/META-INF/dhis/beans.xml
dhis-2/dhis-web/dhis-web-commons/pom.xml
dhis-2/dhis-web/dhis-web-importexport/src/main/java/org/hisp/dhis/importexport/action/dhis14/GetDhis14ConfigurationAction.java
dhis-2/dhis-web/dhis-web-importexport/src/main/java/org/hisp/dhis/importexport/action/dhis14/SetDhis14ConfigurationAction.java
dhis-2/dhis-web/dhis-web-importexport/src/main/java/org/hisp/dhis/importexport/action/imp/GetImportOptionsAction.java
dhis-2/dhis-web/dhis-web-importexport/src/main/java/org/hisp/dhis/importexport/action/imp/ImportAction.java
dhis-2/dhis-web/dhis-web-importexport/src/main/java/org/hisp/dhis/importexport/action/imp/SetImportTypeAction.java
dhis-2/dhis-web/dhis-web-importexport/src/main/java/org/hisp/dhis/importexport/action/object/DiscardObjectAction.java
dhis-2/dhis-web/dhis-web-importexport/src/main/java/org/hisp/dhis/importexport/action/object/MatchObjectAction.java
dhis-2/dhis-web/dhis-web-importexport/src/main/resources/META-INF/dhis/beans.xml
dhis-2/pom.xml
--
lp:dhis2
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk
Your team DHIS 2 developers is subscribed to branch lp:dhis2.
To unsubscribe from this branch go to
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription
=== removed file 'dhis-2/dhis-services/dhis-service-importexport/src/main/java/org/hisp/dhis/importexport/IbatisConfiguration.java'
--- dhis-2/dhis-services/dhis-service-importexport/src/main/java/org/hisp/dhis/importexport/IbatisConfiguration.java 2014-03-18 08:10:10 +
+++ dhis-2/dhis-services/dhis-service-importexport/src/main/java/org/hisp/dhis/importexport/IbatisConfiguration.java 1970-01-01 00:00:00 +
@@ -1,194 +0,0 @@
-package org.hisp.dhis.importexport;
-
-/*
- * Copyright (c) 2004-2014, University of Oslo
- * All rights reserved.
- *
- * Redistribution and use in source and binary forms, with or without
- * modification, are permitted provided that the following conditions are met:
- * Redistributions of source code must retain the above copyright notice, this
- * list of conditions and the following disclaimer.
- *
- * Redistributions in binary form must reproduce the above copyright notice,
- * this list of conditions and the following disclaimer in the documentation
- * and/or other materials provided with the distribution.
- * Neither the name of the HISP project nor the names of its contributors may
- * be used to endorse or promote products derived from this software without
- * specific prior written permission.
- *
- * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND
- * ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED
- * WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
- * DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR
- * ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES
- * (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
- * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON
- * ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
- * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS
- * SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
- */
-
-import java.io.Serializable;
-
-/**
- * @author Lars Helge Overland
- * @version $Id: IbatisConfiguration.java 6028 2008-10-24 13:44:34Z larshelg $
- */
-public class IbatisConfiguration
-implements Serializable
-{
-/**
- * Determines if a de-serialized file is compatible with this class.
- */
-private static final long serialVersionUID = -2191931273375896356L;
-
-private String dataFile;
-
-private String userName;
-
-private String password;
-
-private String levels;
-
-//
Re: [Dhis2-devs] Bug when using ==NULL (is null ) in aggregate query builder
Hi all, This one *[DE:1.2.3] != null *doesn't work . Aggregate functionality works with formula *[DE:1.2.3] is not null*. Best regard, Tran On Sat, Oct 11, 2014 at 5:06 PM, Rodolfo Melia wrote: > Adding Juan and Jose, who has dealt with similar situations. > >> >> >> On Fri, Oct 10, 2014 at 7:10 PM, Prosper BT wrote: >> >>> Using 2.16 demo server, build not specified, there is an error when >>> dealing with data elements and trying to aggregate when data elements are >>> null. >>> >>> ([DE:2005727.*.2005735] is null ) >>> >>> Can you check it works for !=NULL >>> >>> Regards >>> -- >>> Prosper Behumbiize, MPH >>> Phone:+256 414 320076 >>> Cell: +256 772 139037 >>> +256 752 751776 >>> >>> >> >> > ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 17059: Exlucded xercesImpl from spring security openid
revno: 17059
committer: Lars Helge Overland
branch nick: dhis2
timestamp: Sat 2014-10-11 13:29:14 +0200
message:
Exlucded xercesImpl from spring security openid
modified:
dhis-2/pom.xml
--
lp:dhis2
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk
Your team DHIS 2 developers is subscribed to branch lp:dhis2.
To unsubscribe from this branch go to
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription
=== modified file 'dhis-2/pom.xml'
--- dhis-2/pom.xml 2014-10-11 11:23:15 +
+++ dhis-2/pom.xml 2014-10-11 11:29:14 +
@@ -480,6 +480,12 @@
org.springframework.security
spring-security-openid
${spring.security.version}
+
+
+xerces
+xercesImpl
+
+
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
[Dhis2-devs] [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 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@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] [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: boun...@canonical.com [mailto:boun...@canonical.com] On Behalf Of Thu Tran Sent: Saturday, October 11, 2014 12:35 PM To: simon.nd...@ehmis.org 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
Re: [Dhis2-devs] Bug when using ==NULL (is null ) in aggregate query builder
Thanks Tran the one that doesnt work is *[DE:1.2.3] is null* On Sat, Oct 11, 2014 at 2:29 PM, Tran Chau (HISP Vietnam) < tran.hispviet...@gmail.com> wrote: > Hi all, > > This one *[DE:1.2.3] != null *doesn't work . > Aggregate functionality works with formula *[DE:1.2.3] is not null*. > > Best regard, > > Tran > > On Sat, Oct 11, 2014 at 5:06 PM, Rodolfo Melia > wrote: > >> Adding Juan and Jose, who has dealt with similar situations. >> >>> >>> >>> On Fri, Oct 10, 2014 at 7:10 PM, Prosper BT wrote: >>> Using 2.16 demo server, build not specified, there is an error when dealing with data elements and trying to aggregate when data elements are null. ([DE:2005727.*.2005735] is null ) Can you check it works for !=NULL Regards -- Prosper Behumbiize, MPH Phone:+256 414 320076 Cell: +256 772 139037 +256 752 751776 >>> >>> >> > -- Prosper Behumbiize, MPH Phone:+256 414 320076 Cell: +256 772 139037 +256 752 751776 ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] Bug when using ==NULL (is null ) in aggregate query builder
Hi Prosper, *[DE:1.2.3] is null *works fine. On Sat, Oct 11, 2014 at 8:24 PM, Prosper BT wrote: > Thanks Tran > > the one that doesnt work is *[DE:1.2.3] is null* > > On Sat, Oct 11, 2014 at 2:29 PM, Tran Chau (HISP Vietnam) < > tran.hispviet...@gmail.com> wrote: > >> Hi all, >> >> This one *[DE:1.2.3] != null *doesn't work . >> Aggregate functionality works with formula *[DE:1.2.3] is not null*. >> >> Best regard, >> >> Tran >> >> On Sat, Oct 11, 2014 at 5:06 PM, Rodolfo Melia >> wrote: >> >>> Adding Juan and Jose, who has dealt with similar situations. >>> On Fri, Oct 10, 2014 at 7:10 PM, Prosper BT wrote: > Using 2.16 demo server, build not specified, there is an error when > dealing with data elements and trying to aggregate when data elements are > null. > > ([DE:2005727.*.2005735] is null ) > > Can you check it works for !=NULL > > Regards > -- > Prosper Behumbiize, MPH > Phone:+256 414 320076 > Cell: +256 772 139037 > +256 752 751776 > > >>> >> > > > -- > Prosper Behumbiize, MPH > Phone:+256 414 320076 > Cell: +256 772 139037 > +256 752 751776 > > ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] Bug when using ==NULL (is null ) in aggregate query builder
Thanks for the snapshot, Prosper. I saw the bug now. I am working on it. Will inform you when I finish. On Sat, Oct 11, 2014 at 8:59 PM, Prosper BT wrote: > Hi Tran, > > Am running it both on the demo and dev servers, on testing the expressions > it fails see snap shot below and attached pdf > > [image: Inline image 1] > > On Sat, Oct 11, 2014 at 4:48 PM, Tran Chau (HISP Vietnam) < > tran.hispviet...@gmail.com> wrote: > >> Hi Prosper, >> >> *[DE:1.2.3] is null *works fine. >> >> On Sat, Oct 11, 2014 at 8:24 PM, Prosper BT wrote: >> >>> Thanks Tran >>> >>> the one that doesnt work is *[DE:1.2.3] is null* >>> >>> On Sat, Oct 11, 2014 at 2:29 PM, Tran Chau (HISP Vietnam) < >>> tran.hispviet...@gmail.com> wrote: >>> Hi all, This one *[DE:1.2.3] != null *doesn't work . Aggregate functionality works with formula *[DE:1.2.3] is not null*. Best regard, Tran On Sat, Oct 11, 2014 at 5:06 PM, Rodolfo Melia wrote: > Adding Juan and Jose, who has dealt with similar situations. > >> >> >> On Fri, Oct 10, 2014 at 7:10 PM, Prosper BT >> wrote: >> >>> Using 2.16 demo server, build not specified, there is an error when >>> dealing with data elements and trying to aggregate when data elements >>> are >>> null. >>> >>> ([DE:2005727.*.2005735] is null ) >>> >>> Can you check it works for !=NULL >>> >>> Regards >>> -- >>> Prosper Behumbiize, MPH >>> Phone:+256 414 320076 >>> Cell: +256 772 139037 >>> +256 752 751776 >>> >>> >> >> > >>> >>> >>> -- >>> Prosper Behumbiize, MPH >>> Phone:+256 414 320076 >>> Cell: +256 772 139037 >>> +256 752 751776 >>> >>> >> >> > > > -- > Prosper Behumbiize, MPH > Phone:+256 414 320076 > Cell: +256 772 139037 > +256 752 751776 > > ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 17060: Fixed bug - Exception thrown when to run aggregate query builder with programstage as *.
revno: 17060
committer: Tran Chau
branch nick: dhis2
timestamp: Sat 2014-10-11 21:27:16 +0700
message:
Fixed bug - Exception thrown when to run aggregate query builder with
programstage as *.
modified:
dhis-2/dhis-services/dhis-service-eventreporting/src/main/java/org/hisp/dhis/caseaggregation/hibernate/HibernateCaseAggregationConditionStore.java
dhis-2/dhis-services/dhis-service-tracker/src/main/java/org/hisp/dhis/program/hibernate/HibernateProgramStageInstanceStore.java
--
lp:dhis2
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk
Your team DHIS 2 developers is subscribed to branch lp:dhis2.
To unsubscribe from this branch go to
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription
=== modified file 'dhis-2/dhis-services/dhis-service-eventreporting/src/main/java/org/hisp/dhis/caseaggregation/hibernate/HibernateCaseAggregationConditionStore.java'
--- dhis-2/dhis-services/dhis-service-eventreporting/src/main/java/org/hisp/dhis/caseaggregation/hibernate/HibernateCaseAggregationConditionStore.java 2014-10-04 15:48:07 +
+++ dhis-2/dhis-services/dhis-service-eventreporting/src/main/java/org/hisp/dhis/caseaggregation/hibernate/HibernateCaseAggregationConditionStore.java 2014-10-11 14:27:16 +
@@ -1000,8 +1000,13 @@
private String getConditionForProgramStage( String programStageId, Collection orgunitIds )
{
String sql = " EXISTS ( SELECT _psi.programstageinstanceid FROM programstageinstance _psi "
-+ "WHERE _psi.programstageinstanceid=psi.programstageinstanceid " + "AND _psi.programstageid="
-+ programStageId + " AND _psi.executiondate >= '" + PARAM_PERIOD_START_DATE
++ "WHERE _psi.programstageinstanceid=psi.programstageinstanceid ";
+if ( !programStageId.equals( IN_CONDITION_GET_ALL ) )
+{
+sql += "AND _psi.programstageid=" + programStageId;
+}
+
+sql+= " AND _psi.executiondate >= '" + PARAM_PERIOD_START_DATE
+ "' AND _psi.executiondate <= '" + PARAM_PERIOD_END_DATE + "' AND _psi.organisationunitid in ("
+ TextUtils.getCommaDelimitedString( orgunitIds ) + ") ";
=== modified file 'dhis-2/dhis-services/dhis-service-tracker/src/main/java/org/hisp/dhis/program/hibernate/HibernateProgramStageInstanceStore.java'
--- dhis-2/dhis-services/dhis-service-tracker/src/main/java/org/hisp/dhis/program/hibernate/HibernateProgramStageInstanceStore.java 2014-10-07 15:18:38 +
+++ dhis-2/dhis-services/dhis-service-tracker/src/main/java/org/hisp/dhis/program/hibernate/HibernateProgramStageInstanceStore.java 2014-10-11 14:27:16 +
@@ -168,7 +168,6 @@
message = message.replace( TrackedEntityInstanceReminder.TEMPLATE_MESSSAGE_ORGUNIT_NAME, organisationunitName );
message = message.replace( TrackedEntityInstanceReminder.TEMPLATE_MESSSAGE_DAYS_SINCE_DUE_DATE, daysSinceDueDate );
-
SchedulingProgramObject schedulingProgramObject = new SchedulingProgramObject();
schedulingProgramObject.setProgramStageInstanceId( programstageinstanceid );
schedulingProgramObject.setPhoneNumber( rs.getString( "phonenumber" ) );
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
Re: [Dhis2-devs] Bug when using ==NULL (is null ) in aggregate query builder
Hi Prosper, It is fixed on trunk with revision 17060 and 2.16 version with revision 16512. Please update your code and take a look at it. Thank you. Best regards, Tran On Sat, Oct 11, 2014 at 9:12 PM, Tran Chau (HISP Vietnam) < tran.hispviet...@gmail.com> wrote: > Thanks for the snapshot, Prosper. > > I saw the bug now. I am working on it. Will inform you when I finish. > > On Sat, Oct 11, 2014 at 8:59 PM, Prosper BT wrote: > >> Hi Tran, >> >> Am running it both on the demo and dev servers, on testing the >> expressions it fails see snap shot below and attached pdf >> >> [image: Inline image 1] >> >> On Sat, Oct 11, 2014 at 4:48 PM, Tran Chau (HISP Vietnam) < >> tran.hispviet...@gmail.com> wrote: >> >>> Hi Prosper, >>> >>> *[DE:1.2.3] is null *works fine. >>> >>> On Sat, Oct 11, 2014 at 8:24 PM, Prosper BT wrote: >>> Thanks Tran the one that doesnt work is *[DE:1.2.3] is null* On Sat, Oct 11, 2014 at 2:29 PM, Tran Chau (HISP Vietnam) < tran.hispviet...@gmail.com> wrote: > Hi all, > > This one *[DE:1.2.3] != null *doesn't work . > Aggregate functionality works with formula *[DE:1.2.3] is not null*. > > Best regard, > > Tran > > On Sat, Oct 11, 2014 at 5:06 PM, Rodolfo Melia > wrote: > >> Adding Juan and Jose, who has dealt with similar situations. >> >>> >>> >>> On Fri, Oct 10, 2014 at 7:10 PM, Prosper BT >>> wrote: >>> Using 2.16 demo server, build not specified, there is an error when dealing with data elements and trying to aggregate when data elements are null. ([DE:2005727.*.2005735] is null ) Can you check it works for !=NULL Regards -- Prosper Behumbiize, MPH Phone:+256 414 320076 Cell: +256 772 139037 +256 752 751776 >>> >>> >> > -- Prosper Behumbiize, MPH Phone:+256 414 320076 Cell: +256 772 139037 +256 752 751776 >>> >>> >> >> >> -- >> Prosper Behumbiize, MPH >> Phone:+256 414 320076 >> Cell: +256 772 139037 >> +256 752 751776 >> >> > > ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 17061: Data entry, improved performance indicator calculation
revno: 17061
committer: Lars Helge Overland
branch nick: dhis2
timestamp: Sat 2014-10-11 21:29:38 +0200
message:
Data entry, improved performance indicator calculation
modified:
dhis-2/dhis-web/dhis-web-dataentry/src/main/webapp/dhis-web-dataentry/javascript/entry.js
dhis-2/dhis-web/dhis-web-dataentry/src/main/webapp/dhis-web-dataentry/javascript/form.js
--
lp:dhis2
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk
Your team DHIS 2 developers is subscribed to branch lp:dhis2.
To unsubscribe from this branch go to
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription
=== modified file 'dhis-2/dhis-web/dhis-web-dataentry/src/main/webapp/dhis-web-dataentry/javascript/entry.js'
--- dhis-2/dhis-web/dhis-web-dataentry/src/main/webapp/dhis-web-dataentry/javascript/entry.js 2014-10-10 20:13:34 +
+++ dhis-2/dhis-web/dhis-web-dataentry/src/main/webapp/dhis-web-dataentry/javascript/entry.js 2014-10-11 19:29:38 +
@@ -77,13 +77,12 @@
dhis2.de.getDataElementTotalValue = function( de )
{
var sum = new Number();
-
- $( 'input[name="entryfield"]' ).each( function( index )
- {
- var key = $( this ).attr( 'id' );
- var entryFieldId = key.substring( 0, key.indexOf( '-' ) );
-
- if ( de && de == entryFieldId && $( this ).attr( 'value' ) )
+
+ $( '[id^="' + de + '"]' ).each( function( index )
+ {
+ var val = $( this ).attr( 'value' );
+
+ if ( val && dhis2.validation.isNumber( val ) )
{
sum += new Number( $( this ).attr( 'value' ) );
}
=== modified file 'dhis-2/dhis-web/dhis-web-dataentry/src/main/webapp/dhis-web-dataentry/javascript/form.js'
--- dhis-2/dhis-web/dhis-web-dataentry/src/main/webapp/dhis-web-dataentry/javascript/form.js 2014-10-07 03:59:22 +
+++ dhis-2/dhis-web/dhis-web-dataentry/src/main/webapp/dhis-web-dataentry/javascript/form.js 2014-10-11 19:29:38 +
@@ -597,7 +597,8 @@
loadDataValues();
dhis2.de.insertOptionSets();
} );
- } else {
+ }
+ else {
dhis2.de.storageManager.formExistsRemotely( dataSetId ).done( function( value ) {
console.log( 'Loading form remotely: ' + dataSetId );
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 17062: Formula editor min width
revno: 17062 committer: Lars Helge Overland branch nick: dhis2 timestamp: Sat 2014-10-11 21:56:07 +0200 message: Formula editor min width modified: dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-datadictionary/src/main/webapp/dhis-web-maintenance-datadictionary/indicatorExpressionBuilderForm.vm dhis-2/dhis-web/dhis-web-validationrule/src/main/webapp/dhis-web-validationrule/expressionBuilderForm.vm -- lp:dhis2 https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk Your team DHIS 2 developers is subscribed to branch lp:dhis2. To unsubscribe from this branch go to https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription === modified file 'dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-datadictionary/src/main/webapp/dhis-web-maintenance-datadictionary/indicatorExpressionBuilderForm.vm' --- dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-datadictionary/src/main/webapp/dhis-web-maintenance-datadictionary/indicatorExpressionBuilderForm.vm 2014-10-10 14:03:26 + +++ dhis-2/dhis-web/dhis-web-maintenance/dhis-web-maintenance-datadictionary/src/main/webapp/dhis-web-maintenance-datadictionary/indicatorExpressionBuilderForm.vm 2014-10-11 19:56:07 + @@ -58,7 +58,7 @@ - + === modified file 'dhis-2/dhis-web/dhis-web-validationrule/src/main/webapp/dhis-web-validationrule/expressionBuilderForm.vm' --- dhis-2/dhis-web/dhis-web-validationrule/src/main/webapp/dhis-web-validationrule/expressionBuilderForm.vm 2014-10-10 14:03:26 + +++ dhis-2/dhis-web/dhis-web-validationrule/src/main/webapp/dhis-web-validationrule/expressionBuilderForm.vm 2014-10-11 19:56:07 + @@ -48,7 +48,7 @@ - + ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
[Dhis2-devs] [Branch ~dhis2-devs-core/dhis2/trunk] Rev 17063: Fixed bug - Exception thrown when to run Schedule automated aggregation function.
revno: 17063
committer: Tran Chau
branch nick: dhis2
timestamp: Sun 2014-10-12 10:59:00 +0700
message:
Fixed bug - Exception thrown when to run Schedule automated aggregation
function.
modified:
dhis-2/dhis-services/dhis-service-eventreporting/src/main/java/org/hisp/dhis/caseaggregation/hibernate/HibernateCaseAggregationConditionStore.java
--
lp:dhis2
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk
Your team DHIS 2 developers is subscribed to branch lp:dhis2.
To unsubscribe from this branch go to
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription
=== modified file 'dhis-2/dhis-services/dhis-service-eventreporting/src/main/java/org/hisp/dhis/caseaggregation/hibernate/HibernateCaseAggregationConditionStore.java'
--- dhis-2/dhis-services/dhis-service-eventreporting/src/main/java/org/hisp/dhis/caseaggregation/hibernate/HibernateCaseAggregationConditionStore.java 2014-10-11 14:27:16 +
+++ dhis-2/dhis-services/dhis-service-eventreporting/src/main/java/org/hisp/dhis/caseaggregation/hibernate/HibernateCaseAggregationConditionStore.java 2014-10-12 03:59:00 +
@@ -49,6 +49,7 @@
import java.sql.ResultSet;
import java.sql.SQLException;
+import java.util.ArrayList;
import java.util.Calendar;
import java.util.Collection;
import java.util.Date;
@@ -326,35 +327,12 @@
{
try
{
-int periodId = 0;
-
-final String selectSql = "select periodid from period where periodtypeid = ( select periodtypeid from periodtype where name='"
-+ period.getPeriodType().getName()
-+ "' )"
-+ " and startdate='"
-+ DateUtils.getMediumDateString( period.getStartDate() )
-+ "' and enddate='"
-+ DateUtils.getMediumDateString( period.getEndDate() ) + "'";
-
-periodId = jdbcTemplate.queryForObject( selectSql, Integer.class );
-
-if ( periodId == 0 )
-{
-final String insertSql = "insert into period (periodid, periodtypeid,startdate,enddate) " + " VALUES " + "("
-+ statementBuilder.getAutoIncrementValue() + ","+ period.getPeriodType().getId() + ",'" + DateUtils.getMediumDateString( period.getStartDate() )
-+ "','" + DateUtils.getMediumDateString( period.getEndDate() ) + "' )";
-
- jdbcTemplate.update( insertSql );
-}
-else
-{
-final String deleteDataValueSql = "delete from datavalue where dataelementid=" + dataElementId
-+ " and categoryoptioncomboid=" + optionComboId + " and sourceid in ("
-+ TextUtils.getCommaDelimitedString( orgunitIds ) + ") "
-+ "and periodid = " + periodId;
- jdbcTemplate.update( deleteDataValueSql );
-}
-
+period = periodService.reloadPeriod( period );
+final String deleteDataValueSql = "delete from datavalue where dataelementid=" + dataElementId
++ " and categoryoptioncomboid=" + optionComboId + " and sourceid in ("
++ TextUtils.getCommaDelimitedString( orgunitIds ) + ") " + "and periodid = " + period.getId();
+jdbcTemplate.update( deleteDataValueSql );
+
jdbcTemplate.update( sql );
}
@@ -1356,41 +1334,9 @@
Date endDate = calEndDate.getTime();
CalendarPeriodType periodType = (CalendarPeriodType) PeriodType.getPeriodTypeByName( periodTypeName );
-String sql = "select periodtypeid from periodtype where name='" + periodTypeName + "'";
-int periodTypeId = jdbcTemplate.queryForObject( sql, Integer.class );
-
-Collection periods = periodType.generatePeriods( startDate, endDate );
-
-for ( Period period : periods )
-{
-String start = DateUtils.getMediumDateString( period.getStartDate() );
-String end = DateUtils.getMediumDateString( period.getEndDate() );
-
-sql = "select periodid from period where periodtypeid=" + periodTypeId + " and startdate='" + start
-+ "' and enddate='" + end + "'";
-Integer periodid = null;
-SqlRowSet rs = jdbcTemplate.queryForRowSet( sql );
-if ( rs.next() )
-{
-periodid = rs.getInt( "periodid" );
-}
-
-if ( periodid == null )
-{
-String insertSql = "insert into period (periodid, periodtypeid,startdate,enddate) " + " VALUES " + "("
-+ statementBuilder.getAutoIncrementValue() + "," + periodTypeId + ",'" + start + "','" + end
-+ "' )";
-
-jdbcTemplate.execute( insertSql );
-
-period.setId( jdbcTemplate.queryForObject( sql, Integer.class ) );
-
Re: [Dhis2-devs] [Bug 1378893] Re: Prune period and automated aggregation of tracker data fails in 2.16
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 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: boun...@canonical.com [mailto:boun...@canonical.com] On Behalf Of > Thu Tran > Sent: Saturday, October 11, 2014 12:35 PM > To: simon.nd...@ehmis.org > 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.launchpa
