Re: [Dhis2-devs] [Dhis2-users] 2.29 upgrade script error

[Markus Bekken]

Dear Bernard,
You are absolutely right. The program_userroles table is the correct one, and 
the userroleprogram table is a legacy table not used anymore. We just fixed the 
script, please try again with the latest version.

Best regards,
Markus

> 9. mar. 2018 kl. 14:21 skrev Bernard Sadaka (IM Advisor) :
> 
> 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: lib@pu-ami.org 
> Cell: +961 71 004 881 (208)
> Skype: imapuami
> Website: https://www.pu-ami.org 
>  
>  
> From: Dhis2-users 
> [mailto:dhis2-users-bounces+lib.ima=pu-ami@lists.launchpad.net 
> ] On 
> Behalf Of Bernard Sadaka (IM Advisor)
> Sent: Friday, March 9, 2018 3:17 PM
> To: 'Markus Bekken' >
> Cc: dhis2-us...@lists.launchpad.net ; 
> 'DHIS 2 Developers list'  >
> 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: lib@pu-ami.org 
> Cell: +961 71 004 881 (208)
> Skype: imapuami
> Website: https://www.pu-ami.org 
>  
>  
> From: Markus Bekken [mailto:mar...@dhis2.org ] 
> Sent: Friday, March 9, 2018 2:32 PM
> To: Bernard Sadaka (IM Advisor)  >
> Cc: dhis2-us...@lists.launchpad.net ; 
> DHIS 2 Developers list  >
> 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) > >:
>>  
>> 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:
>> 
>> Please advise.
>>  
>> 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: lib@pu-ami.org 
>> Cell: +961 71 004 881 (208)
>> Skype: imapuami
>> Website: https://www.pu-ami.org 
>>  
>>  
>>  
>>  
>> 
>>
>> Virus-free. www.avast.com 
>> 
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs 
>> 
>> Post to : dhis2-devs@lists.launchpad.net 
>> 
>> Unsubscribe : https://launchpad.net/~dhis2-devs 
>> 
>> More help   : https://help.launchpad.net/ListHelp 
>> 
>  

___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-devs] [Dhis2-users] 2.29 upgrade script error

[Bernard Sadaka (IM Advisor)]

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:   lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:   https://www.pu-ami.org





From: Dhis2-users 
[mailto:dhis2-users-bounces+lib.ima=pu-ami@lists.launchpad.net] On Behalf 
Of Bernard Sadaka (IM Advisor)
Sent: Friday, March 9, 2018 3:17 PM
To: 'Markus Bekken' 
Cc: dhis2-us...@lists.launchpad.net; 'DHIS 2 Developers list' 

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:   lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:   https://www.pu-ami.org





From: Markus Bekken [mailto:mar...@dhis2.org]
Sent: Friday, March 9, 2018 2:32 PM
To: Bernard Sadaka (IM Advisor)  
>
Cc: dhis2-us...@lists.launchpad.net  ; 
DHIS 2 Developers list  >
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)  >:



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:



Please advise.



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:   lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:   https://www.pu-ami.org








 


Virus-free.  

 www.avast.com

___
Mailing list:   
https://launchpad.net/~dhis2-devs
Post to :   
dhis2-devs@lists.launchpad.net
Unsubscribe :   
https://launchpad.net/~dhis2-devs
More help   :   
https://help.launchpad.net/ListHelp





---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
___
Mailing list: https://launchpad.net/~dhis2-devs
Post to : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp