dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #50850
Re: [Dhis2-users] 2.29 upgrade script error
Dear Markus,
After a closer look, I found this table:
public | program_userroles | table | dhis
Is it the same?
All the best,
Bernard
Bernard Sadaka
Information Management Advisor
Première Urgence - Aide Médicale Internationale
Nehmeh Building, Sanine Street, Chiyah, 3rd Floor
Ain el Remmaneh, Beirut, Lebanon
E-mail: <mailto:lib.ima@xxxxxxxxxx> lib.ima@xxxxxxxxxx
Cell: +961 71 004 881 (208)
Skype: imapuami
Website: <https://www.pu-ami.org/> https://www.pu-ami.org
From: Dhis2-users [mailto:dhis2-users-bounces+lib.ima=pu-ami.org@xxxxxxxxxxxxxxxxxxx] On Behalf Of Bernard Sadaka (IM Advisor)
Sent: Friday, March 9, 2018 3:17 PM
To: 'Markus Bekken' <markus@xxxxxxxxx>
Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx; 'DHIS 2 Developers list' <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
Subject: Re: [Dhis2-users] [Dhis2-devs] 2.29 upgrade script error
Hello Markus,
Unfortunately I don’t have that table:
dhisdb=# \dt userrole*
List of relations
Schema | Name | Type | Owner
--------+---------------------------+-------+-------
public | userrole | table | dhis
public | userroleauthorities | table | dhis
public | userroledataset | table | dhis
public | userrolemembers | table | dhis
public | userroletranslations | table | dhis
public | userroleuseraccesses | table | dhis
public | userroleusergroupaccesses | table | dhis
(7 rows)
Is there any maintenance scripts I need to run in order to create that table?
All the best,
Bernard
Bernard Sadaka
Information Management Advisor
Première Urgence - Aide Médicale Internationale
Nehmeh Building, Sanine Street, Chiyah, 3rd Floor
Ain el Remmaneh, Beirut, Lebanon
E-mail: <mailto:lib.ima@xxxxxxxxxx> lib.ima@xxxxxxxxxx
Cell: +961 71 004 881 (208)
Skype: imapuami
Website: <https://www.pu-ami.org/> https://www.pu-ami.org
From: Markus Bekken [mailto:markus@xxxxxxxxx]
Sent: Friday, March 9, 2018 2:32 PM
To: Bernard Sadaka (IM Advisor) <lib.ima@xxxxxxxxxx <mailto:lib.ima@xxxxxxxxxx> >
Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx <mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx> ; DHIS 2 Developers list <dhis2-devs@xxxxxxxxxxxxxxxxxxx <mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx> >
Subject: Re: [Dhis2-devs] 2.29 upgrade script error
Hi there Bernard,
that was strange - your 2.28 database should have contained the table userroleprogram.
Assuming you are running 2.28, can you try running this query on your command line?
\dt userrole*
Expecting that one of the lines output is:
public | userroleprogram | table | dhis
Best regards,
Markus
9. mar. 2018 kl. 10:04 skrev Bernard Sadaka (IM Advisor) <lib.ima@xxxxxxxxxx <mailto:lib.ima@xxxxxxxxxx> >:
Dear All,
I am trying to migrate from 2.28 (aff610f) to 2.29, by first running the upgrade script and then updating the .war file.
However I am stuck at the upgrade script with this error:
<image001.png>
Please advise.
All the best,
Bernard
<image002.png>
Bernard Sadaka
Information Management Advisor
Première Urgence - Aide Médicale Internationale
Nehmeh Building, Sanine Street, Chiyah, 3rd Floor
Ain el Remmaneh, Beirut, Lebanon
E-mail: <mailto:lib.ima@xxxxxxxxxx> lib.ima@xxxxxxxxxx
Cell: +961 71 004 881 (208)
Skype: imapuami
Website: <https://www.pu-ami.org/> https://www.pu-ami.org
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=icon>
Virus-free. <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=link> www.avast.com
_______________________________________________
Mailing list: <https://launchpad.net/~dhis2-devs> https://launchpad.net/~dhis2-devs
Post to : <mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx> dhis2-devs@xxxxxxxxxxxxxxxxxxx
Unsubscribe : <https://launchpad.net/~dhis2-devs> https://launchpad.net/~dhis2-devs
More help : <https://help.launchpad.net/ListHelp> https://help.launchpad.net/ListHelp
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
Follow ups
References
