Error

Collins_McAdoyo · 1 August 2016 11:26

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.doQueryAndInitializeNonLazyCollections(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.DefaultProgramSchedulingManager.getScheduledTasks(DefaultProgramSchedulingManager.java:123)
at org.hisp.dhis.patient.scheduling.DefaultProgramSchedulingManager.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

Knut_Staring · 1 August 2016 13:44

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@gmail.com 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.doQueryAndInitializeNonLazyCollections(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.DefaultProgramSchedulingManager.getScheduledTasks(DefaultProgramSchedulingManager.java:123)
at org.hisp.dhis.patient.scheduling.DefaultProgramSchedulingManager.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@lists.launchpad.net

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