Re: [Dhis2-devs] 2.29 upgrade script error

2018-03-09 Thread Bernard Sadaka (IM Advisor) 
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:  <mailto:lib@pu-ami.org> lib@pu-ami.org

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> 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) <lib@pu-ami.org>
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.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@pu-ami.org 
<mailto:lib@pu-ami.org> >:



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

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_source=link_campaign=sig-email_content=emailclient_term=icon>

Virus-free.  
<https://www.avast.com/sig-email?utm_medium=email_source=link_campaign=sig-email_content=emailclient_term=link>
 www.avast.com

___
Mailing list:  <https://launchpad.net/~dhis2-devs> 
https://launchpad.net/~dhis2-devs
Post to :  <mailto:dhis2-devs@lists.launchpad.net> 
dhis2-devs@lists.launchpad.net
Unsubscribe :  <https://launchpad.net/~dhis2-devs> 
https://launchpad.net/~dhis2-devs
More help   :  <https://help.launchpad.net/ListHelp> 
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

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 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 :
> 
> 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
> dco...@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 > > 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) 
>>> >:
>>> 
>>> 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 
>> 
> 

___
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] 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

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