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.
I can not seem to edit these relationship types at all (the log error says “permission denied for relation relationshipconstraint”
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?
Thanks
···
Shurajit Dutta (MPH, MHI)
Health Information Systems Adviser
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.
I can not seem to edit these relationship types at all (the log error says “permission denied for relation relationshipconstraint”
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?
Interestingly this is the reverse problem to that of creating the postgis extension. You have to be a superuser role in the database to create the postgis extension in the database. But …
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.
I can not seem to edit these relationship types at all (the log error says “permission denied for relation relationshipconstraint”
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?
Did the sql fix your issues or are you still having issues? The superuser and ownership is a tricky challenge since we dont know the name of the user, but aside from the postgis extension, the upgradescript should be runnable as a non-superuser if I remember correctly.
···
On 17 September 2018 at 09:58, Bernard Sadaka (IM Advisor) lib.ima@pu-ami.org wrote:
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;
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.
I can not seem to edit these relationship types at all (the log error says “permission denied for relation relationshipconstraint”
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?
Did the sql fix your issues or are you still having issues? The superuser and ownership is a tricky challenge since we dont know the name of the user, but aside from the postgis extension, the upgradescript should be runnable as a non-superuser if I remember correctly.
Interestingly this is the reverse problem to that of creating the postgis extension. You have to be a superuser role in the database to create the postgis extension in the database. But …
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.
I can not seem to edit these relationship types at all (the log error says “permission denied for relation relationshipconstraint”
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?
Did the sql fix your issues or are you still having issues? The superuser and ownership is a tricky challenge since we dont know the name of the user, but aside from the postgis extension, the upgradescript should be runnable as a non-superuser if I remember correctly.
Interestingly this is the reverse problem to that of creating the postgis extension. You have to be a superuser role in the database to create the postgis extension in the database. But …
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.
I can not seem to edit these relationship types at all (the log error says “permission denied for relation relationshipconstraint”
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?
Did the sql fix your issues or are you still having issues? The superuser and ownership is a tricky challenge since we dont know the name of the user, but aside from the postgis extension, the upgradescript should be runnable as a non-superuser if I remember correctly.
Interestingly this is the reverse problem to that of creating the postgis extension. You have to be a superuser role in the database to create the postgis extension in the database. But …
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.
I can not seem to edit these relationship types at all (the log error says “permission denied for relation relationshipconstraint”
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?
But hard to figure the neatest way around because we cannot know in advance the name of the dhis db user.