← Back to team overview

dhis2-users team mailing list archive

  1. dhis2-users team
  2. Mailing list archive
  3. Message #11444

Re: Fwd: Problem with hibernate_sequence on DHIS2 2.22 installation process

  Thread Previous • Date Previous • • Thread Next 
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@xxxxxxxxx> wrote:

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


-- 
---
Thanks and Regards

Brajesh Murari

Follow ups

References

  Thread Previous • Date Previous • • Thread Next