date:20180309

Re: [Dhis2-devs] [Dhis2-users] 2.29 upgrade script error

2018-03-09 Thread Markus Bekken

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) :
> 
> Dear Markus,
> After a closer look, I found this table:
> public | program_userroles | table | dhis
> Is it the same?
>  
> 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 
>  
>  
> From: Dhis2-users 
> [mailto:dhis2-users-bounces+lib.ima=pu-ami@lists.launchpad.net 
> ] On 
> Behalf Of Bernard Sadaka (IM Advisor)
> Sent: Friday, March 9, 2018 3:17 PM
> To: 'Markus Bekken' >
> Cc: dhis2-us...@lists.launchpad.net ; 
> 'DHIS 2 Developers list'  >
> 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
>  
> 
> 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 
>  
>  
> From: Markus Bekken [mailto:mar...@dhis2.org ] 
> Sent: Friday, March 9, 2018 2:32 PM
> To: Bernard Sadaka (IM Advisor)  >
> Cc: dhis2-us...@lists.launchpad.net ; 
> DHIS 2 Developers list  >
> 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) > >:
>>  
>> 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

Re: [Dhis2-devs] [Dhis2-users] 2.29 upgrade script error

2018-03-09 Thread Bernard Sadaka (IM Advisor)

Dear Markus,

After a closer look, I found this table:

public | program_userroles | table | dhis

Is it the same?



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





From: Dhis2-users 
[mailto:dhis2-users-bounces+lib.ima=pu-ami@lists.launchpad.net] On Behalf 
Of Bernard Sadaka (IM Advisor)
Sent: Friday, March 9, 2018 3:17 PM
To: 'Markus Bekken' 
Cc: dhis2-us...@lists.launchpad.net; 'DHIS 2 Developers list' 

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






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





From: Markus Bekken [mailto:mar...@dhis2.org]
Sent: Friday, March 9, 2018 2:32 PM
To: Bernard Sadaka (IM Advisor)  
>
Cc: dhis2-us...@lists.launchpad.net  ; 
DHIS 2 Developers list  >
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)  >:



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





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

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:   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) 
Cc: dhis2-us...@lists.launchpad.net; DHIS 2 Developers list 

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)  >:



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





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

[Dhis2-devs] 2.29 Generated TEI attribute & sequencial number

2018-03-09 Thread Edouard Lavaud

Hi devs,


The generated ID is a nice feature we were looking for. Thanks!

However now I am wondering. In the user guide it specifies:

"Sequential segments will be replaced by a number, based on a counting
value on the server."

How do I do to find this value on the server? Through API or through PqSQL?

We want to migrate data from a legacy system that already have sequential
number.
So once migrated, dhis2 tracker should start from the last value migrated
and not "1".


Thanks,


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

[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 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







---
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] [Dhis2-users] 2.29 upgrade script error

Re: [Dhis2-devs] [Dhis2-users] 2.29 upgrade script error

Re: [Dhis2-devs] 2.29 upgrade script error

Re: [Dhis2-devs] 2.29 upgrade script error

Re: [Dhis2-devs] 2.29 upgrade script error

[Dhis2-devs] 2.29 Generated TEI attribute & sequencial number

[Dhis2-devs] 2.29 upgrade script error

7 matches

Site Navigation

Mail list logo

Footer information