Re: [Dhis2-users] Can't Login after restoring sample database

2015-09-15 Thread Mugeni Harold
Gerald, Please find attached the screenshot upon trying to login. For some reason, I can't find any log files for the dhis application. I am using win7 and the WAR file under tomcat. -Original Message- From: gerald thomas [mailto:gerald17...@gmail.com] Sent: Tuesday, September 15,

Re: [Dhis2-users] Can't Login after restoring sample database

2015-09-15 Thread gerald thomas
Mugeni, I didn't want to jump into conclusion so soon but i think the database backup you have maybe having some issues. Do you have any other database or can you download it again and try it. This time you are only: * stop tomcat * go to pgadmin and delete database (eg dhis): I am assuming you

Re: [Dhis2-users] Can't Login after restoring sample database

2015-09-15 Thread gerald thomas
Mugeni, This seem strange but if you are using win7 then you should find logs in C:\Program Files\apache tomcat\log (if it is 64bit you are using) or C:\Program Files(x86)\apache tomcat\log (if it is 32bit you are using). Workaround: * Shutdown tomcat * delete the database * create a new

Re: [Dhis2-users] Can't Login after restoring sample database

2015-09-15 Thread Morten Olav Hansen
Hi I think you should upgrade to a more recent version of DHIS 2. What version are you using? I would recommend that you re-download DHIS 2 and maybe also the database (if you haven't downloaded it recently) Latest 2.20 release: https://www.dhis2.org/download/releases/2.20/dhis.war Latest demo

Re: [Dhis2-users] Can't Login after restoring sample database

2015-09-15 Thread Mugeni Harold
Gerald, Please find attached the tomcat8 log file, sorry I was looking for a dhis log file, which only exists for dhis-live. Meanwhile I am going through the outlined steps. -Original Message- From: gerald thomas [mailto:gerald17...@gmail.com] Sent: Tuesday, September 15, 2015 10:53

Re: [Dhis2-users] Can't Login after restoring sample database

2015-09-15 Thread Mugeni Harold
Gerald, I have followed the steps in the workaround, but still get the same exception. Cheers -Original Message- From: gerald thomas [mailto:gerald17...@gmail.com] Sent: Tuesday, September 15, 2015 10:53 AM To: Mugeni Harold Cc: dhis2-users@lists.launchpad.net Subject: Re:

[Dhis2-users] Data Collection App or Tool

2015-09-15 Thread gerald thomas
Dear All, In Sierra Leone, every district (13) has a DHMT who received aggregated data report from the facilities (PHUs). During my assessment i found a very big gap between data collection and data entry which i am sure is affecting the quality of data in Sierra Leone. Firstly, Stock out of Data

Re: [Dhis2-users] Can't Login after restoring sample database

2015-09-15 Thread Morten Olav Hansen
Are you sure? because its complaining about something we removed a long time ago (ou.active) -- Morten On Tue, Sep 15, 2015 at 5:23 PM, Mugeni Harold wrote: > Hi Morten, > > > > I am already using the latest of both the dhis2 and the sample database. > > > > *From:* Morten

Re: [Dhis2-users] Can't Login after restoring sample database

2015-09-15 Thread Knut Staring
You can verify your version by going to About DHIS2 On Tue, Sep 15, 2015 at 12:28 PM, Jason Pickering < jason.p.picker...@gmail.com> wrote: > Hi there. The problem is here > > * ERROR 2015-09-15 09:11:38,423 ERROR: column organisati1_.active does not > exist > Position: 608

Re: [Dhis2-users] Can't Login after restoring sample database

2015-09-15 Thread Mugeni Harold
Hi Morten, I am already using the latest of both the dhis2 and the sample database. From: Morten Olav Hansen [mailto:morte...@gmail.com] Sent: Tuesday, September 15, 2015 12:16 PM To: gerald thomas Cc: Mugeni Harold; dhis2-users Subject: Re: [Dhis2-users] Can't Login after restoring

Re: [Dhis2-users] Can't Login after restoring sample database

2015-09-15 Thread Jason Pickering
Hi there. The problem is here * ERROR 2015-09-15 09:11:38,423 ERROR: column organisati1_.active does not exist Position: 608 (SqlExceptionHelper.java [http-nio-8080-exec-2]) which looks like you are using an older version of DHIS2, where this column was present. So, you have a mismatch between

Re: [Dhis2-users] [Dhis2-devs] data set in the version 2.18

2015-09-15 Thread KOFFI Martial
Hello PapaYou had a solution in relation to your problem?because I meet the same problem Merci  Martial KOFFI Le Vendredi 10 juillet 2015 10h15, papa alioune Sokhna a écrit : How to associate a given organizational unit of 2.18. Since the update 2.18, when a

[Dhis2-users] A way to exclude current week

2015-09-15 Thread Raheel Ayaz
Dear all, In pivot table and data visualizer of DHIS2 when a table or a graph is generated for last four weeks then why current week is included in the table or graph. Is a way to exclude current week from the report to have the output data for last four weeks. Same query is applicable to

Re: [Dhis2-users] [Dhis2-devs] A way to exclude current week

2015-09-15 Thread Calle Hedberg
Raheel, The dev team is working on a more generic fix for this in 2.21 - it will be possible to specify an "anchor period/date" which will determine all the other relative reporting periods. Seems it will only be available in 2.21, not 2.20 or earlier. Regards Calle On 15 September 2015 at

[Dhis2-users] Pluriannual pivot table

2015-09-15 Thread Guy Ekani
Hello everyone, Please how can we build a pluriannual pivot table like the one below ? In DHIS 2.18 with a aggregated dataelement Sincerely, Dataelement | January | February    | March   |+++-+2015        |       1 |               2|  

Re: [Dhis2-users] Can't Login after restoring sample database

2015-09-15 Thread Mugeni Harold
Dear All, Thank you so much for the feedback and responses. It is true I was using dhis 2.16 application. I have upgraded to 2.20 and everything seems fine. From: Knut Staring [mailto:knu...@gmail.com] Sent: Tuesday, September 15, 2015 12:33 PM To: Jason Pickering Cc: Mugeni Harold;