dhis2-devs team mailing list archive

Thread
Date

2.16 Postgres Errors, First Startup vs Second

To: DHIS 2 Developers list <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
From: Timothy Harding <hardingt@xxxxxxxxx>
Date: Tue, 14 Oct 2014 12:08:57 +1100

Hello Developers! Thank you again for the help in getting 2.16 running in
our test environment. I had some additional questions about myriad Postgres
errors I'm seeing both on the first startup and subsequent startups. The
document found here: https://www.dhis2.org/216-upgrade said there would be
some errors that would show up on the first startup, but I'm seeing even
more the 2nd time. I've included the entire log file as an attachment to
this email, I did some quick analysis below though. Note that none of these
errors boiled up to Catalina.out, I found them in the Postgres log files.
Also note that even though I am seeing these errors, I am still able to use
2.16.

1st startup:
Beginning around Step [4 of 14, runlevel 3]: TrackerIdentityPopulator and
going until step [14 of 14, runlevel 9]: I18nLocalePopulator I'm seeing
about
399 Postgres errors
- 67 of ERROR:  relation "[^ ]*" already exists$
- 3 of ERROR:  relation "[^ ]*" does not exist$
- 3 of ERROR:  relation "[^ ]*" does not exist at character [0-9]*$
- 62 of ERROR:  table "[^ ]*" does not exist$
- 149 of ERROR:  column "[^ ]*" of relation "[^ ]*" does not exist$
- 3 of ERROR:  column "[^ ]*" of relation "[^ ]*" already exists$
- 8 of ERROR:  column "[^ ]*" does not exist$
- 59 of ERROR:  column "[^ ]*" does not exist at character [0-9]*$
- 29 of ERROR:  constraint "[^ ]*" of relation "[^ ]*" does not exist$
- 2 of ERROR:  index "[^ ]*" does not exist$
- 6 of ERROR:  cannot alter type of a column used by a view or rule
And several more 1 off errors

2nd startup
Beginning and ending in the same spots
414 Postgres errors
- 70 of ERROR:  relation "[^ ]*" already exists$
- 3 of ERROR:  relation "[^ ]*" does not exist$
- 3 of ERROR:  relation "[^ ]*" does not exist at character [0-9]*$
- 63 of ERROR:  table "[^ ]*" does not exist$
- 154 of ERROR:  column "[^ ]*" of relation "[^ ]*" does not exist$
- 3 of ERROR:  column "[^ ]*" of relation "[^ ]*" already exists$
- 8 of ERROR:  column "[^ ]*" does not exist$
- 65 of ERROR:  column "[^ ]*" does not exist at character [0-9]*$
- 29 of ERROR:  constraint "[^ ]*" of relation "[^ ]*" does not exist$
- 2 of ERROR:  index "[^ ]*" does not exist$
- 6 of ERROR:  cannot alter type of a column used by a view or rule
And several more 1 off errors



Timothy Harding
PeaceCorps Volunteer
Republic of Vanuatu
hardingt@xxxxxxxxx
+678 5955137

1st Startup
2014-10-13 14:34:22 VUT ERROR:  relation "trackedentityattribute_uid_key" already exists
2014-10-13 14:34:22 VUT STATEMENT:  ALTER TABLE trackedentityattribute ADD CONSTRAINT trackedentityattribute_uid_key UNIQUE(uid)
2014-10-13 14:34:22 VUT ERROR:  relation "trackedentityattributegroup_uid_key" already exists
2014-10-13 14:34:22 VUT STATEMENT:  ALTER TABLE trackedentityattributegroup ADD CONSTRAINT trackedentityattributegroup_uid_key UNIQUE(uid)
2014-10-13 14:34:22 VUT ERROR:  relation "program_uid_key" already exists
2014-10-13 14:34:22 VUT STATEMENT:  ALTER TABLE program ADD CONSTRAINT program_uid_key UNIQUE(uid)
2014-10-13 14:34:22 VUT ERROR:  relation "programstage_uid_key" already exists
2014-10-13 14:34:22 VUT STATEMENT:  ALTER TABLE programstage ADD CONSTRAINT programstage_uid_key UNIQUE(uid)
2014-10-13 14:34:22 VUT ERROR:  relation "programinstance_uid_key" already exists
2014-10-13 14:34:22 VUT STATEMENT:  ALTER TABLE programinstance ADD CONSTRAINT programinstance_uid_key UNIQUE(uid)
2014-10-13 14:34:22 VUT ERROR:  relation "programstageinstance_uid_key" already exists
2014-10-13 14:34:22 VUT STATEMENT:  ALTER TABLE programstageinstance ADD CONSTRAINT programstageinstance_uid_key UNIQUE(uid)
2014-10-13 14:34:22 VUT ERROR:  relation "relationshiptype_uid_key" already exists
2014-10-13 14:34:22 VUT STATEMENT:  ALTER TABLE relationshiptype ADD CONSTRAINT relationshiptype_uid_key UNIQUE(uid)
2014-10-13 14:34:22 VUT ERROR:  relation "programstagesection_uid_key" already exists
2014-10-13 14:34:22 VUT STATEMENT:  ALTER TABLE programstagesection ADD CONSTRAINT programstagesection_uid_key UNIQUE(uid)
2014-10-13 14:34:22 VUT ERROR:  relation "programvalidation_uid_key" already exists
2014-10-13 14:34:22 VUT STATEMENT:  ALTER TABLE programvalidation ADD CONSTRAINT programvalidation_uid_key UNIQUE(uid)
2014-10-13 14:34:23 VUT ERROR:  relation "reporttable_uid_key" already exists
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE reporttable ADD CONSTRAINT reporttable_uid_key UNIQUE(uid)
2014-10-13 14:34:23 VUT ERROR:  relation "chart_uid_key" already exists
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE chart ADD CONSTRAINT chart_uid_key UNIQUE(uid)
2014-10-13 14:34:23 VUT ERROR:  relation "map_uid_key" already exists
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE map ADD CONSTRAINT map_uid_key UNIQUE(uid)
2014-10-13 14:34:23 VUT ERROR:  relation "mapview_uid_key" already exists
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE mapview ADD CONSTRAINT mapview_uid_key UNIQUE(uid)
2014-10-13 14:34:23 VUT ERROR:  relation "maplegend_uid_key" already exists
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE maplegend ADD CONSTRAINT maplegend_uid_key UNIQUE(uid)
2014-10-13 14:34:23 VUT ERROR:  relation "maplegendset_uid_key" already exists
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE maplegendset ADD CONSTRAINT maplegendset_uid_key UNIQUE(uid)
2014-10-13 14:34:23 VUT ERROR:  relation "report_uid_key" already exists
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE report ADD CONSTRAINT report_uid_key UNIQUE(uid)
2014-10-13 14:34:23 VUT ERROR:  relation "messageconversation_uid_key" already exists
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE messageconversation ADD CONSTRAINT messageconversation_uid_key UNIQUE(uid)
2014-10-13 14:34:23 VUT ERROR:  relation "message_uid_key" already exists
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE message ADD CONSTRAINT message_uid_key UNIQUE(uid)
2014-10-13 14:34:23 VUT ERROR:  relation "document_uid_key" already exists
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE document ADD CONSTRAINT document_uid_key UNIQUE(uid)
2014-10-13 14:34:23 VUT ERROR:  relation "dashboard_uid_key" already exists
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE dashboard ADD CONSTRAINT dashboard_uid_key UNIQUE(uid)
2014-10-13 14:34:23 VUT ERROR:  relation "dashboarditem_uid_key" already exists
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE dashboarditem ADD CONSTRAINT dashboarditem_uid_key UNIQUE(uid)
2014-10-13 14:34:23 VUT ERROR:  relation "interpretation_uid_key" already exists
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE interpretation ADD CONSTRAINT interpretation_uid_key UNIQUE(uid)
2014-10-13 14:34:23 VUT ERROR:  relation "interpretationcomment_uid_key" already exists
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE interpretationcomment ADD CONSTRAINT interpretationcomment_uid_key UNIQUE(uid)
2014-10-13 14:34:23 VUT ERROR:  table "categoryoptioncomboname" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE categoryoptioncomboname
2014-10-13 14:34:23 VUT ERROR:  table "orgunitgroupsetstructure" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE orgunitgroupsetstructure
2014-10-13 14:34:23 VUT ERROR:  table "orgunitstructure" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE orgunitstructure
2014-10-13 14:34:23 VUT ERROR:  table "orgunithierarchystructure" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE orgunithierarchystructure
2014-10-13 14:34:23 VUT ERROR:  table "orgunithierarchy" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE orgunithierarchy
2014-10-13 14:34:23 VUT ERROR:  table "columnorder" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE columnorder
2014-10-13 14:34:23 VUT ERROR:  table "roworder" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE roworder
2014-10-13 14:34:23 VUT ERROR:  table "sectionmembers" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE sectionmembers
2014-10-13 14:34:23 VUT ERROR:  table "reporttable_categoryoptioncombos" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE reporttable_categoryoptioncombos
2014-10-13 14:34:23 VUT ERROR:  table "reporttable_dataelementgroupsets" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE reporttable_dataelementgroupsets
2014-10-13 14:34:23 VUT ERROR:  table "dashboardcontent_datamartexports" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE dashboardcontent_datamartexports
2014-10-13 14:34:23 VUT ERROR:  table "dashboardcontent_mapviews" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE dashboardcontent_mapviews
2014-10-13 14:34:23 VUT ERROR:  table "dashboardcontent_documents" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE dashboardcontent_documents
2014-10-13 14:34:23 VUT ERROR:  table "dashboardcontent_maps" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE dashboardcontent_maps
2014-10-13 14:34:23 VUT ERROR:  table "dashboardcontent_reports" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE dashboardcontent_reports
2014-10-13 14:34:23 VUT ERROR:  table "dashboardcontent_reporttables" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE dashboardcontent_reporttables
2014-10-13 14:34:23 VUT ERROR:  table "dashboardcontent" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE dashboardcontent
2014-10-13 14:34:23 VUT ERROR:  table "customvalue" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE customvalue
2014-10-13 14:34:23 VUT ERROR:  table "reporttable_displaycolumns" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE reporttable_displaycolumns
2014-10-13 14:34:23 VUT ERROR:  table "reportreporttables" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE reportreporttables
2014-10-13 14:34:23 VUT ERROR:  table "frequencyoverrideassociation" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE frequencyoverrideassociation
2014-10-13 14:34:23 VUT ERROR:  table "dataelement_dataelementgroupsetmembers" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE dataelement_dataelementgroupsetmembers
2014-10-13 14:34:23 VUT ERROR:  table "dashboardcontent_olapurls" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE dashboardcontent_olapurls
2014-10-13 14:34:23 VUT ERROR:  table "olapurl" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE olapurl
2014-10-13 14:34:23 VUT ERROR:  table "target" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE target
2014-10-13 14:34:23 VUT ERROR:  table "calculateddataelement" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE calculateddataelement
2014-10-13 14:34:23 VUT ERROR:  table "systemsequence" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE systemsequence
2014-10-13 14:34:23 VUT ERROR:  table "reporttablecolumn" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE reporttablecolumn
2014-10-13 14:34:23 VUT ERROR:  table "datamartexport" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE datamartexport
2014-10-13 14:34:23 VUT ERROR:  table "datamartexportdataelements" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE datamartexportdataelements
2014-10-13 14:34:23 VUT ERROR:  table "datamartexportindicators" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE datamartexportindicators
2014-10-13 14:34:23 VUT ERROR:  table "datamartexportorgunits" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE datamartexportorgunits
2014-10-13 14:34:23 VUT ERROR:  table "datamartexportperiods" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE datamartexportperiods
2014-10-13 14:34:23 VUT ERROR:  table "datasetlockedperiods" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE datasetlockedperiods
2014-10-13 14:34:23 VUT ERROR:  table "datasetlocksource" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE datasetlocksource
2014-10-13 14:34:23 VUT ERROR:  table "datasetlock" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE datasetlock
2014-10-13 14:34:23 VUT ERROR:  table "datasetlockexceptions" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE datasetlockexceptions
2014-10-13 14:34:23 VUT ERROR:  table "indicator_indicatorgroupsetmembers" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE indicator_indicatorgroupsetmembers
2014-10-13 14:34:23 VUT ERROR:  table "maplegendsetindicator" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE maplegendsetindicator
2014-10-13 14:34:23 VUT ERROR:  table "maplegendsetdataelement" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE maplegendsetdataelement
2014-10-13 14:34:23 VUT ERROR:  table "dashboarditem_trackedentitytabularreports" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE dashboarditem_trackedentitytabularreports
2014-10-13 14:34:23 VUT ERROR:  table "categoryoptioncombousergroupaccesses" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE categoryoptioncombousergroupaccesses
2014-10-13 14:34:23 VUT ERROR:  table "validationrulegroupuserrolestoalert" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  DROP TABLE validationrulegroupuserrolestoalert
2014-10-13 14:34:23 VUT ERROR:  column "userid" of relation "categoryoptioncombo" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE categoryoptioncombo drop column userid
2014-10-13 14:34:23 VUT ERROR:  column "publicaccess" of relation "categoryoptioncombo" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE categoryoptioncombo drop column publicaccess
2014-10-13 14:34:23 VUT ERROR:  column "categoryid" of relation "dataelementcategoryoption" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE dataelementcategoryoption drop column categoryid
2014-10-13 14:34:23 VUT ERROR:  column "paramleafparentorganisationunit" of relation "reporttable" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE reporttable DROP column paramleafparentorganisationunit
2014-10-13 14:34:23 VUT ERROR:  column "dimension_type" of relation "reporttable" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE reporttable DROP column dimension_type
2014-10-13 14:34:23 VUT ERROR:  column "dimensiontype" of relation "reporttable" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE reporttable DROP column dimensiontype
2014-10-13 14:34:23 VUT ERROR:  column "tablename" of relation "reporttable" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE reporttable DROP column tablename
2014-10-13 14:34:23 VUT ERROR:  column "existingtablename" of relation "reporttable" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE reporttable DROP column existingtablename
2014-10-13 14:34:23 VUT ERROR:  column "docategoryoptioncombos" of relation "reporttable" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE reporttable DROP column docategoryoptioncombos
2014-10-13 14:34:23 VUT ERROR:  column "mode" of relation "reporttable" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE reporttable DROP column mode
2014-10-13 14:34:23 VUT ERROR:  column "displayorder" of relation "categoryoptioncombo" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE categoryoptioncombo DROP COLUMN displayorder
2014-10-13 14:34:23 VUT ERROR:  column "shortname" of relation "dataelementcategoryoption" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE dataelementcategoryoption DROP COLUMN shortname
2014-10-13 14:34:23 VUT ERROR:  column "label" of relation "section" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE section DROP COLUMN label
2014-10-13 14:34:23 VUT ERROR:  column "title" of relation "section" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE section DROP COLUMN title
2014-10-13 14:34:23 VUT ERROR:  column "polygoncoordinates" of relation "organisationunit" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE organisationunit DROP COLUMN polygoncoordinates
2014-10-13 14:34:23 VUT ERROR:  column "geocode" of relation "organisationunit" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE organisationunit DROP COLUMN geocode
2014-10-13 14:34:23 VUT ERROR:  column "extendeddataelementid" of relation "indicator" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE indicator DROP COLUMN extendeddataelementid
2014-10-13 14:34:23 VUT ERROR:  column "numeratoraggregationtype" of relation "indicator" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE indicator DROP COLUMN numeratoraggregationtype
2014-10-13 14:34:23 VUT ERROR:  column "denominatoraggregationtype" of relation "indicator" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE indicator DROP COLUMN denominatoraggregationtype
2014-10-13 14:34:23 VUT ERROR:  column "locked" of relation "dataset" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE dataset DROP COLUMN locked
2014-10-13 14:34:23 VUT ERROR:  column "completenessrecipientsid" of relation "configuration" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE configuration DROP COLUMN completenessrecipientsid
2014-10-13 14:34:23 VUT ERROR:  column "alternativename" of relation "dataelement" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE dataelement DROP COLUMN alternativename
2014-10-13 14:34:23 VUT ERROR:  column "alternativename" of relation "indicator" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE indicator DROP COLUMN alternativename
2014-10-13 14:34:23 VUT ERROR:  column "image" of relation "orgunitgroup" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE orgunitgroup DROP COLUMN image
2014-10-13 14:34:23 VUT ERROR:  column "usingorgunitgroupsets" of relation "report" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE report DROP COLUMN usingorgunitgroupsets
2014-10-13 14:34:23 VUT ERROR:  column "datatype" of relation "eventchart" does not exist
2014-10-13 14:34:23 VUT STATEMENT:  ALTER TABLE eventchart DROP COLUMN datatype
2014-10-13 14:34:24 VUT ERROR:  index "datamart_crosstab" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  DROP INDEX datamart_crosstab
2014-10-13 14:34:24 VUT ERROR:  table "maporganisationunitrelation" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  DROP TABLE maporganisationunitrelation
2014-10-13 14:34:24 VUT ERROR:  column "mapid" of relation "mapview" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE mapview DROP COLUMN mapid
2014-10-13 14:34:24 VUT ERROR:  column "startdate" of relation "mapview" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE mapview DROP COLUMN startdate
2014-10-13 14:34:24 VUT ERROR:  column "enddate" of relation "mapview" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE mapview DROP COLUMN enddate
2014-10-13 14:34:24 VUT ERROR:  column "mapsource" of relation "mapview" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE mapview DROP COLUMN mapsource
2014-10-13 14:34:24 VUT ERROR:  column "mapsourcetype" of relation "mapview" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE mapview DROP COLUMN mapsourcetype
2014-10-13 14:34:24 VUT ERROR:  column "mapdatetype" of relation "mapview" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE mapview DROP COLUMN mapdatetype
2014-10-13 14:34:24 VUT ERROR:  column "featuretype" of relation "mapview" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE mapview DROP COLUMN featuretype
2014-10-13 14:34:24 VUT ERROR:  column "bounds" of relation "mapview" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE mapview DROP COLUMN bounds
2014-10-13 14:34:24 VUT ERROR:  column "valuetype" of relation "mapview" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE mapview DROP COLUMN valuetype
2014-10-13 14:34:24 VUT ERROR:  column "legendtype" of relation "mapview" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE mapview DROP COLUMN legendtype
2014-10-13 14:34:24 VUT ERROR:  column "mapvaluetype" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE mapview RENAME COLUMN mapvaluetype TO valuetype
2014-10-13 14:34:24 VUT ERROR:  column "maplegendtype" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE mapview RENAME COLUMN maplegendtype TO legendtype
2014-10-13 14:34:24 VUT ERROR:  column "maplegendsetid" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE mapview RENAME COLUMN maplegendsetid TO legendsetid
2014-10-13 14:34:24 VUT ERROR:  constraint "maplegend_name_key" of relation "maplegend" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE maplegend DROP CONSTRAINT maplegend_name_key
2014-10-13 14:34:24 VUT ERROR:  constraint "maplayer_mapsource_key" of relation "maplayer" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE maplayer DROP CONSTRAINT maplayer_mapsource_key
2014-10-13 14:34:24 VUT ERROR:  column "mapsource" of relation "maplayer" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE maplayer DROP COLUMN mapsource
2014-10-13 14:34:24 VUT ERROR:  column "mapsourcetype" of relation "maplayer" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE maplayer DROP COLUMN mapsourcetype
2014-10-13 14:34:24 VUT ERROR:  column "layer" of relation "maplayer" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE maplayer DROP COLUMN layer
2014-10-13 14:34:24 VUT ERROR:  constraint "fk_dataelement_extendeddataelementid" of relation "dataelement" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE dataelement DROP CONSTRAINT fk_dataelement_extendeddataelementid
2014-10-13 14:34:24 VUT ERROR:  column "extendeddataelementid" of relation "dataelement" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE dataelement DROP COLUMN extendeddataelementid
2014-10-13 14:34:24 VUT ERROR:  constraint "fk_indicator_extendeddataelementid" of relation "indicator" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE indicator DROP CONSTRAINT fk_indicator_extendeddataelementid
2014-10-13 14:34:24 VUT ERROR:  column "extendeddataelementid" of relation "indicator" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE indicator DROP COLUMN extendeddataelementid
2014-10-13 14:34:24 VUT ERROR:  table "extendeddataelement" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  DROP TABLE extendeddataelement
2014-10-13 14:34:24 VUT ERROR:  column "haspatients" of relation "organisationunit" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE organisationunit DROP COLUMN hasPatients
2014-10-13 14:34:24 VUT ERROR:  constraint "fk4bae70f697e49675" of relation "categorycombos_optioncombos" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE categorycombos_optioncombos DROP CONSTRAINT fk4bae70f697e49675
2014-10-13 14:34:24 VUT ERROR:  column "sort_order" of relation "categoryoptioncombos_categoryoptions" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  alter table categoryoptioncombos_categoryoptions drop column sort_order
2014-10-13 14:34:24 VUT ERROR:  multiple primary keys for table "categoryoptioncombos_categoryoptions" are not allowed
2014-10-13 14:34:24 VUT STATEMENT:  alter table categoryoptioncombos_categoryoptions add constraint categoryoptioncombos_categoryoptions_pkey primary key(categoryoptioncomboid, categoryoptionid)
2014-10-13 14:34:24 VUT ERROR:  constraint "fk_dataelement_categoryid" of relation "dataelementcategoryoption" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE dataelementcategoryoption DROP CONSTRAINT fk_dataelement_categoryid
2014-10-13 14:34:24 VUT ERROR:  constraint "dataelementcategoryoption_shortname_key" of relation "dataelementcategoryoption" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE dataelementcategoryoption DROP CONSTRAINT dataelementcategoryoption_shortname_key
2014-10-13 14:34:24 VUT ERROR:  relation "index_minmaxdataelement" already exists
2014-10-13 14:34:24 VUT STATEMENT:  CREATE INDEX index_minmaxdataelement ON minmaxdataelement( sourceid, dataelementid, categoryoptioncomboid )
2014-10-13 14:34:24 VUT ERROR:  relation "patientattribute" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE patientattribute ADD mandatory bool
2014-10-13 14:34:24 VUT ERROR:  relation "patientattribute" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE patientattribute ADD groupby bool
2014-10-13 14:34:24 VUT ERROR:  cannot alter type of a column used by a view or rule
2014-10-13 14:34:24 VUT DETAIL:  rule _RETURN on view _view_data_elements depends on column "description"
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE dataelement ALTER description TYPE text
2014-10-13 14:34:24 VUT ERROR:  cannot alter type of a column used by a view or rule
2014-10-13 14:34:24 VUT DETAIL:  rule _RETURN on view _view_translations depends on column "value"
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE translation ALTER value TYPE text
2014-10-13 14:34:24 VUT ERROR:  cannot alter type of a column used by a view or rule
2014-10-13 14:34:24 VUT DETAIL:  rule _RETURN on view _view_test_cases_2 depends on column "comment"
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE organisationunit ALTER comment TYPE text
2014-10-13 14:34:24 VUT ERROR:  column "minvalue" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE minmaxdataelement RENAME minvalue TO minimumvalue
2014-10-13 14:34:24 VUT ERROR:  column "maxvalue" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE minmaxdataelement RENAME maxvalue TO maximumvalue
2014-10-13 14:34:24 VUT ERROR:  constraint "organisationunit_shortname_key" of relation "organisationunit" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE organisationunit DROP CONSTRAINT organisationunit_shortname_key
2014-10-13 14:34:24 VUT ERROR:  constraint "section_name_key" of relation "section" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE section DROP CONSTRAINT section_name_key
2014-10-13 14:34:24 VUT ERROR:  relation "patientattribute" does not exist at character 8
2014-10-13 14:34:24 VUT STATEMENT:  UPDATE patientattribute set inheritable=false where inheritable is null
2014-10-13 14:34:24 VUT ERROR:  column "modified" of relation "aggregateddatavalue" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE aggregateddatavalue DROP COLUMN modified
2014-10-13 14:34:24 VUT ERROR:  column "modified" of relation "aggregatedindicatorvalue" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE aggregatedindicatorvalue DROP COLUMN modified 
2014-10-13 14:34:24 VUT ERROR:  column "patientid" of relation "programinstance" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE programinstance ALTER COLUMN patientid DROP NOT NULL
2014-10-13 14:34:24 VUT ERROR:  column "dimension" does not exist at character 84
2014-10-13 14:34:24 VUT STATEMENT:  UPDATE chart SET series='period', category='data', filter='organisationunit' WHERE dimension='indicator'
2014-10-13 14:34:24 VUT ERROR:  column "dimension" does not exist at character 84
2014-10-13 14:34:24 VUT STATEMENT:  UPDATE chart SET series='data', category='organisationunit', filter='period' WHERE dimension='organisationUnit'
2014-10-13 14:34:24 VUT ERROR:  column "dimension" does not exist at character 84
2014-10-13 14:34:24 VUT STATEMENT:  UPDATE chart SET series='period', category='data', filter='organisationunit' WHERE dimension='dataElement_period'
2014-10-13 14:34:24 VUT ERROR:  column "dimension" does not exist at character 84
2014-10-13 14:34:24 VUT STATEMENT:  UPDATE chart SET series='data', category='organisationunit', filter='period' WHERE dimension='organisationUnit_dataElement'
2014-10-13 14:34:24 VUT ERROR:  column "dimension" does not exist at character 84
2014-10-13 14:34:24 VUT STATEMENT:  UPDATE chart SET series='data', category='period', filter='organisationunit' WHERE dimension='period'
2014-10-13 14:34:24 VUT ERROR:  column "dimension" does not exist at character 84
2014-10-13 14:34:24 VUT STATEMENT:  UPDATE chart SET series='data', category='period', filter='organisationunit' WHERE dimension='period_dataElement'
2014-10-13 14:34:24 VUT ERROR:  column "filter" does not exist at character 97
2014-10-13 14:34:24 VUT STATEMENT:  UPDATE chart SET type=lower(type), series=lower(series), category=lower(category), filter=lower(filter)
2014-10-13 14:34:24 VUT ERROR:  column "dimension" of relation "chart" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE chart ALTER COLUMN dimension DROP NOT NULL
2014-10-13 14:34:24 VUT ERROR:  column "size" of relation "chart" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN size
2014-10-13 14:34:24 VUT ERROR:  column "verticallabels" of relation "chart" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN verticallabels
2014-10-13 14:34:24 VUT ERROR:  column "targetline" of relation "chart" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN targetline
2014-10-13 14:34:24 VUT ERROR:  column "horizontalplotorientation" of relation "chart" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN horizontalplotorientation
2014-10-13 14:34:24 VUT ERROR:  column "hidesubtitle" of relation "chart" already exists
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE chart ADD COLUMN hidesubtitle boolean NOT NULL DEFAULT false
2014-10-13 14:34:24 VUT ERROR:  column "monthslastyear" of relation "chart" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN monthsLastYear
2014-10-13 14:34:24 VUT ERROR:  column "quarterslastyear" of relation "chart" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN quartersLastYear
2014-10-13 14:34:24 VUT ERROR:  column "last6bimonths" of relation "chart" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN last6BiMonths
2014-10-13 14:34:24 VUT ERROR:  constraint "chart_title_key" of relation "chart" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE chart DROP CONSTRAINT chart_title_key
2014-10-13 14:34:24 VUT ERROR:  constraint "chart_name_key" of relation "chart" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE chart DROP CONSTRAINT chart_name_key
2014-10-13 14:34:24 VUT ERROR:  column "domainaxixlabel" of relation "chart" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN domainaxixlabel
2014-10-13 14:34:24 VUT ERROR:  column "last6months" of relation "reporttable" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE reporttable DROP COLUMN last6months
2014-10-13 14:34:24 VUT ERROR:  column "last9months" of relation "reporttable" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE reporttable DROP COLUMN last9months
2014-10-13 14:34:24 VUT ERROR:  column "sofarthisyear" of relation "reporttable" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE reporttable DROP COLUMN sofarthisyear
2014-10-13 14:34:24 VUT ERROR:  column "sofarthisfinancialyear" of relation "reporttable" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE reporttable DROP COLUMN sofarthisfinancialyear
2014-10-13 14:34:24 VUT ERROR:  column "last3to6months" of relation "reporttable" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE reporttable DROP COLUMN last3to6months
2014-10-13 14:34:24 VUT ERROR:  column "last6to9months" of relation "reporttable" does not exist
2014-10-13 14:34:24 VUT STATEMENT:  ALTER TABLE reporttable DROP COLUMN last6to9months
2014-10-13 14:34:25 VUT ERROR:  column "last9to12months" of relation "reporttable" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE reporttable DROP COLUMN last9to12months
2014-10-13 14:34:25 VUT ERROR:  column "last12individualmonths" of relation "reporttable" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE reporttable DROP COLUMN last12individualmonths
2014-10-13 14:34:25 VUT ERROR:  column "individualmonthsthisyear" of relation "reporttable" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE reporttable DROP COLUMN individualmonthsthisyear
2014-10-13 14:34:25 VUT ERROR:  column "individualquartersthisyear" of relation "reporttable" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE reporttable DROP COLUMN individualquartersthisyear
2014-10-13 14:34:25 VUT ERROR:  column "last6months" of relation "chart" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN last6months
2014-10-13 14:34:25 VUT ERROR:  column "last9months" of relation "chart" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN last9months
2014-10-13 14:34:25 VUT ERROR:  column "sofarthisyear" of relation "chart" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN sofarthisyear
2014-10-13 14:34:25 VUT ERROR:  column "sofarthisfinancialyear" of relation "chart" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN sofarthisfinancialyear
2014-10-13 14:34:25 VUT ERROR:  column "last3to6months" of relation "chart" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN last3to6months
2014-10-13 14:34:25 VUT ERROR:  column "last6to9months" of relation "chart" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN last6to9months
2014-10-13 14:34:25 VUT ERROR:  column "last9to12months" of relation "chart" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN last9to12months
2014-10-13 14:34:25 VUT ERROR:  column "last12individualmonths" of relation "chart" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN last12individualmonths
2014-10-13 14:34:25 VUT ERROR:  column "individualmonthsthisyear" of relation "chart" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN individualmonthsthisyear
2014-10-13 14:34:25 VUT ERROR:  column "individualquartersthisyear" of relation "chart" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN individualquartersthisyear
2014-10-13 14:34:25 VUT ERROR:  column "organisationunitgroupsetid" of relation "chart" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN organisationunitgroupsetid
2014-10-13 14:34:25 VUT ERROR:  constraint "fk766ae2938fd8026a" of relation "datasetsource" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE datasetsource DROP CONSTRAINT fk766ae2938fd8026a
2014-10-13 14:34:25 VUT ERROR:  relation "datasetlocksource" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE datasetlocksource DROP CONSTRAINT fk582fdf7e8fd8026a
2014-10-13 14:34:25 VUT ERROR:  constraint "fk_datasetcompleteregistration_sourceid" of relation "completedatasetregistration" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE completedatasetregistration DROP CONSTRAINT fk_datasetcompleteregistration_sourceid
2014-10-13 14:34:25 VUT ERROR:  constraint "fk_minmaxdataelement_sourceid" of relation "minmaxdataelement" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE minmaxdataelement DROP CONSTRAINT fk_minmaxdataelement_sourceid
2014-10-13 14:34:25 VUT ERROR:  constraint "fk_datavalue_sourceid" of relation "datavalue" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE datavalue DROP CONSTRAINT fk_datavalue_sourceid
2014-10-13 14:34:25 VUT ERROR:  constraint "fke509dd5ef1c932ed" of relation "organisationunit" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE organisationunit DROP CONSTRAINT fke509dd5ef1c932ed
2014-10-13 14:34:25 VUT ERROR:  table "source" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  DROP TABLE source CASCADE
2014-10-13 14:34:25 VUT ERROR:  table "datavaluearchive" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  DROP TABLE datavaluearchive
2014-10-13 14:34:25 VUT ERROR:  column "messageconversationkey" of relation "messageconversation" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE messageconversation DROP COLUMN messageconversationkey
2014-10-13 14:34:25 VUT ERROR:  column "messagesubject" of relation "message" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE message DROP COLUMN messagesubject
2014-10-13 14:34:25 VUT ERROR:  column "messagekey" of relation "message" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE message DROP COLUMN messagekey
2014-10-13 14:34:25 VUT ERROR:  column "sentdate" of relation "message" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE message DROP COLUMN sentdate
2014-10-13 14:34:25 VUT ERROR:  column "messagedate" of relation "usermessage" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE usermessage DROP COLUMN messagedate
2014-10-13 14:34:25 VUT ERROR:  table "message_usermessages" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  DROP TABLE message_usermessages
2014-10-13 14:34:25 VUT ERROR:  relation "dataelement_code_key" already exists
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE dataelement ADD CONSTRAINT dataelement_code_key UNIQUE(code)
2014-10-13 14:34:25 VUT ERROR:  relation "indicator_code_key" already exists
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE indicator ADD CONSTRAINT indicator_code_key UNIQUE(code)
2014-10-13 14:34:25 VUT ERROR:  relation "organisationunit_code_key" already exists
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE organisationunit ADD CONSTRAINT organisationunit_code_key UNIQUE(code)
2014-10-13 14:34:25 VUT ERROR:  column "uuid" of relation "attribute" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE attribute DROP COLUMN uuid
2014-10-13 14:34:25 VUT ERROR:  column "uuid" of relation "categorycombo" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE categorycombo DROP COLUMN uuid
2014-10-13 14:34:25 VUT ERROR:  column "uuid" of relation "categoryoptioncombo" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE categoryoptioncombo DROP COLUMN uuid
2014-10-13 14:34:25 VUT ERROR:  column "uuid" of relation "chart" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN uuid
2014-10-13 14:34:25 VUT ERROR:  column "uuid" of relation "concept" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE concept DROP COLUMN uuid
2014-10-13 14:34:25 VUT ERROR:  column "uuid" of relation "constant" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE constant DROP COLUMN uuid
2014-10-13 14:34:25 VUT ERROR:  column "uuid" of relation "datadictionary" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE datadictionary DROP COLUMN uuid
2014-10-13 14:34:25 VUT ERROR:  column "uuid" of relation "dataelement" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE dataelement DROP COLUMN uuid
2014-10-13 14:34:25 VUT ERROR:  column "uuid" of relation "dataelementcategory" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE dataelementcategory DROP COLUMN uuid
2014-10-13 14:34:25 VUT ERROR:  column "uuid" of relation "dataelementcategoryoption" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE dataelementcategoryoption DROP COLUMN uuid
2014-10-13 14:34:25 VUT ERROR:  column "uuid" of relation "dataelementgroup" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE dataelementgroup DROP COLUMN uuid
2014-10-13 14:34:25 VUT ERROR:  column "uuid" of relation "dataelementgroupset" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE dataelementgroupset DROP COLUMN uuid
2014-10-13 14:34:25 VUT ERROR:  column "uuid" of relation "dataset" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE dataset DROP COLUMN uuid
2014-10-13 14:34:25 VUT ERROR:  column "uuid" of relation "indicator" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE indicator DROP COLUMN uuid
2014-10-13 14:34:25 VUT ERROR:  column "uuid" of relation "indicatorgroup" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE indicatorgroup DROP COLUMN uuid
2014-10-13 14:34:25 VUT ERROR:  column "uuid" of relation "indicatorgroupset" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE indicatorgroupset DROP COLUMN uuid
2014-10-13 14:34:25 VUT ERROR:  column "uuid" of relation "indicatortype" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE indicatortype DROP COLUMN uuid
2014-10-13 14:34:25 VUT ERROR:  column "uuid" of relation "orgunitgroup" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE orgunitgroup DROP COLUMN uuid
2014-10-13 14:34:25 VUT ERROR:  column "uuid" of relation "orgunitgroupset" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE orgunitgroupset DROP COLUMN uuid
2014-10-13 14:34:25 VUT ERROR:  column "uuid" of relation "orgunitlevel" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE orgunitlevel DROP COLUMN uuid
2014-10-13 14:34:25 VUT ERROR:  column "uuid" of relation "report" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE report DROP COLUMN uuid
2014-10-13 14:34:25 VUT ERROR:  column "uuid" of relation "validationrule" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE validationrule DROP COLUMN uuid
2014-10-13 14:34:25 VUT ERROR:  column "uuid" of relation "validationrulegroup" does not exist
2014-10-13 14:34:25 VUT STATEMENT:  ALTER TABLE validationrulegroup DROP COLUMN uuid
2014-10-13 14:34:25 VUT ERROR:  column "haspatients" does not exist at character 55
2014-10-13 14:34:25 VUT STATEMENT:  update organisationunit set haspatients = false where haspatients is null
2014-10-13 14:34:25 VUT ERROR:  column "reportingmonth" does not exist at character 53
2014-10-13 14:34:25 VUT STATEMENT:  update reporttable set reportingmonth = false where reportingmonth is null
2014-10-13 14:34:25 VUT ERROR:  column "reportingbimonth" does not exist at character 55
2014-10-13 14:34:25 VUT STATEMENT:  update reporttable set reportingbimonth = false where reportingbimonth is null
2014-10-13 14:34:25 VUT ERROR:  column "reportingquarter" does not exist at character 55
2014-10-13 14:34:25 VUT STATEMENT:  update reporttable set reportingquarter = false where reportingquarter is null
2014-10-13 14:34:25 VUT ERROR:  column "monthsthisyear" does not exist at character 53
2014-10-13 14:34:25 VUT STATEMENT:  update reporttable set monthsthisyear = false where monthsthisyear is null
2014-10-13 14:34:25 VUT ERROR:  column "quartersthisyear" does not exist at character 55
2014-10-13 14:34:25 VUT STATEMENT:  update reporttable set quartersthisyear = false where quartersthisyear is null
2014-10-13 14:34:25 VUT ERROR:  column "thisyear" does not exist at character 47
2014-10-13 14:34:25 VUT STATEMENT:  update reporttable set thisyear = false where thisyear is null
2014-10-13 14:34:25 VUT ERROR:  column "monthslastyear" does not exist at character 53
2014-10-13 14:34:25 VUT STATEMENT:  update reporttable set monthslastyear = false where monthslastyear is null
2014-10-13 14:34:25 VUT ERROR:  column "quarterslastyear" does not exist at character 55
2014-10-13 14:34:25 VUT STATEMENT:  update reporttable set quarterslastyear = false where quarterslastyear is null
2014-10-13 14:34:25 VUT ERROR:  column "lastyear" does not exist at character 47
2014-10-13 14:34:25 VUT STATEMENT:  update reporttable set lastyear = false where lastyear is null
2014-10-13 14:34:25 VUT ERROR:  column "last5years" does not exist at character 49
2014-10-13 14:34:25 VUT STATEMENT:  update reporttable set last5years = false where last5years is null
2014-10-13 14:34:25 VUT ERROR:  column "lastsixmonth" does not exist at character 51
2014-10-13 14:34:25 VUT STATEMENT:  update reporttable set lastsixmonth = false where lastsixmonth is null
2014-10-13 14:34:25 VUT ERROR:  column "last4quarters" does not exist at character 52
2014-10-13 14:34:25 VUT STATEMENT:  update reporttable set last4quarters = false where last4quarters is null
2014-10-13 14:34:25 VUT ERROR:  column "last12months" does not exist at character 51
2014-10-13 14:34:25 VUT STATEMENT:  update reporttable set last12months = false where last12months is null
2014-10-13 14:34:25 VUT ERROR:  column "last3months" does not exist at character 50
2014-10-13 14:34:25 VUT STATEMENT:  update reporttable set last3months = false where last3months is null
2014-10-13 14:34:25 VUT ERROR:  column "last6bimonths" does not exist at character 52
2014-10-13 14:34:25 VUT STATEMENT:  update reporttable set last6bimonths = false where last6bimonths is null
2014-10-13 14:34:25 VUT ERROR:  column "last4quarters" does not exist at character 52
2014-10-13 14:34:25 VUT STATEMENT:  update reporttable set last4quarters = false where last4quarters is null
2014-10-13 14:34:25 VUT ERROR:  column "last2sixmonths" does not exist at character 53
2014-10-13 14:34:25 VUT STATEMENT:  update reporttable set last2sixmonths = false where last2sixmonths is null
2014-10-13 14:34:25 VUT ERROR:  column "thisfinancialyear" does not exist at character 56
2014-10-13 14:34:25 VUT STATEMENT:  update reporttable set thisfinancialyear = false where thisfinancialyear is null
2014-10-13 14:34:25 VUT ERROR:  column "lastfinancialyear" does not exist at character 56
2014-10-13 14:34:25 VUT STATEMENT:  update reporttable set lastfinancialyear = false where lastfinancialyear is null
2014-10-13 14:34:25 VUT ERROR:  column "last5financialyears" does not exist at character 58
2014-10-13 14:34:25 VUT STATEMENT:  update reporttable set last5financialyears = false where last5financialyears is null
2014-10-13 14:34:25 VUT ERROR:  column "reportingbimonth" does not exist at character 49
2014-10-13 14:34:25 VUT STATEMENT:  update chart set reportingbimonth = false where reportingbimonth is null
2014-10-13 14:34:25 VUT ERROR:  column "monthsthisyear" does not exist at character 47
2014-10-13 14:34:25 VUT STATEMENT:  update chart set monthsthisyear = false where monthsthisyear is null
2014-10-13 14:34:25 VUT ERROR:  column "quartersthisyear" does not exist at character 49
2014-10-13 14:34:25 VUT STATEMENT:  update chart set quartersthisyear = false where quartersthisyear is null
2014-10-13 14:34:26 VUT ERROR:  column "monthslastyear" does not exist at character 47
2014-10-13 14:34:26 VUT STATEMENT:  update chart set monthslastyear = false where monthslastyear is null
2014-10-13 14:34:26 VUT ERROR:  column "quarterslastyear" does not exist at character 49
2014-10-13 14:34:26 VUT STATEMENT:  update chart set quarterslastyear = false where quarterslastyear is null
2014-10-13 14:34:26 VUT ERROR:  column "last6bimonths" does not exist at character 46
2014-10-13 14:34:26 VUT STATEMENT:  update chart set last6bimonths = false where last6bimonths is null
2014-10-13 14:34:26 VUT ERROR:  column "filter" does not exist at character 76
2014-10-13 14:34:26 VUT HINT:  There is a column named "filter" in table "chart_filters", but it cannot be referenced from this part of the query.
2014-10-13 14:34:26 VUT STATEMENT:  insert into chart_filters (chartid, sort_order, filter) select chartid, 0, filter from chart
2014-10-13 14:34:26 VUT ERROR:  column "filter" of relation "chart" does not exist
2014-10-13 14:34:26 VUT STATEMENT:  alter table chart drop column filter
2014-10-13 14:34:26 VUT ERROR:  table "reportgroupmembers" does not exist
2014-10-13 14:34:26 VUT STATEMENT:  DROP TABLE reportgroupmembers
2014-10-13 14:34:26 VUT ERROR:  table "reportgroup" does not exist
2014-10-13 14:34:26 VUT STATEMENT:  DROP TABLE reportgroup
2014-10-13 14:34:26 VUT ERROR:  table "reporttablegroupmembers" does not exist
2014-10-13 14:34:26 VUT STATEMENT:  DROP TABLE reporttablegroupmembers
2014-10-13 14:34:26 VUT ERROR:  table "reporttablegroup" does not exist
2014-10-13 14:34:26 VUT STATEMENT:  DROP TABLE reporttablegroup
2014-10-13 14:34:26 VUT ERROR:  table "chartgroupmembers" does not exist
2014-10-13 14:34:26 VUT STATEMENT:  DROP TABLE chartgroupmembers
2014-10-13 14:34:26 VUT ERROR:  table "chartgroup" does not exist
2014-10-13 14:34:26 VUT STATEMENT:  DROP TABLE chartgroup
2014-10-13 14:34:26 VUT ERROR:  cannot alter type of a column used by a view or rule
2014-10-13 14:34:26 VUT DETAIL:  rule _RETURN on view _view_data_elements depends on column "shortname"
2014-10-13 14:34:26 VUT STATEMENT:  ALTER TABLE dataelement ALTER COLUMN shortname TYPE character varying(50)
2014-10-13 14:34:26 VUT ERROR:  cannot alter type of a column used by a view or rule
2014-10-13 14:34:26 VUT DETAIL:  rule _RETURN on view _view_facility_import_view depends on column "shortname"
2014-10-13 14:34:26 VUT STATEMENT:  ALTER TABLE organisationunit ALTER COLUMN shortname TYPE character varying(50)
2014-10-13 14:34:26 VUT ERROR:  constraint "organisationunit_name_key" of relation "organisationunit" does not exist
2014-10-13 14:34:26 VUT STATEMENT:  ALTER TABLE organisationunit DROP CONSTRAINT organisationunit_name_key
2014-10-13 14:34:26 VUT ERROR:  relation "orgunitgroup_name_key" already exists
2014-10-13 14:34:26 VUT STATEMENT:  ALTER TABLE orgunitgroup ADD CONSTRAINT orgunitgroup_name_key UNIQUE (name)
2014-10-13 14:34:26 VUT ERROR:  relation "orgunitgroupset_name_key" already exists
2014-10-13 14:34:26 VUT STATEMENT:  ALTER TABLE orgunitgroupset ADD CONSTRAINT orgunitgroupset_name_key UNIQUE (name)
2014-10-13 14:34:26 VUT ERROR:  constraint "indicator_name_key" of relation "indicator" does not exist
2014-10-13 14:34:26 VUT STATEMENT:  ALTER TABLE indicator DROP CONSTRAINT indicator_name_key
2014-10-13 14:34:26 VUT ERROR:  constraint "indicator_shortname_key" of relation "indicator" does not exist
2014-10-13 14:34:26 VUT STATEMENT:  ALTER TABLE indicator DROP CONSTRAINT indicator_shortname_key
2014-10-13 14:34:26 VUT ERROR:  constraint "indicatorgroup_name_key" of relation "indicatorgroup" does not exist
2014-10-13 14:34:26 VUT STATEMENT:  ALTER TABLE indicatorgroup DROP CONSTRAINT indicatorgroup_name_key
2014-10-13 14:34:26 VUT ERROR:  constraint "indicatorgroupset_name_key" of relation "indicatorgroupset" does not exist
2014-10-13 14:34:26 VUT STATEMENT:  ALTER TABLE indicatorgroupset DROP CONSTRAINT indicatorgroupset_name_key
2014-10-13 14:34:26 VUT ERROR:  constraint "dataset_name_key" of relation "dataset" does not exist
2014-10-13 14:34:26 VUT STATEMENT:  ALTER TABLE dataset DROP CONSTRAINT dataset_name_key
2014-10-13 14:34:26 VUT ERROR:  constraint "dataset_shortname_key" of relation "dataset" does not exist
2014-10-13 14:34:26 VUT STATEMENT:  ALTER TABLE dataset DROP CONSTRAINT dataset_shortname_key
2014-10-13 14:34:26 VUT ERROR:  constraint "document_name_key" of relation "document" does not exist
2014-10-13 14:34:26 VUT STATEMENT:  ALTER TABLE document DROP CONSTRAINT document_name_key
2014-10-13 14:34:26 VUT ERROR:  constraint "reporttable_name_key" of relation "reporttable" does not exist
2014-10-13 14:34:26 VUT STATEMENT:  ALTER TABLE reporttable DROP CONSTRAINT reporttable_name_key
2014-10-13 14:34:26 VUT ERROR:  constraint "report_name_key" of relation "report" does not exist
2014-10-13 14:34:26 VUT STATEMENT:  ALTER TABLE report DROP CONSTRAINT report_name_key
2014-10-13 14:34:26 VUT ERROR:  constraint "usergroup_name_key" of relation "usergroup" does not exist
2014-10-13 14:34:26 VUT STATEMENT:  ALTER TABLE usergroup DROP CONSTRAINT usergroup_name_key
2014-10-13 14:34:26 VUT ERROR:  constraint "datadictionary_name_key" of relation "datadictionary" does not exist
2014-10-13 14:34:26 VUT STATEMENT:  ALTER TABLE datadictionary DROP CONSTRAINT datadictionary_name_key
2014-10-13 14:34:26 VUT ERROR:  column "reportingmonth" does not exist at character 8
2014-10-13 14:34:26 VUT STATEMENT:  select reportingmonth, * from reporttable
2014-10-13 14:34:26 VUT ERROR:  column "doindicators" does not exist at character 23
2014-10-13 14:34:26 VUT STATEMENT:  select reporttableid, doindicators, doperiods, dounits, categorycomboid from reporttable
2014-10-13 14:34:26 VUT ERROR:  column "conceptid" of relation "dataelementcategory" does not exist
2014-10-13 14:34:26 VUT STATEMENT:  ALTER TABLE dataelementcategory DROP COLUMN conceptid
2014-10-13 14:34:26 VUT ERROR:  column "conceptid" of relation "dataelementcategoryoption" does not exist
2014-10-13 14:34:26 VUT STATEMENT:  ALTER TABLE dataelementcategoryoption DROP COLUMN conceptid
2014-10-13 14:34:27 VUT ERROR:  column "validationrulegroupid" of relation "validationrulegroup" already exists
2014-10-13 14:34:27 VUT STATEMENT:  alter table validationrulegroup rename column validationgroupid to validationrulegroupid
2014-10-13 14:34:27 VUT ERROR:  column "viweid" does not exist at character 30
2014-10-13 14:34:27 VUT STATEMENT:  update sqlview set sqlviewid=viweid
2014-10-13 14:34:27 VUT ERROR:  column "viewid" of relation "sqlview" does not exist
2014-10-13 14:34:27 VUT STATEMENT:  alter table sqlview drop column viewid
2014-10-13 14:34:27 VUT ERROR:  cannot alter type of a column used by a view or rule
2014-10-13 14:34:27 VUT DETAIL:  rule _RETURN on view _view_number_of_import_elements depends on column "lastupdated"
2014-10-13 14:34:27 VUT STATEMENT:  ALTER TABLE datavalue ALTER COLUMN lastupdated TYPE timestamp
2014-10-13 14:34:27 VUT ERROR:  index "crosstab" does not exist
2014-10-13 14:34:27 VUT STATEMENT:  drop index crosstab
2014-10-13 14:34:27 VUT ERROR:  column "symbol" of relation "dataset" does not exist
2014-10-13 14:34:27 VUT STATEMENT:  ALTER TABLE dataset DROP COLUMN symbol
2014-10-13 14:34:27 VUT ERROR:  column "operator" of relation "trackedentityattributedimension" does not exist
2014-10-13 14:34:27 VUT STATEMENT:  ALTER TABLE trackedentityattributedimension DROP COLUMN operator
2014-10-13 14:34:27 VUT ERROR:  column "operator" of relation "trackedentitydataelementdimension" does not exist
2014-10-13 14:34:27 VUT STATEMENT:  ALTER TABLE trackedentitydataelementdimension DROP COLUMN operator
2014-10-13 14:34:27 VUT ERROR:  column "dataelementid" does not exist at character 96
2014-10-13 14:34:27 VUT HINT:  There is a column named "dataelementid" in table "mapview_dataelements", but it cannot be referenced from this part of the query.
2014-10-13 14:34:27 VUT STATEMENT:  insert into mapview_dataelements ( mapviewid, sort_order, dataelementid ) select mapviewid, 0, dataelementid from mapview where dataelementid is not null
2014-10-13 14:34:27 VUT ERROR:  column "dataelementid" of relation "mapview" does not exist
2014-10-13 14:34:27 VUT STATEMENT:  alter table mapview drop column dataelementid
2014-10-13 14:34:27 VUT ERROR:  column "dataelementoperandid" does not exist at character 110
2014-10-13 14:34:27 VUT HINT:  There is a column named "dataelementoperandid" in table "mapview_dataelementoperands", but it cannot be referenced from this part of the query.
2014-10-13 14:34:27 VUT STATEMENT:  insert into mapview_dataelementoperands ( mapviewid, sort_order, dataelementoperandid ) select mapviewid, 0, dataelementoperandid from mapview where dataelementoperandid is not null
2014-10-13 14:34:27 VUT ERROR:  column "dataelementoperandid" of relation "mapview" does not exist
2014-10-13 14:34:27 VUT STATEMENT:  alter table mapview drop column dataelementoperandid
2014-10-13 14:34:27 VUT ERROR:  column "indicatorid" does not exist at character 92
2014-10-13 14:34:27 VUT HINT:  There is a column named "indicatorid" in table "mapview_indicators", but it cannot be referenced from this part of the query.
2014-10-13 14:34:27 VUT STATEMENT:  insert into mapview_indicators ( mapviewid, sort_order, indicatorid ) select mapviewid, 0, indicatorid from mapview where indicatorid is not null
2014-10-13 14:34:27 VUT ERROR:  column "indicatorid" of relation "mapview" does not exist
2014-10-13 14:34:27 VUT STATEMENT:  alter table mapview drop column indicatorid
2014-10-13 14:34:27 VUT ERROR:  column "parentorganisationunitid" does not exist at character 106
2014-10-13 14:34:27 VUT STATEMENT:  insert into mapview_organisationunits ( mapviewid, sort_order, organisationunitid ) select mapviewid, 0, parentorganisationunitid from mapview where parentorganisationunitid is not null
2014-10-13 14:34:27 VUT ERROR:  column "parentorganisationunitid" of relation "mapview" does not exist
2014-10-13 14:34:27 VUT STATEMENT:  alter table mapview drop column parentorganisationunitid
2014-10-13 14:34:27 VUT ERROR:  column "periodid" does not exist at character 86
2014-10-13 14:34:27 VUT HINT:  There is a column named "periodid" in table "mapview_periods", but it cannot be referenced from this part of the query.
2014-10-13 14:34:27 VUT STATEMENT:  insert into mapview_periods ( mapviewid, sort_order, periodid ) select mapviewid, 0, periodid from mapview where periodid is not null
2014-10-13 14:34:27 VUT ERROR:  column "periodid" of relation "mapview" does not exist
2014-10-13 14:34:27 VUT STATEMENT:  alter table mapview drop column periodid
2014-10-13 14:34:27 VUT ERROR:  column m.organisationunitlevelid does not exist at character 145
2014-10-13 14:34:27 VUT STATEMENT:  insert into mapview_orgunitlevels ( mapviewid, sort_order, orgunitlevel ) select m.mapviewid, 0, o.level from mapview m join orgunitlevel o on (m.organisationunitlevelid=o.orgunitlevelid) where m.organisationunitlevelid is not null
2014-10-13 14:34:27 VUT ERROR:  column "organisationunitlevelid" of relation "mapview" does not exist
2014-10-13 14:34:27 VUT STATEMENT:  alter table mapview drop column organisationunitlevelid
2014-10-13 14:34:27 VUT ERROR:  column "dataelementgroupid" of relation "mapview" does not exist
2014-10-13 14:34:27 VUT STATEMENT:  alter table mapview drop column dataelementgroupid
2014-10-13 14:34:27 VUT ERROR:  column "indicatorgroupid" of relation "mapview" does not exist
2014-10-13 14:34:27 VUT STATEMENT:  alter table mapview drop column indicatorgroupid
2014-10-13 14:34:27 VUT ERROR:  column "description" does not exist
2014-10-13 14:34:27 VUT STATEMENT:  ALTER TABLE relationshiptype RENAME description TO name
2014-10-13 14:34:27 VUT ERROR:  column "showonreport" of relation "programstage_dataelements" does not exist
2014-10-13 14:34:27 VUT STATEMENT:  ALTER TABLE programstage_dataelements DROP COLUMN showOnReport
2014-10-13 14:34:27 VUT ERROR:  column "hidedateofincident" of relation "program" does not exist
2014-10-13 14:34:27 VUT STATEMENT:  ALTER TABLE program DROP COLUMN hidedateofincident
2014-10-13 14:34:27 VUT ERROR:  column "singleevent" does not exist at character 33
2014-10-13 14:34:27 VUT STATEMENT:  UPDATE program SET type=2 where singleevent=true
2014-10-13 14:34:27 VUT ERROR:  column "anonymous" does not exist at character 33
2014-10-13 14:34:27 VUT STATEMENT:  UPDATE program SET type=3 where anonymous=true
2014-10-13 14:34:27 VUT ERROR:  column "singleevent" of relation "program" does not exist
2014-10-13 14:34:27 VUT STATEMENT:  ALTER TABLE program DROP COLUMN singleevent
2014-10-13 14:34:27 VUT ERROR:  column "anonymous" of relation "program" does not exist
2014-10-13 14:34:27 VUT STATEMENT:  ALTER TABLE program DROP COLUMN anonymous
2014-10-13 14:34:27 VUT ERROR:  table "programattributevalue" does not exist
2014-10-13 14:34:27 VUT STATEMENT:  DROP TABLE programattributevalue
2014-10-13 14:34:27 VUT ERROR:  table "programinstance_attributes" does not exist
2014-10-13 14:34:27 VUT STATEMENT:  DROP TABLE programinstance_attributes
2014-10-13 14:34:27 VUT ERROR:  table "programattributeoption" does not exist
2014-10-13 14:34:27 VUT STATEMENT:  DROP TABLE programattributeoption
2014-10-13 14:34:27 VUT ERROR:  table "programattribute" does not exist
2014-10-13 14:34:27 VUT STATEMENT:  DROP TABLE programattribute
2014-10-13 14:34:27 VUT ERROR:  column "description" does not exist
2014-10-13 14:34:27 VUT STATEMENT:  ALTER TABLE caseaggregationcondition RENAME description TO name
2014-10-13 14:34:27 VUT ERROR:  column "providedbyanotherfacility" of relation "programstageinstance" does not exist
2014-10-13 14:34:27 VUT STATEMENT:  ALTER TABLE programstageinstance DROP COLUMN providedbyanotherfacility
2014-10-13 14:34:27 VUT ERROR:  column "stageinprogram" of relation "programstageinstance" does not exist
2014-10-13 14:34:27 VUT STATEMENT:  ALTER TABLE programstageinstance DROP COLUMN stageInProgram
2014-10-13 14:34:28 VUT ERROR:  relation "programstageinstance_executiondate" already exists
2014-10-13 14:34:28 VUT STATEMENT:  CREATE INDEX programstageinstance_executiondate ON programstageinstance (executiondate)
2014-10-13 14:34:28 VUT ERROR:  column "generatedbyenrollmentdate" does not exist at character 58
2014-10-13 14:34:28 VUT STATEMENT:  UPDATE program SET generatedByEnrollmentDate=false WHERE generatedByEnrollmentDate is null
2014-10-13 14:34:28 VUT ERROR:  column "stageinprogram" of relation "programstage" does not exist
2014-10-13 14:34:28 VUT STATEMENT:  ALTER TABLE programstage DROP COLUMN stageinprogram
2014-10-13 14:34:28 VUT ERROR:  relation "index_programinstance" already exists
2014-10-13 14:34:28 VUT STATEMENT:  CREATE INDEX index_programinstance ON programinstance( programinstanceid )
2014-10-13 14:34:28 VUT ERROR:  column "maxdaysallowedinputdata" of relation "program" does not exist
2014-10-13 14:34:28 VUT STATEMENT:  ALTER TABLE program DROP COLUMN maxDaysAllowedInputData
2014-10-13 14:34:28 VUT ERROR:  syntax error at or near "modify" at character 20
2014-10-13 14:34:28 VUT STATEMENT:  ALTER TABLE period modify periodid int AUTO_INCREMENT
2014-10-13 14:34:28 VUT ERROR:  column "displayinreports" does not exist at character 58
2014-10-13 14:34:28 VUT STATEMENT:  UPDATE program SET programstage_dataelements=false WHERE displayInReports is null
2014-10-13 14:34:28 VUT ERROR:  column "leftside" of relation "programvalidation" does not exist
2014-10-13 14:34:28 VUT STATEMENT:  ALTER TABLE programvalidation DROP COLUMN leftside
2014-10-13 14:34:28 VUT ERROR:  column "rightside" of relation "programvalidation" does not exist
2014-10-13 14:34:28 VUT STATEMENT:  ALTER TABLE programvalidation DROP COLUMN rightside
2014-10-13 14:34:28 VUT ERROR:  column "datetype" of relation "programvalidation" does not exist
2014-10-13 14:34:28 VUT STATEMENT:  ALTER TABLE programvalidation DROP COLUMN dateType
2014-10-13 14:34:28 VUT ERROR:  column "name" of relation "programvalidation" already exists
2014-10-13 14:34:28 VUT STATEMENT:  ALTER TABLE programvalidation RENAME description TO name
2014-10-13 14:34:28 VUT ERROR:  column "blockentryform" does not exist at character 47
2014-10-13 14:34:28 VUT STATEMENT:  UPDATE program SET blockEntryForm=false WHERE blockEntryForm is null
2014-10-13 14:34:28 VUT ERROR:  constraint "program_name_key" of relation "dataset" does not exist
2014-10-13 14:34:28 VUT STATEMENT:  ALTER TABLE dataset DROP CONSTRAINT program_name_key
2014-10-13 14:34:28 VUT ERROR:  relation "prorgam" does not exist at character 8
2014-10-13 14:34:28 VUT STATEMENT:  update prorgam set "operator"='times' where "operator"='SUM'
2014-10-13 14:34:28 VUT ERROR:  column "remindcompleted" does not exist at character 48
2014-10-13 14:34:28 VUT STATEMENT:  update program set remindCompleted=false where remindCompleted is null
2014-10-13 14:34:28 VUT ERROR:  column "completed" does not exist at character 43
2014-10-13 14:34:28 VUT STATEMENT:  UPDATE programinstance SET status=0 WHERE completed=false
2014-10-13 14:34:28 VUT ERROR:  column pi.completed does not exist at character 209
2014-10-13 14:34:28 VUT STATEMENT:  UPDATE programinstance SET status=2 WHERE programinstanceid in ( select psi.programinstanceid from programinstance pi join programstageinstance psi on psi.programinstanceid = psi.programstageinstanceid where pi.completed=true and psi.completed = false )
2014-10-13 14:34:28 VUT ERROR:  column "completed" of relation "programinstance" does not exist
2014-10-13 14:34:28 VUT STATEMENT:  ALTER TABLE programinstance DROP COLUMN completed
2014-10-13 14:34:28 VUT ERROR:  column "disableregistrationfields" of relation "program" does not exist
2014-10-13 14:34:28 VUT STATEMENT:  ALTER TABLE program DROP COLUMN disableRegistrationFields
2014-10-13 14:34:28 VUT ERROR:  column "useformnamedataelement" does not exist at character 54
2014-10-13 14:34:28 VUT STATEMENT:  UPDATE program SET useFormNameDataElement=true where useFormNameDataElement is null
2014-10-13 14:34:28 VUT ERROR:  column "generatedbyenrollmentdate" of relation "program" does not exist
2014-10-13 14:34:28 VUT STATEMENT:  ALTER TABLE program DROP COLUMN generatedByEnrollmentDate
2014-10-13 14:34:28 VUT ERROR:  column "blockentryform" of relation "program" does not exist
2014-10-13 14:34:28 VUT STATEMENT:  ALTER TABLE program DROP COLUMN blockEntryForm
2014-10-13 14:34:28 VUT ERROR:  column "remindcompleted" of relation "program" does not exist
2014-10-13 14:34:28 VUT STATEMENT:  ALTER TABLE program DROP COLUMN remindCompleted
2014-10-13 14:34:28 VUT ERROR:  column "displayprovidedotherfacility" of relation "program" does not exist
2014-10-13 14:34:28 VUT STATEMENT:  ALTER TABLE program DROP COLUMN displayProvidedOtherFacility
2014-10-13 14:34:28 VUT ERROR:  column "facilitylb" of relation "program" does not exist
2014-10-13 14:34:28 VUT STATEMENT:  ALTER TABLE program DROP COLUMN facilityLB
2014-10-13 14:34:28 VUT ERROR:  column "coordinates" does not exist at character 32
2014-10-13 14:34:28 VUT STATEMENT:  SELECT programstageinstanceid, coordinates FROM programstageinstance where coordinates is not null
2014-10-13 14:34:28 VUT ERROR:  column "usebirthdateasincidentdate" of relation "program" does not exist
2014-10-13 14:34:28 VUT STATEMENT:  ALTER TABLE program DROP COLUMN useBirthDateAsIncidentDate
2014-10-13 14:34:28 VUT ERROR:  column "usebirthdateasenrollmentdate" of relation "program" does not exist
2014-10-13 14:34:28 VUT STATEMENT:  ALTER TABLE program DROP COLUMN useBirthDateAsEnrollmentDate
2014-10-13 14:34:28 VUT ERROR:  column "name" does not exist at character 82
2014-10-13 14:34:28 VUT STATEMENT:  update userroleauthorities set "name"='trackedEntityExcelTemplateFileName' where "name"='patientExcelTemplateFileName'
2014-10-13 14:34:28 VUT ERROR:  column "mandatory" of relation "trackedentityattribute" does not exist at character 112
2014-10-13 14:34:28 VUT STATEMENT:  INSERT INTO trackedentityattribute ( trackedentityattributeid, uid, lastUpdated, name, description, valueType, mandatory, inherit, displayOnVisitSchedule, uniquefield, orgunitScope, programScope ) select nextval('hibernate_sequence'), uid, lastUpdated, name,  description, type, mandatory, false, false, true, orgunitScope, programScope from patientidentifiertype
2014-10-13 14:34:28 VUT ERROR:  relation "patientidentifier" does not exist at character 178
2014-10-13 14:34:28 VUT STATEMENT:  INSERT INTO trackedentityattributevalue (trackedentityinstanceid, trackedentityattributeid, value ) select trackedentityinstanceid, pa.trackedentityattributeid, identifier from patientidentifier pi inner join patientidentifiertype pit on pi.patientidentifiertypeid=pit.patientidentifiertypeid inner join trackedentityattribute pa on pa.uid=pit.uid where pi.trackedentityinstanceid is not null
2014-10-13 14:34:28 VUT ERROR:  table "program_identifiertypes" does not exist
2014-10-13 14:34:28 VUT STATEMENT:  DROP TABLE program_identifiertypes
2014-10-13 14:34:28 VUT ERROR:  table "patientidentifier" does not exist
2014-10-13 14:34:28 VUT STATEMENT:  DROP TABLE patientidentifier
2014-10-13 14:34:28 VUT ERROR:  table "patientidentifiertype" does not exist
2014-10-13 14:34:28 VUT STATEMENT:  DROP TABLE patientidentifiertype
2014-10-13 14:34:28 VUT ERROR:  constraint "fk_patientidentifiertype_periodtypeid" for table "trackedentityattribute" does not exist
2014-10-13 14:34:28 VUT STATEMENT:  ALTER TABLE trackedentityattribute RENAME CONSTRAINT fk_patientidentifiertype_periodtypeid TO trackedentityattribute_periodtypeid
2014-10-13 14:34:28 VUT ERROR:  column "programattributeid" does not exist
2014-10-13 14:34:28 VUT STATEMENT:  ALTER TABLE program_attributes RENAME COLUMN programattributeid TO programtrackedentityattributeid
2014-10-13 14:34:28 VUT ERROR:  column "trackedentityattributeoptionid" of relation "trackedentityattributevalue" does not exist
2014-10-13 14:34:28 VUT STATEMENT:  ALTER TABLE trackedentityattributevalue DROP COLUMN trackedentityattributeoptionid
2014-10-13 14:34:28 VUT ERROR:  table "trackedentityattributeoption" does not exist
2014-10-13 14:34:28 VUT STATEMENT:  DROP TABLE trackedentityattributeoption
2014-10-13 14:34:28 VUT ERROR:  column trackedentityattribute.mandatory does not exist at character 43
2014-10-13 14:34:28 VUT STATEMENT:  UPDATE program_attributes SET mandatory = trackedentityattribute.mandatory FROM program_attributes pa INNER JOIN trackedentityattribute  ON pa.trackedentityattributeid=trackedentityattribute.trackedentityattributeid  where trackedentityattribute.mandatory is not null
2014-10-13 14:34:28 VUT ERROR:  column "mandatory" of relation "trackedentityattribute" does not exist
2014-10-13 14:34:28 VUT STATEMENT:  ALTER TABLE trackedentityattribute DROP COLUMN mandatory
2014-10-13 14:34:28 VUT ERROR:  column "groupby" of relation "trackedentityattribute" does not exist
2014-10-13 14:34:28 VUT STATEMENT:  ALTER TABLE trackedentityattribute DROP COLUMN groupBy
2014-10-13 14:34:29 VUT ERROR:  column "allowdateinfuture" does not exist at character 49
2014-10-13 14:34:29 VUT STATEMENT:  update program_attributes set allowfuturedate = allowdateinfuture where allowfuturedate is null
2014-10-13 14:34:29 VUT ERROR:  column "allowdateinfuture" of relation "program_attributes" does not exist
2014-10-13 14:34:29 VUT STATEMENT:  ALTER TABLE program_attributes DROP COLUMN allowdateinfuture
2014-10-13 14:34:29 VUT ERROR:  sequence "period_periodid_seq" does not exist
2014-10-13 14:34:29 VUT STATEMENT:  DROP SEQUENCE period_periodid_seq
2014-10-13 14:34:29 VUT ERROR:  relation "constant_uid_key" already exists
2014-10-13 14:34:29 VUT STATEMENT:  ALTER TABLE constant ADD CONSTRAINT constant_uid_key UNIQUE(uid)
2014-10-13 14:34:29 VUT ERROR:  relation "concept_uid_key" already exists
2014-10-13 14:34:29 VUT STATEMENT:  ALTER TABLE concept ADD CONSTRAINT concept_uid_key UNIQUE(uid)
2014-10-13 14:34:29 VUT ERROR:  relation "attribute_uid_key" already exists
2014-10-13 14:34:29 VUT STATEMENT:  ALTER TABLE attribute ADD CONSTRAINT attribute_uid_key UNIQUE(uid)
2014-10-13 14:34:29 VUT ERROR:  relation "indicatortype_uid_key" already exists
2014-10-13 14:34:29 VUT STATEMENT:  ALTER TABLE indicatortype ADD CONSTRAINT indicatortype_uid_key UNIQUE(uid)
2014-10-13 14:34:29 VUT ERROR:  relation "indicator_uid_key" already exists
2014-10-13 14:34:29 VUT STATEMENT:  ALTER TABLE indicator ADD CONSTRAINT indicator_uid_key UNIQUE(uid)
2014-10-13 14:34:29 VUT ERROR:  relation "indicatorgroup_uid_key" already exists
2014-10-13 14:34:29 VUT STATEMENT:  ALTER TABLE indicatorgroup ADD CONSTRAINT indicatorgroup_uid_key UNIQUE(uid)
2014-10-13 14:34:29 VUT ERROR:  relation "indicatorgroupset_uid_key" already exists
2014-10-13 14:34:29 VUT STATEMENT:  ALTER TABLE indicatorgroupset ADD CONSTRAINT indicatorgroupset_uid_key UNIQUE(uid)
2014-10-13 14:34:29 VUT ERROR:  relation "datadictionary_uid_key" already exists
2014-10-13 14:34:29 VUT STATEMENT:  ALTER TABLE datadictionary ADD CONSTRAINT datadictionary_uid_key UNIQUE(uid)
2014-10-13 14:34:29 VUT ERROR:  relation "validationrule_uid_key" already exists
2014-10-13 14:34:29 VUT STATEMENT:  ALTER TABLE validationrule ADD CONSTRAINT validationrule_uid_key UNIQUE(uid)
2014-10-13 14:34:29 VUT ERROR:  relation "validationrulegroup_uid_key" already exists
2014-10-13 14:34:29 VUT STATEMENT:  ALTER TABLE validationrulegroup ADD CONSTRAINT validationrulegroup_uid_key UNIQUE(uid)
2014-10-13 14:34:29 VUT ERROR:  relation "dataset_uid_key" already exists
2014-10-13 14:34:29 VUT STATEMENT:  ALTER TABLE dataset ADD CONSTRAINT dataset_uid_key UNIQUE(uid)
2014-10-13 14:34:29 VUT ERROR:  relation "section_uid_key" already exists
2014-10-13 14:34:29 VUT STATEMENT:  ALTER TABLE section ADD CONSTRAINT section_uid_key UNIQUE(uid)
2014-10-13 14:34:29 VUT ERROR:  relation "orgunitlevel_uid_key" already exists
2014-10-13 14:34:29 VUT STATEMENT:  ALTER TABLE orgunitlevel ADD CONSTRAINT orgunitlevel_uid_key UNIQUE(uid)
2014-10-13 14:34:29 VUT ERROR:  relation "organisationunit_uid_key" already exists
2014-10-13 14:34:29 VUT STATEMENT:  ALTER TABLE organisationunit ADD CONSTRAINT organisationunit_uid_key UNIQUE(uid)
2014-10-13 14:34:29 VUT ERROR:  relation "orgunitgroup_uid_key" already exists
2014-10-13 14:34:29 VUT STATEMENT:  ALTER TABLE orgunitgroup ADD CONSTRAINT orgunitgroup_uid_key UNIQUE(uid)
2014-10-13 14:34:29 VUT ERROR:  relation "orgunitgroupset_uid_key" already exists
2014-10-13 14:34:29 VUT STATEMENT:  ALTER TABLE orgunitgroupset ADD CONSTRAINT orgunitgroupset_uid_key UNIQUE(uid)
2014-10-13 14:34:29 VUT ERROR:  relation "dataelement_uid_key" already exists
2014-10-13 14:34:29 VUT STATEMENT:  ALTER TABLE dataelement ADD CONSTRAINT dataelement_uid_key UNIQUE(uid)
2014-10-13 14:34:29 VUT ERROR:  relation "dataelementgroup_uid_key" already exists
2014-10-13 14:34:29 VUT STATEMENT:  ALTER TABLE dataelementgroup ADD CONSTRAINT dataelementgroup_uid_key UNIQUE(uid)
2014-10-13 14:34:29 VUT ERROR:  relation "dataelementgroupset_uid_key" already exists
2014-10-13 14:34:29 VUT STATEMENT:  ALTER TABLE dataelementgroupset ADD CONSTRAINT dataelementgroupset_uid_key UNIQUE(uid)
2014-10-13 14:34:29 VUT ERROR:  relation "sqlview_uid_key" already exists
2014-10-13 14:34:29 VUT STATEMENT:  ALTER TABLE sqlview ADD CONSTRAINT sqlview_uid_key UNIQUE(uid)
2014-10-13 14:34:29 VUT ERROR:  relation "dataelementcategory_uid_key" already exists
2014-10-13 14:34:29 VUT STATEMENT:  ALTER TABLE dataelementcategory ADD CONSTRAINT dataelementcategory_uid_key UNIQUE(uid)
2014-10-13 14:34:29 VUT ERROR:  relation "dataelementcategoryoption_uid_key" already exists
2014-10-13 14:34:29 VUT STATEMENT:  ALTER TABLE dataelementcategoryoption ADD CONSTRAINT dataelementcategoryoption_uid_key UNIQUE(uid)
2014-10-13 14:34:29 VUT ERROR:  relation "categorycombo_uid_key" already exists
2014-10-13 14:34:29 VUT STATEMENT:  ALTER TABLE categorycombo ADD CONSTRAINT categorycombo_uid_key UNIQUE(uid)
2014-10-13 14:34:29 VUT ERROR:  relation "categoryoptioncombo_uid_key" already exists
2014-10-13 14:34:29 VUT STATEMENT:  ALTER TABLE categoryoptioncombo ADD CONSTRAINT categoryoptioncombo_uid_key UNIQUE(uid)
2014-10-13 14:34:29 VUT ERROR:  relation "userinfo_uid_key" already exists
2014-10-13 14:34:29 VUT STATEMENT:  ALTER TABLE userinfo ADD CONSTRAINT userinfo_uid_key UNIQUE(uid)
2014-10-13 14:34:29 VUT ERROR:  relation "usergroup_uid_key" already exists
2014-10-13 14:34:29 VUT STATEMENT:  ALTER TABLE usergroup ADD CONSTRAINT usergroup_uid_key UNIQUE(uid)
2014-10-13 14:34:29 VUT ERROR:  relation "userrole_uid_key" already exists
2014-10-13 14:34:29 VUT STATEMENT:  ALTER TABLE userrole ADD CONSTRAINT userrole_uid_key UNIQUE(uid)
2014-10-13 14:34:29 VUT ERROR:  relation "optionset_uid_key" already exists
2014-10-13 14:34:29 VUT STATEMENT:  ALTER TABLE optionset ADD CONSTRAINT optionset_uid_key UNIQUE(uid)
2014-10-13 14:34:29 VUT ERROR:  relation "aggregateddatavalue" already exists
2014-10-13 14:34:29 VUT STATEMENT:  CREATE TABLE aggregateddatavalue ( dataelementid INTEGER, categoryoptioncomboid INTEGER, periodid INTEGER, organisationunitid INTEGER, periodtypeid INTEGER, level INTEGER, value double precision )
2014-10-13 14:34:29 VUT ERROR:  relation "aggregatedorgunitdatavalue" already exists
2014-10-13 14:34:29 VUT STATEMENT:  CREATE TABLE aggregatedorgunitdatavalue ( dataelementid INTEGER, categoryoptioncomboid INTEGER, periodid INTEGER, organisationunitid INTEGER, organisationunitgroupid INTEGER, periodtypeid INTEGER, level INTEGER, value double precision )
2014-10-13 14:34:29 VUT ERROR:  relation "aggregatedindicatorvalue" already exists
2014-10-13 14:34:29 VUT STATEMENT:  CREATE TABLE aggregatedindicatorvalue ( indicatorid INTEGER, periodid INTEGER, organisationunitid INTEGER, periodtypeid INTEGER, level INTEGER, annualized VARCHAR( 10 ), factor double precision, value double precision, numeratorvalue double precision, denominatorvalue double precision )
2014-10-13 14:34:29 VUT ERROR:  relation "aggregatedorgunitindicatorvalue" already exists
2014-10-13 14:34:29 VUT STATEMENT:  CREATE TABLE aggregatedorgunitindicatorvalue ( indicatorid INTEGER, periodid INTEGER, organisationunitid INTEGER, organisationunitgroupid INTEGER, periodtypeid INTEGER, level INTEGER, annualized VARCHAR( 10 ), factor double precision, value double precision, numeratorvalue double precision, denominatorvalue double precision )
2014-10-13 14:34:29 VUT ERROR:  relation "aggregateddatasetcompleteness" already exists
2014-10-13 14:34:29 VUT STATEMENT:  CREATE TABLE aggregateddatasetcompleteness ( datasetid INTEGER, periodid INTEGER, periodname VARCHAR( 30 ), organisationunitid INTEGER, sources INTEGER, registrations INTEGER, registrationsOnTime INTEGER, value double precision, valueOnTime double precision )
2014-10-13 14:34:29 VUT ERROR:  relation "aggregatedorgunitdatasetcompleteness" already exists
2014-10-13 14:34:29 VUT STATEMENT:  CREATE TABLE aggregatedorgunitdatasetcompleteness ( datasetid INTEGER, periodid INTEGER, periodname VARCHAR( 30 ), organisationunitid INTEGER, organisationunitgroupid INTEGER, sources INTEGER, registrations INTEGER, registrationsOnTime INTEGER, value double precision, valueOnTime double precision )
2014-10-13 14:34:29 VUT ERROR:  relation "messageconversation_lastmessage" already exists
2014-10-13 14:34:29 VUT STATEMENT:  CREATE INDEX messageconversation_lastmessage ON messageconversation (lastmessage)
2014-10-13 14:34:29 VUT ERROR:  relation "interpretation_lastupdated" already exists
2014-10-13 14:34:29 VUT STATEMENT:  CREATE INDEX interpretation_lastupdated ON interpretation (lastupdated)
2014-10-13 14:34:29 VUT ERROR:  column "mapvaluetype" does not exist at character 30
2014-10-13 14:34:29 VUT STATEMENT:  update mapview set valuetype=mapvaluetype where valuetype is null
2014-10-13 14:34:29 VUT ERROR:  column "maplegendtype" does not exist at character 31
2014-10-13 14:34:29 VUT STATEMENT:  update mapview set legendtype=maplegendtype where legendtype is null
2014-10-13 14:34:29 VUT ERROR:  column "maplegendsetid" does not exist at character 32
2014-10-13 14:34:29 VUT STATEMENT:  update mapview set legendsetid=maplegendsetid where legendsetid is null
2014-10-13 14:34:29 VUT ERROR:  column "mapvaluetype" of relation "mapview" does not exist
2014-10-13 14:34:29 VUT STATEMENT:  alter table mapview drop column mapvaluetype
2014-10-13 14:34:29 VUT ERROR:  column "maplegendtype" of relation "mapview" does not exist
2014-10-13 14:34:29 VUT STATEMENT:  alter table mapview drop column maplegendtype
2014-10-13 14:34:29 VUT ERROR:  column "maplegendsetid" of relation "mapview" does not exist
2014-10-13 14:34:29 VUT STATEMENT:  alter table mapview drop column maplegendsetid
2014-10-13 14:34:29 VUT ERROR:  column "bounds" of relation "mapview" does not exist
2014-10-13 14:34:29 VUT STATEMENT:  alter table mapview drop column bounds
2014-10-13 14:34:29 VUT ERROR:  column "code" of relation "mapview" does not exist
2014-10-13 14:34:29 VUT STATEMENT:  alter table mapview drop column code
2014-10-13 14:34:29 VUT ERROR:  column "periodtypeid" of relation "mapview" does not exist
2014-10-13 14:34:29 VUT STATEMENT:  alter table mapview drop column periodtypeid
2014-10-13 14:34:29 VUT ERROR:  column "valuetype" does not exist at character 50
2014-10-13 14:34:29 VUT STATEMENT:  update mapview set valuetype='dataElement' where valuetype='dataelement'
2014-10-13 14:34:29 VUT ERROR:  column "name" does not exist at character 19
2014-10-13 14:34:29 VUT STATEMENT:  select mapviewid, name, userid, longitude, latitude, zoom from mapview where mapviewid not in (select mapviewid from mapmapviews)



2nd Startup
2014-10-14 10:27:48 VUT ERROR:  relation "trackedentityattribute_uid_key" already exists
2014-10-14 10:27:48 VUT STATEMENT:  ALTER TABLE trackedentityattribute ADD CONSTRAINT trackedentityattribute_uid_key UNIQUE(uid)
2014-10-14 10:27:48 VUT ERROR:  relation "trackedentityattributegroup_uid_key" already exists
2014-10-14 10:27:48 VUT STATEMENT:  ALTER TABLE trackedentityattributegroup ADD CONSTRAINT trackedentityattributegroup_uid_key UNIQUE(uid)
2014-10-14 10:27:48 VUT ERROR:  relation "trackedentityinstancereminder_uid_key" already exists
2014-10-14 10:27:48 VUT STATEMENT:  ALTER TABLE trackedentityinstancereminder ADD CONSTRAINT trackedentityinstancereminder_uid_key UNIQUE(uid)
2014-10-14 10:27:48 VUT ERROR:  relation "program_uid_key" already exists
2014-10-14 10:27:48 VUT STATEMENT:  ALTER TABLE program ADD CONSTRAINT program_uid_key UNIQUE(uid)
2014-10-14 10:27:48 VUT ERROR:  relation "programstage_uid_key" already exists
2014-10-14 10:27:48 VUT STATEMENT:  ALTER TABLE programstage ADD CONSTRAINT programstage_uid_key UNIQUE(uid)
2014-10-14 10:27:48 VUT ERROR:  relation "programinstance_uid_key" already exists
2014-10-14 10:27:48 VUT STATEMENT:  ALTER TABLE programinstance ADD CONSTRAINT programinstance_uid_key UNIQUE(uid)
2014-10-14 10:27:48 VUT ERROR:  relation "programstageinstance_uid_key" already exists
2014-10-14 10:27:48 VUT STATEMENT:  ALTER TABLE programstageinstance ADD CONSTRAINT programstageinstance_uid_key UNIQUE(uid)
2014-10-14 10:27:48 VUT ERROR:  relation "relationshiptype_uid_key" already exists
2014-10-14 10:27:48 VUT STATEMENT:  ALTER TABLE relationshiptype ADD CONSTRAINT relationshiptype_uid_key UNIQUE(uid)
2014-10-14 10:27:48 VUT ERROR:  relation "programstagesection_uid_key" already exists
2014-10-14 10:27:48 VUT STATEMENT:  ALTER TABLE programstagesection ADD CONSTRAINT programstagesection_uid_key UNIQUE(uid)
2014-10-14 10:27:48 VUT ERROR:  relation "programvalidation_uid_key" already exists
2014-10-14 10:27:48 VUT STATEMENT:  ALTER TABLE programvalidation ADD CONSTRAINT programvalidation_uid_key UNIQUE(uid)
2014-10-14 10:27:48 VUT ERROR:  relation "reporttable_uid_key" already exists
2014-10-14 10:27:48 VUT STATEMENT:  ALTER TABLE reporttable ADD CONSTRAINT reporttable_uid_key UNIQUE(uid)
2014-10-14 10:27:48 VUT ERROR:  relation "chart_uid_key" already exists
2014-10-14 10:27:48 VUT STATEMENT:  ALTER TABLE chart ADD CONSTRAINT chart_uid_key UNIQUE(uid)
2014-10-14 10:27:48 VUT ERROR:  relation "map_uid_key" already exists
2014-10-14 10:27:48 VUT STATEMENT:  ALTER TABLE map ADD CONSTRAINT map_uid_key UNIQUE(uid)
2014-10-14 10:27:48 VUT ERROR:  relation "mapview_uid_key" already exists
2014-10-14 10:27:48 VUT STATEMENT:  ALTER TABLE mapview ADD CONSTRAINT mapview_uid_key UNIQUE(uid)
2014-10-14 10:27:48 VUT ERROR:  relation "maplegend_uid_key" already exists
2014-10-14 10:27:48 VUT STATEMENT:  ALTER TABLE maplegend ADD CONSTRAINT maplegend_uid_key UNIQUE(uid)
2014-10-14 10:27:48 VUT ERROR:  relation "maplegendset_uid_key" already exists
2014-10-14 10:27:48 VUT STATEMENT:  ALTER TABLE maplegendset ADD CONSTRAINT maplegendset_uid_key UNIQUE(uid)
2014-10-14 10:27:48 VUT ERROR:  relation "report_uid_key" already exists
2014-10-14 10:27:48 VUT STATEMENT:  ALTER TABLE report ADD CONSTRAINT report_uid_key UNIQUE(uid)
2014-10-14 10:27:48 VUT ERROR:  relation "messageconversation_uid_key" already exists
2014-10-14 10:27:48 VUT STATEMENT:  ALTER TABLE messageconversation ADD CONSTRAINT messageconversation_uid_key UNIQUE(uid)
2014-10-14 10:27:48 VUT ERROR:  relation "message_uid_key" already exists
2014-10-14 10:27:48 VUT STATEMENT:  ALTER TABLE message ADD CONSTRAINT message_uid_key UNIQUE(uid)
2014-10-14 10:27:48 VUT ERROR:  relation "document_uid_key" already exists
2014-10-14 10:27:48 VUT STATEMENT:  ALTER TABLE document ADD CONSTRAINT document_uid_key UNIQUE(uid)
2014-10-14 10:27:48 VUT ERROR:  relation "dashboard_uid_key" already exists
2014-10-14 10:27:48 VUT STATEMENT:  ALTER TABLE dashboard ADD CONSTRAINT dashboard_uid_key UNIQUE(uid)
2014-10-14 10:27:48 VUT ERROR:  relation "dashboarditem_uid_key" already exists
2014-10-14 10:27:48 VUT STATEMENT:  ALTER TABLE dashboarditem ADD CONSTRAINT dashboarditem_uid_key UNIQUE(uid)
2014-10-14 10:27:48 VUT ERROR:  relation "interpretation_uid_key" already exists
2014-10-14 10:27:48 VUT STATEMENT:  ALTER TABLE interpretation ADD CONSTRAINT interpretation_uid_key UNIQUE(uid)
2014-10-14 10:27:48 VUT ERROR:  relation "interpretationcomment_uid_key" already exists
2014-10-14 10:27:48 VUT STATEMENT:  ALTER TABLE interpretationcomment ADD CONSTRAINT interpretationcomment_uid_key UNIQUE(uid)
2014-10-14 10:27:48 VUT ERROR:  table "categoryoptioncomboname" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE categoryoptioncomboname
2014-10-14 10:27:48 VUT ERROR:  table "orgunitgroupsetstructure" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE orgunitgroupsetstructure
2014-10-14 10:27:48 VUT ERROR:  table "orgunitstructure" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE orgunitstructure
2014-10-14 10:27:48 VUT ERROR:  table "orgunithierarchystructure" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE orgunithierarchystructure
2014-10-14 10:27:48 VUT ERROR:  table "orgunithierarchy" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE orgunithierarchy
2014-10-14 10:27:48 VUT ERROR:  table "columnorder" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE columnorder
2014-10-14 10:27:48 VUT ERROR:  table "roworder" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE roworder
2014-10-14 10:27:48 VUT ERROR:  table "sectionmembers" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE sectionmembers
2014-10-14 10:27:48 VUT ERROR:  table "reporttable_categoryoptioncombos" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE reporttable_categoryoptioncombos
2014-10-14 10:27:48 VUT ERROR:  table "reporttable_dataelementgroupsets" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE reporttable_dataelementgroupsets
2014-10-14 10:27:48 VUT ERROR:  table "dashboardcontent_datamartexports" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE dashboardcontent_datamartexports
2014-10-14 10:27:48 VUT ERROR:  table "dashboardcontent_mapviews" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE dashboardcontent_mapviews
2014-10-14 10:27:48 VUT ERROR:  table "dashboardcontent_documents" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE dashboardcontent_documents
2014-10-14 10:27:48 VUT ERROR:  table "dashboardcontent_maps" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE dashboardcontent_maps
2014-10-14 10:27:48 VUT ERROR:  table "dashboardcontent_reports" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE dashboardcontent_reports
2014-10-14 10:27:48 VUT ERROR:  table "dashboardcontent_reporttables" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE dashboardcontent_reporttables
2014-10-14 10:27:48 VUT ERROR:  table "dashboardcontent" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE dashboardcontent
2014-10-14 10:27:48 VUT ERROR:  table "customvalue" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE customvalue
2014-10-14 10:27:48 VUT ERROR:  table "reporttable_displaycolumns" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE reporttable_displaycolumns
2014-10-14 10:27:48 VUT ERROR:  table "reportreporttables" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE reportreporttables
2014-10-14 10:27:48 VUT ERROR:  table "frequencyoverrideassociation" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE frequencyoverrideassociation
2014-10-14 10:27:48 VUT ERROR:  table "dataelement_dataelementgroupsetmembers" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE dataelement_dataelementgroupsetmembers
2014-10-14 10:27:48 VUT ERROR:  table "dashboardcontent_olapurls" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE dashboardcontent_olapurls
2014-10-14 10:27:48 VUT ERROR:  table "olapurl" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE olapurl
2014-10-14 10:27:48 VUT ERROR:  table "target" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE target
2014-10-14 10:27:48 VUT ERROR:  table "calculateddataelement" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE calculateddataelement
2014-10-14 10:27:48 VUT ERROR:  table "systemsequence" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE systemsequence
2014-10-14 10:27:48 VUT ERROR:  table "reporttablecolumn" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE reporttablecolumn
2014-10-14 10:27:48 VUT ERROR:  table "datamartexport" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE datamartexport
2014-10-14 10:27:48 VUT ERROR:  table "datamartexportdataelements" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE datamartexportdataelements
2014-10-14 10:27:48 VUT ERROR:  table "datamartexportindicators" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE datamartexportindicators
2014-10-14 10:27:48 VUT ERROR:  table "datamartexportorgunits" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE datamartexportorgunits
2014-10-14 10:27:48 VUT ERROR:  table "datamartexportperiods" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE datamartexportperiods
2014-10-14 10:27:48 VUT ERROR:  table "datasetlockedperiods" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE datasetlockedperiods
2014-10-14 10:27:48 VUT ERROR:  table "datasetlocksource" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE datasetlocksource
2014-10-14 10:27:48 VUT ERROR:  table "datasetlock" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE datasetlock
2014-10-14 10:27:48 VUT ERROR:  table "datasetlockexceptions" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE datasetlockexceptions
2014-10-14 10:27:48 VUT ERROR:  table "indicator_indicatorgroupsetmembers" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE indicator_indicatorgroupsetmembers
2014-10-14 10:27:48 VUT ERROR:  table "maplegendsetindicator" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE maplegendsetindicator
2014-10-14 10:27:48 VUT ERROR:  table "maplegendsetdataelement" does not exist
2014-10-14 10:27:48 VUT STATEMENT:  DROP TABLE maplegendsetdataelement
2014-10-14 10:27:49 VUT ERROR:  table "dashboarditem_trackedentitytabularreports" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  DROP TABLE dashboarditem_trackedentitytabularreports
2014-10-14 10:27:49 VUT ERROR:  table "categoryoptioncombousergroupaccesses" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  DROP TABLE categoryoptioncombousergroupaccesses
2014-10-14 10:27:49 VUT ERROR:  table "validationrulegroupuserrolestoalert" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  DROP TABLE validationrulegroupuserrolestoalert
2014-10-14 10:27:49 VUT ERROR:  column "userid" of relation "categoryoptioncombo" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE categoryoptioncombo drop column userid
2014-10-14 10:27:49 VUT ERROR:  column "publicaccess" of relation "categoryoptioncombo" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE categoryoptioncombo drop column publicaccess
2014-10-14 10:27:49 VUT ERROR:  column "categoryid" of relation "dataelementcategoryoption" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE dataelementcategoryoption drop column categoryid
2014-10-14 10:27:49 VUT ERROR:  column "paramleafparentorganisationunit" of relation "reporttable" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE reporttable DROP column paramleafparentorganisationunit
2014-10-14 10:27:49 VUT ERROR:  column "dimension_type" of relation "reporttable" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE reporttable DROP column dimension_type
2014-10-14 10:27:49 VUT ERROR:  column "dimensiontype" of relation "reporttable" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE reporttable DROP column dimensiontype
2014-10-14 10:27:49 VUT ERROR:  column "tablename" of relation "reporttable" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE reporttable DROP column tablename
2014-10-14 10:27:49 VUT ERROR:  column "existingtablename" of relation "reporttable" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE reporttable DROP column existingtablename
2014-10-14 10:27:49 VUT ERROR:  column "docategoryoptioncombos" of relation "reporttable" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE reporttable DROP column docategoryoptioncombos
2014-10-14 10:27:49 VUT ERROR:  column "mode" of relation "reporttable" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE reporttable DROP column mode
2014-10-14 10:27:49 VUT ERROR:  column "displayorder" of relation "categoryoptioncombo" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE categoryoptioncombo DROP COLUMN displayorder
2014-10-14 10:27:49 VUT ERROR:  column "shortname" of relation "dataelementcategoryoption" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE dataelementcategoryoption DROP COLUMN shortname
2014-10-14 10:27:49 VUT ERROR:  column "label" of relation "section" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE section DROP COLUMN label
2014-10-14 10:27:49 VUT ERROR:  column "title" of relation "section" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE section DROP COLUMN title
2014-10-14 10:27:49 VUT ERROR:  column "polygoncoordinates" of relation "organisationunit" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE organisationunit DROP COLUMN polygoncoordinates
2014-10-14 10:27:49 VUT ERROR:  column "geocode" of relation "organisationunit" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE organisationunit DROP COLUMN geocode
2014-10-14 10:27:49 VUT ERROR:  column "extendeddataelementid" of relation "indicator" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE indicator DROP COLUMN extendeddataelementid
2014-10-14 10:27:49 VUT ERROR:  column "numeratoraggregationtype" of relation "indicator" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE indicator DROP COLUMN numeratoraggregationtype
2014-10-14 10:27:49 VUT ERROR:  column "denominatoraggregationtype" of relation "indicator" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE indicator DROP COLUMN denominatoraggregationtype
2014-10-14 10:27:49 VUT ERROR:  column "locked" of relation "dataset" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE dataset DROP COLUMN locked
2014-10-14 10:27:49 VUT ERROR:  column "completenessrecipientsid" of relation "configuration" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE configuration DROP COLUMN completenessrecipientsid
2014-10-14 10:27:49 VUT ERROR:  column "alternativename" of relation "dataelement" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE dataelement DROP COLUMN alternativename
2014-10-14 10:27:49 VUT ERROR:  column "alternativename" of relation "indicator" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE indicator DROP COLUMN alternativename
2014-10-14 10:27:49 VUT ERROR:  column "image" of relation "orgunitgroup" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE orgunitgroup DROP COLUMN image
2014-10-14 10:27:49 VUT ERROR:  column "usingorgunitgroupsets" of relation "report" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE report DROP COLUMN usingorgunitgroupsets
2014-10-14 10:27:49 VUT ERROR:  column "datatype" of relation "eventchart" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE eventchart DROP COLUMN datatype
2014-10-14 10:27:49 VUT ERROR:  column "type" of relation "validationrule" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE validationrule DROP COLUMN type
2014-10-14 10:27:49 VUT ERROR:  index "datamart_crosstab" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  DROP INDEX datamart_crosstab
2014-10-14 10:27:49 VUT ERROR:  table "maporganisationunitrelation" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  DROP TABLE maporganisationunitrelation
2014-10-14 10:27:49 VUT ERROR:  column "mapid" of relation "mapview" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE mapview DROP COLUMN mapid
2014-10-14 10:27:49 VUT ERROR:  column "startdate" of relation "mapview" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE mapview DROP COLUMN startdate
2014-10-14 10:27:49 VUT ERROR:  column "enddate" of relation "mapview" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE mapview DROP COLUMN enddate
2014-10-14 10:27:49 VUT ERROR:  column "mapsource" of relation "mapview" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE mapview DROP COLUMN mapsource
2014-10-14 10:27:49 VUT ERROR:  column "mapsourcetype" of relation "mapview" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE mapview DROP COLUMN mapsourcetype
2014-10-14 10:27:49 VUT ERROR:  column "mapdatetype" of relation "mapview" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE mapview DROP COLUMN mapdatetype
2014-10-14 10:27:49 VUT ERROR:  column "featuretype" of relation "mapview" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE mapview DROP COLUMN featuretype
2014-10-14 10:27:49 VUT ERROR:  column "bounds" of relation "mapview" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE mapview DROP COLUMN bounds
2014-10-14 10:27:49 VUT ERROR:  column "valuetype" of relation "mapview" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE mapview DROP COLUMN valuetype
2014-10-14 10:27:49 VUT ERROR:  column "legendtype" of relation "mapview" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE mapview DROP COLUMN legendtype
2014-10-14 10:27:49 VUT ERROR:  column "mapvaluetype" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE mapview RENAME COLUMN mapvaluetype TO valuetype
2014-10-14 10:27:49 VUT ERROR:  column "maplegendtype" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE mapview RENAME COLUMN maplegendtype TO legendtype
2014-10-14 10:27:49 VUT ERROR:  column "maplegendsetid" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE mapview RENAME COLUMN maplegendsetid TO legendsetid
2014-10-14 10:27:49 VUT ERROR:  constraint "maplegend_name_key" of relation "maplegend" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE maplegend DROP CONSTRAINT maplegend_name_key
2014-10-14 10:27:49 VUT ERROR:  constraint "maplayer_mapsource_key" of relation "maplayer" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE maplayer DROP CONSTRAINT maplayer_mapsource_key
2014-10-14 10:27:49 VUT ERROR:  column "mapsource" of relation "maplayer" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE maplayer DROP COLUMN mapsource
2014-10-14 10:27:49 VUT ERROR:  column "mapsourcetype" of relation "maplayer" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE maplayer DROP COLUMN mapsourcetype
2014-10-14 10:27:49 VUT ERROR:  column "layer" of relation "maplayer" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE maplayer DROP COLUMN layer
2014-10-14 10:27:49 VUT ERROR:  constraint "fk_dataelement_extendeddataelementid" of relation "dataelement" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE dataelement DROP CONSTRAINT fk_dataelement_extendeddataelementid
2014-10-14 10:27:49 VUT ERROR:  column "extendeddataelementid" of relation "dataelement" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE dataelement DROP COLUMN extendeddataelementid
2014-10-14 10:27:49 VUT ERROR:  constraint "fk_indicator_extendeddataelementid" of relation "indicator" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE indicator DROP CONSTRAINT fk_indicator_extendeddataelementid
2014-10-14 10:27:49 VUT ERROR:  column "extendeddataelementid" of relation "indicator" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE indicator DROP COLUMN extendeddataelementid
2014-10-14 10:27:49 VUT ERROR:  table "extendeddataelement" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  DROP TABLE extendeddataelement
2014-10-14 10:27:49 VUT ERROR:  column "haspatients" of relation "organisationunit" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE organisationunit DROP COLUMN hasPatients
2014-10-14 10:27:49 VUT ERROR:  constraint "fk4bae70f697e49675" of relation "categorycombos_optioncombos" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE categorycombos_optioncombos DROP CONSTRAINT fk4bae70f697e49675
2014-10-14 10:27:49 VUT ERROR:  column "sort_order" of relation "categoryoptioncombos_categoryoptions" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  alter table categoryoptioncombos_categoryoptions drop column sort_order
2014-10-14 10:27:49 VUT ERROR:  multiple primary keys for table "categoryoptioncombos_categoryoptions" are not allowed
2014-10-14 10:27:49 VUT STATEMENT:  alter table categoryoptioncombos_categoryoptions add constraint categoryoptioncombos_categoryoptions_pkey primary key(categoryoptioncomboid, categoryoptionid)
2014-10-14 10:27:49 VUT ERROR:  constraint "fk_dataelement_categoryid" of relation "dataelementcategoryoption" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE dataelementcategoryoption DROP CONSTRAINT fk_dataelement_categoryid
2014-10-14 10:27:49 VUT ERROR:  constraint "dataelementcategoryoption_shortname_key" of relation "dataelementcategoryoption" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE dataelementcategoryoption DROP CONSTRAINT dataelementcategoryoption_shortname_key
2014-10-14 10:27:49 VUT ERROR:  relation "index_minmaxdataelement" already exists
2014-10-14 10:27:49 VUT STATEMENT:  CREATE INDEX index_minmaxdataelement ON minmaxdataelement( sourceid, dataelementid, categoryoptioncomboid )
2014-10-14 10:27:49 VUT ERROR:  relation "patientattribute" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE patientattribute ADD mandatory bool
2014-10-14 10:27:49 VUT ERROR:  relation "patientattribute" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE patientattribute ADD groupby bool
2014-10-14 10:27:49 VUT ERROR:  cannot alter type of a column used by a view or rule
2014-10-14 10:27:49 VUT DETAIL:  rule _RETURN on view _view_data_elements depends on column "description"
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE dataelement ALTER description TYPE text
2014-10-14 10:27:49 VUT ERROR:  cannot alter type of a column used by a view or rule
2014-10-14 10:27:49 VUT DETAIL:  rule _RETURN on view _view_translations depends on column "value"
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE translation ALTER value TYPE text
2014-10-14 10:27:49 VUT ERROR:  cannot alter type of a column used by a view or rule
2014-10-14 10:27:49 VUT DETAIL:  rule _RETURN on view _view_test_cases_2 depends on column "comment"
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE organisationunit ALTER comment TYPE text
2014-10-14 10:27:49 VUT ERROR:  column "minvalue" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE minmaxdataelement RENAME minvalue TO minimumvalue
2014-10-14 10:27:49 VUT ERROR:  column "maxvalue" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE minmaxdataelement RENAME maxvalue TO maximumvalue
2014-10-14 10:27:49 VUT ERROR:  constraint "organisationunit_shortname_key" of relation "organisationunit" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE organisationunit DROP CONSTRAINT organisationunit_shortname_key
2014-10-14 10:27:49 VUT ERROR:  constraint "section_name_key" of relation "section" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE section DROP CONSTRAINT section_name_key
2014-10-14 10:27:49 VUT ERROR:  relation "patientattribute" does not exist at character 8
2014-10-14 10:27:49 VUT STATEMENT:  UPDATE patientattribute set inheritable=false where inheritable is null
2014-10-14 10:27:49 VUT ERROR:  column "modified" of relation "aggregateddatavalue" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE aggregateddatavalue DROP COLUMN modified
2014-10-14 10:27:49 VUT ERROR:  column "modified" of relation "aggregatedindicatorvalue" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE aggregatedindicatorvalue DROP COLUMN modified 
2014-10-14 10:27:49 VUT ERROR:  column "patientid" of relation "programinstance" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE programinstance ALTER COLUMN patientid DROP NOT NULL
2014-10-14 10:27:49 VUT ERROR:  column "dimension" does not exist at character 84
2014-10-14 10:27:49 VUT STATEMENT:  UPDATE chart SET series='period', category='data', filter='organisationunit' WHERE dimension='indicator'
2014-10-14 10:27:49 VUT ERROR:  column "dimension" does not exist at character 84
2014-10-14 10:27:49 VUT STATEMENT:  UPDATE chart SET series='data', category='organisationunit', filter='period' WHERE dimension='organisationUnit'
2014-10-14 10:27:49 VUT ERROR:  column "dimension" does not exist at character 84
2014-10-14 10:27:49 VUT STATEMENT:  UPDATE chart SET series='period', category='data', filter='organisationunit' WHERE dimension='dataElement_period'
2014-10-14 10:27:49 VUT ERROR:  column "dimension" does not exist at character 84
2014-10-14 10:27:49 VUT STATEMENT:  UPDATE chart SET series='data', category='organisationunit', filter='period' WHERE dimension='organisationUnit_dataElement'
2014-10-14 10:27:49 VUT ERROR:  column "dimension" does not exist at character 84
2014-10-14 10:27:49 VUT STATEMENT:  UPDATE chart SET series='data', category='period', filter='organisationunit' WHERE dimension='period'
2014-10-14 10:27:49 VUT ERROR:  column "dimension" does not exist at character 84
2014-10-14 10:27:49 VUT STATEMENT:  UPDATE chart SET series='data', category='period', filter='organisationunit' WHERE dimension='period_dataElement'
2014-10-14 10:27:49 VUT ERROR:  column "filter" does not exist at character 97
2014-10-14 10:27:49 VUT STATEMENT:  UPDATE chart SET type=lower(type), series=lower(series), category=lower(category), filter=lower(filter)
2014-10-14 10:27:49 VUT ERROR:  column "dimension" of relation "chart" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE chart ALTER COLUMN dimension DROP NOT NULL
2014-10-14 10:27:49 VUT ERROR:  column "size" of relation "chart" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN size
2014-10-14 10:27:49 VUT ERROR:  column "verticallabels" of relation "chart" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN verticallabels
2014-10-14 10:27:49 VUT ERROR:  column "targetline" of relation "chart" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN targetline
2014-10-14 10:27:49 VUT ERROR:  column "horizontalplotorientation" of relation "chart" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN horizontalplotorientation
2014-10-14 10:27:49 VUT ERROR:  column "hidesubtitle" of relation "chart" already exists
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE chart ADD COLUMN hidesubtitle boolean NOT NULL DEFAULT false
2014-10-14 10:27:49 VUT ERROR:  column "monthslastyear" of relation "chart" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN monthsLastYear
2014-10-14 10:27:49 VUT ERROR:  column "quarterslastyear" of relation "chart" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN quartersLastYear
2014-10-14 10:27:49 VUT ERROR:  column "last6bimonths" of relation "chart" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN last6BiMonths
2014-10-14 10:27:49 VUT ERROR:  constraint "chart_title_key" of relation "chart" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE chart DROP CONSTRAINT chart_title_key
2014-10-14 10:27:49 VUT ERROR:  constraint "chart_name_key" of relation "chart" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE chart DROP CONSTRAINT chart_name_key
2014-10-14 10:27:49 VUT ERROR:  column "domainaxixlabel" of relation "chart" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN domainaxixlabel
2014-10-14 10:27:49 VUT ERROR:  column "last6months" of relation "reporttable" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE reporttable DROP COLUMN last6months
2014-10-14 10:27:49 VUT ERROR:  column "last9months" of relation "reporttable" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE reporttable DROP COLUMN last9months
2014-10-14 10:27:49 VUT ERROR:  column "sofarthisyear" of relation "reporttable" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE reporttable DROP COLUMN sofarthisyear
2014-10-14 10:27:49 VUT ERROR:  column "sofarthisfinancialyear" of relation "reporttable" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE reporttable DROP COLUMN sofarthisfinancialyear
2014-10-14 10:27:49 VUT ERROR:  column "last3to6months" of relation "reporttable" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE reporttable DROP COLUMN last3to6months
2014-10-14 10:27:49 VUT ERROR:  column "last6to9months" of relation "reporttable" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE reporttable DROP COLUMN last6to9months
2014-10-14 10:27:49 VUT ERROR:  column "last9to12months" of relation "reporttable" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE reporttable DROP COLUMN last9to12months
2014-10-14 10:27:49 VUT ERROR:  column "last12individualmonths" of relation "reporttable" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE reporttable DROP COLUMN last12individualmonths
2014-10-14 10:27:49 VUT ERROR:  column "individualmonthsthisyear" of relation "reporttable" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE reporttable DROP COLUMN individualmonthsthisyear
2014-10-14 10:27:49 VUT ERROR:  column "individualquartersthisyear" of relation "reporttable" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE reporttable DROP COLUMN individualquartersthisyear
2014-10-14 10:27:49 VUT ERROR:  column "last6months" of relation "chart" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN last6months
2014-10-14 10:27:49 VUT ERROR:  column "last9months" of relation "chart" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN last9months
2014-10-14 10:27:49 VUT ERROR:  column "sofarthisyear" of relation "chart" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN sofarthisyear
2014-10-14 10:27:49 VUT ERROR:  column "sofarthisfinancialyear" of relation "chart" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN sofarthisfinancialyear
2014-10-14 10:27:49 VUT ERROR:  column "last3to6months" of relation "chart" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN last3to6months
2014-10-14 10:27:49 VUT ERROR:  column "last6to9months" of relation "chart" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN last6to9months
2014-10-14 10:27:49 VUT ERROR:  column "last9to12months" of relation "chart" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN last9to12months
2014-10-14 10:27:49 VUT ERROR:  column "last12individualmonths" of relation "chart" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN last12individualmonths
2014-10-14 10:27:49 VUT ERROR:  column "individualmonthsthisyear" of relation "chart" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN individualmonthsthisyear
2014-10-14 10:27:49 VUT ERROR:  column "individualquartersthisyear" of relation "chart" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN individualquartersthisyear
2014-10-14 10:27:49 VUT ERROR:  column "organisationunitgroupsetid" of relation "chart" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN organisationunitgroupsetid
2014-10-14 10:27:49 VUT ERROR:  constraint "fk766ae2938fd8026a" of relation "datasetsource" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE datasetsource DROP CONSTRAINT fk766ae2938fd8026a
2014-10-14 10:27:49 VUT ERROR:  relation "datasetlocksource" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE datasetlocksource DROP CONSTRAINT fk582fdf7e8fd8026a
2014-10-14 10:27:49 VUT ERROR:  constraint "fk_datasetcompleteregistration_sourceid" of relation "completedatasetregistration" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE completedatasetregistration DROP CONSTRAINT fk_datasetcompleteregistration_sourceid
2014-10-14 10:27:49 VUT ERROR:  constraint "fk_minmaxdataelement_sourceid" of relation "minmaxdataelement" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE minmaxdataelement DROP CONSTRAINT fk_minmaxdataelement_sourceid
2014-10-14 10:27:49 VUT ERROR:  constraint "fk_datavalue_sourceid" of relation "datavalue" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE datavalue DROP CONSTRAINT fk_datavalue_sourceid
2014-10-14 10:27:49 VUT ERROR:  constraint "fke509dd5ef1c932ed" of relation "organisationunit" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE organisationunit DROP CONSTRAINT fke509dd5ef1c932ed
2014-10-14 10:27:49 VUT ERROR:  table "source" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  DROP TABLE source CASCADE
2014-10-14 10:27:49 VUT ERROR:  table "datavaluearchive" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  DROP TABLE datavaluearchive
2014-10-14 10:27:49 VUT ERROR:  column "messageconversationkey" of relation "messageconversation" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE messageconversation DROP COLUMN messageconversationkey
2014-10-14 10:27:49 VUT ERROR:  column "messagesubject" of relation "message" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE message DROP COLUMN messagesubject
2014-10-14 10:27:49 VUT ERROR:  column "messagekey" of relation "message" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE message DROP COLUMN messagekey
2014-10-14 10:27:49 VUT ERROR:  column "sentdate" of relation "message" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE message DROP COLUMN sentdate
2014-10-14 10:27:49 VUT ERROR:  column "messagedate" of relation "usermessage" does not exist
2014-10-14 10:27:49 VUT STATEMENT:  ALTER TABLE usermessage DROP COLUMN messagedate
2014-10-14 10:27:50 VUT ERROR:  table "message_usermessages" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  DROP TABLE message_usermessages
2014-10-14 10:27:50 VUT ERROR:  relation "dataelement_code_key" already exists
2014-10-14 10:27:50 VUT STATEMENT:  ALTER TABLE dataelement ADD CONSTRAINT dataelement_code_key UNIQUE(code)
2014-10-14 10:27:50 VUT ERROR:  relation "indicator_code_key" already exists
2014-10-14 10:27:50 VUT STATEMENT:  ALTER TABLE indicator ADD CONSTRAINT indicator_code_key UNIQUE(code)
2014-10-14 10:27:50 VUT ERROR:  relation "organisationunit_code_key" already exists
2014-10-14 10:27:50 VUT STATEMENT:  ALTER TABLE organisationunit ADD CONSTRAINT organisationunit_code_key UNIQUE(code)
2014-10-14 10:27:50 VUT ERROR:  column "uuid" of relation "attribute" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  ALTER TABLE attribute DROP COLUMN uuid
2014-10-14 10:27:50 VUT ERROR:  column "uuid" of relation "categorycombo" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  ALTER TABLE categorycombo DROP COLUMN uuid
2014-10-14 10:27:50 VUT ERROR:  column "uuid" of relation "categoryoptioncombo" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  ALTER TABLE categoryoptioncombo DROP COLUMN uuid
2014-10-14 10:27:50 VUT ERROR:  column "uuid" of relation "chart" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  ALTER TABLE chart DROP COLUMN uuid
2014-10-14 10:27:50 VUT ERROR:  column "uuid" of relation "concept" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  ALTER TABLE concept DROP COLUMN uuid
2014-10-14 10:27:50 VUT ERROR:  column "uuid" of relation "constant" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  ALTER TABLE constant DROP COLUMN uuid
2014-10-14 10:27:50 VUT ERROR:  column "uuid" of relation "datadictionary" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  ALTER TABLE datadictionary DROP COLUMN uuid
2014-10-14 10:27:50 VUT ERROR:  column "uuid" of relation "dataelement" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  ALTER TABLE dataelement DROP COLUMN uuid
2014-10-14 10:27:50 VUT ERROR:  column "uuid" of relation "dataelementcategory" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  ALTER TABLE dataelementcategory DROP COLUMN uuid
2014-10-14 10:27:50 VUT ERROR:  column "uuid" of relation "dataelementcategoryoption" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  ALTER TABLE dataelementcategoryoption DROP COLUMN uuid
2014-10-14 10:27:50 VUT ERROR:  column "uuid" of relation "dataelementgroup" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  ALTER TABLE dataelementgroup DROP COLUMN uuid
2014-10-14 10:27:50 VUT ERROR:  column "uuid" of relation "dataelementgroupset" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  ALTER TABLE dataelementgroupset DROP COLUMN uuid
2014-10-14 10:27:50 VUT ERROR:  column "uuid" of relation "dataset" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  ALTER TABLE dataset DROP COLUMN uuid
2014-10-14 10:27:50 VUT ERROR:  column "uuid" of relation "indicator" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  ALTER TABLE indicator DROP COLUMN uuid
2014-10-14 10:27:50 VUT ERROR:  column "uuid" of relation "indicatorgroup" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  ALTER TABLE indicatorgroup DROP COLUMN uuid
2014-10-14 10:27:50 VUT ERROR:  column "uuid" of relation "indicatorgroupset" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  ALTER TABLE indicatorgroupset DROP COLUMN uuid
2014-10-14 10:27:50 VUT ERROR:  column "uuid" of relation "indicatortype" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  ALTER TABLE indicatortype DROP COLUMN uuid
2014-10-14 10:27:50 VUT ERROR:  column "uuid" of relation "orgunitgroup" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  ALTER TABLE orgunitgroup DROP COLUMN uuid
2014-10-14 10:27:50 VUT ERROR:  column "uuid" of relation "orgunitgroupset" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  ALTER TABLE orgunitgroupset DROP COLUMN uuid
2014-10-14 10:27:50 VUT ERROR:  column "uuid" of relation "orgunitlevel" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  ALTER TABLE orgunitlevel DROP COLUMN uuid
2014-10-14 10:27:50 VUT ERROR:  column "uuid" of relation "report" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  ALTER TABLE report DROP COLUMN uuid
2014-10-14 10:27:50 VUT ERROR:  column "uuid" of relation "validationrule" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  ALTER TABLE validationrule DROP COLUMN uuid
2014-10-14 10:27:50 VUT ERROR:  column "uuid" of relation "validationrulegroup" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  ALTER TABLE validationrulegroup DROP COLUMN uuid
2014-10-14 10:27:50 VUT ERROR:  column "haspatients" does not exist at character 55
2014-10-14 10:27:50 VUT STATEMENT:  update organisationunit set haspatients = false where haspatients is null
2014-10-14 10:27:50 VUT ERROR:  column "reportingmonth" does not exist at character 53
2014-10-14 10:27:50 VUT STATEMENT:  update reporttable set reportingmonth = false where reportingmonth is null
2014-10-14 10:27:50 VUT ERROR:  column "reportingbimonth" does not exist at character 55
2014-10-14 10:27:50 VUT STATEMENT:  update reporttable set reportingbimonth = false where reportingbimonth is null
2014-10-14 10:27:50 VUT ERROR:  column "reportingquarter" does not exist at character 55
2014-10-14 10:27:50 VUT STATEMENT:  update reporttable set reportingquarter = false where reportingquarter is null
2014-10-14 10:27:50 VUT ERROR:  column "monthsthisyear" does not exist at character 53
2014-10-14 10:27:50 VUT STATEMENT:  update reporttable set monthsthisyear = false where monthsthisyear is null
2014-10-14 10:27:50 VUT ERROR:  column "quartersthisyear" does not exist at character 55
2014-10-14 10:27:50 VUT STATEMENT:  update reporttable set quartersthisyear = false where quartersthisyear is null
2014-10-14 10:27:50 VUT ERROR:  column "thisyear" does not exist at character 47
2014-10-14 10:27:50 VUT STATEMENT:  update reporttable set thisyear = false where thisyear is null
2014-10-14 10:27:50 VUT ERROR:  column "monthslastyear" does not exist at character 53
2014-10-14 10:27:50 VUT STATEMENT:  update reporttable set monthslastyear = false where monthslastyear is null
2014-10-14 10:27:50 VUT ERROR:  column "quarterslastyear" does not exist at character 55
2014-10-14 10:27:50 VUT STATEMENT:  update reporttable set quarterslastyear = false where quarterslastyear is null
2014-10-14 10:27:50 VUT ERROR:  column "lastyear" does not exist at character 47
2014-10-14 10:27:50 VUT STATEMENT:  update reporttable set lastyear = false where lastyear is null
2014-10-14 10:27:50 VUT ERROR:  column "last5years" does not exist at character 49
2014-10-14 10:27:50 VUT STATEMENT:  update reporttable set last5years = false where last5years is null
2014-10-14 10:27:50 VUT ERROR:  column "lastsixmonth" does not exist at character 51
2014-10-14 10:27:50 VUT STATEMENT:  update reporttable set lastsixmonth = false where lastsixmonth is null
2014-10-14 10:27:50 VUT ERROR:  column "last4quarters" does not exist at character 52
2014-10-14 10:27:50 VUT STATEMENT:  update reporttable set last4quarters = false where last4quarters is null
2014-10-14 10:27:50 VUT ERROR:  column "last12months" does not exist at character 51
2014-10-14 10:27:50 VUT STATEMENT:  update reporttable set last12months = false where last12months is null
2014-10-14 10:27:50 VUT ERROR:  column "last3months" does not exist at character 50
2014-10-14 10:27:50 VUT STATEMENT:  update reporttable set last3months = false where last3months is null
2014-10-14 10:27:50 VUT ERROR:  column "last6bimonths" does not exist at character 52
2014-10-14 10:27:50 VUT STATEMENT:  update reporttable set last6bimonths = false where last6bimonths is null
2014-10-14 10:27:50 VUT ERROR:  column "last4quarters" does not exist at character 52
2014-10-14 10:27:50 VUT STATEMENT:  update reporttable set last4quarters = false where last4quarters is null
2014-10-14 10:27:50 VUT ERROR:  column "last2sixmonths" does not exist at character 53
2014-10-14 10:27:50 VUT STATEMENT:  update reporttable set last2sixmonths = false where last2sixmonths is null
2014-10-14 10:27:50 VUT ERROR:  column "thisfinancialyear" does not exist at character 56
2014-10-14 10:27:50 VUT STATEMENT:  update reporttable set thisfinancialyear = false where thisfinancialyear is null
2014-10-14 10:27:50 VUT ERROR:  column "lastfinancialyear" does not exist at character 56
2014-10-14 10:27:50 VUT STATEMENT:  update reporttable set lastfinancialyear = false where lastfinancialyear is null
2014-10-14 10:27:50 VUT ERROR:  column "last5financialyears" does not exist at character 58
2014-10-14 10:27:50 VUT STATEMENT:  update reporttable set last5financialyears = false where last5financialyears is null
2014-10-14 10:27:50 VUT ERROR:  column "totals" does not exist at character 44
2014-10-14 10:27:50 VUT STATEMENT:  update reporttable set totals = true where totals is null
2014-10-14 10:27:50 VUT ERROR:  column "totals" does not exist at character 36
2014-10-14 10:27:50 VUT STATEMENT:  update reporttable set coltotals = totals where coltotals is null
2014-10-14 10:27:50 VUT ERROR:  column "totals" does not exist at character 36
2014-10-14 10:27:50 VUT STATEMENT:  update reporttable set rowtotals = totals where rowtotals is null
2014-10-14 10:27:50 VUT ERROR:  column "totals" of relation "reporttable" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  alter table reporttable drop column totals
2014-10-14 10:27:50 VUT ERROR:  column "reportingbimonth" does not exist at character 49
2014-10-14 10:27:50 VUT STATEMENT:  update chart set reportingbimonth = false where reportingbimonth is null
2014-10-14 10:27:50 VUT ERROR:  column "monthsthisyear" does not exist at character 47
2014-10-14 10:27:50 VUT STATEMENT:  update chart set monthsthisyear = false where monthsthisyear is null
2014-10-14 10:27:50 VUT ERROR:  column "quartersthisyear" does not exist at character 49
2014-10-14 10:27:50 VUT STATEMENT:  update chart set quartersthisyear = false where quartersthisyear is null
2014-10-14 10:27:50 VUT ERROR:  column "monthslastyear" does not exist at character 47
2014-10-14 10:27:50 VUT STATEMENT:  update chart set monthslastyear = false where monthslastyear is null
2014-10-14 10:27:50 VUT ERROR:  column "quarterslastyear" does not exist at character 49
2014-10-14 10:27:50 VUT STATEMENT:  update chart set quarterslastyear = false where quarterslastyear is null
2014-10-14 10:27:50 VUT ERROR:  column "last6bimonths" does not exist at character 46
2014-10-14 10:27:50 VUT STATEMENT:  update chart set last6bimonths = false where last6bimonths is null
2014-10-14 10:27:50 VUT ERROR:  column "filter" does not exist at character 76
2014-10-14 10:27:50 VUT HINT:  There is a column named "filter" in table "chart_filters", but it cannot be referenced from this part of the query.
2014-10-14 10:27:50 VUT STATEMENT:  insert into chart_filters (chartid, sort_order, filter) select chartid, 0, filter from chart
2014-10-14 10:27:50 VUT ERROR:  column "filter" of relation "chart" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  alter table chart drop column filter
2014-10-14 10:27:50 VUT ERROR:  table "reportgroupmembers" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  DROP TABLE reportgroupmembers
2014-10-14 10:27:50 VUT ERROR:  table "reportgroup" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  DROP TABLE reportgroup
2014-10-14 10:27:50 VUT ERROR:  table "reporttablegroupmembers" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  DROP TABLE reporttablegroupmembers
2014-10-14 10:27:50 VUT ERROR:  table "reporttablegroup" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  DROP TABLE reporttablegroup
2014-10-14 10:27:50 VUT ERROR:  table "chartgroupmembers" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  DROP TABLE chartgroupmembers
2014-10-14 10:27:50 VUT ERROR:  table "chartgroup" does not exist
2014-10-14 10:27:50 VUT STATEMENT:  DROP TABLE chartgroup
2014-10-14 10:27:51 VUT ERROR:  cannot alter type of a column used by a view or rule
2014-10-14 10:27:51 VUT DETAIL:  rule _RETURN on view _view_data_elements depends on column "shortname"
2014-10-14 10:27:51 VUT STATEMENT:  ALTER TABLE dataelement ALTER COLUMN shortname TYPE character varying(50)
2014-10-14 10:27:51 VUT ERROR:  cannot alter type of a column used by a view or rule
2014-10-14 10:27:51 VUT DETAIL:  rule _RETURN on view _view_facility_import_view depends on column "shortname"
2014-10-14 10:27:51 VUT STATEMENT:  ALTER TABLE organisationunit ALTER COLUMN shortname TYPE character varying(50)
2014-10-14 10:27:51 VUT ERROR:  constraint "organisationunit_name_key" of relation "organisationunit" does not exist
2014-10-14 10:27:51 VUT STATEMENT:  ALTER TABLE organisationunit DROP CONSTRAINT organisationunit_name_key
2014-10-14 10:27:51 VUT ERROR:  relation "orgunitgroup_name_key" already exists
2014-10-14 10:27:51 VUT STATEMENT:  ALTER TABLE orgunitgroup ADD CONSTRAINT orgunitgroup_name_key UNIQUE (name)
2014-10-14 10:27:51 VUT ERROR:  relation "orgunitgroupset_name_key" already exists
2014-10-14 10:27:51 VUT STATEMENT:  ALTER TABLE orgunitgroupset ADD CONSTRAINT orgunitgroupset_name_key UNIQUE (name)
2014-10-14 10:27:51 VUT ERROR:  constraint "indicator_name_key" of relation "indicator" does not exist
2014-10-14 10:27:51 VUT STATEMENT:  ALTER TABLE indicator DROP CONSTRAINT indicator_name_key
2014-10-14 10:27:51 VUT ERROR:  constraint "indicator_shortname_key" of relation "indicator" does not exist
2014-10-14 10:27:51 VUT STATEMENT:  ALTER TABLE indicator DROP CONSTRAINT indicator_shortname_key
2014-10-14 10:27:51 VUT ERROR:  constraint "indicatorgroup_name_key" of relation "indicatorgroup" does not exist
2014-10-14 10:27:51 VUT STATEMENT:  ALTER TABLE indicatorgroup DROP CONSTRAINT indicatorgroup_name_key
2014-10-14 10:27:51 VUT ERROR:  constraint "indicatorgroupset_name_key" of relation "indicatorgroupset" does not exist
2014-10-14 10:27:51 VUT STATEMENT:  ALTER TABLE indicatorgroupset DROP CONSTRAINT indicatorgroupset_name_key
2014-10-14 10:27:51 VUT ERROR:  constraint "dataset_name_key" of relation "dataset" does not exist
2014-10-14 10:27:51 VUT STATEMENT:  ALTER TABLE dataset DROP CONSTRAINT dataset_name_key
2014-10-14 10:27:51 VUT ERROR:  constraint "dataset_shortname_key" of relation "dataset" does not exist
2014-10-14 10:27:51 VUT STATEMENT:  ALTER TABLE dataset DROP CONSTRAINT dataset_shortname_key
2014-10-14 10:27:51 VUT ERROR:  constraint "document_name_key" of relation "document" does not exist
2014-10-14 10:27:51 VUT STATEMENT:  ALTER TABLE document DROP CONSTRAINT document_name_key
2014-10-14 10:27:51 VUT ERROR:  constraint "reporttable_name_key" of relation "reporttable" does not exist
2014-10-14 10:27:51 VUT STATEMENT:  ALTER TABLE reporttable DROP CONSTRAINT reporttable_name_key
2014-10-14 10:27:51 VUT ERROR:  constraint "report_name_key" of relation "report" does not exist
2014-10-14 10:27:51 VUT STATEMENT:  ALTER TABLE report DROP CONSTRAINT report_name_key
2014-10-14 10:27:51 VUT ERROR:  constraint "usergroup_name_key" of relation "usergroup" does not exist
2014-10-14 10:27:51 VUT STATEMENT:  ALTER TABLE usergroup DROP CONSTRAINT usergroup_name_key
2014-10-14 10:27:51 VUT ERROR:  constraint "datadictionary_name_key" of relation "datadictionary" does not exist
2014-10-14 10:27:51 VUT STATEMENT:  ALTER TABLE datadictionary DROP CONSTRAINT datadictionary_name_key
2014-10-14 10:27:51 VUT ERROR:  column "reportingmonth" does not exist at character 8
2014-10-14 10:27:51 VUT STATEMENT:  select reportingmonth, * from reporttable
2014-10-14 10:27:51 VUT ERROR:  column "doindicators" does not exist at character 23
2014-10-14 10:27:51 VUT STATEMENT:  select reporttableid, doindicators, doperiods, dounits, categorycomboid from reporttable
2014-10-14 10:27:51 VUT ERROR:  column "conceptid" of relation "dataelementcategory" does not exist
2014-10-14 10:27:51 VUT STATEMENT:  ALTER TABLE dataelementcategory DROP COLUMN conceptid
2014-10-14 10:27:51 VUT ERROR:  column "conceptid" of relation "dataelementcategoryoption" does not exist
2014-10-14 10:27:51 VUT STATEMENT:  ALTER TABLE dataelementcategoryoption DROP COLUMN conceptid
2014-10-14 10:27:51 VUT ERROR:  column "validationrulegroupid" of relation "validationrulegroup" already exists
2014-10-14 10:27:51 VUT STATEMENT:  alter table validationrulegroup rename column validationgroupid to validationrulegroupid
2014-10-14 10:27:51 VUT ERROR:  column "viweid" does not exist at character 30
2014-10-14 10:27:51 VUT STATEMENT:  update sqlview set sqlviewid=viweid
2014-10-14 10:27:51 VUT ERROR:  column "viewid" of relation "sqlview" does not exist
2014-10-14 10:27:51 VUT STATEMENT:  alter table sqlview drop column viewid
2014-10-14 10:27:51 VUT ERROR:  cannot alter type of a column used by a view or rule
2014-10-14 10:27:51 VUT DETAIL:  rule _RETURN on view _view_number_of_import_elements depends on column "lastupdated"
2014-10-14 10:27:51 VUT STATEMENT:  ALTER TABLE datavalue ALTER COLUMN lastupdated TYPE timestamp
2014-10-14 10:27:51 VUT ERROR:  index "crosstab" does not exist
2014-10-14 10:27:51 VUT STATEMENT:  drop index crosstab
2014-10-14 10:27:51 VUT ERROR:  column "symbol" of relation "dataset" does not exist
2014-10-14 10:27:51 VUT STATEMENT:  ALTER TABLE dataset DROP COLUMN symbol
2014-10-14 10:27:51 VUT ERROR:  column "operator" of relation "trackedentityattributedimension" does not exist
2014-10-14 10:27:51 VUT STATEMENT:  ALTER TABLE trackedentityattributedimension DROP COLUMN operator
2014-10-14 10:27:51 VUT ERROR:  column "operator" of relation "trackedentitydataelementdimension" does not exist
2014-10-14 10:27:51 VUT STATEMENT:  ALTER TABLE trackedentitydataelementdimension DROP COLUMN operator
2014-10-14 10:27:52 VUT ERROR:  column "dataelementid" does not exist at character 96
2014-10-14 10:27:52 VUT HINT:  There is a column named "dataelementid" in table "mapview_dataelements", but it cannot be referenced from this part of the query.
2014-10-14 10:27:52 VUT STATEMENT:  insert into mapview_dataelements ( mapviewid, sort_order, dataelementid ) select mapviewid, 0, dataelementid from mapview where dataelementid is not null
2014-10-14 10:27:52 VUT ERROR:  column "dataelementid" of relation "mapview" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  alter table mapview drop column dataelementid
2014-10-14 10:27:52 VUT ERROR:  column "dataelementoperandid" does not exist at character 110
2014-10-14 10:27:52 VUT HINT:  There is a column named "dataelementoperandid" in table "mapview_dataelementoperands", but it cannot be referenced from this part of the query.
2014-10-14 10:27:52 VUT STATEMENT:  insert into mapview_dataelementoperands ( mapviewid, sort_order, dataelementoperandid ) select mapviewid, 0, dataelementoperandid from mapview where dataelementoperandid is not null
2014-10-14 10:27:52 VUT ERROR:  column "dataelementoperandid" of relation "mapview" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  alter table mapview drop column dataelementoperandid
2014-10-14 10:27:52 VUT ERROR:  column "indicatorid" does not exist at character 92
2014-10-14 10:27:52 VUT HINT:  There is a column named "indicatorid" in table "mapview_indicators", but it cannot be referenced from this part of the query.
2014-10-14 10:27:52 VUT STATEMENT:  insert into mapview_indicators ( mapviewid, sort_order, indicatorid ) select mapviewid, 0, indicatorid from mapview where indicatorid is not null
2014-10-14 10:27:52 VUT ERROR:  column "indicatorid" of relation "mapview" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  alter table mapview drop column indicatorid
2014-10-14 10:27:52 VUT ERROR:  column "parentorganisationunitid" does not exist at character 106
2014-10-14 10:27:52 VUT STATEMENT:  insert into mapview_organisationunits ( mapviewid, sort_order, organisationunitid ) select mapviewid, 0, parentorganisationunitid from mapview where parentorganisationunitid is not null
2014-10-14 10:27:52 VUT ERROR:  column "parentorganisationunitid" of relation "mapview" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  alter table mapview drop column parentorganisationunitid
2014-10-14 10:27:52 VUT ERROR:  column "periodid" does not exist at character 86
2014-10-14 10:27:52 VUT HINT:  There is a column named "periodid" in table "mapview_periods", but it cannot be referenced from this part of the query.
2014-10-14 10:27:52 VUT STATEMENT:  insert into mapview_periods ( mapviewid, sort_order, periodid ) select mapviewid, 0, periodid from mapview where periodid is not null
2014-10-14 10:27:52 VUT ERROR:  column "periodid" of relation "mapview" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  alter table mapview drop column periodid
2014-10-14 10:27:52 VUT ERROR:  column m.organisationunitlevelid does not exist at character 145
2014-10-14 10:27:52 VUT STATEMENT:  insert into mapview_orgunitlevels ( mapviewid, sort_order, orgunitlevel ) select m.mapviewid, 0, o.level from mapview m join orgunitlevel o on (m.organisationunitlevelid=o.orgunitlevelid) where m.organisationunitlevelid is not null
2014-10-14 10:27:52 VUT ERROR:  column "organisationunitlevelid" of relation "mapview" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  alter table mapview drop column organisationunitlevelid
2014-10-14 10:27:52 VUT ERROR:  column "dataelementgroupid" of relation "mapview" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  alter table mapview drop column dataelementgroupid
2014-10-14 10:27:52 VUT ERROR:  column "indicatorgroupid" of relation "mapview" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  alter table mapview drop column indicatorgroupid
2014-10-14 10:27:52 VUT ERROR:  column "active" of relation "dataelement" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  ALTER TABLE dataelement DROP COLUMN active
2014-10-14 10:27:52 VUT ERROR:  column "description" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  ALTER TABLE relationshiptype RENAME description TO name
2014-10-14 10:27:52 VUT ERROR:  column "showonreport" of relation "programstage_dataelements" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  ALTER TABLE programstage_dataelements DROP COLUMN showOnReport
2014-10-14 10:27:52 VUT ERROR:  column "hidedateofincident" of relation "program" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  ALTER TABLE program DROP COLUMN hidedateofincident
2014-10-14 10:27:52 VUT ERROR:  column "singleevent" does not exist at character 33
2014-10-14 10:27:52 VUT STATEMENT:  UPDATE program SET type=2 where singleevent=true
2014-10-14 10:27:52 VUT ERROR:  column "anonymous" does not exist at character 33
2014-10-14 10:27:52 VUT STATEMENT:  UPDATE program SET type=3 where anonymous=true
2014-10-14 10:27:52 VUT ERROR:  column "singleevent" of relation "program" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  ALTER TABLE program DROP COLUMN singleevent
2014-10-14 10:27:52 VUT ERROR:  column "anonymous" of relation "program" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  ALTER TABLE program DROP COLUMN anonymous
2014-10-14 10:27:52 VUT ERROR:  table "programattributevalue" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  DROP TABLE programattributevalue
2014-10-14 10:27:52 VUT ERROR:  table "programinstance_attributes" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  DROP TABLE programinstance_attributes
2014-10-14 10:27:52 VUT ERROR:  table "programattributeoption" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  DROP TABLE programattributeoption
2014-10-14 10:27:52 VUT ERROR:  table "programattribute" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  DROP TABLE programattribute
2014-10-14 10:27:52 VUT ERROR:  column "description" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  ALTER TABLE caseaggregationcondition RENAME description TO name
2014-10-14 10:27:52 VUT ERROR:  column "providedbyanotherfacility" of relation "programstageinstance" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  ALTER TABLE programstageinstance DROP COLUMN providedbyanotherfacility
2014-10-14 10:27:52 VUT ERROR:  column "stageinprogram" of relation "programstageinstance" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  ALTER TABLE programstageinstance DROP COLUMN stageInProgram
2014-10-14 10:27:52 VUT ERROR:  relation "programstageinstance_executiondate" already exists
2014-10-14 10:27:52 VUT STATEMENT:  CREATE INDEX programstageinstance_executiondate ON programstageinstance (executiondate)
2014-10-14 10:27:52 VUT ERROR:  column "generatedbyenrollmentdate" does not exist at character 58
2014-10-14 10:27:52 VUT STATEMENT:  UPDATE program SET generatedByEnrollmentDate=false WHERE generatedByEnrollmentDate is null
2014-10-14 10:27:52 VUT ERROR:  column "stageinprogram" of relation "programstage" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  ALTER TABLE programstage DROP COLUMN stageinprogram
2014-10-14 10:27:52 VUT ERROR:  relation "index_programinstance" already exists
2014-10-14 10:27:52 VUT STATEMENT:  CREATE INDEX index_programinstance ON programinstance( programinstanceid )
2014-10-14 10:27:52 VUT ERROR:  column "maxdaysallowedinputdata" of relation "program" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  ALTER TABLE program DROP COLUMN maxDaysAllowedInputData
2014-10-14 10:27:52 VUT ERROR:  syntax error at or near "modify" at character 20
2014-10-14 10:27:52 VUT STATEMENT:  ALTER TABLE period modify periodid int AUTO_INCREMENT
2014-10-14 10:27:52 VUT ERROR:  column "displayinreports" does not exist at character 58
2014-10-14 10:27:52 VUT STATEMENT:  UPDATE program SET programstage_dataelements=false WHERE displayInReports is null
2014-10-14 10:27:52 VUT ERROR:  column "leftside" of relation "programvalidation" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  ALTER TABLE programvalidation DROP COLUMN leftside
2014-10-14 10:27:52 VUT ERROR:  column "rightside" of relation "programvalidation" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  ALTER TABLE programvalidation DROP COLUMN rightside
2014-10-14 10:27:52 VUT ERROR:  column "datetype" of relation "programvalidation" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  ALTER TABLE programvalidation DROP COLUMN dateType
2014-10-14 10:27:52 VUT ERROR:  column "name" of relation "programvalidation" already exists
2014-10-14 10:27:52 VUT STATEMENT:  ALTER TABLE programvalidation RENAME description TO name
2014-10-14 10:27:52 VUT ERROR:  column "blockentryform" does not exist at character 47
2014-10-14 10:27:52 VUT STATEMENT:  UPDATE program SET blockEntryForm=false WHERE blockEntryForm is null
2014-10-14 10:27:52 VUT ERROR:  constraint "program_name_key" of relation "dataset" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  ALTER TABLE dataset DROP CONSTRAINT program_name_key
2014-10-14 10:27:52 VUT ERROR:  relation "prorgam" does not exist at character 8
2014-10-14 10:27:52 VUT STATEMENT:  update prorgam set "operator"='times' where "operator"='SUM'
2014-10-14 10:27:52 VUT ERROR:  column "remindcompleted" does not exist at character 48
2014-10-14 10:27:52 VUT STATEMENT:  update program set remindCompleted=false where remindCompleted is null
2014-10-14 10:27:52 VUT ERROR:  column "completed" does not exist at character 43
2014-10-14 10:27:52 VUT STATEMENT:  UPDATE programinstance SET status=0 WHERE completed=false
2014-10-14 10:27:52 VUT ERROR:  column pi.completed does not exist at character 209
2014-10-14 10:27:52 VUT STATEMENT:  UPDATE programinstance SET status=2 WHERE programinstanceid in ( select psi.programinstanceid from programinstance pi join programstageinstance psi on psi.programinstanceid = psi.programstageinstanceid where pi.completed=true and psi.completed = false )
2014-10-14 10:27:52 VUT ERROR:  column "completed" of relation "programinstance" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  ALTER TABLE programinstance DROP COLUMN completed
2014-10-14 10:27:52 VUT ERROR:  column "disableregistrationfields" of relation "program" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  ALTER TABLE program DROP COLUMN disableRegistrationFields
2014-10-14 10:27:52 VUT ERROR:  column "useformnamedataelement" does not exist at character 54
2014-10-14 10:27:52 VUT STATEMENT:  UPDATE program SET useFormNameDataElement=true where useFormNameDataElement is null
2014-10-14 10:27:52 VUT ERROR:  column "generatedbyenrollmentdate" of relation "program" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  ALTER TABLE program DROP COLUMN generatedByEnrollmentDate
2014-10-14 10:27:52 VUT ERROR:  column "blockentryform" of relation "program" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  ALTER TABLE program DROP COLUMN blockEntryForm
2014-10-14 10:27:52 VUT ERROR:  column "remindcompleted" of relation "program" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  ALTER TABLE program DROP COLUMN remindCompleted
2014-10-14 10:27:52 VUT ERROR:  column "displayprovidedotherfacility" of relation "program" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  ALTER TABLE program DROP COLUMN displayProvidedOtherFacility
2014-10-14 10:27:52 VUT ERROR:  column "facilitylb" of relation "program" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  ALTER TABLE program DROP COLUMN facilityLB
2014-10-14 10:27:52 VUT ERROR:  column "allowdateinfuture" does not exist at character 68
2014-10-14 10:27:52 VUT STATEMENT:  update programstage_dataelements set allowDateInFuture=false where allowDateInFuture is null
2014-10-14 10:27:52 VUT ERROR:  column "coordinates" does not exist at character 32
2014-10-14 10:27:52 VUT STATEMENT:  SELECT programstageinstanceid, coordinates FROM programstageinstance where coordinates is not null
2014-10-14 10:27:52 VUT ERROR:  column "usebirthdateasincidentdate" of relation "program" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  ALTER TABLE program DROP COLUMN useBirthDateAsIncidentDate
2014-10-14 10:27:52 VUT ERROR:  column "usebirthdateasenrollmentdate" of relation "program" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  ALTER TABLE program DROP COLUMN useBirthDateAsEnrollmentDate
2014-10-14 10:27:52 VUT ERROR:  column "name" does not exist at character 82
2014-10-14 10:27:52 VUT STATEMENT:  update userroleauthorities set "name"='trackedEntityExcelTemplateFileName' where "name"='patientExcelTemplateFileName'
2014-10-14 10:27:52 VUT ERROR:  column "mandatory" of relation "trackedentityattribute" does not exist at character 112
2014-10-14 10:27:52 VUT STATEMENT:  INSERT INTO trackedentityattribute ( trackedentityattributeid, uid, lastUpdated, name, description, valueType, mandatory, inherit, displayOnVisitSchedule, uniquefield, orgunitScope, programScope ) select nextval('hibernate_sequence'), uid, lastUpdated, name,  description, type, mandatory, false, false, true, orgunitScope, programScope from patientidentifiertype
2014-10-14 10:27:52 VUT ERROR:  relation "patientidentifier" does not exist at character 178
2014-10-14 10:27:52 VUT STATEMENT:  INSERT INTO trackedentityattributevalue (trackedentityinstanceid, trackedentityattributeid, value ) select trackedentityinstanceid, pa.trackedentityattributeid, identifier from patientidentifier pi inner join patientidentifiertype pit on pi.patientidentifiertypeid=pit.patientidentifiertypeid inner join trackedentityattribute pa on pa.uid=pit.uid where pi.trackedentityinstanceid is not null
2014-10-14 10:27:52 VUT ERROR:  table "program_identifiertypes" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  DROP TABLE program_identifiertypes
2014-10-14 10:27:52 VUT ERROR:  table "patientidentifier" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  DROP TABLE patientidentifier
2014-10-14 10:27:52 VUT ERROR:  table "patientidentifiertype" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  DROP TABLE patientidentifiertype
2014-10-14 10:27:52 VUT ERROR:  constraint "fk_patientidentifiertype_periodtypeid" for table "trackedentityattribute" does not exist
2014-10-14 10:27:52 VUT STATEMENT:  ALTER TABLE trackedentityattribute RENAME CONSTRAINT fk_patientidentifiertype_periodtypeid TO trackedentityattribute_periodtypeid
2014-10-14 10:27:53 VUT ERROR:  column "programattributeid" does not exist
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE program_attributes RENAME COLUMN programattributeid TO programtrackedentityattributeid
2014-10-14 10:27:53 VUT ERROR:  column "trackedentityattributeoptionid" of relation "trackedentityattributevalue" does not exist
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE trackedentityattributevalue DROP COLUMN trackedentityattributeoptionid
2014-10-14 10:27:53 VUT ERROR:  table "trackedentityattributeoption" does not exist
2014-10-14 10:27:53 VUT STATEMENT:  DROP TABLE trackedentityattributeoption
2014-10-14 10:27:53 VUT ERROR:  column trackedentityattribute.mandatory does not exist at character 43
2014-10-14 10:27:53 VUT STATEMENT:  UPDATE program_attributes SET mandatory = trackedentityattribute.mandatory FROM program_attributes pa INNER JOIN trackedentityattribute  ON pa.trackedentityattributeid=trackedentityattribute.trackedentityattributeid  where trackedentityattribute.mandatory is not null
2014-10-14 10:27:53 VUT ERROR:  column "mandatory" of relation "trackedentityattribute" does not exist
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE trackedentityattribute DROP COLUMN mandatory
2014-10-14 10:27:53 VUT ERROR:  column "groupby" of relation "trackedentityattribute" does not exist
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE trackedentityattribute DROP COLUMN groupBy
2014-10-14 10:27:53 VUT ERROR:  table "orgunitgroupprograms" does not exist
2014-10-14 10:27:53 VUT STATEMENT:  DROP TABLE orgunitgroupprograms
2014-10-14 10:27:53 VUT ERROR:  column "completed" does not exist at character 48
2014-10-14 10:27:53 VUT STATEMENT:  UPDATE programstageinstance SET status=1 WHERE completed=true
2014-10-14 10:27:53 VUT ERROR:  column "completed" of relation "programstageinstance" does not exist
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE programstageinstance DROP COLUMN completed
2014-10-14 10:27:53 VUT ERROR:  column "allowdateinfuture" does not exist at character 56
2014-10-14 10:27:53 VUT STATEMENT:  update programstage_dataelements set allowfuturedate = allowdateinfuture where allowfuturedate is null
2014-10-14 10:27:53 VUT ERROR:  column "allowdateinfuture" of relation "programstage_dataelements" does not exist
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE programstage_dataelements DROP COLUMN allowdateinfuture
2014-10-14 10:27:53 VUT ERROR:  column "allowdateinfuture" does not exist at character 49
2014-10-14 10:27:53 VUT STATEMENT:  update program_attributes set allowfuturedate = allowdateinfuture where allowfuturedate is null
2014-10-14 10:27:53 VUT ERROR:  column "allowdateinfuture" of relation "program_attributes" does not exist
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE program_attributes DROP COLUMN allowdateinfuture
2014-10-14 10:27:53 VUT ERROR:  sequence "period_periodid_seq" does not exist
2014-10-14 10:27:53 VUT STATEMENT:  DROP SEQUENCE period_periodid_seq
2014-10-14 10:27:53 VUT ERROR:  relation "constant_uid_key" already exists
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE constant ADD CONSTRAINT constant_uid_key UNIQUE(uid)
2014-10-14 10:27:53 VUT ERROR:  relation "concept_uid_key" already exists
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE concept ADD CONSTRAINT concept_uid_key UNIQUE(uid)
2014-10-14 10:27:53 VUT ERROR:  relation "attribute_uid_key" already exists
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE attribute ADD CONSTRAINT attribute_uid_key UNIQUE(uid)
2014-10-14 10:27:53 VUT ERROR:  relation "indicatortype_uid_key" already exists
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE indicatortype ADD CONSTRAINT indicatortype_uid_key UNIQUE(uid)
2014-10-14 10:27:53 VUT ERROR:  relation "indicator_uid_key" already exists
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE indicator ADD CONSTRAINT indicator_uid_key UNIQUE(uid)
2014-10-14 10:27:53 VUT ERROR:  relation "indicatorgroup_uid_key" already exists
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE indicatorgroup ADD CONSTRAINT indicatorgroup_uid_key UNIQUE(uid)
2014-10-14 10:27:53 VUT ERROR:  relation "indicatorgroupset_uid_key" already exists
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE indicatorgroupset ADD CONSTRAINT indicatorgroupset_uid_key UNIQUE(uid)
2014-10-14 10:27:53 VUT ERROR:  relation "datadictionary_uid_key" already exists
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE datadictionary ADD CONSTRAINT datadictionary_uid_key UNIQUE(uid)
2014-10-14 10:27:53 VUT ERROR:  relation "validationrule_uid_key" already exists
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE validationrule ADD CONSTRAINT validationrule_uid_key UNIQUE(uid)
2014-10-14 10:27:53 VUT ERROR:  relation "validationrulegroup_uid_key" already exists
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE validationrulegroup ADD CONSTRAINT validationrulegroup_uid_key UNIQUE(uid)
2014-10-14 10:27:53 VUT ERROR:  relation "dataset_uid_key" already exists
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE dataset ADD CONSTRAINT dataset_uid_key UNIQUE(uid)
2014-10-14 10:27:53 VUT ERROR:  relation "section_uid_key" already exists
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE section ADD CONSTRAINT section_uid_key UNIQUE(uid)
2014-10-14 10:27:53 VUT ERROR:  relation "orgunitlevel_uid_key" already exists
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE orgunitlevel ADD CONSTRAINT orgunitlevel_uid_key UNIQUE(uid)
2014-10-14 10:27:53 VUT ERROR:  relation "organisationunit_uid_key" already exists
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE organisationunit ADD CONSTRAINT organisationunit_uid_key UNIQUE(uid)
2014-10-14 10:27:53 VUT ERROR:  relation "orgunitgroup_uid_key" already exists
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE orgunitgroup ADD CONSTRAINT orgunitgroup_uid_key UNIQUE(uid)
2014-10-14 10:27:53 VUT ERROR:  relation "orgunitgroupset_uid_key" already exists
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE orgunitgroupset ADD CONSTRAINT orgunitgroupset_uid_key UNIQUE(uid)
2014-10-14 10:27:53 VUT ERROR:  relation "dataelement_uid_key" already exists
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE dataelement ADD CONSTRAINT dataelement_uid_key UNIQUE(uid)
2014-10-14 10:27:53 VUT ERROR:  relation "dataelementgroup_uid_key" already exists
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE dataelementgroup ADD CONSTRAINT dataelementgroup_uid_key UNIQUE(uid)
2014-10-14 10:27:53 VUT ERROR:  relation "dataelementgroupset_uid_key" already exists
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE dataelementgroupset ADD CONSTRAINT dataelementgroupset_uid_key UNIQUE(uid)
2014-10-14 10:27:53 VUT ERROR:  relation "sqlview_uid_key" already exists
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE sqlview ADD CONSTRAINT sqlview_uid_key UNIQUE(uid)
2014-10-14 10:27:53 VUT ERROR:  relation "dataelementcategory_uid_key" already exists
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE dataelementcategory ADD CONSTRAINT dataelementcategory_uid_key UNIQUE(uid)
2014-10-14 10:27:53 VUT ERROR:  relation "dataelementcategoryoption_uid_key" already exists
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE dataelementcategoryoption ADD CONSTRAINT dataelementcategoryoption_uid_key UNIQUE(uid)
2014-10-14 10:27:53 VUT ERROR:  relation "categorycombo_uid_key" already exists
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE categorycombo ADD CONSTRAINT categorycombo_uid_key UNIQUE(uid)
2014-10-14 10:27:53 VUT ERROR:  relation "categoryoptioncombo_uid_key" already exists
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE categoryoptioncombo ADD CONSTRAINT categoryoptioncombo_uid_key UNIQUE(uid)
2014-10-14 10:27:53 VUT ERROR:  relation "translation_uid_key" already exists
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE translation ADD CONSTRAINT translation_uid_key UNIQUE(uid)
2014-10-14 10:27:53 VUT ERROR:  relation "userinfo_uid_key" already exists
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE userinfo ADD CONSTRAINT userinfo_uid_key UNIQUE(uid)
2014-10-14 10:27:53 VUT ERROR:  relation "usergroup_uid_key" already exists
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE usergroup ADD CONSTRAINT usergroup_uid_key UNIQUE(uid)
2014-10-14 10:27:53 VUT ERROR:  relation "userrole_uid_key" already exists
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE userrole ADD CONSTRAINT userrole_uid_key UNIQUE(uid)
2014-10-14 10:27:53 VUT ERROR:  relation "optionset_uid_key" already exists
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE optionset ADD CONSTRAINT optionset_uid_key UNIQUE(uid)
2014-10-14 10:27:53 VUT ERROR:  relation "validationcriteria_uid_key" already exists
2014-10-14 10:27:53 VUT STATEMENT:  ALTER TABLE validationcriteria ADD CONSTRAINT validationcriteria_uid_key UNIQUE(uid)
2014-10-14 10:27:53 VUT ERROR:  relation "aggregateddatavalue" already exists
2014-10-14 10:27:53 VUT STATEMENT:  CREATE TABLE aggregateddatavalue ( dataelementid INTEGER, categoryoptioncomboid INTEGER, periodid INTEGER, organisationunitid INTEGER, periodtypeid INTEGER, level INTEGER, value double precision )
2014-10-14 10:27:53 VUT ERROR:  relation "aggregatedorgunitdatavalue" already exists
2014-10-14 10:27:53 VUT STATEMENT:  CREATE TABLE aggregatedorgunitdatavalue ( dataelementid INTEGER, categoryoptioncomboid INTEGER, periodid INTEGER, organisationunitid INTEGER, organisationunitgroupid INTEGER, periodtypeid INTEGER, level INTEGER, value double precision )
2014-10-14 10:27:53 VUT ERROR:  relation "aggregatedindicatorvalue" already exists
2014-10-14 10:27:53 VUT STATEMENT:  CREATE TABLE aggregatedindicatorvalue ( indicatorid INTEGER, periodid INTEGER, organisationunitid INTEGER, periodtypeid INTEGER, level INTEGER, annualized VARCHAR( 10 ), factor double precision, value double precision, numeratorvalue double precision, denominatorvalue double precision )
2014-10-14 10:27:53 VUT ERROR:  relation "aggregatedorgunitindicatorvalue" already exists
2014-10-14 10:27:53 VUT STATEMENT:  CREATE TABLE aggregatedorgunitindicatorvalue ( indicatorid INTEGER, periodid INTEGER, organisationunitid INTEGER, organisationunitgroupid INTEGER, periodtypeid INTEGER, level INTEGER, annualized VARCHAR( 10 ), factor double precision, value double precision, numeratorvalue double precision, denominatorvalue double precision )
2014-10-14 10:27:53 VUT ERROR:  relation "aggregateddatasetcompleteness" already exists
2014-10-14 10:27:53 VUT STATEMENT:  CREATE TABLE aggregateddatasetcompleteness ( datasetid INTEGER, periodid INTEGER, periodname VARCHAR( 30 ), organisationunitid INTEGER, sources INTEGER, registrations INTEGER, registrationsOnTime INTEGER, value double precision, valueOnTime double precision )
2014-10-14 10:27:53 VUT ERROR:  relation "aggregatedorgunitdatasetcompleteness" already exists
2014-10-14 10:27:53 VUT STATEMENT:  CREATE TABLE aggregatedorgunitdatasetcompleteness ( datasetid INTEGER, periodid INTEGER, periodname VARCHAR( 30 ), organisationunitid INTEGER, organisationunitgroupid INTEGER, sources INTEGER, registrations INTEGER, registrationsOnTime INTEGER, value double precision, valueOnTime double precision )
2014-10-14 10:27:53 VUT ERROR:  relation "messageconversation_lastmessage" already exists
2014-10-14 10:27:53 VUT STATEMENT:  CREATE INDEX messageconversation_lastmessage ON messageconversation (lastmessage)
2014-10-14 10:27:53 VUT ERROR:  relation "interpretation_lastupdated" already exists
2014-10-14 10:27:53 VUT STATEMENT:  CREATE INDEX interpretation_lastupdated ON interpretation (lastupdated)
2014-10-14 10:27:53 VUT ERROR:  column "mapvaluetype" does not exist at character 30
2014-10-14 10:27:53 VUT STATEMENT:  update mapview set valuetype=mapvaluetype where valuetype is null
2014-10-14 10:27:53 VUT ERROR:  column "maplegendtype" does not exist at character 31
2014-10-14 10:27:53 VUT STATEMENT:  update mapview set legendtype=maplegendtype where legendtype is null
2014-10-14 10:27:53 VUT ERROR:  column "maplegendsetid" does not exist at character 32
2014-10-14 10:27:53 VUT STATEMENT:  update mapview set legendsetid=maplegendsetid where legendsetid is null
2014-10-14 10:27:53 VUT ERROR:  column "mapvaluetype" of relation "mapview" does not exist
2014-10-14 10:27:53 VUT STATEMENT:  alter table mapview drop column mapvaluetype
2014-10-14 10:27:53 VUT ERROR:  column "maplegendtype" of relation "mapview" does not exist
2014-10-14 10:27:53 VUT STATEMENT:  alter table mapview drop column maplegendtype
2014-10-14 10:27:53 VUT ERROR:  column "maplegendsetid" of relation "mapview" does not exist
2014-10-14 10:27:53 VUT STATEMENT:  alter table mapview drop column maplegendsetid
2014-10-14 10:27:53 VUT ERROR:  column "bounds" of relation "mapview" does not exist
2014-10-14 10:27:53 VUT STATEMENT:  alter table mapview drop column bounds
2014-10-14 10:27:53 VUT ERROR:  column "code" of relation "mapview" does not exist
2014-10-14 10:27:53 VUT STATEMENT:  alter table mapview drop column code
2014-10-14 10:27:53 VUT ERROR:  column "periodtypeid" of relation "mapview" does not exist
2014-10-14 10:27:53 VUT STATEMENT:  alter table mapview drop column periodtypeid
2014-10-14 10:27:54 VUT ERROR:  column "valuetype" does not exist at character 50
2014-10-14 10:27:54 VUT STATEMENT:  update mapview set valuetype='dataElement' where valuetype='dataelement'
2014-10-14 10:27:54 VUT ERROR:  column "name" does not exist at character 19
2014-10-14 10:27:54 VUT STATEMENT:  select mapviewid, name, userid, longitude, latitude, zoom from mapview where mapviewid not in (select mapviewid from mapmapviews)