dhis2-devs team mailing list archive

[Markus Bekken <markus@xxxxxxxxx>]

Hi Dan!
You are are absolutely right. The script currently triggers a migration of data into the programstageusergroupaccesses before this table is created.

To get around the problem right away you need to run the script except for the last line, then start the server, and run the last line of the script to do the migration:
select migrateRoleToUserGroup();

Looking at a better fix now - to migrate as part of the server startup.

Markus

P.S. This does not look like the same problem that Bernard had for some reason - but expecting that Bernard need to do the same workaround.

> 9. mar. 2018 kl. 13:39 skrev Dan Cocos <dcocos@xxxxxxxxx>:
> 
> We’ve run into a similar problem when testing from 2.28 to 2.29
> 
> psql:/tmp/229-upgrade.sql:117: ERROR:  relation "programstageusergroupaccesses" does not exist
> LINE 1: insert into programstageusergroupaccesses ( programid, userg…
> 
> When looked deeper into it, that table did not exist. Is it possible these tables don’t exist or weren’t migrated from a previous upgrade if one isn’t using Tracker? 
> 
> Thanks,
> Dan
> 
> Dan Cocos
> Principal, BAO Systems
> dcocos@xxxxxxxxxxxxxx <mailto:dcocos@xxxxxxxxxxxxxx> | http://www.baosystems.com <http://www.baosystems.com/> |  2900 K Street, Suite 406, Washington D.C. 20007
> 
>> On Mar 9, 2018, at 7:31 AM, Markus Bekken <markus@xxxxxxxxx <mailto:markus@xxxxxxxxx>> wrote:
>> 
>> 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/>
>>>  
>>>  
>>> 
>>>  <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> <x-msg://58/#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>_______________________________________________
>>> 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>
>> _______________________________________________
>> 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>
>