Exception while trying to view Notes & Discrepancies

Hi,
I am using version 3.1.1 community on CentOS, with postgres 8.4. I get the following exception while trying to view the Notes & Discrepancies tab (nothing on the client side):
org.postgresql.util.PSQLException: ERROR: permission denied for relation discrepancy_note
Howerver, I don't get this exception on another system which runs the same version of OpenClinica and postgres. The only difference is that the database users are different. I don't know how to reproduce this error on a different machine. I tried changing the ownership of the table on an instance that is working correctly to something other than 'clinica' and 'postgres' (these were the users on the two instances that are not showing this exception), but that did not reproduce the issue.
I have attached the log file for convenience. What is the issue here?
Thanks,
Suresh
Email Disclaimer: www.stjude.org/emaildisclaimer
Consultation Disclaimer: www.stjude.org/consultationdisclaimer
Attachments:
catalina.out 284 KB

Comments

  • Hi,
    I am using version 3.1.1 community on CentOS, with postgres 8.4. I get the following exception while trying to view the Notes & Discrepancies tab (nothing on the client side):
    org.postgresql.util.PSQLException: ERROR: permission denied for relation discrepancy_note
    Howerver, I don't get this exception on another system which runs the same version of OpenClinica and postgres. The only difference is that the database users are different. I don't know how to reproduce this error on a different machine. I tried changing the ownership of the table on an instance that is working correctly to something other than 'clinica' and 'postgres' (these were the users on the two instances that are not showing this exception), but that did not reproduce the issue.
    I have attached the log file for convenience. What is the issue here?
    Thanks,
    Suresh
    Email Disclaimer: www.stjude.org/emaildisclaimer
    Consultation Disclaimer: www.stjude.org/consultationdisclaimer
    Attachments:
    catalina.out 284 KB
  • jamuna269jamuna269 Posts: 109
    Sureh Please check to make sure the database owner is same as the owner of the table.
    On Tue, Mar 26, 2013 at 1:34 PM, Thiagarajan, Suresh wrote:
    Hi,
    I am using version 3.1.1 community on CentOS, with postgres 8.4. I get the following exception while trying to view the Notes & Discrepancies tab (nothing on the client side):
    org.postgresql.util.PSQLException: ERROR: permission denied for relation discrepancy_note
    Howerver, I don't get this exception on another system which runs the same version of OpenClinica and postgres. The only difference is that the database users are different. I don't know how to reproduce this error on a different machine. I tried changing the ownership of the table on an instance that is working correctly to something other than 'clinica' and 'postgres' (these were the users on the two instances that are not showing this exception), but that did not reproduce the issue.
    I have attached the log file for convenience. What is the issue here?
    Thanks,
    Suresh
    Email Disclaimer: www.stjude.org/emaildisclaimer
    Consultation Disclaimer: www.stjude.org/consultationdisclaimer
This discussion has been closed.