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 <[email protected]>: > > 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 > [email protected] <mailto:[email protected]> | > 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 <[email protected] >> <mailto:[email protected]>> 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) >>> <[email protected] <mailto:[email protected]>>: >>> >>> 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: [email protected] <mailto:[email protected]> >>> 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 : [email protected] >>> <mailto:[email protected]> >>> 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 : [email protected] >> <mailto:[email protected]> >> 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 Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
