dhis2-users team mailing list archive

Thread
Date
Fwd: Problem with hibernate_sequence on DHIS2 2.22 installation process

To: dhis2-users@xxxxxxxxxxxxxxxxxxx, babacar2005@xxxxxxxxxxx
From: Knut Staring <knutst@xxxxxxxxx>
Date: Thu, 29 Sep 2016 02:03:44 +0200
In-reply-to: <20160928171849.23585.4577.launchpad@gac.canonical.com>
---------- Forwarded message ----------
From: "Babacar NGOM" <babacar2005@xxxxxxxxxxx>
Date: Sep 28, 2016 7:18 PM
Subject: Problem with hibernate_sequence on DHIS2 2.22 installation process
To: "Knut Staring" <knutst@xxxxxxxxx>
Cc:

Hello,
I am about to install version 2.22 of DHIS2. After deployment, my
console displays the following errors:

ERROR 2016-09-28 11:47:20,754 ERROR: sequence "hibernate_sequence" does
not exist (SchemaExport.java [localhost-startStop-1])

Thank you to bring your help if possible.

For completeness I add the lines from the log file catalina.out:

* ERROR 2016-09-28 11: 47: 19.398 ERROR: relation "attribute" does not
exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.401 HHH000389: Unsuccessful: alter table
drop constraint fk_attributevalue_attributeid AttributeValue
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.404 ERROR: relation "AttributeValue" does
not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.407 HHH000389: Unsuccessful: alter table
drop constraint caseaggregationcondition
fk_caseaggregationcondition_dataelement (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.409 ERROR: relation
"caseaggregationcondition" does not exist (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.413 HHH000389: Unsuccessful: alter table
drop constraint caseaggregationcondition
fk_caseaggregationcondition_categoryoptioncomboid (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.414 ERROR: relation
"caseaggregationcondition" does not exist (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.421 HHH000389: Unsuccessful: alter table
drop constraint caseaggregationcondition
fk_caseaggregationcondition_deSum (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.421 ERROR: relation
"caseaggregationcondition" does not exist (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.427 HHH000389: Unsuccessful: alter table
drop constraint categories_categoryoptions fk_category_categoryoptionid
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.428 ERROR: relation
"categories_categoryoptions" does not exist (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.430 HHH000389: Unsuccessful: alter table
drop constraint categories_categoryoptions
fk_categories_categoryoptions_categoryid (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.431 ERROR: relation
"categories_categoryoptions" does not exist (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.433 HHH000389: Unsuccessful: alter table
drop constraint categorycombo fk_categorycombo_userid (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.433 ERROR: relation "categorycombo" does
not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.442 HHH000389: Unsuccessful: alter table
drop constraint categorycombos_categories
fk_categorycombos_categories_categorycomboid (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.443 ERROR: relation
"categorycombos_categories" does not exist (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.444 HHH000389: Unsuccessful: alter table
drop constraint categorycombos_categories fk_categorycombo_categoryid
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.445 ERROR: relation
"categorycombos_categories" does not exist (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.447 HHH000389: Unsuccessful: alter table
drop constraint categorycombos_optioncombos
fk_categorycombo_categoryoptioncomboid (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.447 ERROR: relation
"categorycombos_optioncombos" does not exist (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.449 HHH000389: Unsuccessful: alter table
drop constraint categorycombos_optioncombos
fk_categorycombos_optioncombos_categorycomboid (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.449 ERROR: relation
"categorycombos_optioncombos" does not exist (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.451 HHH000389: Unsuccessful: alter table
drop constraint categorycombousergroupaccesses
FK_p95o4dnytx8vxb7yugxlu2hhf (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.451 ERROR: relation
"categorycombousergroupaccesses" does not exist (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.462 HHH000389: Unsuccessful: alter table
drop constraint categorycombousergroupaccesses
FK_84l0gr1y8gnprsgxs3031v00i (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.463 ERROR: relation
"categorycombousergroupaccesses" does not exist (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.464 HHH000389: Unsuccessful: alter table
drop constraint categorydimension fk_categorydimension_category
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.465 ERROR: relation "categorydimension"
does not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.466 HHH000389: Unsuccessful: alter table
drop constraint categorydimension_items
fk_categorydimension_items_categoryoptionid (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19,467 ERROR: relation
"categorydimension_items" does not exist (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.469 HHH000389: Unsuccessful: alter table
drop constraint categorydimension_items
fk_categorydimension_items_categorydimensionid (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.469 ERROR: relation
"categorydimension_items" does not exist (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.471 HHH000389: Unsuccessful: alter table
drop constraint categoryoption_organisationunits
fk_categoryoption_organisationunits_organisationunitid
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.472 ERROR: relation
"categoryoption_organisationunits" does not exist (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.473 HHH000389: Unsuccessful: alter table
drop constraint categoryoption_organisationunits
fk_categoryoption_organisationunits_categoryoptionid (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.474 ERROR: relation
"categoryoption_organisationunits" does not exist (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.476 HHH000389: Unsuccessful: alter table
drop constraint categoryoptioncombos_categoryoptions
fk_categoryoptioncombos_categoryoptions_categoryoptioncomboid
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.476 ERROR: relation
"categoryoptioncombos_categoryoptions" does not exist (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.486 HHH000389: Unsuccessful: alter table
drop constraint categoryoptioncombos_categoryoptions
fk_categoryoptioncombo_categoryoptionid (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.487 ERROR: relation
"categoryoptioncombos_categoryoptions" does not exist (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.489 HHH000389: Unsuccessful: alter table
drop constraint categoryoptiongroup fk_categoryoptiongroup_userid
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.489 ERROR: relation "categoryoptiongroup"
does not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.491 HHH000389: Unsuccessful: alter table
drop constraint categoryoptiongroupattributevalues
FK_287ampe6pn4aepyn14hv71907 (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.492 ERROR: relation
"categoryoptiongroupattributevalues" does not exist (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.494 HHH000389: Unsuccessful: alter table
drop constraint categoryoptiongroupattributevalues
FK_3ebjdp5gqlb90il4grn8u8xg5 (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.494 ERROR: relation
"categoryoptiongroupattributevalues" does not exist (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.496 HHH000389: Unsuccessful: alter table
drop constraint categoryoptiongroupmembers
fk_categoryoptiongroupmembers_categoryoptiongroupid (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.497 ERROR: relation
"categoryoptiongroupmembers" does not exist (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.505 HHH000389: Unsuccessful: alter table
drop constraint categoryoptiongroupmembers
fk_categoryoptiongroupmembers_categoryoptionid (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.505 ERROR: relation
"categoryoptiongroupmembers" does not exist (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.507 HHH000389: Unsuccessful: alter table
drop constraint categoryoptiongroupset fk_categoryoptiongroupset_userid
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.508 ERROR: relation
"categoryoptiongroupset" does not exist (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.510 HHH000389: Unsuccessful: alter table
drop constraint categoryoptiongroupsetmembers
fk_categoryoptiongroupsetmembers_categoryoptiongroupid
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.510 ERROR: relation
"categoryoptiongroupsetmembers" does not exist (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.512 HHH000389: Unsuccessful: alter table
drop constraint categoryoptiongroupsetmembers
fk_categoryoptiongroupsetmembers_categoryoptiongroupsetid
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.512 ERROR: relation
"categoryoptiongroupsetmembers" does not exist (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.514 HHH000389: Unsuccessful: alter table
drop constraint categoryoptiongroupsetusergroupaccesses
FK_3tn4w8rs68lpvrdaksbsalta7 (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.514 ERROR: relation
"categoryoptiongroupsetusergroupaccesses" does not exist
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.526 HHH000389: Unsuccessful: alter table
drop constraint categoryoptiongroupsetusergroupaccesses
FK_aifepg7627cpodnvy0xjc2ae5 (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.527 ERROR: relation
"categoryoptiongroupsetusergroupaccesses" does not exist
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.528 HHH000389: Unsuccessful: alter table
drop constraint categoryoptiongroupusergroupaccesses
FK_kw8ong945syafd2310ahwfu9l (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.529 ERROR: relation
"categoryoptiongroupusergroupaccesses" does not exist (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.531 HHH000389: Unsuccessful: alter table
drop constraint categoryoptiongroupusergroupaccesses
FK_9lhu9n0rwxfpdv0tbvvi683dx (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.531 ERROR: relation
"categoryoptiongroupusergroupaccesses" does not exist (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.533 HHH000389: Unsuccessful: alter table
drop constraint chart fk_chart_relativeperiodsid (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.534 ERROR: relation "chart" does not exist
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.535 HHH000389: Unsuccessful: alter table
drop constraint chart fk_chart_userid (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.536 ERROR: relation "chart" does not exist
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.538 HHH000389: Unsuccessful: alter table
drop constraint chart_categorydimensions
fk_chart_categorydimensions_categorydimensionid (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.538 ERROR: relation
"chart_categorydimensions" does not exist (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.540 HHH000389: Unsuccessful: alter table
drop constraint chart_categorydimensions
fk_chart_categorydimensions_chartid (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.541 ERROR: relation
"chart_categorydimensions" does not exist (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.549 HHH000389: Unsuccessful: alter table
drop constraint chart_categoryoptiongroups
fk_chart_categoryoptiongroups_categoryoptiongroupid (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.549 ERROR: relation
"chart_categoryoptiongroups" does not exist (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.551 HHH000389: Unsuccessful: alter table
drop constraint chart_categoryoptiongroups
fk_chart_categoryoptiongroups_chartid (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.552 ERROR: relation
"chart_categoryoptiongroups" does not exist (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.554 HHH000389: Unsuccessful: alter table
drop constraint chart_datadimensionitems
fk_chart_datadimensionitems_datadimensionitemid (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.554 ERROR: relation
"chart_datadimensionitems" does not exist (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.556 HHH000389: Unsuccessful: alter table
drop constraint chart_datadimensionitems
fk_chart_datadimensionitems_chartid (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.556 ERROR: relation
"chart_datadimensionitems" does not exist (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.558 HHH000389: Unsuccessful: alter table
drop constraint chart_dataelementgroups
fk_chart_dataelementgroups_dataelementgroupid (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.559 ERROR: relation
"chart_dataelementgroups" does not exist (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.569 HHH000389: Unsuccessful: alter table
drop constraint chart_dataelementgroups
fk_chart_dataelementgroups_chartid (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.569 ERROR: relation
"chart_dataelementgroups" does not exist (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.571 HHH000389: Unsuccessful: alter table
drop constraint chart_filters FK_d092ulk11oo8kdwieke857qkp
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.572 ERROR: relation "chart_filters" does
not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.573 HHH000389: Unsuccessful: alter table
drop constraint chart_itemorgunitgroups
fk_chart_itemorgunitgroups_orgunitgroupid (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.574 ERROR: relation
"chart_itemorgunitgroups" does not exist (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.575 HHH000389: Unsuccessful: alter table
drop constraint chart_itemorgunitgroups
fk_chart_itemorgunitunitgroups_chartid (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.576 ERROR: relation
"chart_itemorgunitgroups" does not exist (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.577 HHH000389: Unsuccessful: alter table
drop constraint chart_organisationunits
fk_chart_organisationunits_organisationunitid (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.578 ERROR: relation
"chart_organisationunits" does not exist (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.579 HHH000389: Unsuccessful: alter table
drop constraint chart_organisationunits
fk_chart_organisationunits_chartid (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.580 ERROR: relation
"chart_organisationunits" does not exist (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.581 HHH000389: Unsuccessful: alter table
drop constraint chart_orgunitgroups
fk_chart_orgunitgroups_orgunitgroupid (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.581 ERROR: relation "chart_orgunitgroups"
does not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.583 HHH000389: Unsuccessful: alter table
drop constraint chart_orgunitgroups fk_chart_orgunitunitgroups_chartid
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.583 ERROR: relation "chart_orgunitgroups"
does not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.594 HHH000389: Unsuccessful: alter table
drop constraint chart_orgunitlevels fk_chart_orgunitlevels_chartid
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.595 ERROR: relation "chart_orgunitlevels"
does not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.597 HHH000389: Unsuccessful: alter table
drop constraint chart_periods fk_chart_periods_periodid
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.597 ERROR: relation "chart_periods" does
not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.599 HHH000389: Unsuccessful: alter table
drop constraint chart_periods fk_chart_periods_chartid
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.599 ERROR: relation "chart_periods" does
not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.601 HHH000389: Unsuccessful: alter table
drop constraint chartusergroupaccesses FK_191y3j7pfufwrenbd2h9q3pek
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.602 ERROR: relation
"chartusergroupaccesses" does not exist (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.604 HHH000389: Unsuccessful: alter table
drop constraint chartusergroupaccesses FK_dip5t4mdml147shrgnse9w8ia
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.604 ERROR: relation
"chartusergroupaccesses" does not exist (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.606 HHH000389: Unsuccessful: alter table
drop constraint colorset_colors fk_colorset_colors_colorid
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.606 ERROR: relation "colorset_colors" does
not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.608 HHH000389: Unsuccessful: alter table
drop constraint colorset_colors fk_colorset_colors_colorsetid
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.608 ERROR: relation "colorset_colors" does
not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.617 HHH000389: Unsuccessful: alter table
drop constraint completedatasetregistration
fk_datasetcompleteregistration_datasetid (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.617 ERROR: relation
"completedatasetregistration" does not exist (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.619 HHH000389: Unsuccessful: alter table
drop constraint completedatasetregistration
fk_datasetcompleteregistration_periodid (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.619 ERROR: relation
"completedatasetregistration" does not exist (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.621 HHH000389: Unsuccessful: alter table
drop constraint completedatasetregistration
fk_completedatasetregistration_organisationunitid (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.621 ERROR: relation
"completedatasetregistration" does not exist (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.623 HHH000389: Unsuccessful: alter table
drop constraint completedatasetregistration
fk_completedatasetregistration_attributeoptioncomboid (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.623 ERROR: relation
"completedatasetregistration" does not exist (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.625 HHH000389: Unsuccessful: alter table
drop constraint configuration fk_configuration_feedback_recipients
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.625 ERROR: relation "configuration" does
not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.627 HHH000389: Unsuccessful: alter table
drop constraint configuration fk_configuration_offline_orgunit_level
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.627 ERROR: relation "configuration" does
not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.629 HHH000389: Unsuccessful: alter table
drop constraint configuration
fk_configuration_infrastructural_indicators (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.629 ERROR: relation "configuration" does
not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.638 HHH000389: Unsuccessful: alter table
drop constraint configuration
fk_configuration_infrastructural_dataelements (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.638 ERROR: relation "configuration" does
not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.640 HHH000389: Unsuccessful: alter table
drop constraint configuration
fk_configuration_infrastructural_periodtype (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.640 ERROR: relation "configuration" does
not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.642 HHH000389: Unsuccessful: alter table
drop constraint configuration fk_configuration_selfregistrationrole
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.642 ERROR: relation "configuration" does
not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.644 HHH000389: Unsuccessful: alter table
drop constraint configuration fk_configuration_selfregistrationorgunit
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.644 ERROR: relation "configuration" does
not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.646 HHH000389: Unsuccessful: alter table
drop constraint configuration_corswhitelist
fk_configuration_corswhitelist (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.647 ERROR: relation
"configuration_corswhitelist" does not exist (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.648 HHH000389: Unsuccessful: alter table
drop constraint constant fk_constant_userid (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.648 ERROR: relation "constant" does not
exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.650 HHH000389: Unsuccessful: alter table
drop constraint constantusergroupaccesses FK_9a0eh0b7g9invjjs34nuvntkd
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.650 ERROR: relation
"constantusergroupaccesses" does not exist (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.658 HHH000389: Unsuccessful: alter table
drop constraint constantusergroupaccesses FK_2wir7o5ifmimtyky3r8pw347e
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.658 ERROR: relation
"constantusergroupaccesses" does not exist (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.660 HHH000389: Unsuccessful: alter table
drop constraint dashboard fk_dashboard_userid (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.660 ERROR: relation "dashboard" does not
exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.662 HHH000389: Unsuccessful: alter table
drop constraint dashboard_items fk_dashboard_items_dashboarditemid
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.662 ERROR: relation "dashboard_items" does
not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.663 HHH000389: Unsuccessful: alter table
drop constraint dashboard_items fk_dashboard_items_dashboardid
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.664 ERROR: relation "dashboard_items" does
not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.665 HHH000389: Unsuccessful: alter table
drop constraint dashboarditem fk_dashboarditem_chartid
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.666 ERROR: relation "dashboarditem" does
not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.667 HHH000389: Unsuccessful: alter table
drop constraint dashboarditem fk_dashboarditem_eventchartid
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.668 ERROR: relation "dashboarditem" does
not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.678 HHH000389: Unsuccessful: alter table
drop constraint dashboarditem fk_dashboarditem_mapid (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.678 ERROR: relation "dashboarditem" does
not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.680 HHH000389: Unsuccessful: alter table
drop constraint dashboarditem fk_dashboarditem_reporttableid
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.680 ERROR: relation "dashboarditem" does
not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.682 HHH000389: Unsuccessful: alter table
drop constraint dashboarditem fk_dashboarditem_eventreportid
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.682 ERROR: relation "dashboarditem" does
not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.684 HHH000389: Unsuccessful: alter table
drop constraint dashboarditem_reports fk_dashboarditem_reports_reportid
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.684 ERROR: relation
"dashboarditem_reports" does not exist (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.685 HHH000389: Unsuccessful: alter table
drop constraint dashboarditem_reports
fk_dashboarditem_reports_dashboardid (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.686 ERROR: relation
"dashboarditem_reports" does not exist (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.687 HHH000389: Unsuccessful: alter table
drop constraint dashboarditem_resources
fk_dashboarditem_resources_resourceid (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.688 ERROR: relation
"dashboarditem_resources" does not exist (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.689 HHH000389: Unsuccessful: alter table
drop constraint dashboarditem_resources
fk_dashboarditem_resources_dashboardid (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.690 ERROR: relation
"dashboarditem_resources" does not exist (SchemaExport.java [localhost
StartStop-1])
* ERROR 2016-09-28 11: 47: 19.691 HHH000389: Unsuccessful: alter table
drop constraint dashboarditem_users fk_dashboarditem_users_userinfoid
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.691 ERROR: relation "dashboarditem_users"
does not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.702 HHH000389: Unsuccessful: alter table
drop constraint dashboarditem_users fk_dashboarditem_users_dashboardid
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.702 ERROR: relation "dashboarditem_users"
does not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.704 HHH000389: Unsuccessful: alter table
drop constraint dashboardusergroupaccesses FK_75d35u3n0i5wea6bevn7v6t3l
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.704 ERROR: relation
"dashboardusergroupaccesses" does not exist (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.706 HHH000389: Unsuccessful: alter table
drop constraint dashboardusergroupaccesses FK_5ejgnh1eqww2iy4m3cs98yl6m
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.706 ERROR: relation
"dashboardusergroupaccesses" does not exist (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.708 HHH000389: Unsuccessful: alter table
drop constraint dataapproval fk_dataapproval_dataapprovallevel
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.708 ERROR: relation "dataapproval" does
not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.710 HHH000389: Unsuccessful: alter table
drop constraint dataapproval fk_dataapproval_workflowid
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.711 ERROR: relation "dataapproval" does
not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.712 HHH000389: Unsuccessful: alter table
drop constraint dataapproval fk_dataapproval_periodid (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.712 ERROR: relation "dataapproval" does
not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.714 HHH000389: Unsuccessful: alter table
drop constraint dataapproval fk_dataapproval_organisationunitid
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.714 ERROR: relation "dataapproval" does
not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.716 HHH000389: Unsuccessful: alter table
drop constraint dataapproval fk_dataapproval_attributeoptioncomboid
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.716 ERROR: relation "dataapproval" does
not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.718 HHH000389: Unsuccessful: alter table
drop constraint dataapproval fk_dataapproval_creator (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.718 ERROR: relation "dataapproval" does
not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.730 HHH000389: Unsuccessful: alter table
drop constraint dataapprovallevel
fK_dataapprovallevel_categoryoptiongroupsetid (SchemaExport.java
[localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.731 ERROR: relation "dataapprovallevel"
does not exist (SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.732 HHH000389: Unsuccessful: alter table
drop constraint dataapprovallevel fk_dataapprovallevel_userid
(SchemaExport.java [localhost StartStop-1])
* ERROR 2016-09-28 11: 47: 19.733 ERROR: relation "dataapprovallevel"
does not exist (SchemaExport.java [localhost StartStop-1])
--
This message was sent from Launchpad by
Babacar NGOM (https://launchpad.net/~babacar2005)
using the "Contact this team's admins" link on the DHIS 2 developers team
page (https://launchpad.net/~dhis2-devs).
For more information see
https://help.launchpad.net/YourAccount/ContactingPeople
Follow ups

Re: Fwd: Problem with hibernate_sequence on DHIS2 2.22 installation process
From: Brajesh Murari, 2016-09-29