← Back to team overview

dhis2-devs team mailing list archive

Re: 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>
Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx; DHIS 2 Developers list <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

PNG image

JPEG image


Follow ups

References