Re: [Dhis2-devs] Cannot Add Program rules

2015-07-30 Thread Harsh Atal
yes, this is a bug Emma, I ran into exactly this issue last week when trying to use program rules...had reported on the listit'll probably get fixed soon. regards harsh On 31 July 2015 at 11:43, Emma Kassy wrote: > Dear Developers, > > First of all great work on the program rules, I have se

[Dhis2-devs] Cannot Add Program rules

2015-07-30 Thread Emma Kassy
Dear Developers, First of all great work on the program rules, I have seen it work with a 2.20 snapshot although I do not remember the version. However after the release of stable 2.20, the program rules are not working. When you clcik Add New and go through the process of creating data sources an

[Dhis2-devs] Aggregate Query Builder

2015-07-30 Thread channara rin
Hi all DHIS2, Can we aggregate trackers' attributes/data elements in a whole year? thank you channara ___ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More he

Re: [Dhis2-devs] [Dhis2-users] FW: Problem with Tracker program after updating to 2.20 stable

2015-07-30 Thread Halvdan Grelland
Hmm, yeah something doesn't seem right here. Not really familiar with the detailed workings of the analytics table creation process, though (Lars would be the one to ask). What's the schema for the left over analytics_temp_2015? Also, can you make sure to (manually) delete the temp table and re-run

[Dhis2-devs] [Bug 1479858] [NEW] Relative periods (Reporting Month, month this year) in Standard Reports returns wrong periods

2015-07-30 Thread Alex Tumwesigye
Public bug reported: Relative periods (Reporting Month, month this year) in Standard Reports returns wrong periods. For example: When you edit a standard report, tick reporting month and save. When you run the report, it returns the chosen period minus one e.g July 2015 will return data of Ju

Re: [Dhis2-devs] [Dhis2-users] FW: Problem with Tracker program after updating to 2.20 stable

2015-07-30 Thread Elmarie Claasen
Hi Halvdan, No the analytics is still failing. Here is the log. I don’t quite understand what is wrong. What I can see in the database is because analytics is failing the table Analytics_2015_temp remains after the analytics fails. Regards, Elmarie Claasen Hisp logo Project Mana

Re: [Dhis2-devs] [Dhis2-users] FW: Problem with Tracker program after updating to 2.20 stable

2015-07-30 Thread Halvdan Grelland
Hi, Yes, the first issue seems to be fixed (and there is no indication of faults in the log as you say). Why it didn't run properly before I don't know. As for the analytics: yes, analytics tables (named analytics_2014, analytics_2015 etc) er generated tables. If they do not exist, you might expe

Re: [Dhis2-devs] [Dhis2-users] FW: Problem with Tracker program after updating to 2.20 stable

2015-07-30 Thread Abyot Gizaw
May be. I don't think you can alter a table while you have views or user defined functions referring to the table. On Thu, Jul 30, 2015 at 1:33 PM Elmarie Claasen wrote: > Thanks a lot Abyot, > > > > We ran this script after deleting 2 sql views which referenced this table > as it would not run

Re: [Dhis2-devs] [Dhis2-users] FW: Problem with Tracker program after updating to 2.20 stable

2015-07-30 Thread Elmarie Claasen
Hi Halvdan, I don’t see anything failing in the startup routine – here is the log of the first startup after the replaced the war file. Maybe the log should give an error if the tables was not successfully updated? Can you assist in how we fix the problem with the analytics table which st

Re: [Dhis2-devs] [Dhis2-users] FW: Problem with Tracker program after updating to 2.20 stable

2015-07-30 Thread Halvdan Grelland
In addition; please look at the startup log of dhis2 (specifically under InitTableAlterator) and see if there's any queries failing. 2015-07-30 12:59 GMT+02:00 Abyot Gizaw : > > > On Thu, Jul 30, 2015 at 11:30 AM Elmarie Claasen wrote: > >> Hi Devs, >> >> >> >> I have an urgent database issue wh

Re: [Dhis2-devs] [Dhis2-users] FW: Problem with Tracker program after updating to 2.20 stable

2015-07-30 Thread Elmarie Claasen
Thanks a lot Abyot, We ran this script after deleting 2 sql views which referenced this table as it would not run until we deleted the 2 sql views. A follow up question –could it be that this change did not execute because of the 2 sql views? We know that dhis2 drops sql views before runnin

[Dhis2-devs] [Bug 1474419] Re: metadata import into empty db in 2.19 dhis2 fails

2015-07-30 Thread Oreste Parlatano
I have the same problem in Mozambique. Import never finishes it gets ‘stuck’ during importing of meta-data sets. -- You received this bug notification because you are a member of DHIS 2 developers, which is subscribed to DHIS. https://bugs.launchpad.net/bugs/1474419 Title: metadata import into

Re: [Dhis2-devs] [Dhis2-users] FW: Problem with Tracker program after updating to 2.20 stable

2015-07-30 Thread Abyot Gizaw
On Thu, Jul 30, 2015 at 11:30 AM Elmarie Claasen wrote: > Hi Devs, > > > > I have an urgent database issue which I have to resolve as this project is > implementing by Monday and my database is not running on 2.20 stable which > I need for the tracker capture app to load. Can someone please assis

Re: [Dhis2-devs] Sections in Tracker Capture - hiding drop down list options

2015-07-30 Thread Markus Bekken
Ok, thanks - the editor was being developed during 2.19, perhaps it is a prerelease problem. Although most of the code was included in 2.19, it was not all finished till 2.20 - I think we need to backport some fixes and changes if we are going to have partial support in 2.19. Markus > 30. jul.

Re: [Dhis2-devs] Sections in Tracker Capture - hiding drop down list options

2015-07-30 Thread Prosper BT
Thanks Abyot and Markus, If it was fixed can it be back-ported to 2.19? Also Markus program rules dont work in 2.19, they disappear for editing after creating them. Regards On Thu, Jul 30, 2015 at 12:32 PM, Markus Bekken wrote: > Hi guys - I fixed this issue some time back, I think it was in

Re: [Dhis2-devs] Sections in Tracker Capture - hiding drop down list options

2015-07-30 Thread Markus Bekken
Hi guys - I fixed this issue some time back, I think it was in 2.20 - looking for the revision number now. Markus > 29. jul. 2015 kl. 21.47 skrev Prosper BT : > > Hi Team, > > When you use sections in stages and go to data entry and happen to have a > drop down list, the next section covers t

[Dhis2-devs] FW: Problem with Tracker program after updating to 2.20 stable

2015-07-30 Thread Elmarie Claasen
Hi Devs, I have an urgent database issue which I have to resolve as this project is implementing by Monday and my database is not running on 2.20 stable which I need for the tracker capture app to load. Can someone please assist. We have a database called ISHP which Erling has been helping

Re: [Dhis2-devs] Sections in Tracker Capture - hiding drop down list options

2015-07-30 Thread Abyot Gizaw
Hi Prosper, Thanks for reporting. Sure, will take a look and fix. Thank you, Abyot. On Wed, Jul 29, 2015 at 9:47 PM Prosper BT wrote: > Hi Team, > > When you use sections in stages and go to data entry and happen to have a > drop down list, the next section covers the list and you cant see all