Problem with hibernate_sequence on DHIS2 2.22 installation process

Support - Assistance technique
1

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])

···

---------- Forwarded message ----------
From: “Babacar NGOM” babacar2005@hotmail.com
Date: Sep 28, 2016 7:18 PM
Subject: Problem with hibernate_sequence on DHIS2 2.22 installation process
To: “Knut Staring” knutst@gmail.com

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

2

Hello Babacar,

Replace and reconfigure your “dhis.conf” file available in “DHIS2_HOME” directory with following as given below, from

hibernate.connection.schema = update

to

hibernate.hbm2ddl.auto = update

Your dhis.conf should looks like as given below, if you are using postgresql database

hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect

hibernate.connection.driver_class = org.postgresql.Driver

hibernate.connection.url = jdbc:postgresql:dhis2-UN

hibernate.connection.username = postgres

hibernate.connection.password = postgres

#Database schema behavior, can be validate, update, create, create-drop

#hibernate.connection.schema = update

hibernate.hbm2ddl.auto = update

encryption.password = abcd

···

On Thu, Sep 29, 2016 at 5:33 AM, Knut Staring knutst@gmail.com wrote:

---------- Forwarded message ----------
From: “Babacar NGOM” babacar2005@hotmail.com
Date: Sep 28, 2016 7:18 PM
Subject: Problem with hibernate_sequence on DHIS2 2.22 installation process
To: “Knut Staring” knutst@gmail.com
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

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

–

Thanks and Regards

Brajesh Murari

3

Hi Bacabar,

this indicates that your database configuration file is not picked up.

Try having a “dhis.conf” configuration file with the following property files (Brajesh your example is wrong) as stated in the docs:

Lars


# ---------------------------------------------------------------------- # Database connection for PostgreSQL # ---------------------------------------------------------------------- # Hibernate SQL dialect connection.dialect = org.hibernate.dialect.PostgreSQLDialect # JDBC driver class connection.driver_class = org.postgresql.Driver # Database connection URL connection.url = jdbc:postgresql:dhis2 # Database username connection.username = dhis # Database password (sensitive) connection.password = xxxx # Database schema behavior, can be 'validate', 'update', 'create', 'create-drop' connection.schema = update # Max size of connection pool (default: 40) # connection.pool.max_size = 40
···

On Thu, Sep 29, 2016 at 6:31 AM, Brajesh Murari brajesh.murari@gmail.com wrote:

Hello Babacar,

Replace and reconfigure your “dhis.conf” file available in “DHIS2_HOME” directory with following as given below, from

hibernate.connection.schema = update

to

hibernate.hbm2ddl.auto = update

Your dhis.conf should looks like as given below, if you are using postgresql database

hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect

hibernate.connection.driver_class = org.postgresql.Driver

hibernate.connection.url = jdbc:postgresql:dhis2-UN

hibernate.connection.username = postgres

hibernate.connection.password = postgres

#Database schema behavior, can be validate, update, create, create-drop

#hibernate.connection.schema = update

hibernate.hbm2ddl.auto = update

encryption.password = abcd

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

–

On Thu, Sep 29, 2016 at 5:33 AM, Knut Staring knutst@gmail.com wrote:

---------- Forwarded message ----------
From: “Babacar NGOM” babacar2005@hotmail.com
Date: Sep 28, 2016 7:18 PM
Subject: Problem with hibernate_sequence on DHIS2 2.22 installation process
To: “Knut Staring” knutst@gmail.com
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

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

Thanks and Regards

Brajesh Murari

–

Lars Helge Øverland

Lead developer, DHIS 2

University of Oslo

Skype: larshelgeoverland

lars@dhis2.org

http://www.dhis2.org