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.mur...@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 > > > On Thu, Sep 29, 2016 at 5:33 AM, Knut Staring <knu...@gmail.com> wrote: > >> ---------- Forwarded message ---------- >> From: "Babacar NGOM" <babacar2...@hotmail.com> >> Date: Sep 28, 2016 7:18 PM >> Subject: Problem with hibernate_sequence on DHIS2 2.22 installation >> process >> To: "Knut Staring" <knu...@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 > > > _______________________________________________ > 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 > > -- Lars Helge Øverland Lead developer, DHIS 2 University of Oslo Skype: larshelgeoverland l...@dhis2.org http://www.dhis2.org <https://www.dhis2.org/>
_______________________________________________ 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
