dhis2-users team mailing list archive

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

To: Brajesh Murari <brajesh.murari@xxxxxxxxx>
From: Lars Helge Øverland <lars@xxxxxxxxx>
Date: Thu, 29 Sep 2016 08:43:41 +0200
Cc: DHIS 2 Users list <dhis2-users@xxxxxxxxxxxxxxxxxxx>
In-reply-to: <CAMfSqypBOL1Chfat5g=FwKevK6oV=M6gYny_Lrt9kXqVs95SVg@mail.gmail.com>
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
<http://dhis2.github.io/dhis2-docs/master/en/implementer/html/install_dhis2_configuration_reference.html>
:

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@xxxxxxxxx>
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
>
>
> 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
>
>
> _______________________________________________
> 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
>
>


-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
lars@xxxxxxxxx
http://www.dhis2.org <https://www.dhis2.org/>
References

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