dhis2-users team mailing list archive

[Walusiku Muyunda <jomuwalu@xxxxxxxxx>]

Win Server 2016

On Wed, Oct 3, 2018, 19:14 Bob Jolliffe <bobjolliffe@xxxxxxxxx> wrote:

> Upgrading from 2.28 to 2.29 should be smooth enough.  At least I haven't
> heard of issues.  There a few hazards with the next step as I indicated.
> What operating system platform are you on?
>
> On Wed, 3 Oct 2018 at 18:09, Walusiku Muyunda <jomuwalu@xxxxxxxxx> wrote:
>
>> Thank you Bob for the insight. Am currently trying to upgrade from 2.28
>> to 2.29(since its recommended to for the sequential releases) then later
>> when am sure the upgrade was successful, I'll upgrade to 2.30 and I'll keep
>> your comments in mind. Am using the dhis user to connect to the data and
>> its the same as in the config file.
>>
>> Watching the log file showed some error with a missing analytics table
>> repeated a number of times, could be be other errors I may have missed.
>>
>> On Wed, Oct 3, 2018, 19:02 Bob Jolliffe <bobjolliffe@xxxxxxxxx> wrote:
>>
>>> There is a little bit of trickery involved with the upgrade from 2.29 to
>>> 2.30.  It has been discussed earlier in this group I believe.  It is
>>> related to the loading of the postgis extension.
>>>
>>> So it is quite important to understand which user you connect the
>>> database to run the upgrade.sql script, which user owns the database and
>>> its contents and which user is being used in dhis.conf to connect to the
>>> database.   If you can let us know these I can alert you to some potential
>>> problems.
>>>
>>> Generally, look at the log file while the dhis2 is starting up and see
>>> if there are any issues flagged there.  It is not foolproof, but a good
>>> start.
>>>
>>> Cheers
>>> Bob
>>>
>>> On Wed, 3 Oct 2018 at 17:55, Walusiku Muyunda <jomuwalu@xxxxxxxxx>
>>> wrote:
>>>
>>>> Looks like the upgrade script run just fine, but is there a way to
>>>> verify that everything upgraded correctly besides waiting for users to
>>>> report something thats not working?
>>>>
>>>> Thank you.
>>>>
>>>>
>>>>
>>>> On Wed, Oct 3, 2018 at 3:38 PM Walusiku Muyunda <jomuwalu@xxxxxxxxx>
>>>> wrote:
>>>>
>>>>> Using PostgreSQL query window. What am I supposed to use?
>>>>>
>>>>> *Thanks*
>>>>>
>>>>> On Wed, Oct 3, 2018 at 3:32 PM Stephen Ocaya <socaya@xxxxxxxxxxxxxx>
>>>>> wrote:
>>>>>
>>>>>> What are you using to execute the queries. I think it depends on the
>>>>>> UI or command.  Otherwise, I think it should be OK.
>>>>>>
>>>>>> Regards
>>>>>>
>>>>>> On Wed, Oct 3, 2018, 14:23 Walusiku Muyunda <jomuwalu@xxxxxxxxx>
>>>>>> wrote:
>>>>>>
>>>>>>> When I execute the script in postgresql query window I get a result
>>>>>>> in 1sec with only 1 row affected. That does not seem to be good. The
>>>>>>> documentation next to the download only show what has been moved.
>>>>>>>
>>>>>>> Is there a specific way of running the script?
>>>>>>>
>>>>>>>
>>>>>>> On Wed, Oct 3, 2018 at 12:44 PM Mamadou Diao Diallo <
>>>>>>> diao_diallo@xxxxxxxxxx> wrote:
>>>>>>>
>>>>>>>> Hi Walusiku,
>>>>>>>>
>>>>>>>> The script should have comment on the procedure to upgrade, find
>>>>>>>> here the upgrade notes and scripts for all versions :
>>>>>>>> https://www.dhis2.org/downloads
>>>>>>>>
>>>>>>>> Best,
>>>>>>>> Diao
>>>>>>>>
>>>>>>>> *DIALLO MAMADOU DIAO Technical Advisor and Developer*
>>>>>>>> *John Snow Research and Training Institute | GOFR Connect - Drupal
>>>>>>>> Dev - DHIS2*
>>>>>>>> *PHONE : +224 623 909 413 | +224 662 256 106*
>>>>>>>> *SKYPE : diaodiallo08*
>>>>>>>> *www.jsi.com <http://www.jsi.com/>*
>>>>>>>>
>>>>>>>>
>>>>>>>> On Wed, Oct 3, 2018 at 7:59 AM Walusiku Muyunda <jomuwalu@xxxxxxxxx>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> Thank you Elmarie for the quick and very helpful response. I have
>>>>>>>>> downloaded the upgrade scripts, where can I find the upgrade procedure
>>>>>>>>> documentation? Or do I just run the upgrade script and then replace the war
>>>>>>>>> file with the newer version?
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On Wed, Oct 3, 2018 at 9:31 AM Elmarie Claasen <elmarie@xxxxxxxx>
>>>>>>>>> wrote:
>>>>>>>>>
>>>>>>>>>> Hi Walusiki,
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> You should always run sequential upgrades to the next version as
>>>>>>>>>> there may be upgrade scripts for each version. After upgrade you need to
>>>>>>>>>> start up the instance and then you can proceed to the next version.
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> Regards,
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> *Elmarie Claasen*
>>>>>>>>>>
>>>>>>>>>> [image: Hisp logo]
>>>>>>>>>>
>>>>>>>>>> Project Manager
>>>>>>>>>>
>>>>>>>>>> Health Information Systems Program
>>>>>>>>>>
>>>>>>>>>> Tel:      041-367 1027
>>>>>>>>>>
>>>>>>>>>> Cell:     082 374 2209
>>>>>>>>>>
>>>>>>>>>> E-mail: elmarie@xxxxxxxx
>>>>>>>>>>
>>>>>>>>>> Skype:  elmarie.claasen52
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> *From:* Dhis2-users <dhis2-users-bounces+elmarie=
>>>>>>>>>> hisp.org@xxxxxxxxxxxxxxxxxxx> *On Behalf Of *Walusiku Muyunda
>>>>>>>>>> *Sent:* Wednesday, October 3, 2018 9:25 AM
>>>>>>>>>> *To:* dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>>>>>>>> *Subject:* [Dhis2-users] Upgrade DHIS 2.28 to 2.30
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> Yet another quick question: Is it okay to upgrade from version
>>>>>>>>>> 2.28 directly to 2.30. Are there any problems of doing so?
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> Thank you
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> *Walusiku J. Muyunda*
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> *Cell: +260967006614Cell: +260971000614*
>>>>>>>>>>
>>>>>>>>>> *"We have heaven to win and hell to shun, our lives testify
>>>>>>>>>> better!" <http://wildvoices.blogspot.com/>*
>>>>>>>>>>
>>>>>>>>>> *This message and any attachments are subject to a disclaimer
>>>>>>>>>> published at http://www.hisp.org/policies.html#comms_disclaimer
>>>>>>>>>> <http://www.hisp.org/policies.html#comms_disclaimer>.  Please read the
>>>>>>>>>> disclaimer before opening any attachment or taking any other action in
>>>>>>>>>> terms of this electronic transmission.  If you cannot access the
>>>>>>>>>> disclaimer, kindly send an email to disclaimer@xxxxxxxx
>>>>>>>>>> <disclaimer@xxxxxxxx> and a copy will be provided to you. By replying to
>>>>>>>>>> this e-mail or opening any attachment you agree to be bound by the
>>>>>>>>>> provisions of the disclaimer.*
>>>>>>>>>>
>>>>>>>>> _______________________________________________
>>>>>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>>>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>>>>
>>>>>>>> _______________________________________________
>>>>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>>>>> More help   : https://help.launchpad.net/ListHelp
>>>>>>>
>>>>>>
>>>>>>
>>>>>> Strategic Information Systems for Actions
>>>>>> Plot 36 Impala Avenue, Kololo
>>>>>> P.O. Box 4750, Kampala
>>>>>>
>>>>> _______________________________________________
>>>> Mailing list: https://launchpad.net/~dhis2-users
>>>> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
>>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>>> More help   : https://help.launchpad.net/ListHelp
>>>>
>>>