dhis2-users team mailing list archive

Thread
Date
Re: Error

To: Collins McAdoyo <collins.adoyo@xxxxxxxxx>
From: Knut Staring <knutst@xxxxxxxxx>
Date: Mon, 1 Aug 2016 15:44:54 +0200
Cc: "dhis2-users@xxxxxxxxxxxxxxxxxxx" <dhis2-users@xxxxxxxxxxxxxxxxxxx>
In-reply-to: <CAMgRV59rCF_SjO+FQaMfLqDJ=-JCh_58PNr7kEnLtetFc2+ygg@mail.gmail.com>
Looks like DHIS2 does not have sufficient permissions for the database.
Since this is locally,  you could just give the dhis user superuser
privileges.

On Mon, Aug 1, 2016 at 1:26 PM, Collins McAdoyo <collins.adoyo@xxxxxxxxx>
wrote:

> Dear Team,
>
> Below is the catalina.out error log. Kindly any suggestions on how to fix
> it.My application is DHIS2.12 and am trying to deploy it locally.
>
> Aug 01, 2016 1:01:15 PM org.apache.catalina.startup.ClassLoaderFactory
> validateFile
> WARNING: Problem with directory [/usr/share/tomcat7/common/classes],
> exists: [false], isDirectory: [false], canRead: [false]
> Aug 01, 2016 1:01:15 PM org.apache.catalina.startup.ClassLoaderFactory
> validateFile
> WARNING: Problem with directory [/usr/share/tomcat7/common], exists:
> [false], isDirectory: [false], canRead: [false]
> Aug 01, 2016 1:01:15 PM org.apache.catalina.startup.ClassLoaderFactory
> validateFile
> WARNING: Problem with directory [/usr/share/tomcat7/server/classes],
> exists: [false], isDirectory: [false], canRead: [false]
> Aug 01, 2016 1:01:15 PM org.apache.catalina.startup.ClassLoaderFactory
> validateFile
> WARNING: Problem with directory [/usr/share/tomcat7/server], exists:
> [false], isDirectory: [false], canRead: [false]
> Aug 01, 2016 1:01:15 PM org.apache.catalina.startup.ClassLoaderFactory
> validateFile
> WARNING: Problem with directory [/usr/share/tomcat7/shared/classes],
> exists: [false], isDirectory: [false], canRead: [false]
> Aug 01, 2016 1:01:15 PM org.apache.catalina.startup.ClassLoaderFactory
> validateFile
> WARNING: Problem with directory [/usr/share/tomcat7/shared], exists:
> [false], isDirectory: [false], canRead: [false]
> Aug 01, 2016 1:01:15 PM org.apache.coyote.AbstractProtocol init
> INFO: Initializing ProtocolHandler ["http-bio-8080"]
> Aug 01, 2016 1:01:15 PM org.apache.catalina.startup.Catalina load
> INFO: Initialization processed in 460 ms
> Aug 01, 2016 1:01:15 PM org.apache.catalina.core.StandardService
> startInternal
> INFO: Starting service Catalina
> Aug 01, 2016 1:01:15 PM org.apache.catalina.core.StandardEngine
> startInternal
> INFO: Starting Servlet Engine: Apache Tomcat/7.0.52 (Ubuntu)
> Aug 01, 2016 1:01:15 PM org.apache.catalina.startup.HostConfig deployWAR
> INFO: Deploying web application archive /tomcat-dhis/webapps/ovc.war
> Aug 01, 2016 1:01:16 PM org.apache.catalina.loader.WebappClassLoader
> validateJarFile
> INFO: validateJarFile(/tomcat-dhis/webapps/ovc/WEB-INF/lib/
> geronimo-servlet_2.5_spec-1.1.2.jar) - jar not loaded. See Servlet Spec
> 3.0, section 10.7.2. Offending class: javax/servlet/Servlet.class
> * INFO  2016-08-01 13:01:29,056 System property dhis2.home not set
> (DefaultLocationManager.java [localhost-startStop-1])
> * INFO  2016-08-01 13:01:29,063 Environment variable DHIS2_HOME points to
> /home/dhis/config (DefaultLocationManager.java [localhost-startStop-1])
> * WARN  2016-08-01 13:01:29,416 HHH000223: Recognized obsolete hibernate
> namespace http://hibernate.sourceforge.net/. Use namespace
> http://www.hibernate.org/dtd/ instead. Refer to Hibernate 3.6 Migration
> Guide! (DTDEntityResolver.java [localhost-startStop-1])
> * WARN  2016-08-01 13:01:31,130 HHH000223: Recognized obsolete hibernate
> namespace http://hibernate.sourceforge.net/. Use namespace
> http://www.hibernate.org/dtd/ instead. Refer to Hibernate 3.6 Migration
> Guide! (DTDEntityResolver.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,443 HHH000388: Unsuccessful: alter table chart
> add column organisationUnitLevel int4 (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,445 ERROR: must be owner of relation chart
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,449 HHH000388: Unsuccessful: alter table
> dataelement add column active boolean not null (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,450 ERROR: must be owner of relation
> dataelement (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,453 HHH000388: Unsuccessful: alter table
> dataelementcategory add column conceptid int4 (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,454 ERROR: must be owner of relation
> dataelementcategory (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,457 HHH000388: Unsuccessful: alter table
> dataelementcategoryoption add column conceptid int4 (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,458 ERROR: must be owner of relation
> dataelementcategoryoption (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,461 HHH000388: Unsuccessful: alter table
> mapview add column valueType varchar(255) (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,462 ERROR: must be owner of relation mapview
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,465 HHH000388: Unsuccessful: alter table
> mapview add column indicatorgroupid int4 (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,466 ERROR: must be owner of relation mapview
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,473 HHH000388: Unsuccessful: alter table
> mapview add column indicatorid int4 (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,474 ERROR: must be owner of relation mapview
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,479 HHH000388: Unsuccessful: alter table
> mapview add column dataelementgroupid int4 (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,481 ERROR: must be owner of relation mapview
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,484 HHH000388: Unsuccessful: alter table
> mapview add column dataelementid int4 (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,485 ERROR: must be owner of relation mapview
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,488 HHH000388: Unsuccessful: alter table
> mapview add column dataelementoperandid int4 (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,489 ERROR: must be owner of relation mapview
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,492 HHH000388: Unsuccessful: alter table
> mapview add column periodid int4 (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,493 ERROR: must be owner of relation mapview
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,497 HHH000388: Unsuccessful: alter table
> mapview add column parentorganisationunitid int4 (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,499 ERROR: must be owner of relation mapview
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,502 HHH000388: Unsuccessful: alter table
> mapview add column organisationunitlevelid int4 (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,503 ERROR: must be owner of relation mapview
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,506 HHH000388: Unsuccessful: alter table
> mapview add column legendType varchar(255) (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,507 ERROR: must be owner of relation mapview
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,511 HHH000388: Unsuccessful: alter table
> organisationunit add column geoCode varchar(255) (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,513 ERROR: must be owner of relation
> organisationunit (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,516 HHH000388: Unsuccessful: alter table
> program add column displayProvidedOtherFacility boolean (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,517 ERROR: must be owner of relation program
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,520 HHH000388: Unsuccessful: alter table
> program add column generatedByEnrollmentDate boolean (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,522 ERROR: must be owner of relation program
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,524 HHH000388: Unsuccessful: alter table
> program add column blockEntryForm boolean (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,525 ERROR: must be owner of relation program
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,528 HHH000388: Unsuccessful: alter table
> program add column remindCompleted boolean (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,529 ERROR: must be owner of relation program
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,535 HHH000388: Unsuccessful: alter table
> program add column disableRegistrationFields boolean (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,537 ERROR: must be owner of relation program
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,541 HHH000388: Unsuccessful: alter table
> programinstance add column patientid int4 (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,542 ERROR: must be owner of relation
> programinstance (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,546 HHH000388: Unsuccessful: alter table
> programinstance add column patientcommentid int4 (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,547 ERROR: must be owner of relation
> programinstance (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,551 HHH000388: Unsuccessful: alter table
> programstage add column dataEntryForm int4 (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,552 ERROR: must be owner of relation
> programstage (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,555 HHH000388: Unsuccessful: alter table
> programstageinstance add column completed boolean not null
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,556 ERROR: must be owner of relation
> programstageinstance (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,561 HHH000388: Unsuccessful: alter table
> programstageinstance add column coordinates text (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,562 ERROR: must be owner of relation
> programstageinstance (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,566 HHH000388: Unsuccessful: alter table
> relationship add column patientaid int4 not null (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,567 ERROR: must be owner of relation
> relationship (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,572 HHH000388: Unsuccessful: alter table
> relationship add column patientbid int4 not null (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,573 ERROR: must be owner of relation
> relationship (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,576 HHH000388: Unsuccessful: alter table
> reporttable add column totals boolean (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,577 ERROR: must be owner of relation
> reporttable (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,583 HHH000388: Unsuccessful: alter table
> reporttable add column organisationUnitLevel int4 (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,584 ERROR: must be owner of relation
> reporttable (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,587 HHH000388: Unsuccessful: alter table
> translation add column objectid int4 not null (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,588 ERROR: must be owner of relation
> translation (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,590 HHH000388: Unsuccessful: alter table
> validationrule add column type varchar(255) (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,591 ERROR: must be owner of relation
> validationrule (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,595 HHH000388: Unsuccessful: alter table
> customreport add constraint fk_customreport_userid foreign key (userid)
> references userinfo (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,596 ERROR: must be owner of relation
> customreport (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,599 HHH000388: Unsuccessful: alter table
> customreport_design add constraint fk_customreport_customreportdesignid
> foreign key (customreportdesignid) references customreportdesign
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,600 ERROR: must be owner of relation
> customreport_design (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,604 HHH000388: Unsuccessful: alter table
> customreport_design add constraint fk_customreport_design_customreportid
> foreign key (customreportid) references customreport (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,605 ERROR: must be owner of relation
> customreport_design (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,608 HHH000388: Unsuccessful: alter table
> customreport_filter add constraint fk_customreport_customreportfilterid
> foreign key (customreportfilterid) references customreportfilter
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,609 ERROR: must be owner of relation
> customreport_filter (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,612 HHH000388: Unsuccessful: alter table
> customreport_filter add constraint fk_customreport_filter_customreportid
> foreign key (customreportid) references customreport (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,613 ERROR: must be owner of relation
> customreport_filter (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,619 HHH000388: Unsuccessful: alter table
> dashboardcontent add constraint fk_dashboardcontent_userinfoid foreign key
> (dashboardcontentid) references userinfo (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,620 ERROR: permission denied for relation
> userinfo (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,624 HHH000388: Unsuccessful: alter table
> dashboardcontent_documents add constraint fk_dashboardcontent_documents_documentid
> foreign key (documentid) references document (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,626 ERROR: permission denied for relation
> document (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,631 HHH000388: Unsuccessful: alter table
> dashboardcontent_maps add constraint fk_dashboardcontent_maps_mapid foreign
> key (mapid) references map (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,632 ERROR: permission denied for relation map
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,635 HHH000388: Unsuccessful: alter table
> dashboardcontent_reports add constraint fk_dashboardcontent_reports_reportid
> foreign key (reportid) references report (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,636 ERROR: permission denied for relation
> report (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,640 HHH000388: Unsuccessful: alter table
> dashboardcontent_reporttables add constraint fk_dashboardcontent_reporttableid
> foreign key (reporttableid) references reporttable (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,641 ERROR: permission denied for relation
> reporttable (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,655 HHH000388: Unsuccessful: alter table
> dataelementcategory add constraint fk_dataelementcategory_conceptid
> foreign key (conceptid) references concept (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,656 ERROR: must be owner of relation
> dataelementcategory (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,659 HHH000388: Unsuccessful: alter table
> dataelementcategoryoption add constraint fk_dataelementcategory_conceptid
> foreign key (conceptid) references concept (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,660 ERROR: must be owner of relation
> dataelementcategoryoption (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,663 HHH000388: Unsuccessful: alter table
> datavalue_audit add constraint fk_datavalueaudit_datavalue foreign key
> (dataelementid, periodid, sourceid, categoryoptioncomboid) references
> datavalue (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,665 ERROR: permission denied for relation
> datavalue (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,669 HHH000388: Unsuccessful: alter table
> employee add constraint fk_employee_organisationunitid foreign key
> (organisationunitid) references organisationunit (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,670 ERROR: must be owner of relation employee
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,672 HHH000388: Unsuccessful: alter table
> location add constraint fk_location_parentorganisationunitid foreign key
> (parentorganisationunitid) references organisationunit (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,673 ERROR: must be owner of relation location
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,676 HHH000388: Unsuccessful: alter table
> mapview add constraint fk_mapview_indicatorgroupid foreign key
> (indicatorgroupid) references indicatorgroup (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,677 ERROR: must be owner of relation mapview
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,682 HHH000388: Unsuccessful: alter table
> mapview add constraint fk_mapview_indicatorid foreign key (indicatorid)
> references indicator (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,683 ERROR: must be owner of relation mapview
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,686 HHH000388: Unsuccessful: alter table
> mapview add constraint fk_mapview_dataelementgroupid foreign key
> (dataelementgroupid) references dataelementgroup (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,687 ERROR: must be owner of relation mapview
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,690 HHH000388: Unsuccessful: alter table
> mapview add constraint fk_mapview_dataelementid foreign key (dataelementid)
> references dataelement (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,691 ERROR: must be owner of relation mapview
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,695 HHH000388: Unsuccessful: alter table
> mapview add constraint fk_mapview_dataelementoperandid foreign key
> (dataelementoperandid) references dataelementoperand (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,696 ERROR: must be owner of relation mapview
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,701 HHH000388: Unsuccessful: alter table
> mapview add constraint fk_mapview_periodid foreign key (periodid)
> references period (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,702 ERROR: must be owner of relation mapview
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,705 HHH000388: Unsuccessful: alter table
> mapview add constraint fk_mapview_parentorganisationunitid foreign key
> (parentorganisationunitid) references organisationunit (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,706 ERROR: must be owner of relation mapview
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,708 HHH000388: Unsuccessful: alter table
> mapview add constraint fk_mapview_organisationunitlevelid foreign key
> (organisationunitlevelid) references orgunitlevel (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,709 ERROR: must be owner of relation mapview
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,713 HHH000388: Unsuccessful: alter table
> orgunitgroupprograms add constraint FK545DEC86B8B57B9D foreign key
> (orgunitgroupid) references orgunitgroup (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,714 ERROR: permission denied for relation
> orgunitgroup (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,719 HHH000388: Unsuccessful: alter table
> orgunitgroupprograms add constraint FK545DEC86A3100C9F foreign key
> (programid) references program (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,720 ERROR: permission denied for relation
> program (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,723 HHH000388: Unsuccessful: alter table
> patient add constraint fk_representativeid foreign key (representativeid)
> references patient (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,724 ERROR: must be owner of relation patient
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,731 HHH000388: Unsuccessful: alter table
> patient add constraint fk_patient_organisationunitid foreign key
> (organisationunitid) references organisationunit (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,732 ERROR: must be owner of relation patient
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,735 HHH000388: Unsuccessful: alter table
> patient add constraint fk_user_patientid foreign key (healthworkerid)
> references userinfo (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,736 ERROR: must be owner of relation patient
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,739 HHH000388: Unsuccessful: alter table
> patient_attributes add constraint fk_patient_patientattributeid foreign key
> (patientattributeid) references patientattribute (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,740 ERROR: must be owner of relation
> patient_attributes (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,743 HHH000388: Unsuccessful: alter table
> patient_attributes add constraint fk_patient_attributes_patientid foreign
> key (patientid) references patient (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,744 ERROR: must be owner of relation
> patient_attributes (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,749 HHH000388: Unsuccessful: alter table
> patient_programs add constraint fk_patient_programid foreign key
> (programid) references program (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,750 ERROR: must be owner of relation
> patient_programs (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,753 HHH000388: Unsuccessful: alter table
> patient_programs add constraint fk_patient_programs_patientid foreign key
> (patientid) references patient (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,754 ERROR: must be owner of relation
> patient_programs (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,757 HHH000388: Unsuccessful: alter table
> patientaggregatereport add constraint fk_patientaggregatereport_programstage
> foreign key (programstageid) references programstage (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,759 ERROR: must be owner of relation
> patientaggregatereport (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,764 HHH000388: Unsuccessful: alter table
> patientaggregatereport add constraint fk_patientaggregatereport_dataelementid
> foreign key (dataelementid) references dataelement (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,764 ERROR: must be owner of relation
> patientaggregatereport (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,769 HHH000388: Unsuccessful: alter table
> patientaggregatereport add constraint fk_patientaggregatereport_dataelementsumtid
> foreign key (desumid) references dataelement (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,770 ERROR: must be owner of relation
> patientaggregatereport (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,773 HHH000388: Unsuccessful: alter table
> patientaggregatereport add constraint fk_patientaggregatereport_userid
> foreign key (userid) references userinfo (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,774 ERROR: must be owner of relation
> patientaggregatereport (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,777 HHH000388: Unsuccessful: alter table
> patientaggregatereport_enddates add constraint FKAA499D9B2B6A4DA6 foreign
> key (patientaggregatereportid) references patientaggregatereport
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,778 ERROR: must be owner of relation
> patientaggregatereport_enddates (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,781 HHH000388: Unsuccessful: alter table
> patientaggregatereport_filtervalues add constraint
> fk_patientaggregatereportid_filtervalues foreign key
> (patientaggregatereportid) references patientaggregatereport
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,782 ERROR: must be owner of relation
> patientaggregatereport_filtervalues (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,786 HHH000388: Unsuccessful: alter table
> patientaggregatereport_fixedperiods add constraint FK3824AF6F2B6A4DA6
> foreign key (patientaggregatereportid) references patientaggregatereport
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,788 ERROR: must be owner of relation
> patientaggregatereport_fixedperiods (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,791 HHH000388: Unsuccessful: alter table
> patientaggregatereport_organisationUnits add constraint
> fk_patientaggregatereportid_organisationunit foreign key
> (organisationunitid) references organisationunit (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,792 ERROR: must be owner of relation
> patientaggregatereport_organisationunits (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,798 HHH000388: Unsuccessful: alter table
> patientaggregatereport_organisationUnits add constraint
> fk_patientaggregatereport_organisationunitid foreign key
> (patientaggregatereportid) references patientaggregatereport
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,799 ERROR: must be owner of relation
> patientaggregatereport_organisationunits (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,802 HHH000388: Unsuccessful: alter table
> patientaggregatereport_relativeperiods add constraint
> fk_patientaggregatereportid_relativeperiods foreign key
> (patientaggregatereportid) references patientaggregatereport
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,803 ERROR: must be owner of relation
> patientaggregatereport_relativeperiods (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,806 HHH000388: Unsuccessful: alter table
> patientaggregatereport_startdates add constraint FKE073FE342B6A4DA6
> foreign key (patientaggregatereportid) references patientaggregatereport
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,806 ERROR: must be owner of relation
> patientaggregatereport_startdates (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,809 HHH000388: Unsuccessful: alter table
> patientaggregatereportusergroupaccesses add constraint FKF280A258C10E4182
> foreign key (usergroupaccessid) references usergroupaccess
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,810 ERROR: must be owner of relation
> patientaggregatereportusergroupaccesses (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,816 HHH000388: Unsuccessful: alter table
> patientaggregatereportusergroupaccesses add constraint FKF280A2582B6A4DA6
> foreign key (patientaggregatereportid) references patientaggregatereport
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,817 ERROR: must be owner of relation
> patientaggregatereportusergroupaccesses (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,820 HHH000388: Unsuccessful: alter table
> patientattribute add constraint fk_attribute_group foreign key
> (patientattributegroupid) references patientattributegroup
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,823 ERROR: must be owner of relation
> patientattribute (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,826 HHH000388: Unsuccessful: alter table
> patientattribute add constraint FK9D9B5537E05A5BD0 foreign key
> (patientmobilesettingid) references patientmobilesetting (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,827 ERROR: must be owner of relation
> patientattribute (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,832 HHH000388: Unsuccessful: alter table
> patientattributeoption add constraint fk_patientattributeoption_patientattributeid
> foreign key (patientattributeid) references patientattribute
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,834 ERROR: must be owner of relation
> patientattributeoption (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,837 HHH000388: Unsuccessful: alter table
> patientattributevalue add constraint fk_patientattributevalue_patientid
> foreign key (patientid) references patient (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,838 ERROR: must be owner of relation
> patientattributevalue (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,840 HHH000388: Unsuccessful: alter table
> patientattributevalue add constraint fk_patientattributevalue_patientattributeid
> foreign key (patientattributeid) references patientattribute
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,841 ERROR: must be owner of relation
> patientattributevalue (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,845 HHH000388: Unsuccessful: alter table
> patientattributevalue add constraint fk_patientAttributeValue_patientAttributeOption
> foreign key (patientattributeoptionid) references patientattributeoption
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,846 ERROR: must be owner of relation
> patientattributevalue (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,849 HHH000388: Unsuccessful: alter table
> patientaudit add constraint fk_patientauditid_patientid foreign key
> (patientid) references patient (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,850 ERROR: must be owner of relation
> patientaudit (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,854 HHH000388: Unsuccessful: alter table
> patientcomment add constraint FK200983BABACED27D foreign key
> (programstageinstanceid) references programstageinstance (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,855 ERROR: must be owner of relation
> patientcomment (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,860 HHH000388: Unsuccessful: alter table
> patientdatavalue add constraint fk_patientdatavalue_programstageinstanceid
> foreign key (programstageinstanceid) references programstageinstance
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,861 ERROR: must be owner of relation
> patientdatavalue (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,864 HHH000388: Unsuccessful: alter table
> patientdatavalue add constraint fk_patientdatavalue_dataelementid foreign
> key (dataelementid) references dataelement (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,865 ERROR: must be owner of relation
> patientdatavalue (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,868 HHH000388: Unsuccessful: alter table
> patientidentifier add constraint fk_patientidentifier_patient foreign key
> (patientid) references patient (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,869 ERROR: there is no primary key for
> referenced table "patient" (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,872 HHH000388: Unsuccessful: alter table
> patientregistrationform add constraint fk_patientregistrationform_programid
> foreign key (programid) references program (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,873 ERROR: must be owner of relation
> patientregistrationform (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,875 HHH000388: Unsuccessful: alter table
> patientregistrationform add constraint fk_patientregistrationform_dataentryformid
> foreign key (dataEntryForm) references dataentryform (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,885 ERROR: must be owner of relation
> patientregistrationform (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,887 HHH000388: Unsuccessful: alter table
> patientreminder add constraint FKE625D677A3100C9F foreign key (programid)
> references program (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,888 ERROR: must be owner of relation
> patientreminder (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,893 HHH000388: Unsuccessful: alter table
> patientreminder add constraint FKE625D6778704EE73 foreign key
> (programStageid) references programstage (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,894 ERROR: must be owner of relation
> patientreminder (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,896 HHH000388: Unsuccessful: alter table
> patienttabularreport add constraint fk_patientaggregatereport_programstage
> foreign key (programstageid) references programstage (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,897 ERROR: must be owner of relation
> patienttabularreport (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,899 HHH000388: Unsuccessful: alter table
> patienttabularreport add constraint fk_patienttabularreport_userid foreign
> key (userid) references userinfo (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,899 ERROR: must be owner of relation
> patienttabularreport (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,901 HHH000388: Unsuccessful: alter table
> patienttabularreport_filtervalues add constraint
> fk_patienttabularreportid_filtervalues foreign key
> (patientaggregatereportid) references patienttabularreport
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,902 ERROR: must be owner of relation
> patienttabularreport_filtervalues (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,904 HHH000388: Unsuccessful: alter table
> patienttabularreport_organisationUnits add constraint
> fk_patienttabularreportid_organisationunit foreign key
> (organisationunitid) references organisationunit (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,905 ERROR: must be owner of relation
> patienttabularreport_organisationunits (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,908 HHH000388: Unsuccessful: alter table
> patienttabularreport_organisationUnits add constraint
> fk_patienttabularreport_organisationUnitid foreign key
> (patienttabularreportid) references patienttabularreport (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,911 ERROR: must be owner of relation
> patienttabularreport_organisationunits (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,916 HHH000388: Unsuccessful: alter table
> patienttabularreportusergroupaccesses add constraint FK4C2B557AC10E4182
> foreign key (usergroupaccessid) references usergroupaccess
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,917 ERROR: must be owner of relation
> patienttabularreportusergroupaccesses (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,921 HHH000388: Unsuccessful: alter table
> patienttabularreportusergroupaccesses add constraint FK4C2B557AD6A4FF22
> foreign key (patienttabularreportid) references patienttabularreport
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,922 ERROR: must be owner of relation
> patienttabularreportusergroupaccesses (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,926 HHH000388: Unsuccessful: alter table
> program_patientAttributes add constraint fk_program_patientAttributes_patientattributeid
> foreign key (patientattributeid) references patientattribute
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,927 ERROR: must be owner of relation
> program_patientattributes (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,931 HHH000388: Unsuccessful: alter table
> program_patientAttributes add constraint fk_program_patientAttributes_programid
> foreign key (programid) references program (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,933 ERROR: must be owner of relation
> program_patientattributes (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,935 HHH000388: Unsuccessful: alter table
> program_patientIdentifierTypes add constraint fk_program_
> patientIdentifierTypes_patientidentifiertypeid foreign key
> (patientidentifiertypeid) references patientidentifiertype
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,936 ERROR: must be owner of relation
> program_patientidentifiertypes (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,939 HHH000388: Unsuccessful: alter table
> program_patientIdentifierTypes add constraint fk_program_
> patientIdentifierTypes_programid foreign key (programid) references
> program (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,940 ERROR: must be owner of relation
> program_patientidentifiertypes (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,948 HHH000388: Unsuccessful: alter table
> programinstance add constraint fk_programinstance_patientid foreign key
> (patientid) references patient (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,949 ERROR: must be owner of relation
> programinstance (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,953 HHH000388: Unsuccessful: alter table
> programinstance add constraint fk_programinstance_patientcommentid
> foreign key (patientcommentid) references patientcomment (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,954 ERROR: must be owner of relation
> programinstance (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,957 HHH000388: Unsuccessful: alter table
> programstage add constraint fk_programstage_dataentryform foreign key
> (dataEntryForm) references dataentryform (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,960 ERROR: must be owner of relation
> programstage (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,971 HHH000388: Unsuccessful: alter table
> relationship add constraint fk_relationship_patientida foreign key
> (patientaid) references patient (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,971 ERROR: must be owner of relation
> relationship (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,974 HHH000388: Unsuccessful: alter table
> relationship add constraint fk_relationship_patientidb foreign key
> (patientbid) references patient (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,975 ERROR: must be owner of relation
> relationship (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,979 HHH000388: Unsuccessful: alter table
> school add constraint fk_school_organisationunitid foreign key
> (organisationunitid) references organisationunit (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,983 ERROR: must be owner of relation school
> (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,985 HHH000388: Unsuccessful: alter table
> school_ovc add constraint fk_school_patientid foreign key (patientid)
> references patient (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,985 ERROR: must be owner of relation
> school_ovc (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,987 HHH000388: Unsuccessful: alter table
> school_ovc add constraint fk_school_ovc_schoolid foreign key (schoolid)
> references school (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,988 ERROR: must be owner of relation
> school_ovc (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,990 HHH000388: Unsuccessful: alter table
> schooldetails add constraint fk_schooldetails_schoolid foreign key
> (schoolid) references school (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,991 ERROR: must be owner of relation
> schooldetails (SchemaUpdate.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,992 HHH000388: Unsuccessful: alter table
> schooldetails add constraint fk_schooldetails_patientattributeid foreign
> key (patientattributeid) references patientattribute (SchemaUpdate.java
> [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:41,993 ERROR: must be owner of relation
> schooldetails (SchemaUpdate.java [localhost-startStop-1])
> * INFO  2016-08-01 13:01:48,503 Found the following message senders:
> [org.hisp.dhis.message.EmailMessageSender@57ec63bd,
> org.hisp.dhis.sms.outbound.SmsSender@1b66abf6]
> (DefaultMessageService.java [localhost-startStop-1])
> * WARN  2016-08-01 13:01:54,188 SQL Error: 0, SQLState: 42501
> (SqlExceptionHelper.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:54,189 ERROR: permission denied for relation
> systemsetting (SqlExceptionHelper.java [localhost-startStop-1])
> * INFO  2016-08-01 13:01:54,239 Camel context stopped
> (DHIS2LifecycleStrategy.java [localhost-startStop-1])
> * ERROR 2016-08-01 13:01:54,291 Context initialization failed
> (ContextLoader.java [localhost-startStop-1])
> org.springframework.beans.factory.BeanCreationException: Error creating
> bean with name 'org.hisp.dhis.patient.scheduling.ProgramSchedulingManager'
> defined in URL [jar:file:/tomcat-dhis/webapps/ovc/WEB-INF/lib/dhis-
> service-patient-2.12.jar!/META-INF/dhis/beans.xml]: Invocation of init
> method failed; nested exception is org.hibernate.exception.SQLGrammarException:
> could not extract ResultSet
>     at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.initializeBean(
> AbstractAutowireCapableBeanFactory.java:1488)
>     at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.doCreateBean(
> AbstractAutowireCapableBeanFactory.java:524)
>     at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.createBean(
> AbstractAutowireCapableBeanFactory.java:461)
>     at org.springframework.beans.factory.support.AbstractBeanFactory$1.
> getObject(AbstractBeanFactory.java:295)
>     at org.springframework.beans.factory.support.
> DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.
> java:223)
>     at org.springframework.beans.factory.support.
> AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:292)
>     at org.springframework.beans.factory.support.
> AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
>     at org.springframework.beans.factory.support.
> DefaultListableBeanFactory.preInstantiateSingletons(
> DefaultListableBeanFactory.java:626)
>     at org.springframework.context.support.AbstractApplicationContext.
> finishBeanFactoryInitialization(AbstractApplicationContext.java:932)
>     at org.springframework.context.support.AbstractApplicationContext.
> refresh(AbstractApplicationContext.java:479)
>     at org.springframework.web.context.ContextLoader.
> configureAndRefreshWebApplicationContext(ContextLoader.java:389)
>     at org.springframework.web.context.ContextLoader.
> initWebApplicationContext(ContextLoader.java:294)
>     at org.springframework.web.context.ContextLoaderListener.
> contextInitialized(ContextLoaderListener.java:112)
>     at org.apache.catalina.core.StandardContext.listenerStart(
> StandardContext.java:5010)
>     at org.apache.catalina.core.StandardContext.startInternal(
> StandardContext.java:5504)
>     at org.apache.catalina.util.LifecycleBase.start(
> LifecycleBase.java:150)
>     at org.apache.catalina.core.ContainerBase.addChildInternal(
> ContainerBase.java:901)
>     at org.apache.catalina.core.ContainerBase.addChild(
> ContainerBase.java:877)
>     at org.apache.catalina.core.StandardHost.addChild(
> StandardHost.java:632)
>     at org.apache.catalina.startup.HostConfig.deployWAR(
> HostConfig.java:1073)
>     at org.apache.catalina.startup.HostConfig$DeployWar.run(
> HostConfig.java:1857)
>     at java.util.concurrent.Executors$RunnableAdapter.
> call(Executors.java:511)
>     at java.util.concurrent.FutureTask.run(FutureTask.java:266)
>     at java.util.concurrent.ThreadPoolExecutor.runWorker(
> ThreadPoolExecutor.java:1142)
>     at java.util.concurrent.ThreadPoolExecutor$Worker.run(
> ThreadPoolExecutor.java:617)
>     at java.lang.Thread.run(Thread.java:745)
> Caused by: org.hibernate.exception.SQLGrammarException: could not extract
> ResultSet
>     at org.hibernate.exception.internal.SQLStateConversionDelegate.
> convert(SQLStateConversionDelegate.java:122)
>     at org.hibernate.exception.internal.StandardSQLExceptionConverter.
> convert(StandardSQLExceptionConverter.java:49)
>     at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(
> SqlExceptionHelper.java:125)
>     at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(
> SqlExceptionHelper.java:110)
>     at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.
> extract(ResultSetReturnImpl.java:61)
>     at org.hibernate.loader.Loader.getResultSet(Loader.java:2031)
>     at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1832)
>     at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1811)
>     at org.hibernate.loader.Loader.doQuery(Loader.java:899)
>     at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCol
> lections(Loader.java:341)
>     at org.hibernate.loader.Loader.doList(Loader.java:2516)
>     at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2361)
>     at org.hibernate.loader.Loader.list(Loader.java:2324)
>     at org.hibernate.loader.criteria.CriteriaLoader.list(
> CriteriaLoader.java:124)
>     at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1661)
>     at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:374)
>     at org.hibernate.internal.CriteriaImpl.uniqueResult(
> CriteriaImpl.java:396)
>     at org.hisp.dhis.hibernate.HibernateGenericStore.getObject(
> HibernateGenericStore.java:195)
>     at org.hisp.dhis.hibernate.HibernateGenericStore.getByName(
> HibernateGenericStore.java:327)
>     at org.hisp.dhis.setting.DefaultSystemSettingManager.getSystemSetting(
> DefaultSystemSettingManager.java:99)
>     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>     at sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:62)
>     at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:43)
>     at java.lang.reflect.Method.invoke(Method.java:498)
>     at org.springframework.aop.support.AopUtils.
> invokeJoinpointUsingReflection(AopUtils.java:317)
>     at org.springframework.aop.framework.ReflectiveMethodInvocation.
> invokeJoinpoint(ReflectiveMethodInvocation.java:183)
>     at org.springframework.aop.framework.ReflectiveMethodInvocation.
> proceed(ReflectiveMethodInvocation.java:150)
>     at org.springframework.transaction.interceptor.
> TransactionInterceptor$1.proceedWithInvocation(
> TransactionInterceptor.java:96)
>     at org.springframework.transaction.interceptor.
> TransactionAspectSupport.invokeWithinTransaction(
> TransactionAspectSupport.java:260)
>     at org.springframework.transaction.interceptor.
> TransactionInterceptor.invoke(TransactionInterceptor.java:94)
>     at org.springframework.aop.framework.ReflectiveMethodInvocation.
> proceed(ReflectiveMethodInvocation.java:172)
>     at org.springframework.aop.framework.JdkDynamicAopProxy.
> invoke(JdkDynamicAopProxy.java:204)
>     at com.sun.proxy.$Proxy96.getSystemSetting(Unknown Source)
>     at org.hisp.dhis.patient.scheduling.DefaultProgramSchedulingManage
> r.getScheduledTasks(DefaultProgramSchedulingManager.java:123)
>     at org.hisp.dhis.patient.scheduling.DefaultProgramSchedulingManage
> r.scheduleTasks(DefaultProgramSchedulingManager.java:77)
>     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>     at sun.reflect.NativeMethodAccessorImpl.invoke(
> NativeMethodAccessorImpl.java:62)
>     at sun.reflect.DelegatingMethodAccessorImpl.invoke(
> DelegatingMethodAccessorImpl.java:43)
>     at java.lang.reflect.Method.invoke(Method.java:498)
>     at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(
> AbstractAutowireCapableBeanFactory.java:1614)
>     at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.invokeInitMethods(
> AbstractAutowireCapableBeanFactory.java:1555)
>     at org.springframework.beans.factory.support.
> AbstractAutowireCapableBeanFactory.initializeBean(
> AbstractAutowireCapableBeanFactory.java:1485)
>     ... 25 more
> Caused by: org.postgresql.util.PSQLException: ERROR: permission denied
> for relation systemsetting
>     at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(
> QueryExecutorImpl.java:2103)
>     at org.postgresql.core.v3.QueryExecutorImpl.processResults(
> QueryExecutorImpl.java:1836)
>     at org.postgresql.core.v3.QueryExecutorImpl.execute(
> QueryExecutorImpl.java:257)
>     at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(
> AbstractJdbc2Statement.java:512)
>     at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(
> AbstractJdbc2Statement.java:388)
>     at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(
> AbstractJdbc2Statement.java:273)
>     at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(
> NewProxyPreparedStatement.java:76)
>     at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.
> extract(ResultSetReturnImpl.java:56)
>     ... 62 more
> Aug 01, 2016 1:01:54 PM org.apache.catalina.core.StandardContext
> startInternal
> SEVERE: Error listenerStart
> Aug 01, 2016 1:01:54 PM org.apache.catalina.core.StandardContext
> startInternal
> SEVERE: Context [/ovc] startup failed due to previous errors
> * INFO  2016-08-01 13:01:54,335 De-registering jdbc driver:
> org.postgresql.Driver@264aa07a (StartupListener.java
> [localhost-startStop-1])
> Aug 01, 2016 1:01:54 PM org.apache.catalina.loader.WebappClassLoader
> checkThreadLocalMapForLeaks
> SEVERE: The web application [/ovc] created a ThreadLocal with key of type
> [com.sun.xml.bind.v2.ClassFactory$1] (value [com.sun.xml.bind.v2.
> ClassFactory$1@472b6e8c]) and a value of type [java.util.WeakHashMap]
> (value [{class org.apache.camel.model.PackageScanDefinition=java.
> lang.ref.WeakReference@48b1cac, class org.apache.camel.spring.
> CamelProducerTemplateFactoryBean=java.lang.ref.WeakReference@7478fd75,
> class javax.xml.bind.annotation.adapters.CollapsedStringAdapter=java.
> lang.ref.WeakReference@745456bc, class java.util.ArrayList=java.lang.
> ref.WeakReference@689719b4, class org.apache.camel.spring.
> CamelContextFactoryBean=java.lang.ref.WeakReference@34a50676}]) but
> failed to remove it when the web application was stopped. Threads are going
> to be renewed over time to try and avoid a probable memory leak.
> Aug 01, 2016 1:01:54 PM org.apache.coyote.AbstractProtocol start
> INFO: Starting ProtocolHandler ["http-bio-8080"]
> Aug 01, 2016 1:01:54 PM org.apache.catalina.startup.Catalina start
> INFO: Server startup in 38598 ms
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to     : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://dhis2.org
References

Error
From: Collins McAdoyo, 2016-08-01