Re: [Dhis2-devs] Tracked Entity Instances Query - SQL syntax error

2016-08-23 Thread Pamod Amarakoon
Hi Morten, Just wondering whether this has been fixed. Thank you On Wed, Aug 17, 2016 at 7:24 PM, Pamod Amarakoon wrote: > Thank you Morten. > > On Wed, Aug 17, 2016 at 7:10 PM, Morten Olav Hansen > wrote: > >> Seems like a bug yes, I will look into it >>

[Dhis2-devs] Dataelement not loading in dataelement group

2016-08-23 Thread Guy Ekani
Hello Team, Please how many dataelements could we load in datalement group window?  because in our case we have about 3.000 and it's not loading in DHIS 2.23, but was previously loading well in Dhis 2.21 Please help = EKANI Guy 

Re: [Dhis2-devs] Problem generating resource tables

2016-08-23 Thread Wilfred Senyoni
Hi developers I have experienced the same issue while creating a fresh database with version 2.24 build revision: 23511. Just to add on the new dataset interface you can create a new dataset without a assigning a datasaet category combination while using the old interface you are forced to choose

Re: [Dhis2-devs] GIS App Does Not Load and Just Hangs

2016-08-23 Thread Lorill Crees
Hi Jan, I am just following up on the developer list thread with our offline discussions for everyone's benefit. I've pasted your response below. We will upgrade to 2.24 to fix this issue. Cheers, Lorill On Tue, Aug 23, 2016 at 1:00 AM, Jan Henrik Øverland wrote: > Hi Lorill,

Re: [Dhis2-devs] [Bug 1612375] [NEW] Program indicators: error in percentage calculations when using d2:condition (inconsistent results at different levels of aggregation)

2016-08-23 Thread Sam Johnson
Hi all, I reported a bug in the web program indicator calculations a couple of weeks ago, and included in the report everything that’s needed to quickly replicate the bug, but I don’t think anyone has had a chance to look at this report yet. Have I followed the correct process for reporting

Re: [Dhis2-devs] Application Security testing for DHIS 2

2016-08-23 Thread Greg Wilson
Aamer: As part of the DATIM work, BAO is performing IBM AppScan vulnerability assessment and confirmation. The results of these assessments will be passed onto the development team for remediation. Due to the sensitive nature of security vulnerabilities, we will follow standard, responsible best

Re: [Dhis2-devs] [Bug 1614956] Re: Dataset Import/Export does not affect custom entry form

2016-08-23 Thread Timothy Harding
Thanks Morten! The new build works as expected now :D tyvm Quick question, Because there is no Data Entry Form in the "Meta Data Detailed Exporter" might it be good to have the corresponding dataEntryForm export by default when exporting a dataset? This is the default export from that interface

Re: [Dhis2-devs] [Bug 1614543] Re: Dry run Alters Data 2.23

2016-08-23 Thread Timothy Harding
Thanks Morten. I will give the /23/ a shot for sure! As far as the cache preheat, that is a stumper. I turn it off for most of my imports because with DATIM it is the difference between a 300 second import and an 800 second import. Thanks for looking into this. *Timothy Harding* Sr. Systems

Re: [Dhis2-devs] [Dhis2-users] Error in DHIS2

2016-08-23 Thread Lars Helge Øverland
Hi Ravi, most likely this is caused by wrong database credentials. Please double check that your database name, username and password are correct. You can try to log into your database using psql from the command line to verify. psql -d dhis_db -U postgres regards, Lars On Tue, Aug 23, 2016

Re: [Dhis2-devs] [Dhis2-users] ANALYTICS ENGINE IN MAINTENANCE MODE, TRY AGAIN

2016-08-23 Thread Stanley Kalyati
Thank you Lars it has worked. Best -Original Message- From: "Lars Helge Øverland" Sent: ‎23/‎08/‎2016 12:54 To: "Stanley Kalyati" Cc: "DHIS Users" ; "DHIS 2 Developers list" Subject:

Re: [Dhis2-devs] [Dhis2-users] ANALYTICS ENGINE IN MAINTENANCE MODE, TRY AGAIN

2016-08-23 Thread Lars Helge Øverland
Hi Stanly, you can go to Apps > Settings > General and uncheck "Put anaylytics in maintenance mode" to disable this. regards, Lars On Tue, Aug 23, 2016 at 12:36 PM, Stanley Kalyati wrote: > Dear Colleagues, > > I am now confused please help.I run maintenance mode

[Dhis2-devs] ANALYTICS ENGINE IN MAINTENANCE MODE,TRY AGAIN

2016-08-23 Thread Stanley Kalyati
Dear Colleagues, I am now confused please help.I run maintenance mode yesterday and then cleared cache for both DHIS2 and web browser. Since then i cant see my pivot tables or graphs. Whenever i run the Visualiser am getting this error: "Code 503 ,Status Service unavailable" "Analytics engine

Re: [Dhis2-devs] [Dhis2-users] Error in DHIS2

2016-08-23 Thread Michael Mwebaze
Hi Ravi, do you have the environment variable DHIS2_HOME pointing to the directory containing either hibernate.properties or dhis.conf configuration files? Below is a link to a sample configuration file and you can just limit to the section 'Database connection for PostgreSQL'

Re: [Dhis2-devs] Application Security testing for DHIS 2

2016-08-23 Thread Aamer Mohammed
Hi dhis devs, We are looking for testing the application in areas which focus on "CIA triad" (Confidentiality, Integrity, Availability) of DHIS users and resources. Just wanted to check from DHIS devs if any kind of methodologies are already inplace for testing the code for below vulnerabilities.

Re: [Dhis2-devs] Upgrading to 2.24 and /api/24/metadata issue

2016-08-23 Thread Morten Olav Hansen
Maybe you should turn of PG logging the DDL statements.. maybe there is startdate failed because of xyz, could be useful in hunting down the issue.. -- Morten Olav Hansen Senior Engineer, DHIS 2 University of Oslo http://www.dhis2.org On Tue, Aug 23, 2016 at 3:55 PM, Vanya Seth

Re: [Dhis2-devs] Upgrading to 2.24 and /api/24/metadata issue

2016-08-23 Thread Vanya Seth
We can try that. Regards Vanya On Tue, Aug 23, 2016 at 2:34 PM, Morten Olav Hansen wrote: > Maybe you should turn of PG logging the DDL statements.. maybe there is > startdate failed because of xyz, could be useful in hunting down the issue.. > > -- > Morten Olav Hansen >

Re: [Dhis2-devs] Upgrading to 2.24 and /api/24/metadata issue

2016-08-23 Thread Vanya Seth
Well its very strange as this works fine in our local machines. On the VM's even tried dropping the db, creating new and then deploying the war. Still to no avail. Mostly this manual creation of columns should work. But what if there are other such things that might have been missed and will

[Dhis2-devs] Reporting rates in analytics - 0 vs not expected

2016-08-23 Thread Olav Poppe
Hi devs, I’m a bit confused about the way the completeness analytics API works - I suspect there might be a bug when looking at the facility level (i.e. the level where data is entered): - there is no difference between "not expected to report" and "not reported" - I would expect not reported

Re: [Dhis2-devs] Upgrading to 2.24 and /api/24/metadata issue

2016-08-23 Thread Morten Olav Hansen
That sounds strange Vanya, looked at the HBM files and there was nothing special about those fields. Could you try a manual add: alter table mapview add column startdate timestamp without time zone alter table mapview add column enddate timestamp without time zone and see if that fixes it (I

[Dhis2-devs] DHIS2 Live Database file - reg

2016-08-23 Thread Chandrasekar Ravi
Dear All, We are implemented DHIS2 tracker capture and data capture with DHIS2 Live. I need to open the database file (Dhis2 Live -> database -> dhis2.trace.db) . If i am using SQL lite to retrieve data it ask password to open. What password I need to give? Thanks & Regards *Chandrasekar Ravi*

Re: [Dhis2-devs] scheduling in DHIS

2016-08-23 Thread Vanya Seth
Hi Halvdan We will extend the functionality and send a patch. Regards Vanya On Mon, Aug 22, 2016 at 5:57 PM, Halvdan Hoem Grelland wrote: > Vanya, > > If you're talking about simply exposing > TaskExecutor.submitListenable(Runnable) > in the Scheduler interface, it's not a

[Dhis2-devs] Upgrading to 2.24 and /api/24/metadata issue

2016-08-23 Thread Vanya Seth
Hello devs We were updating our test VM's to 2.24 from 2.21. We did it in an incremental manner. Apparently on few of the VM's after upgrade the /api/24/metadata (GET) call is failing with the following error: WARN 2016-08-23 11:47:59,957 SQL Error: 0, SQLState: 42703 (SqlExceptionHelper.java

[Dhis2-devs] [Bug 1614543] Re: Dry run Alters Data 2.23

2016-08-23 Thread Morten Olav Hansen
This is strange.. but seems this is only true if preheatCache=false, if preheating is enabled.. it seems to work as intended.. I will try and fix it, but not sure what is causing this -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to