Re: [Dhis2-devs] 2.29 upgrade script error

2018-03-09 Thread Bernard Sadaka (IM Advisor)
g> Cc: dhis2-us...@lists.launchpad.net; DHIS 2 Developers list <dhis2-devs@lists.launchpad.net> 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

Re: [Dhis2-devs] 2.29 upgrade script error

2018-03-09 Thread Markus Bekken
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

Re: [Dhis2-devs] 2.29 upgrade script error

2018-03-09 Thread Markus Bekken
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

[Dhis2-devs] 2.29 upgrade script error

2018-03-09 Thread 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