dhis2-devs team mailing list archive

[Markus Bekken <markus@xxxxxxxxx>]

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) <lib.ima@xxxxxxxxxx>:
> 
> Dear Markus,
> After a closer look, I found this table:
> public     | program_userroles         | table | dhis
> Is it the same?
>  
> All the best,
> Bernard
>  
> <image001.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: lib.ima@xxxxxxxxxx <mailto: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 <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 <mailto:markus@xxxxxxxxx>>
> Cc: dhis2-users@xxxxxxxxxxxxxxxxxxx <mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx>; 'DHIS 2 Developers list' <dhis2-devs@xxxxxxxxxxxxxxxxxxx <mailto: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
>  
> <image001.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: lib.ima@xxxxxxxxxx <mailto: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 <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: lib.ima@xxxxxxxxxx <mailto:lib.ima@xxxxxxxxxx>
>> Cell: +961 71 004 881 (208)
>> Skype: imapuami
>> Website: https://www.pu-ami.org <https://www.pu-ami.org/>
>>  
>>  
>>  
>> <image002.jpg> <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=icon>	
>> Virus-free. www.avast.com <https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=emailclient&utm_term=link>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs <https://launchpad.net/~dhis2-devs>
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx <mailto: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>
>