dhis2-users team mailing list archive

Thread
Date
Error

To: dhis2-users@xxxxxxxxxxxxxxxxxxx
From: Collins McAdoyo <collins.adoyo@xxxxxxxxx>
Date: Mon, 1 Aug 2016 14:26:11 +0300
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(AbstractAutowireCapableBeanFac
tory.java:461)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.
getObject(AbstractBeanFactory.java:295)
    at org.springframework.beans.factory.support.
DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.
java:223)
    at org.springframework.beans.factory.support.
AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:292)
    at org.springframework.beans.factory.support.
AbstractBeanFactory.getBean(AbstractBeanFactory.java:194)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.
preInstantiateSingletons(DefaultListableBeanFactory.java:626)
    at org.springframework.context.support.AbstractApplicationContext.
finishBeanFactoryInitialization(AbstractApplicationContext.java:932)
    at org.springframework.context.support.AbstractApplicationContext.
refresh(AbstractApplicationContext.java:479)
    at org.springframework.web.context.ContextLoader.
configureAndRefreshWebApplicationContext(ContextLoader.java:389)
    at org.springframework.web.context.ContextLoader.
initWebApplicationContext(ContextLoader.java:294)
    at org.springframework.web.context.ContextLoaderListener.
contextInitialized(ContextLoaderListener.java:112)
    at org.apache.catalina.core.StandardContext.listenerStart(
StandardContext.java:5010)
    at org.apache.catalina.core.StandardContext.startInternal(
StandardContext.java:5504)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
    at org.apache.catalina.core.ContainerBase.addChildInternal(
ContainerBase.java:901)
    at org.apache.catalina.core.ContainerBase.addChild(
ContainerBase.java:877)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:632)
    at org.apache.catalina.startup.HostConfig.deployWAR(
HostConfig.java:1073)
    at org.apache.catalina.startup.HostConfig$DeployWar.run(
HostConfig.java:1857)
    at java.util.concurrent.Executors$RunnableAdapter.
call(Executors.java:511)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(
ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(
ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)
Caused by: org.hibernate.exception.SQLGrammarException: could not extract
ResultSet
    at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(
SQLStateConversionDelegate.java:122)
    at org.hibernate.exception.internal.StandardSQLExceptionConverter.
convert(StandardSQLExceptionConverter.java:49)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(
SqlExceptionHelper.java:125)
    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(
SqlExceptionHelper.java:110)
    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.
extract(ResultSetReturnImpl.java:61)
    at org.hibernate.loader.Loader.getResultSet(Loader.java:2031)
    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1832)
    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1811)
    at org.hibernate.loader.Loader.doQuery(Loader.java:899)
    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCol
lections(Loader.java:341)
    at org.hibernate.loader.Loader.doList(Loader.java:2516)
    at org.hibernate.loader.Loader.listUsingQueryCache(Loader.java:2361)
    at org.hibernate.loader.Loader.list(Loader.java:2324)
    at org.hibernate.loader.criteria.CriteriaLoader.list(
CriteriaLoader.java:124)
    at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1661)
    at org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:374)
    at org.hibernate.internal.CriteriaImpl.uniqueResult(
CriteriaImpl.java:396)
    at org.hisp.dhis.hibernate.HibernateGenericStore.getObject(
HibernateGenericStore.java:195)
    at org.hisp.dhis.hibernate.HibernateGenericStore.getByName(
HibernateGenericStore.java:327)
    at org.hisp.dhis.setting.DefaultSystemSettingManager.getSystemSetting(
DefaultSystemSettingManager.java:99)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.aop.support.AopUtils.
invokeJoinpointUsingReflection(AopUtils.java:317)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.
invokeJoinpoint(ReflectiveMethodInvocation.java:183)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:150)
    at org.springframework.transaction.interceptor.TransactionInterceptor$1.
proceedWithInvocation(TransactionInterceptor.java:96)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.
invokeWithinTransaction(TransactionAspectSupport.java:260)
    at org.springframework.transaction.interceptor.
TransactionInterceptor.invoke(TransactionInterceptor.java:94)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
ReflectiveMethodInvocation.java:172)
    at org.springframework.aop.framework.JdkDynamicAopProxy.
invoke(JdkDynamicAopProxy.java:204)
    at com.sun.proxy.$Proxy96.getSystemSetting(Unknown Source)
    at org.hisp.dhis.patient.scheduling.DefaultProgramSchedulingManage
r.getScheduledTasks(DefaultProgramSchedulingManager.java:123)
    at org.hisp.dhis.patient.scheduling.DefaultProgramSchedulingManage
r.scheduleTasks(DefaultProgramSchedulingManager.java:77)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.springframework.beans.factory.support.
AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(
AbstractAutowireCapableBeanFactory.java:1614)
    at org.springframework.beans.factory.support.
AbstractAutowireCapableBeanFactory.invokeInitMethods(
AbstractAutowireCapableBeanFactory.java:1555)
    at org.springframework.beans.factory.support.
AbstractAutowireCapableBeanFactory.initializeBean(
AbstractAutowireCapableBeanFactory.java:1485)
    ... 25 more
Caused by: org.postgresql.util.PSQLException: ERROR: permission denied for
relation systemsetting
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(
QueryExecutorImpl.java:2103)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(
QueryExecutorImpl.java:1836)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(
QueryExecutorImpl.java:257)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(
AbstractJdbc2Statement.java:512)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(
AbstractJdbc2Statement.java:388)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(
AbstractJdbc2Statement.java:273)
    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(
NewProxyPreparedStatement.java:76)
    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.
extract(ResultSetReturnImpl.java:56)
    ... 62 more
Aug 01, 2016 1:01:54 PM org.apache.catalina.core.StandardContext
startInternal
SEVERE: Error listenerStart
Aug 01, 2016 1:01:54 PM org.apache.catalina.core.StandardContext
startInternal
SEVERE: Context [/ovc] startup failed due to previous errors
* INFO  2016-08-01 13:01:54,335 De-registering jdbc driver:
org.postgresql.Driver@264aa07a (StartupListener.java
[localhost-startStop-1])
Aug 01, 2016 1:01:54 PM org.apache.catalina.loader.WebappClassLoader
checkThreadLocalMapForLeaks
SEVERE: The web application [/ovc] created a ThreadLocal with key of type
[com.sun.xml.bind.v2.ClassFactory$1] (value [com.sun.xml.bind.v2.
ClassFactory$1@472b6e8c]) and a value of type [java.util.WeakHashMap]
(value [{class org.apache.camel.model.PackageScanDefinition=java.
lang.ref.WeakReference@48b1cac, class org.apache.camel.spring.
CamelProducerTemplateFactoryBean=java.lang.ref.WeakReference@7478fd75,
class javax.xml.bind.annotation.adapters.CollapsedStringAdapter=java.
lang.ref.WeakReference@745456bc, class java.util.ArrayList=java.lang.
ref.WeakReference@689719b4, class org.apache.camel.spring.
CamelContextFactoryBean=java.lang.ref.WeakReference@34a50676}]) but failed
to remove it when the web application was stopped. Threads are going to be
renewed over time to try and avoid a probable memory leak.
Aug 01, 2016 1:01:54 PM org.apache.coyote.AbstractProtocol start
INFO: Starting ProtocolHandler ["http-bio-8080"]
Aug 01, 2016 1:01:54 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 38598 ms
Follow ups

Re: Error
From: Knut Staring, 2016-08-01