PER01000: Got SQLException executing statement "ALTER TABLE VDCGROUPRELATIONSHIP ADD CONSTRAINT FK_VDCGROUPRELATIONSHIP_group_id FOREIGN KEY (group_id) REFERENCES VDCGROUP (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdcgrouprelationship_group_id" for relation "vdcgrouprelationship" already exists PER01000: Got SQLException executing statement "ALTER TABLE VARIABLECATEGORY ADD CONSTRAINT FK_VARIABLECATEGORY_DATAVARIABLE_ID FOREIGN KEY (DATAVARIABLE_ID) REFERENCES DATAVARIABLE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_variablecategory_datavariable_id" for relation "variablecategory" already exists PER01000: Got SQLException executing statement "ALTER TABLE VDCCOLLECTION ADD CONSTRAINT FK_VDCCOLLECTION_OWNER_ID FOREIGN KEY (OWNER_ID) REFERENCES VDC (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdccollection_owner_id" for relation "vdccollection" already exists PER01000: Got SQLException executing statement "ALTER TABLE VDCCOLLECTION ADD CONSTRAINT FK_VDCCOLLECTION_PARENTCOLLECTION_ID FOREIGN KEY (PARENTCOLLECTION_ID) REFERENCES VDCCOLLECTION (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdccollection_parentcollection_id" for relation "vdccollection" already exists PER01000: Got SQLException executing statement "ALTER TABLE STUDYCOMMENT ADD CONSTRAINT FK_STUDYCOMMENT_STUDYVERSION_ID FOREIGN KEY (STUDYVERSION_ID) REFERENCES STUDYVERSION (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studycomment_studyversion_id" for relation "studycomment" already exists PER01000: Got SQLException executing statement "ALTER TABLE STUDYCOMMENT ADD CONSTRAINT FK_STUDYCOMMENT_COMMENTCREATOR_ID FOREIGN KEY (COMMENTCREATOR_ID) REFERENCES VDCUSER (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studycomment_commentcreator_id" for relation "studycomment" already exists PER01000: Got SQLException executing statement "ALTER TABLE VARIABLERANGEITEM ADD CONSTRAINT FK_VARIABLERANGEITEM_DATAVARIABLE_ID FOREIGN KEY (DATAVARIABLE_ID) REFERENCES DATAVARIABLE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_variablerangeitem_datavariable_id" for relation "variablerangeitem" already exists PER01000: Got SQLException executing statement "ALTER TABLE VARGROUPING ADD CONSTRAINT FK_VARGROUPING_DATATABLE_ID FOREIGN KEY (DATATABLE_ID) REFERENCES DATATABLE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vargrouping_datatable_id" for relation "vargrouping" already exists PER01000: Got SQLException executing statement "ALTER TABLE TEMPLATEFILECATEGORY ADD CONSTRAINT FK_TEMPLATEFILECATEGORY_TEMPLATE_ID FOREIGN KEY (TEMPLATE_ID) REFERENCES TEMPLATE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_templatefilecategory_template_id" for relation "templatefilecategory" already exists PER01000: Got SQLException executing statement "ALTER TABLE CONTACTSUBJECT ADD CONSTRAINT FK_CONTACTSUBJECT_VDC_ID FOREIGN KEY (VDC_ID) REFERENCES VDC (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_contactsubject_vdc_id" for relation "contactsubject" already exists PER01000: Got SQLException executing statement "ALTER TABLE STUDYFILEACTIVITY ADD CONSTRAINT FK_STUDYFILEACTIVITY_STUDYFILE_ID FOREIGN KEY (STUDYFILE_ID) REFERENCES STUDYFILE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyfileactivity_studyfile_id" for relation "studyfileactivity" already exists PER01000: Got SQLException executing statement "ALTER TABLE STUDYFILEACTIVITY ADD CONSTRAINT FK_STUDYFILEACTIVITY_STUDY_ID FOREIGN KEY (STUDY_ID) REFERENCES STUDY (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyfileactivity_study_id" for relation "studyfileactivity" already exists PER01000: Got SQLException executing statement "ALTER TABLE TEMPLATEFIELD ADD CONSTRAINT FK_TEMPLATEFIELD_STUDYFIELD_ID FOREIGN KEY (STUDYFIELD_ID) REFERENCES STUDYFIELD (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_templatefield_studyfield_id" for relation "templatefield" already exists PER01000: Got SQLException executing statement "ALTER TABLE TEMPLATEFIELD ADD CONSTRAINT FK_TEMPLATEFIELD_CONTROLLEDVOCABULARY_ID FOREIGN KEY (CONTROLLEDVOCABULARY_ID) REFERENCES CONTROLLEDVOCABULARY (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_templatefield_controlledvocabulary_id" for relation "templatefield" already exists PER01000: Got SQLException executing statement "ALTER TABLE TEMPLATEFIELD ADD CONSTRAINT FK_TEMPLATEFIELD_TEMPLATE_ID FOREIGN KEY (TEMPLATE_ID) REFERENCES TEMPLATE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_templatefield_template_id" for relation "templatefield" already exists PER01000: Got SQLException executing statement "ALTER TABLE NETWORKROLEREQUEST ADD CONSTRAINT FK_NETWORKROLEREQUEST_VDCUSER_ID FOREIGN KEY (VDCUSER_ID) REFERENCES VDCUSER (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_networkrolerequest_vdcuser_id" for relation "networkrolerequest" already exists PER01000: Got SQLException executing statement "ALTER TABLE NETWORKROLEREQUEST ADD CONSTRAINT FK_NETWORKROLEREQUEST_NETWORKROLE_ID FOREIGN KEY (NETWORKROLE_ID) REFERENCES NETWORKROLE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_networkrolerequest_networkrole_id" for relation "networkrolerequest" already exists PER01000: Got SQLException executing statement "ALTER TABLE SUMMARYSTATISTIC ADD CONSTRAINT FK_SUMMARYSTATISTIC_DATAVARIABLE_ID FOREIGN KEY (DATAVARIABLE_ID) REFERENCES DATAVARIABLE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_summarystatistic_datavariable_id" for relation "summarystatistic" already exists PER01000: Got SQLException executing statement "ALTER TABLE SUMMARYSTATISTIC ADD CONSTRAINT FK_SUMMARYSTATISTIC_TYPE_ID FOREIGN KEY (TYPE_ID) REFERENCES SUMMARYSTATISTICTYPE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_summarystatistic_type_id" for relation "summarystatistic" already exists PER01000: Got SQLException executing statement "ALTER TABLE STUDYABSTRACT ADD CONSTRAINT FK_STUDYABSTRACT_METADATA_ID FOREIGN KEY (METADATA_ID) REFERENCES METADATA (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyabstract_metadata_id" for relation "studyabstract" already exists PER01000: Got SQLException executing statement "ALTER TABLE STUDYRELSTUDY ADD CONSTRAINT FK_STUDYRELSTUDY_METADATA_ID FOREIGN KEY (METADATA_ID) REFERENCES METADATA (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyrelstudy_metadata_id" for relation "studyrelstudy" already exists PER01000: Got SQLException executing statement "ALTER TABLE STUDYGEOBOUNDING ADD CONSTRAINT FK_STUDYGEOBOUNDING_METADATA_ID FOREIGN KEY (METADATA_ID) REFERENCES METADATA (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studygeobounding_metadata_id" for relation "studygeobounding" already exists PER01000: Got SQLException executing statement "ALTER TABLE STUDYPRODUCER ADD CONSTRAINT FK_STUDYPRODUCER_METADATA_ID FOREIGN KEY (METADATA_ID) REFERENCES METADATA (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyproducer_metadata_id" for relation "studyproducer" already exists PER01000: Got SQLException executing statement "ALTER TABLE LOGINAFFILIATE ADD CONSTRAINT FK_LOGINAFFILIATE_USERGROUP_ID FOREIGN KEY (USERGROUP_ID) REFERENCES USERGROUP (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_loginaffiliate_usergroup_id" for relation "loginaffiliate" already exists PER01000: Got SQLException executing statement "ALTER TABLE VARIABLERANGE ADD CONSTRAINT FK_VARIABLERANGE_BEGINVALUETYPE_ID FOREIGN KEY (BEGINVALUETYPE_ID) REFERENCES VARIABLERANGETYPE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_variablerange_beginvaluetype_id" for relation "variablerange" already exists PER01000: Got SQLException executing statement "ALTER TABLE VARIABLERANGE ADD CONSTRAINT FK_VARIABLERANGE_DATAVARIABLE_ID FOREIGN KEY (DATAVARIABLE_ID) REFERENCES DATAVARIABLE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_variablerange_datavariable_id" for relation "variablerange" already exists PER01000: Got SQLException executing statement "ALTER TABLE VARIABLERANGE ADD CONSTRAINT FK_VARIABLERANGE_ENDVALUETYPE_ID FOREIGN KEY (ENDVALUETYPE_ID) REFERENCES VARIABLERANGETYPE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_variablerange_endvaluetype_id" for relation "variablerange" already exists PER01000: Got SQLException executing statement "ALTER TABLE STUDYGRANT ADD CONSTRAINT FK_STUDYGRANT_METADATA_ID FOREIGN KEY (METADATA_ID) REFERENCES METADATA (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studygrant_metadata_id" for relation "studygrant" already exists PER01000: Got SQLException executing statement "ALTER TABLE DATAVARIABLE ADD CONSTRAINT FK_DATAVARIABLE_VARIABLEINTERVALTYPE_ID FOREIGN KEY (VARIABLEINTERVALTYPE_ID) REFERENCES VARIABLEINTERVALTYPE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_datavariable_variableintervaltype_id" for relation "datavariable" already exists PER01000: Got SQLException executing statement "ALTER TABLE DATAVARIABLE ADD CONSTRAINT FK_DATAVARIABLE_VARIABLEFORMATTYPE_ID FOREIGN KEY (VARIABLEFORMATTYPE_ID) REFERENCES VARIABLEFORMATTYPE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_datavariable_variableformattype_id" for relation "datavariable" already exists PER01000: Got SQLException executing statement "ALTER TABLE DATAVARIABLE ADD CONSTRAINT FK_DATAVARIABLE_DATATABLE_ID FOREIGN KEY (DATATABLE_ID) REFERENCES DATATABLE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_datavariable_datatable_id" for relation "datavariable" already exists PER01000: Got SQLException executing statement "ALTER TABLE STUDYRELPUBLICATION ADD CONSTRAINT FK_STUDYRELPUBLICATION_METADATA_ID FOREIGN KEY (METADATA_ID) REFERENCES METADATA (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyrelpublication_metadata_id" for relation "studyrelpublication" already exists PER01000: Got SQLException executing statement "ALTER TABLE CONTROLLEDVOCABULARYVALUE ADD CONSTRAINT FK_CONTROLLEDVOCABULARYVALUE_CONTROLLEDVOCABULARY_ID FOREIGN KEY (CONTROLLEDVOCABULARY_ID) REFERENCES CONTROLLEDVOCABULARY (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_controlledvocabularyvalue_controlledvocabulary_id" for relation "controlledvocabularyvalue" already exists PER01000: Got SQLException executing statement "ALTER TABLE STUDYDISTRIBUTOR ADD CONSTRAINT FK_STUDYDISTRIBUTOR_METADATA_ID FOREIGN KEY (METADATA_ID) REFERENCES METADATA (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studydistributor_metadata_id" for relation "studydistributor" already exists PER01000: Got SQLException executing statement "ALTER TABLE STUDYNOTE ADD CONSTRAINT FK_STUDYNOTE_METADATA_ID FOREIGN KEY (METADATA_ID) REFERENCES METADATA (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studynote_metadata_id" for relation "studynote" already exists PER01000: Got SQLException executing statement "ALTER TABLE VERSIONCONTRIBUTOR ADD CONSTRAINT FK_VERSIONCONTRIBUTOR_CONTRIBUTOR_ID FOREIGN KEY (CONTRIBUTOR_ID) REFERENCES VDCUSER (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_versioncontributor_contributor_id" for relation "versioncontributor" already exists PER01000: Got SQLException executing statement "ALTER TABLE VERSIONCONTRIBUTOR ADD CONSTRAINT FK_VERSIONCONTRIBUTOR_STUDYVERSION_ID FOREIGN KEY (STUDYVERSION_ID) REFERENCES STUDYVERSION (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_versioncontributor_studyversion_id" for relation "versioncontributor" already exists PER01000: Got SQLException executing statement "ALTER TABLE DATAVARIABLEMAPPING ADD CONSTRAINT FK_DATAVARIABLEMAPPING_DATAVARIABLE_ID FOREIGN KEY (DATAVARIABLE_ID) REFERENCES DATAVARIABLE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_datavariablemapping_datavariable_id" for relation "datavariablemapping" already exists PER01000: Got SQLException executing statement "ALTER TABLE DATAVARIABLEMAPPING ADD CONSTRAINT FK_DATAVARIABLEMAPPING_VARGROUPING_ID FOREIGN KEY (VARGROUPING_ID) REFERENCES VARGROUPING (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_datavariablemapping_vargrouping_id" for relation "datavariablemapping" already exists PER01000: Got SQLException executing statement "ALTER TABLE DATAVARIABLEMAPPING ADD CONSTRAINT FK_DATAVARIABLEMAPPING_DATATABLE_ID FOREIGN KEY (DATATABLE_ID) REFERENCES DATATABLE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_datavariablemapping_datatable_id" for relation "datavariablemapping" already exists PER01000: Got SQLException executing statement "ALTER TABLE DATAVARIABLEMAPPING ADD CONSTRAINT FK_DATAVARIABLEMAPPING_VARGROUP_ID FOREIGN KEY (VARGROUP_ID) REFERENCES VARGROUP (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_datavariablemapping_vargroup_id" for relation "datavariablemapping" already exists PER01000: Got SQLException executing statement "ALTER TABLE VISUALIZATIONDISPLAY ADD CONSTRAINT FK_VISUALIZATIONDISPLAY_DATATABLE_ID FOREIGN KEY (DATATABLE_ID) REFERENCES DATATABLE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_visualizationdisplay_datatable_id" for relation "visualizationdisplay" already exists PER01000: Got SQLException executing statement "ALTER TABLE TERMSOFUSE ADD CONSTRAINT FK_TERMSOFUSE_VDC_ID FOREIGN KEY (VDC_ID) REFERENCES VDC (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_termsofuse_vdc_id" for relation "termsofuse" already exists PER01000: Got SQLException executing statement "ALTER TABLE VDC ADD CONSTRAINT FK_VDC_ROOTCOLLECTION_ID FOREIGN KEY (ROOTCOLLECTION_ID) REFERENCES VDCCOLLECTION (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdc_rootcollection_id" for relation "vdc" already exists PER01000: Got SQLException executing statement "ALTER TABLE VDC ADD CONSTRAINT FK_VDC_HARVESTINGDATAVERSE_ID FOREIGN KEY (HARVESTINGDATAVERSE_ID) REFERENCES HARVESTINGDATAVERSE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdc_harvestingdataverse_id" for relation "vdc" already exists PER01000: Got SQLException executing statement "ALTER TABLE VDC ADD CONSTRAINT FK_VDC_DEFAULTTEMPLATE_ID FOREIGN KEY (DEFAULTTEMPLATE_ID) REFERENCES TEMPLATE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdc_defaulttemplate_id" for relation "vdc" already exists PER01000: Got SQLException executing statement "ALTER TABLE VDC ADD CONSTRAINT FK_VDC_CREATOR_ID FOREIGN KEY (CREATOR_ID) REFERENCES VDCUSER (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdc_creator_id" for relation "vdc" already exists PER01000: Got SQLException executing statement "ALTER TABLE VDC ADD CONSTRAINT FK_VDC_REVIEWER_ID FOREIGN KEY (REVIEWER_ID) REFERENCES VDCUSER (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdc_reviewer_id" for relation "vdc" already exists PER01000: Got SQLException executing statement "ALTER TABLE WEIGHTEDVARRELATIONSHIP ADD CONSTRAINT FK_WEIGHTEDVARRELATIONSHIP_variable_id FOREIGN KEY (variable_id) REFERENCES DATAVARIABLE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_weightedvarrelationship_variable_id" for relation "weightedvarrelationship" already exists PER01000: Got SQLException executing statement "ALTER TABLE WEIGHTEDVARRELATIONSHIP ADD CONSTRAINT FK_WEIGHTEDVARRELATIONSHIP_weighted_variable_id FOREIGN KEY (weighted_variable_id) REFERENCES DATAVARIABLE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_weightedvarrelationship_weighted_variable_id" for relation "weightedvarrelationship" already exists PER01000: Got SQLException executing statement "ALTER TABLE STUDYFIELD ADD CONSTRAINT FK_STUDYFIELD_PARENTSTUDYFIELD_ID FOREIGN KEY (PARENTSTUDYFIELD_ID) REFERENCES STUDYFIELD (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyfield_parentstudyfield_id" for relation "studyfield" already exists PER01000: Got SQLException executing statement "ALTER TABLE HARVESTINGDATAVERSE ADD CONSTRAINT FK_HARVESTINGDATAVERSE_HANDLEPREFIX_ID FOREIGN KEY (HANDLEPREFIX_ID) REFERENCES HANDLEPREFIX (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_harvestingdataverse_handleprefix_id" for relation "harvestingdataverse" already exists PER01000: Got SQLException executing statement "ALTER TABLE HARVESTINGDATAVERSE ADD CONSTRAINT FK_HARVESTINGDATAVERSE_HARVESTFORMATTYPE_ID FOREIGN KEY (HARVESTFORMATTYPE_ID) REFERENCES HARVESTFORMATTYPE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_harvestingdataverse_harvestformattype_id" for relation "harvestingdataverse" already exists PER01000: Got SQLException executing statement "ALTER TABLE FILEMETADATA ADD CONSTRAINT FK_FILEMETADATA_STUDYFILE_ID FOREIGN KEY (STUDYFILE_ID) REFERENCES STUDYFILE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_filemetadata_studyfile_id" for relation "filemetadata" already exists PER01000: Got SQLException executing statement "ALTER TABLE FILEMETADATA ADD CONSTRAINT FK_FILEMETADATA_STUDYVERSION_ID FOREIGN KEY (STUDYVERSION_ID) REFERENCES STUDYVERSION (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_filemetadata_studyversion_id" for relation "filemetadata" already exists PER01000: Got SQLException executing statement "ALTER TABLE STUDYVERSION ADD CONSTRAINT FK_STUDYVERSION_METADATA_ID FOREIGN KEY (METADATA_ID) REFERENCES METADATA (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyversion_metadata_id" for relation "studyversion" already exists PER01000: Got SQLException executing statement "ALTER TABLE STUDYVERSION ADD CONSTRAINT FK_STUDYVERSION_STUDY_ID FOREIGN KEY (STUDY_ID) REFERENCES STUDY (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyversion_study_id" for relation "studyversion" already exists PER01000: Got SQLException executing statement "ALTER TABLE LOGINDOMAIN ADD CONSTRAINT FK_LOGINDOMAIN_USERGROUP_ID FOREIGN KEY (USERGROUP_ID) REFERENCES USERGROUP (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_logindomain_usergroup_id" for relation "logindomain" already exists PER01000: Got SQLException executing statement "ALTER TABLE DATATABLE ADD CONSTRAINT FK_DATATABLE_STUDYFILE_ID FOREIGN KEY (STUDYFILE_ID) REFERENCES STUDYFILE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_datatable_studyfile_id" for relation "datatable" already exists PER01000: Got SQLException executing statement "ALTER TABLE VDCNETWORK ADD CONSTRAINT FK_VDCNETWORK_DEFAULTTEMPLATE_ID FOREIGN KEY (DEFAULTTEMPLATE_ID) REFERENCES TEMPLATE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdcnetwork_defaulttemplate_id" for relation "vdcnetwork" already exists PER01000: Got SQLException executing statement "ALTER TABLE VDCNETWORK ADD CONSTRAINT FK_VDCNETWORK_DEFAULTNETWORKADMIN_ID FOREIGN KEY (DEFAULTNETWORKADMIN_ID) REFERENCES VDCUSER (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdcnetwork_defaultnetworkadmin_id" for relation "vdcnetwork" already exists PER01000: Got SQLException executing statement "ALTER TABLE NETWORKCONTACTSUBJECT ADD CONSTRAINT FK_NETWORKCONTACTSUBJECT_VDCNETWORK_ID FOREIGN KEY (VDCNETWORK_ID) REFERENCES VDCNETWORK (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_networkcontactsubject_vdcnetwork_id" for relation "networkcontactsubject" already exists PER01000: Got SQLException executing statement "ALTER TABLE VDCUSER ADD CONSTRAINT FK_VDCUSER_NETWORKROLE_ID FOREIGN KEY (NETWORKROLE_ID) REFERENCES NETWORKROLE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdcuser_networkrole_id" for relation "vdcuser" already exists PER01000: Got SQLException executing statement "ALTER TABLE PAGEDEF ADD CONSTRAINT FK_PAGEDEF_NETWORKROLE_ID FOREIGN KEY (NETWORKROLE_ID) REFERENCES NETWORKROLE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_pagedef_networkrole_id" for relation "pagedef" already exists PER01000: Got SQLException executing statement "ALTER TABLE PAGEDEF ADD CONSTRAINT FK_PAGEDEF_ROLE_ID FOREIGN KEY (ROLE_ID) REFERENCES ROLE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_pagedef_role_id" for relation "pagedef" already exists PER01000: Got SQLException executing statement "ALTER TABLE STUDYOTHERID ADD CONSTRAINT FK_STUDYOTHERID_METADATA_ID FOREIGN KEY (METADATA_ID) REFERENCES METADATA (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyotherid_metadata_id" for relation "studyotherid" already exists PER01000: Got SQLException executing statement "ALTER TABLE STUDY_USERGROUP ADD CONSTRAINT FK_STUDY_USERGROUP_allowedGroups_ID FOREIGN KEY (allowedGroups_ID) REFERENCES USERGROUP (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_study_usergroup_allowedgroups_id" for relation "study_usergroup" already exists PER01000: Got SQLException executing statement "ALTER TABLE STUDY_USERGROUP ADD CONSTRAINT FK_STUDY_USERGROUP_studies_ID FOREIGN KEY (studies_ID) REFERENCES STUDY (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_study_usergroup_studies_id" for relation "study_usergroup" already exists PER01000: Got SQLException executing statement "ALTER TABLE STUDY_VDCUSER ADD CONSTRAINT FK_STUDY_VDCUSER_allowedUsers_ID FOREIGN KEY (allowedUsers_ID) REFERENCES VDCUSER (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_study_vdcuser_allowedusers_id" for relation "study_vdcuser" already exists PER01000: Got SQLException executing statement "ALTER TABLE STUDY_VDCUSER ADD CONSTRAINT FK_STUDY_VDCUSER_studies_ID FOREIGN KEY (studies_ID) REFERENCES STUDY (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_study_vdcuser_studies_id" for relation "study_vdcuser" already exists PER01000: Got SQLException executing statement "ALTER TABLE COLL_STUDIES ADD CONSTRAINT FK_COLL_STUDIES_study_id FOREIGN KEY (study_id) REFERENCES STUDY (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_coll_studies_study_id" for relation "coll_studies" already exists PER01000: Got SQLException executing statement "ALTER TABLE COLL_STUDIES ADD CONSTRAINT FK_COLL_STUDIES_vdc_collection_id FOREIGN KEY (vdc_collection_id) REFERENCES VDCCOLLECTION (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_coll_studies_vdc_collection_id" for relation "coll_studies" already exists PER01000: Got SQLException executing statement "ALTER TABLE STUDY_STUDYFIELD ADD CONSTRAINT FK_STUDY_STUDYFIELD_summaryFields_ID FOREIGN KEY (summaryFields_ID) REFERENCES STUDYFIELD (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_study_studyfield_summaryfields_id" for relation "study_studyfield" already exists PER01000: Got SQLException executing statement "ALTER TABLE STUDY_STUDYFIELD ADD CONSTRAINT FK_STUDY_STUDYFIELD_studies_ID FOREIGN KEY (studies_ID) REFERENCES STUDY (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_study_studyfield_studies_id" for relation "study_studyfield" already exists PER01000: Got SQLException executing statement "ALTER TABLE GROUP_GROUPTYPES ADD CONSTRAINT FK_GROUP_GROUPTYPES_group_id FOREIGN KEY (group_id) REFERENCES VARGROUP (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_group_grouptypes_group_id" for relation "group_grouptypes" already exists PER01000: Got SQLException executing statement "ALTER TABLE GROUP_GROUPTYPES ADD CONSTRAINT FK_GROUP_GROUPTYPES_group_type_id FOREIGN KEY (group_type_id) REFERENCES VARGROUPTYPE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_group_grouptypes_group_type_id" for relation "group_grouptypes" already exists PER01000: Got SQLException executing statement "ALTER TABLE COLL_ADV_SEARCH_FIELDS ADD CONSTRAINT FK_COLL_ADV_SEARCH_FIELDS_vdc_collection_id FOREIGN KEY (vdc_collection_id) REFERENCES VDCCOLLECTION (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_coll_adv_search_fields_vdc_collection_id" for relation "coll_adv_search_fields" already exists PER01000: Got SQLException executing statement "ALTER TABLE COLL_ADV_SEARCH_FIELDS ADD CONSTRAINT FK_COLL_ADV_SEARCH_FIELDS_study_field_id FOREIGN KEY (study_field_id) REFERENCES STUDYFIELD (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_coll_adv_search_fields_study_field_id" for relation "coll_adv_search_fields" already exists PER01000: Got SQLException executing statement "ALTER TABLE COLL_ANY_SEARCH_FIELDS ADD CONSTRAINT FK_COLL_ANY_SEARCH_FIELDS_study_field_id FOREIGN KEY (study_field_id) REFERENCES STUDYFIELD (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_coll_any_search_fields_study_field_id" for relation "coll_any_search_fields" already exists PER01000: Got SQLException executing statement "ALTER TABLE COLL_ANY_SEARCH_FIELDS ADD CONSTRAINT FK_COLL_ANY_SEARCH_FIELDS_vdc_collection_id FOREIGN KEY (vdc_collection_id) REFERENCES VDCCOLLECTION (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_coll_any_search_fields_vdc_collection_id" for relation "coll_any_search_fields" already exists PER01000: Got SQLException executing statement "ALTER TABLE VDC_LINKED_COLLECTIONS ADD CONSTRAINT FK_VDC_LINKED_COLLECTIONS_vdc_id FOREIGN KEY (vdc_id) REFERENCES VDC (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdc_linked_collections_vdc_id" for relation "vdc_linked_collections" already exists PER01000: Got SQLException executing statement "ALTER TABLE VDC_LINKED_COLLECTIONS ADD CONSTRAINT FK_VDC_LINKED_COLLECTIONS_linked_collection_id FOREIGN KEY (linked_collection_id) REFERENCES VDCCOLLECTION (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdc_linked_collections_linked_collection_id" for relation "vdc_linked_collections" already exists PER01000: Got SQLException executing statement "ALTER TABLE COLL_SEARCH_RESULT_FIELDS ADD CONSTRAINT FK_COLL_SEARCH_RESULT_FIELDS_vdc_collection_id FOREIGN KEY (vdc_collection_id) REFERENCES VDCCOLLECTION (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_coll_search_result_fields_vdc_collection_id" for relation "coll_search_result_fields" already exists PER01000: Got SQLException executing statement "ALTER TABLE COLL_SEARCH_RESULT_FIELDS ADD CONSTRAINT FK_COLL_SEARCH_RESULT_FIELDS_study_field_id FOREIGN KEY (study_field_id) REFERENCES STUDYFIELD (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_coll_search_result_fields_study_field_id" for relation "coll_search_result_fields" already exists PER01000: Got SQLException executing statement "ALTER TABLE FLAGGED_STUDY_COMMENTS ADD CONSTRAINT FK_FLAGGED_STUDY_COMMENTS_user_id FOREIGN KEY (user_id) REFERENCES VDCUSER (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_flagged_study_comments_user_id" for relation "flagged_study_comments" already exists PER01000: Got SQLException executing statement "ALTER TABLE FLAGGED_STUDY_COMMENTS ADD CONSTRAINT FK_FLAGGED_STUDY_COMMENTS_study_comment_id FOREIGN KEY (study_comment_id) REFERENCES STUDYCOMMENT (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_flagged_study_comments_study_comment_id" for relation "flagged_study_comments" already exists PER01000: Got SQLException executing statement "ALTER TABLE vdc_fileusergroup ADD CONSTRAINT FK_vdc_fileusergroup_allowedfilegroups_id FOREIGN KEY (allowedfilegroups_id) REFERENCES USERGROUP (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdc_fileusergroup_allowedfilegroups_id" for relation "vdc_fileusergroup" already exists PER01000: Got SQLException executing statement "ALTER TABLE vdc_fileusergroup ADD CONSTRAINT FK_vdc_fileusergroup_vdc_id FOREIGN KEY (vdc_id) REFERENCES VDC (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdc_fileusergroup_vdc_id" for relation "vdc_fileusergroup" already exists PER01000: Got SQLException executing statement "ALTER TABLE STUDYFILE_USERGROUP ADD CONSTRAINT FK_STUDYFILE_USERGROUP_allowedGroups_ID FOREIGN KEY (allowedGroups_ID) REFERENCES USERGROUP (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyfile_usergroup_allowedgroups_id" for relation "studyfile_usergroup" already exists PER01000: Got SQLException executing statement "ALTER TABLE STUDYFILE_USERGROUP ADD CONSTRAINT FK_STUDYFILE_USERGROUP_studyFiles_ID FOREIGN KEY (studyFiles_ID) REFERENCES STUDYFILE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyfile_usergroup_studyfiles_id" for relation "studyfile_usergroup" already exists PER01000: Got SQLException executing statement "ALTER TABLE VDCUSER_USERGROUP ADD CONSTRAINT FK_VDCUSER_USERGROUP_userGroups_ID FOREIGN KEY (userGroups_ID) REFERENCES USERGROUP (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdcuser_usergroup_usergroups_id" for relation "vdcuser_usergroup" already exists PER01000: Got SQLException executing statement "ALTER TABLE VDCUSER_USERGROUP ADD CONSTRAINT FK_VDCUSER_USERGROUP_users_ID FOREIGN KEY (users_ID) REFERENCES VDCUSER (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdcuser_usergroup_users_id" for relation "vdcuser_usergroup" already exists PER01000: Got SQLException executing statement "ALTER TABLE VDC_USERGROUP ADD CONSTRAINT FK_VDC_USERGROUP_allowedGroups_ID FOREIGN KEY (allowedGroups_ID) REFERENCES USERGROUP (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdc_usergroup_allowedgroups_id" for relation "vdc_usergroup" already exists PER01000: Got SQLException executing statement "ALTER TABLE VDC_USERGROUP ADD CONSTRAINT FK_VDC_USERGROUP_vdcs_ID FOREIGN KEY (vdcs_ID) REFERENCES VDC (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdc_usergroup_vdcs_id" for relation "vdc_usergroup" already exists PER01000: Got SQLException executing statement "ALTER TABLE VDC_ADV_SEARCH_FIELDS ADD CONSTRAINT FK_VDC_ADV_SEARCH_FIELDS_study_field_id FOREIGN KEY (study_field_id) REFERENCES STUDYFIELD (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdc_adv_search_fields_study_field_id" for relation "vdc_adv_search_fields" already exists PER01000: Got SQLException executing statement "ALTER TABLE VDC_ADV_SEARCH_FIELDS ADD CONSTRAINT FK_VDC_ADV_SEARCH_FIELDS_vdc_id FOREIGN KEY (vdc_id) REFERENCES VDC (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdc_adv_search_fields_vdc_id" for relation "vdc_adv_search_fields" already exists PER01000: Got SQLException executing statement "ALTER TABLE vdc_fileuser ADD CONSTRAINT FK_vdc_fileuser_allowedfileusers_id FOREIGN KEY (allowedfileusers_id) REFERENCES VDCUSER (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdc_fileuser_allowedfileusers_id" for relation "vdc_fileuser" already exists PER01000: Got SQLException executing statement "ALTER TABLE vdc_fileuser ADD CONSTRAINT FK_vdc_fileuser_vdc_id FOREIGN KEY (vdc_id) REFERENCES VDC (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdc_fileuser_vdc_id" for relation "vdc_fileuser" already exists PER01000: Got SQLException executing statement "ALTER TABLE VDC_ANY_SEARCH_FIELDS ADD CONSTRAINT FK_VDC_ANY_SEARCH_FIELDS_study_field_id FOREIGN KEY (study_field_id) REFERENCES STUDYFIELD (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdc_any_search_fields_study_field_id" for relation "vdc_any_search_fields" already exists PER01000: Got SQLException executing statement "ALTER TABLE VDC_ANY_SEARCH_FIELDS ADD CONSTRAINT FK_VDC_ANY_SEARCH_FIELDS_vdc_id FOREIGN KEY (vdc_id) REFERENCES VDC (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdc_any_search_fields_vdc_id" for relation "vdc_any_search_fields" already exists PER01000: Got SQLException executing statement "ALTER TABLE SEARCH_RESULT_FIELDS ADD CONSTRAINT FK_SEARCH_RESULT_FIELDS_study_field_id FOREIGN KEY (study_field_id) REFERENCES STUDYFIELD (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_search_result_fields_study_field_id" for relation "search_result_fields" already exists PER01000: Got SQLException executing statement "ALTER TABLE SEARCH_RESULT_FIELDS ADD CONSTRAINT FK_SEARCH_RESULT_FIELDS_vdc_id FOREIGN KEY (vdc_id) REFERENCES VDC (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_search_result_fields_vdc_id" for relation "search_result_fields" already exists PER01000: Got SQLException executing statement "ALTER TABLE SUMMARY_FIELDS ADD CONSTRAINT FK_SUMMARY_FIELDS_vdc_id FOREIGN KEY (vdc_id) REFERENCES VDC (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_summary_fields_vdc_id" for relation "summary_fields" already exists PER01000: Got SQLException executing statement "ALTER TABLE SUMMARY_FIELDS ADD CONSTRAINT FK_SUMMARY_FIELDS_study_field_id FOREIGN KEY (study_field_id) REFERENCES STUDYFIELD (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_summary_fields_study_field_id" for relation "summary_fields" already exists PER01000: Got SQLException executing statement "ALTER TABLE VDCGROUP_VDCS ADD CONSTRAINT FK_VDCGROUP_VDCS_VDCGROUP_ID FOREIGN KEY (VDCGROUP_ID) REFERENCES VDCGROUP (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdcgroup_vdcs_vdcgroup_id" for relation "vdcgroup_vdcs" already exists PER01000: Got SQLException executing statement "ALTER TABLE VDCGROUP_VDCS ADD CONSTRAINT FK_VDCGROUP_VDCS_VDC_ID FOREIGN KEY (VDC_ID) REFERENCES VDC (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdcgroup_vdcs_vdc_id" for relation "vdcgroup_vdcs" already exists PER01000: Got SQLException executing statement "ALTER TABLE STUDYFILE_VDCUSER ADD CONSTRAINT FK_STUDYFILE_VDCUSER_allowedUsers_ID FOREIGN KEY (allowedUsers_ID) REFERENCES VDCUSER (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyfile_vdcuser_allowedusers_id" for relation "studyfile_vdcuser" already exists PER01000: Got SQLException executing statement "ALTER TABLE STUDYFILE_VDCUSER ADD CONSTRAINT FK_STUDYFILE_VDCUSER_studyFiles_ID FOREIGN KEY (studyFiles_ID) REFERENCES STUDYFILE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyfile_vdcuser_studyfiles_id" for relation "studyfile_vdcuser" already exists PER01000: Got SQLException executing statement "ALTER TABLE VDCUSER_STUDYCOMMENT ADD CONSTRAINT FK_VDCUSER_STUDYCOMMENT_flaggedStudyComments_ID FOREIGN KEY (flaggedStudyComments_ID) REFERENCES STUDYCOMMENT (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdcuser_studycomment_flaggedstudycomments_id" for relation "vdcuser_studycomment" already exists PER01000: Got SQLException executing statement "ALTER TABLE VDCUSER_STUDYCOMMENT ADD CONSTRAINT FK_VDCUSER_STUDYCOMMENT_VDCUser_ID FOREIGN KEY (VDCUser_ID) REFERENCES VDCUSER (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdcuser_studycomment_vdcuser_id" for relation "vdcuser_studycomment" already exists PER01000: Got SQLException executing statement "CREATE TABLE SEQUENCE (SEQ_NAME VARCHAR(50) NOT NULL, SEQ_COUNT DECIMAL(38), PRIMARY KEY (SEQ_NAME))": org.postgresql.util.PSQLException: ERROR: relation "sequence" already exists PER01000: Got SQLException executing statement "INSERT INTO SEQUENCE(SEQ_NAME, SEQ_COUNT) values ('SEQ_GEN', 0)": org.postgresql.util.PSQLException: ERROR: duplicate key value violates unique constraint "sequence_pkey" Command deploy completed with warnings. OK; stopping glasfish. Waiting for the domain to stop ........ Command stop-domain executed successfully. The database needs to be populated with some intial content before we restart the DVN one last time. However, populating a database on a remote PostgresQL server is not supported yet! Please copy the file referenceData.sql (found in this directory) onto the remote server and populate the database manually, as user postgres, with the following command: psql -d postgres -f referenceData.sql then start glassfish again on this server with /home/icrisat/glassfish3/bin/asadmin start-domain domain1 [root@localhost dvninstall]# ./installThe database needs to be populated with some intial content bash: ./installThe: No such file or directory [root@localhost dvninstall]# before we restart the DVN one last time. bash: before: command not found [root@localhost dvninstall]# However, populating a database on a remote PostgresQL server is not supported yet! bash: However,: command not found [root@localhost dvninstall]# Please copy the file referenceData.sql (found in this directory) bash: syntax error near unexpected token `(' [root@localhost dvninstall]# onto the remote server and populate the database manually, bash: onto: command not found [root@localhost dvninstall]# as user postgres, with the following command: The database needs to be populated with some intial content before we restart the DVN one last time. However, populating a database on a remote PostgresQL server is not supported yet! Please copy the file referenceData.sql (found in this directory) onto the remote server and populate the database manually, as user postgres, with the following command: psql -d postgres -f referenceData.sql then start glassfish again on this server with /home/icrisat/glassfish3/bin/asadmin start-domain domain1 The database needs to be populated with some intial content before we restart the DVN one last time. However, populating a database on a remote PostgresQL server is not supported yet! Please copy the file referenceData.sql (found in this directory) onto the remote server and populate the database manually, as user postgres, with the following command: psql -d postgres -f referenceData.sql then start glassfish again on this server with /home/icrisat/glassfish3/bin/asadmin start-domain domain1 Assembler messages: Error: can't open user for reading: No such file or directory user:0: Error: can't open postgres, for reading: No such file or directory postgres,:0: Error: can't open with for reading: No such file or directory with:0: Error: can't open the for reading: No such file or directory the:0: Error: can't open following for reading: No such file or directory following:0: Error: can't open command: for reading: No such file or directory [root@localhost dvninstall]# [root@localhost dvninstall]# psql -d postgres -f referenceData.sql Password: psql: FATAL: password authentication failed for user "root" [root@localhost dvninstall]#