← Back to team overview

dhis2-devs team mailing list archive

Re: [Dhis2-users] Error when upgrading DHIS2 from 2.29 to 2.30 - relationships


I faced this same error before: “'permission denied for relation XXX”

and I fixed it using this query in the DB:


ALTER TABLE public.relationshipitem OWNER to dhis;


Replace dhis with your DB user


All the best,



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.ima@xxxxxxxxxx> lib.ima@xxxxxxxxxx 

Cell: +961 71 004 881 (208)

Skype: imapuami

Website:  <https://www.pu-ami.org/> https://www.pu-ami.org



From: Dhis2-users [mailto:dhis2-users-bounces+lib.ima=pu-ami.org@xxxxxxxxxxxxxxxxxxx] On Behalf Of Em Le Hong
Sent: Monday, September 17, 2018 11:51 AM
To: Shurajit Dutta <shurajitdutta@xxxxxxxxx>; DHIS 2 Developers list <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
Cc: DHIS 2 Users list <dhis2-users@xxxxxxxxxxxxxxxxxxx>
Subject: Re: [Dhis2-users] Error when upgrading DHIS2 from 2.29 to 2.30 - relationships


Hi all,


I got the same problem with Nick. 

It says 'permission denied for relation relationshipitem', 



On Tue, Sep 11, 2018 at 11:18 PM Shurajit Dutta <shurajitdutta@xxxxxxxxx <mailto:shurajitdutta@xxxxxxxxx> > wrote:

Hi everyone,


I am trying to upgrade a DHIS2 instance from 2.29 to 2.30. I have done this on a couple other instances successfully. The issue I seem to be having here is with the relationship types. In 2.29, I have the following relationships:



This changes to the following (as per the release notes this is expected) in 2.30:



There are a couple issues I seem to be running into. 


1. I can not seem to edit these relationship types at all (the log error says "permission denied for relation relationshipconstraint"



2. I can not seem to open any tracker programs in tracker capture (the log error says "permission denied for relation relationshipitem")



Has anyone encountered this error? Any suggestions on how to fix it?





Shurajit Dutta (MPH, MHI)

Health Information Systems Adviser

Mailing list: https://launchpad.net/~dhis2-users
Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx <mailto:dhis2-users@xxxxxxxxxxxxxxxxxxx> 
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp



Em Le Hong

DHIS2 Implementation| HISP Vietnam 

em.hispvietnam@xxxxxxxxx <mailto:em.hispvietnam@xxxxxxxxx>  | Skype:  <mailto:em.hispvietnam@xxxxxxxxx> em.hispvietnam@xxxxxxxxx





PNG image

JPEG image

PNG image

PNG image

PNG image

PNG image

JPEG image

Follow ups