Re: [Dhis2-users] DHIS version 2.15 released

2014-04-24 Thread Muhire Andrew
Bravo to the deve. and community. I am very happy for the data access right to org unit levels.very important..   "Better Information, better Decisions, better Health"  Muhire Andrew  Ministry of Health / HMIS ""A mind is a terrible thing to waste""

Re: [Dhis2-users] [Dhis2-devs] DHIS version 2.15 released

2014-04-24 Thread John Ojo
Awesome! Congratulations to the development team. John   John Ojo MD, FMCPH Monitoring & Evaluation Specialist West African Regional Disease Surveillance (WARDS) Project West Africa Health Organization (WAHO/ECOWAS) Bobo-Dioulasso, Burkina Faso. Mobile: +226 65897160 Skype:  Johnojo On Wednesd

Re: [Dhis2-users] runing Analytics errors.

2014-04-24 Thread Lars Helge Øverland
Hi, This is not a bug, dhis drops the resource tables and needs to know about views depending on them. You can simply create the views as dhis sql views in data admin and it will be handled properly. regards, Lars On Apr 24, 2014 5:26 PM, "Emmanuel Willer CHARLES" wrote: > Hi all, > > It is su

Re: [Dhis2-users] runing Analytics errors.

2014-04-24 Thread Emmanuel Willer CHARLES
Hi all, It is surely right. deleting the view we created has solved the problem. is that bug fixed on one of the newer versions, as we are using ver 2.13 Build revision:12917. thanks for your help guys. On Thu, Apr 24, 2014 at 8:30 AM, Emmanuel Willer CHARLES < emmanuelwil...@gmail.com> wrote

Re: [Dhis2-users] runing Analytics errors.

2014-04-24 Thread Dapo Adejumo
Hi, This is related to a bug with analytics and sql views that was initially fixed but seems to have crept in again. It will need to be fixed – A temporary workaround is to delete sql views from your database. Regards, Dapo Adejumo +2

Re: [Dhis2-users] runing Analytics errors.

2014-04-24 Thread Jason Pickering
Hi Emmanuel, It is not possible to have views linked directly to the resource tables, as they are dropped and regenerated each time when the analytics runs. Two options. 1) Encapsulate your view in a stored procedure. 2) Use the SQL view function of DHIS2. Both approaches have been discussed pre

[Dhis2-users] runing Analytics errors.

2014-04-24 Thread Emmanuel Willer CHARLES
Hi All, we are having error to run analytic reports, it lasts longer than usual. when we try to run a resource table, we have the following error message. Please Help. ERROR MESSAGE Link to error message: http://gyazo.com/d50d019cb8374ec38dcf020488c0167a Thank you for prompt answer. --