Re: [Dhis2-users] [Dhis2-devs] PostgreSQL-9.5 failed to boot-up at restart of Linux server

I already tried that and restart server but the issue is the same. On Jan 26, 2017 7:27 AM, "J. Paul Mutali" wrote: > Hi Gerald, > > you can use this command: sudo update-rc.d postgresql enable > > Hope it will work for you. > > --- > > JP Mutali > > Kigali - Rwanda > > On

Re: [Dhis2-users] [Dhis2-devs] PostgreSQL-9.5 failed to boot-up at restart of Linux server

Hi Gerald, you can use this command: sudo update-rc.d postgresql enable Hope it will work for you. --- JP Mutali Kigali - Rwanda On Thu, Jan 26, 2017 at 8:52 AM, gerald thomas wrote: > There were some issues with the migration so I had to purge the 9.3 and do > a

Re: [Dhis2-users] PostgreSQL-9.5 failed to boot-up at restart of Linux server

There were some issues with the migration so I had to purge the 9.3 and do a fresh installation of 9.5 and restore my backup. But if the server reboot I will have to manually do: pg_ctlcluster 9.5 main start On Jan 26, 2017 5:59 AM, "Uwe Wahser" wrote: Hi Gerald, we did the

Re: [Dhis2-users] PostgreSQL-9.5 failed to boot-up at restart of Linux server

Hi Gerald, we did the upgrade while upgrading to Ubuntu 16.04 and everything starts normally. But you have to manually migrate your 9.3 databases into the 9.5 format - did you do that? These were the bash commands I recorded back then (at your own risk, no guarantee - do backups and all that

Re: [Dhis2-users] Delete tracker data

Hi Karina I thank it is not a good idea... you can use API option... Best Dr Allade On Jan 26, 2017 05:19, Karina Dian Lestari wrote: Hi all, What is the best way to delete all tracker data? I have around 50 data on my tracker and I want to delete them all. Maybe

[Dhis2-users] Delete tracker data

Hi all, What is the best way to delete all tracker data? I have around 50 data on my tracker and I want to delete them all. Maybe deleting through PostgreSQL is a good idea? but I don't know the steps. I am using PostgreSQL 9.4. Thank you in advance. -- Karin.

[Dhis2-users] PostgreSQL-9.5 failed to boot-up at restart of Linux server

Dear All, We are upgrading DHIS2 server database (PostgreSQL from 9.3.15 to 9.5.5) and it had been successfully done but the Postgres does not automatically start after boot-up. I am using: (pg_ctlcluster 9.5 main start) to start my database but i want it start automatically. Please can someone

Re: [Dhis2-users] Need Assistance

Okay. Is there any chance you can get that instance and database upgraded to a later version of DHIS 2? Perhaps someone can assist you? regards, Lars On Wed, Jan 25, 2017 at 12:33 PM, Stephen Gbanyan wrote: > Hi Lars, > > I am using 2.19-SNAPSHOT. This was use during the

Re: [Dhis2-users] Need Assistance

Hi Lars, I am using 2.19-SNAPSHOT. This was use during the ebola crisis and now I want to get the data out. Thanks Stephen On Wed, Jan 25, 2017 at 11:00 AM, Lars Helge Øverland wrote: > Hi Stephen, > > this issue has been fixed since DHIS 2.22. Which version are you running?

Re: [Dhis2-users] Modify Report Table via Web API?

This is as far as I can tell, also an issue on the current version running, on play. Is this expected behavior or a bug with in the API? Best, Trøyel From: Dhis2-users [mailto:dhis2-users-bounces+troyel.nerbo=nrc...@lists.launchpad.net] On Behalf Of Morten Olav Hansen Sent: onsdag 25. januar

Re: [Dhis2-users] Need Assistance

Hi Stephen, this issue has been fixed since DHIS 2.22. Which version are you running? Are you able to upgrade? best, Lars On Wed, Jan 25, 2017 at 11:57 AM, Stephen Gbanyan wrote: > Hi All, > > I tried running Analytics table and got this error message. Kindly help. > >

Re: [Dhis2-users] Modify Report Table via Web API?

Try this: select * from reporttable rt inner join relativeperiods rp using (relativeperiodsid); ​ On Wed, Jan 25, 2017 at 11:15 AM, Morina Matasi wrote: > > did you try using a PUT through the Web API, or trough SQL directly in the >> database? >> >> > Which

Re: [Dhis2-users] Modify Report Table via Web API?

Hi Morina In your database, there is a table called "reporttable", this has a column named "relativeperiodsid", use this identifier to update the table "relativeperiods" (there you can set true/false etc as you like) -- Morten Olav Hansen Senior Engineer, DHIS 2 University of Oslo

Re: [Dhis2-users] Modify Report Table via Web API?

> did you try using a PUT through the Web API, or trough SQL directly in the > database? > > Which database table contains these definitions? SQL will be a faster option. > regards, > > Lars > > > On Wed, Jan 25, 2017 at 10:33 AM, Morina Matasi > wrote: > >> Is it

Re: [Dhis2-users] Modify Report Table via Web API?

Hi Morina, did you try using a PUT through the Web API, or trough SQL directly in the database? regards, Lars On Wed, Jan 25, 2017 at 10:33 AM, Morina Matasi wrote: > Is it possible to modify a report table through the Web API? I have had > issues with a report

[Dhis2-users] Modify Report Table via Web API?

Is it possible to modify a report table through the Web API? I have had issues with a report table that has changed values in Relative periods for some reason. See the copy of the Relative periods below in XML format. You will see that all values are false but we know that when creating this