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)