Skip to first unread message
Joerg Messer
Jan 17, 2013, 7:57:59 PM1/17/13
to dataverse...@googlegroups.com
Greetings,
I just saw the tweet announcing v3.3 of Dataverse. Could someone point me at the location of the relevant files? I can't find anything beyond v3.2 on Sourceforge. Thanks.
//Joerg Messer @ UBC
I just saw the tweet announcing v3.3 of Dataverse. Could someone point me at the location of the relevant files? I can't find anything beyond v3.2 on Sourceforge. Thanks.
//Joerg Messer @ UBC
Gustavo Durand
Jan 17, 2013, 8:08:10 PM1/17/13
to dataverse...@googlegroups.com
Hi Joerg,
The tweet went out before the posting on Sourceforge was finalized. It
should be up by tomorrow and I will e-mail you when it is there.
Thanks,
Gustavo
The tweet went out before the posting on Sourceforge was finalized. It
should be up by tomorrow and I will e-mail you when it is there.
Thanks,
Gustavo
Joerg Messer
Jan 17, 2013, 8:08:46 PM1/17/13
to dataverse...@googlegroups.com
Gustavo Durand
Jan 17, 2013, 8:30:32 PM1/17/13
to dataverse...@googlegroups.com
Hi Joerg (and others),
3.3 is now available on Sourceforge!
Please let us know what you think and if there are any issues or
questions you have.
Gustavo
3.3 is now available on Sourceforge!
Please let us know what you think and if there are any issues or
questions you have.
Gustavo
Philip Durbin
Jan 18, 2013, 8:33:23 AM1/18/13
to dataverse...@googlegroups.com
Here's a handy link:
http://sourceforge.net/projects/dvn/files/dvn/3.3/
Enjoy! :)
Phil
On Thu, Jan 17, 2013 at 8:30 PM, Gustavo Durand
--
Philip Durbin
Software Developer for http://thedata.org
http://www.iq.harvard.edu/people/philip-durbin
http://sourceforge.net/projects/dvn/files/dvn/3.3/
Enjoy! :)
Phil
On Thu, Jan 17, 2013 at 8:30 PM, Gustavo Durand
Philip Durbin
Software Developer for http://thedata.org
http://www.iq.harvard.edu/people/philip-durbin
Joerg Messer
Jan 18, 2013, 5:36:19 PM1/18/13
to dataverse...@googlegroups.com
Greetings,
I've just carried out the DVN v3.2 to v3.3 upgrade by undeploying the existing v3.2 war file, modifying the database and then deploying the new v3.3 war file. I ended up with an ostensibly functioning v3.3 system but I did get a few unsettling errors when I deployed the new war (below). Is this anything that I should be concerned about? Just checking.
//Joerg Messer - UBC Library
----
./asadmin deploy /usr/local/src/dataverse/dvn_3.3/DVN-web_v3_3.war
PER01003: Deployment encountered SQL Exceptions:
PER01000: Got SQLException executing statement "CREATE TABLE STUDYFILE (ID SERIAL NOT NULL, fileClass VARCHAR(31), ALLOWACCESSREQUEST BOOLEAN, DISPLAYORDER INTEGER, FILESYSTEMLOCATION TEXT, FILESYSTEMNAME VARCHAR(255), FILETYPE VARCHAR(255), ORIGINALFILETYPE VARCHAR(255), REQUESTACCESS BOOLEAN, RESTRICTED BOOLEAN, UNF VARCHAR(255), VERSION BIGINT, STUDY_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studyfile" already exists
PER01000: Got SQLException executing statement "CREATE TABLE TEMPLATE (ID SERIAL NOT NULL, DESCRIPTION VARCHAR(255), ENABLED BOOLEAN, NAME VARCHAR(255), VERSION BIGINT, VDC_ID BIGINT, METADATA_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "template" already exists
PER01000: Got SQLException executing statement "CREATE TABLE LOCKSSSERVER (ID SERIAL NOT NULL, IPADDRESS VARCHAR(255), VERSION BIGINT, LOCKSSCONFIG_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "lockssserver" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYAUTHOR (ID SERIAL NOT NULL, AFFILIATION VARCHAR(255), DISPLAYORDER INTEGER, IDTYPE VARCHAR(255), IDVALUE VARCHAR(255), NAME VARCHAR(255), VERSION BIGINT, METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studyauthor" already exists
PER01000: Got SQLException executing statement "CREATE TABLE ROLE (ID SERIAL NOT NULL, DESCRIPTION VARCHAR(255), NAME VARCHAR(255), PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "role" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYTOPICCLASS (ID SERIAL NOT NULL, DISPLAYORDER INTEGER, VALUE TEXT, VERSION BIGINT, VOCAB VARCHAR(255), VOCABURI VARCHAR(255), METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studytopicclass" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDCROLE (ID SERIAL NOT NULL, ROLE_ID BIGINT NOT NULL, VDC_ID BIGINT NOT NULL, VDCUSER_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "vdcrole" already exists
PER01000: Got SQLException executing statement "CREATE TABLE OAISET (ID SERIAL NOT NULL, DEFINITION TEXT, DESCRIPTION TEXT, NAME TEXT, SPEC TEXT, VERSION BIGINT, LOCKSSCONFIG_ID BIGINT UNIQUE, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "oaiset" already exists
PER01000: Got SQLException executing statement "CREATE TABLE FIELDINPUTLEVEL (ID SERIAL NOT NULL, NAME VARCHAR(255), PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "fieldinputlevel" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDCACTIVITY (ID SERIAL NOT NULL, FOREIGNSTUDYLOCALDOWNLOADCOUNT INTEGER NOT NULL, LOCALSTUDYFOREIGNDOWNLOADCOUNT INTEGER NOT NULL, LOCALSTUDYLOCALDOWNLOADCOUNT INTEGER NOT NULL, LOCALSTUDYNETWORKDOWNLOADCOUNT INTEGER NOT NULL, VDC_ID BIGINT UNIQUE, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "vdcactivity" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDY (ID SERIAL NOT NULL, AUTHORITY TEXT, CREATETIME TIMESTAMP, HARVESTIDENTIFIER VARCHAR(255), ISHARVESTED BOOLEAN, LASTEXPORTTIME TIMESTAMP, LASTINDEXTIME TIMESTAMP, LASTUPDATETIME TIMESTAMP, NUMBEROFDOWNLOADS BIGINT, PROTOCOL TEXT, REQUESTACCESS BOOLEAN, RESTRICTED BOOLEAN, STUDYID VARCHAR(255), VERSION BIGINT, CREATOR_ID BIGINT NOT NULL, LASTUPDATER_ID BIGINT, OWNER_ID BIGINT NOT NULL, REVIEWER_ID BIGINT, TEMPLATE_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "study" already exists
PER01000: Got SQLException executing statement "CREATE TABLE CONTROLLEDVOCABULARY (ID SERIAL NOT NULL, DESCRIPTION TEXT, FIELDTYPE VARCHAR(255), NAME VARCHAR(255), PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "controlledvocabulary" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYSOFTWARE (ID SERIAL NOT NULL, DISPLAYORDER INTEGER, NAME VARCHAR(255), SOFTWAREVERSION VARCHAR(255), VERSION BIGINT, METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studysoftware" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYOTHERREF (ID SERIAL NOT NULL, DISPLAYORDER INTEGER, TEXT TEXT, VERSION BIGINT, METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studyotherref" already exists
PER01000: Got SQLException executing statement "CREATE TABLE CUSTOMQUESTIONVALUE (ID SERIAL NOT NULL, VALUESTRING VARCHAR(255), CUSTOMQUESTION_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "customquestionvalue" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VARGROUPTYPE (ID SERIAL NOT NULL, NAME VARCHAR(255), VARGROUPING_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "vargrouptype" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYRELMATERIAL (ID SERIAL NOT NULL, DISPLAYORDER INTEGER, TEXT TEXT, VERSION BIGINT, METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studyrelmaterial" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYACCESSREQUEST (ID SERIAL NOT NULL, STUDY_ID BIGINT NOT NULL, VDCUSER_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studyaccessrequest" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYKEYWORD (ID SERIAL NOT NULL, DISPLAYORDER INTEGER, VALUE TEXT, VERSION BIGINT, VOCAB VARCHAR(255), VOCABURI VARCHAR(255), METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studykeyword" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VARGROUP (ID SERIAL NOT NULL, NAME VARCHAR(255), UNITS VARCHAR(255), VARGROUPING_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "vargroup" already exists
PER01000: Got SQLException executing statement "CREATE TABLE CAPTCHA (ID BIGINT NOT NULL, DOMAINNAME VARCHAR(255), PRIVATEKEY VARCHAR(255), PUBLICKEY VARCHAR(255), PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "captcha" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYFIELDVALUE (ID SERIAL NOT NULL, DISPLAYORDER INTEGER, STRVALUE TEXT, METADATA_ID BIGINT NOT NULL, STUDYFIELD_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studyfieldvalue" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYREQUEST (ID SERIAL NOT NULL, STUDY_ID BIGINT NOT NULL, VDCUSER_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studyrequest" already exists
PER01000: Got SQLException executing statement "CREATE TABLE HANDLEPREFIX (ID SERIAL NOT NULL, PREFIX VARCHAR(255), PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "handleprefix" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYDOWNLOAD (ID SERIAL NOT NULL, NUMBEROFDOWNLOADS INTEGER, STUDY_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studydownload" already exists
PER01000: Got SQLException executing statement "CREATE TABLE TWITTERCREDENTIALS (ID SERIAL NOT NULL, ACCESSTOKEN VARCHAR(255), ACCESSTOKENSECRET VARCHAR(255), VDC_ID BIGINT UNIQUE, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "twittercredentials" already exists
PER01000: Got SQLException executing statement "CREATE TABLE ROLEREQUEST (ID SERIAL NOT NULL, ROLE_ID BIGINT NOT NULL, VDC_ID BIGINT NOT NULL, VDCUSER_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "rolerequest" already exists
PER01000: Got SQLException executing statement "CREATE TABLE GUESTBOOKRESPONSE (ID SERIAL NOT NULL, DOWNLOADTYPE VARCHAR(255), EMAIL VARCHAR(255), FIRSTNAME VARCHAR(255), INSTITUTION VARCHAR(255), LASTNAME VARCHAR(255), POSITION VARCHAR(255), RESPONSETIME TIMESTAMP, SESSIONID VARCHAR(255), GUESTBOOKQUESTIONNAIRE_ID BIGINT NOT NULL, STUDY_ID BIGINT NOT NULL, STUDYFILE_ID BIGINT NOT NULL, STUDYVERSION_ID BIGINT, VDCUSER_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "guestbookresponse" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYLOCK (ID SERIAL NOT NULL, DETAIL VARCHAR(255), STARTTIME TIMESTAMP, USER_ID BIGINT NOT NULL, STUDY_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studylock" already exists
PER01000: Got SQLException executing statement "CREATE TABLE LOCKSSCONFIG (ID SERIAL NOT NULL, ALLOWRESTRICTED BOOLEAN, LICENSETEXT TEXT, SERVERACCESS VARCHAR(255), LICENSETYPE_ID BIGINT, VDC_ID BIGINT UNIQUE, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "lockssconfig" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDCGROUPRELATIONSHIP (group_id BIGINT NOT NULL, subgroup_id BIGINT NOT NULL, PRIMARY KEY (group_id, subgroup_id))": org.postgresql.util.PSQLException: ERROR: relation "vdcgrouprelationship" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VARIABLECATEGORY (ID SERIAL NOT NULL, FREQUENCY FLOAT, LABEL VARCHAR(255), MISSING BOOLEAN, VALUE TEXT, DATAVARIABLE_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "variablecategory" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDCCOLLECTION (ID SERIAL NOT NULL, DESCRIPTION TEXT, DISPLAYORDER INTEGER, LOCALSCOPE BOOLEAN, NAME VARCHAR(255), QUERY TEXT, TYPE VARCHAR(255), VERSION BIGINT, OWNER_ID BIGINT, PARENTCOLLECTION_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "vdccollection" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYCOMMENT (ID SERIAL NOT NULL, COMMENT TEXT, CREATETIME TIMESTAMP, STATUS INTEGER, COMMENTCREATOR_ID BIGINT NOT NULL, STUDYVERSION_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studycomment" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VARIABLERANGEITEM (ID SERIAL NOT NULL, VALUE DECIMAL(38), DATAVARIABLE_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "variablerangeitem" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VARGROUPING (ID SERIAL NOT NULL, GROUPINGTYPE VARCHAR(255), NAME VARCHAR(255), DATATABLE_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "vargrouping" already exists
PER01000: Got SQLException executing statement "CREATE TABLE TEMPLATEFILECATEGORY (ID SERIAL NOT NULL, DISPLAYORDER INTEGER, NAME VARCHAR(255), TEMPLATE_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "templatefilecategory" already exists
PER01000: Got SQLException executing statement "CREATE TABLE CONTACTSUBJECT (ID SERIAL NOT NULL, SUBJECTTEXT VARCHAR(255), VDC_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "contactsubject" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYFILEACTIVITY (ID SERIAL NOT NULL, DOWNLOADCOUNT INTEGER, LASTDOWNLOADTIME TIMESTAMP, STUDY_ID BIGINT NOT NULL, STUDYFILE_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studyfileactivity" already exists
PER01000: Got SQLException executing statement "CREATE TABLE TEMPLATEFIELD (ID SERIAL NOT NULL, DEFAULTVALUE VARCHAR(255), DISPLAYORDER INTEGER, FIELDINPUTLEVELSTRING VARCHAR(255), VERSION BIGINT, CONTROLLEDVOCABULARY_ID BIGINT, STUDYFIELD_ID BIGINT NOT NULL, TEMPLATE_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "templatefield" already exists
PER01000: Got SQLException executing statement "CREATE TABLE NETWORKROLEREQUEST (ID SERIAL NOT NULL, NETWORKROLE_ID BIGINT NOT NULL, VDCUSER_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "networkrolerequest" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDCNETWORKSTATS (ID SERIAL NOT NULL, FILECOUNT BIGINT, STUDYCOUNT BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "vdcnetworkstats" already exists
PER01000: Got SQLException executing statement "CREATE TABLE NETWORKROLE (ID SERIAL NOT NULL, DESCRIPTION VARCHAR(255), NAME VARCHAR(255), PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "networkrole" already exists
PER01000: Got SQLException executing statement "CREATE TABLE SUMMARYSTATISTIC (ID SERIAL NOT NULL, VALUE VARCHAR(255), DATAVARIABLE_ID BIGINT NOT NULL, TYPE_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "summarystatistic" already exists
PER01000: Got SQLException executing statement "CREATE TABLE DATAFILEFORMATTYPE (ID BIGINT NOT NULL, MIMETYPE VARCHAR(255), NAME VARCHAR(255), VALUE VARCHAR(255), PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "datafileformattype" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYABSTRACT (ID SERIAL NOT NULL, DATE VARCHAR(255), DISPLAYORDER INTEGER, TEXT TEXT, VERSION BIGINT, METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studyabstract" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYRELSTUDY (ID SERIAL NOT NULL, DISPLAYORDER INTEGER, TEXT TEXT, VERSION BIGINT, METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studyrelstudy" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYGEOBOUNDING (ID SERIAL NOT NULL, DISPLAYORDER INTEGER, EASTLONGITUDE VARCHAR(255), NORTHLATITUDE VARCHAR(255), SOUTHLATITUDE VARCHAR(255), VERSION BIGINT, WESTLONGITUDE VARCHAR(255), METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studygeobounding" already exists
PER01000: Got SQLException executing statement "CREATE TABLE HARVESTSTUDY (ID SERIAL NOT NULL, GLOBALID VARCHAR(255), LASTUPDATETIME TIMESTAMP, REMOVED BOOLEAN, SETNAME VARCHAR(255), PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "harveststudy" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYPRODUCER (ID SERIAL NOT NULL, ABBREVIATION VARCHAR(255), AFFILIATION VARCHAR(255), DISPLAYORDER INTEGER, LOGO VARCHAR(255), NAME VARCHAR(255), URL VARCHAR(255), VERSION BIGINT, METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studyproducer" already exists
PER01000: Got SQLException executing statement "CREATE TABLE LICENSETYPE (ID SERIAL NOT NULL, IMAGEURL VARCHAR(255), LICENSEURL VARCHAR(255), NAME VARCHAR(255), RDFURL VARCHAR(255), SHORTNAME VARCHAR(255), PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "licensetype" already exists
PER01000: Got SQLException executing statement "CREATE TABLE LOGINAFFILIATE (ID SERIAL NOT NULL, NAME VARCHAR(255), URL VARCHAR(255), VERSION BIGINT, USERGROUP_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "loginaffiliate" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VARIABLERANGE (ID SERIAL NOT NULL, BEGINVALUE VARCHAR(255), ENDVALUE VARCHAR(255), BEGINVALUETYPE_ID BIGINT, DATAVARIABLE_ID BIGINT NOT NULL, ENDVALUETYPE_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "variablerange" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYGRANT (ID SERIAL NOT NULL, AGENCY VARCHAR(255), DISPLAYORDER INTEGER, NUMBER TEXT, VERSION BIGINT, METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studygrant" already exists
PER01000: Got SQLException executing statement "CREATE TABLE USERGROUP (ID SERIAL NOT NULL, DESCRIPTION VARCHAR(255), FRIENDLYNAME VARCHAR(255), NAME VARCHAR(255), PINSERVICE VARCHAR(255), VERSION BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "usergroup" already exists
PER01000: Got SQLException executing statement "CREATE TABLE DATAVARIABLE (ID SERIAL NOT NULL, CONCEPT VARCHAR(255), FILEENDPOSITION BIGINT, FILEORDER INTEGER, FILESTARTPOSITION BIGINT, FORMATCATEGORY VARCHAR(255), FORMATSCHEMA VARCHAR(255), FORMATSCHEMANAME VARCHAR(255), LABEL TEXT, NAME VARCHAR(255), NUMBEROFDECIMALPOINTS BIGINT, QUESTIONTEXT TEXT, RECORDSEGMENTNUMBER BIGINT, UNF VARCHAR(255), UNIVERSE VARCHAR(255), VERSION BIGINT, WEIGHTED BOOLEAN, DATATABLE_ID BIGINT NOT NULL, VARIABLEFORMATTYPE_ID BIGINT NOT NULL, VARIABLEINTERVALTYPE_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "datavariable" already exists
PER01000: Got SQLException executing statement "CREATE TABLE CONTROLLEDVOCABULARYVALUE (ID SERIAL NOT NULL, VALUE TEXT, CONTROLLEDVOCABULARY_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "controlledvocabularyvalue" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYRELPUBLICATION (ID SERIAL NOT NULL, DISPLAYORDER INTEGER, IDNUMBER VARCHAR(255), IDTYPE VARCHAR(255), REPLICATIONDATA BOOLEAN, TEXT TEXT, URL VARCHAR(255), VERSION BIGINT, METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studyrelpublication" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYDISTRIBUTOR (ID SERIAL NOT NULL, ABBREVIATION VARCHAR(255), AFFILIATION VARCHAR(255), DISPLAYORDER INTEGER, LOGO VARCHAR(255), NAME VARCHAR(255), URL VARCHAR(255), VERSION BIGINT, METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studydistributor" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYNOTE (ID SERIAL NOT NULL, DISPLAYORDER INTEGER, SUBJECT VARCHAR(255), TEXT TEXT, TYPE VARCHAR(255), VERSION BIGINT, METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studynote" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VERSIONCONTRIBUTOR (ID SERIAL NOT NULL, LASTUPDATETIME TIMESTAMP, VERSION BIGINT, CONTRIBUTOR_ID BIGINT NOT NULL, STUDYVERSION_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "versioncontributor" already exists
PER01000: Got SQLException executing statement "CREATE TABLE DATAVARIABLEMAPPING (ID SERIAL NOT NULL, LABEL VARCHAR(255), X_AXIS BOOLEAN, DATATABLE_ID BIGINT NOT NULL, DATAVARIABLE_ID BIGINT NOT NULL, VARGROUP_ID BIGINT, VARGROUPING_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "datavariablemapping" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VISUALIZATIONDISPLAY (ID SERIAL NOT NULL, DEFAULTDISPLAY INTEGER, MEASURETYPELABEL VARCHAR(255), SHOWDATATABLE BOOLEAN, SHOWFLASHGRAPH BOOLEAN, SHOWIMAGEGRAPH BOOLEAN, SOURCEINFOLABEL VARCHAR(255), DATATABLE_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "visualizationdisplay" already exists
PER01000: Got SQLException executing statement "CREATE TABLE TERMSOFUSE (ID SERIAL NOT NULL, CREATETIME TIMESTAMP, ENABLED BOOLEAN, TERMS TEXT, VDC_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "termsofuse" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDC (ID SERIAL NOT NULL, aboutThisDataverse TEXT, AFFILIATION VARCHAR(255), ALIAS VARCHAR(255), ALLOWCONTRIBUTORREQUESTS BOOLEAN, ALLOWCONTRIBUTORSEDITALL BOOLEAN, ALLOWREGISTEREDUSERSTOCONTRIBUTE BOOLEAN, ALLOWSTUDYCOMMENTS BOOLEAN, announcements TEXT, CONTACTEMAIL VARCHAR(255), COPYRIGHT VARCHAR(255), CREATEDDATE TIMESTAMP, DEFAULTSORTORDER VARCHAR(255), termsOfUse TEXT, depositTermsOfUseEnabled BOOLEAN, DESCRIPTION VARCHAR(255), DISPLAYANNOUNCEMENTS BOOLEAN, DISPLAYINFRAME BOOLEAN, DISPLAYNETWORKANNOUNCEMENTS BOOLEAN, DISPLAYNEWSTUDIES BOOLEAN, downloadTermsOfUse TEXT, downloadTermsOfUseEnabled BOOLEAN, DTYPE VARCHAR(255), DVNDESCRIPTION VARCHAR(255), FILESRESTRICTED BOOLEAN, FIRSTNAME VARCHAR(255), footer TEXT, header TEXT, LASTNAME VARCHAR(255), LOGO VARCHAR(255), NAME VARCHAR(255), PARENTSITE VARCHAR(255), RELEASEDATE TIMESTAMP, RESTRICTED BOOLEAN, termsOfUseEnabled BOOLEAN, VERSION BIGINT, VISIBILITY VARCHAR(255), CREATOR_ID BIGINT, DEFAULTTEMPLATE_ID BIGINT, REVIEWER_ID BIGINT, HARVESTINGDATAVERSE_ID BIGINT, ROOTCOLLECTION_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "vdc" already exists
PER01000: Got SQLException executing statement "CREATE TABLE CUSTOMQUESTIONRESPONSE (ID SERIAL NOT NULL, RESPONSE VARCHAR(255), CUSTOMQUESTION_ID BIGINT NOT NULL, GUESTBOOKRESPONSE_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "customquestionresponse" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VARIABLERANGETYPE (ID BIGINT NOT NULL, NAME VARCHAR(255), PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "variablerangetype" already exists
PER01000: Got SQLException executing statement "CREATE TABLE WEIGHTEDVARRELATIONSHIP (variable_id BIGINT NOT NULL, weighted_variable_id BIGINT NOT NULL, PRIMARY KEY (variable_id, weighted_variable_id))": org.postgresql.util.PSQLException: ERROR: relation "weightedvarrelationship" already exists
PER01000: Got SQLException executing statement "CREATE TABLE METADATAFORMATTYPE (ID BIGINT NOT NULL, FORMATSCHEMA VARCHAR(255), MIMETYPE VARCHAR(255), NAME VARCHAR(255), NAMESPACE VARCHAR(255), PARTIALEXCLUDESUPPORTED BOOLEAN, PARTIALSELECTSUPPORTED BOOLEAN, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "metadataformattype" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VARIABLEINTERVALTYPE (ID BIGINT NOT NULL, NAME VARCHAR(255), PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "variableintervaltype" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYFIELD (ID SERIAL NOT NULL, ADVANCEDSEARCHFIELD BOOLEAN, ALLOWCONTROLLEDVOCABULARY BOOLEAN, ALLOWMULTIPLES BOOLEAN, BASICSEARCHFIELD BOOLEAN, CUSTOMFIELD BOOLEAN, description TEXT, DISPLAYORDER INTEGER, FIELDTYPE VARCHAR(255), name TEXT, SEARCHRESULTFIELD BOOLEAN, title TEXT, PARENTSTUDYFIELD_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studyfield" already exists
PER01000: Got SQLException executing statement "CREATE TABLE HARVESTINGDATAVERSE (ID SERIAL NOT NULL, FAILEDSTUDYCOUNT BIGINT, FAILEDSTUDYCOUNTNONZERO BIGINT, GENERATERANDOMIDS BOOLEAN, HARVESTRESULT VARCHAR(255), HARVESTTYPE VARCHAR(255), HARVESTEDSTUDYCOUNT BIGINT, HARVESTEDSTUDYCOUNTNONZERO BIGINT, HARVESTINGNOW BOOLEAN, HARVESTINGSET VARCHAR(255), LASTHARVESTTIME TIMESTAMP, LASTSUCCESSFULHARVESTTIME TIMESTAMP, LASTSUCCESSFULNONZEROHARVESTTIME TIMESTAMP, SCHEDULEDAYOFWEEK INTEGER, SCHEDULEHOUROFDAY INTEGER, SCHEDULEPERIOD VARCHAR(255), SCHEDULED BOOLEAN, SERVERURL VARCHAR(255), SUBSETRESTRICTED BOOLEAN, VERSION BIGINT, HANDLEPREFIX_ID BIGINT, HARVESTFORMATTYPE_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "harvestingdataverse" already exists
PER01000: Got SQLException executing statement "CREATE TABLE FILEMETADATA (ID SERIAL NOT NULL, CATEGORY TEXT, DESCRIPTION TEXT, LABEL VARCHAR(255), VERSION BIGINT, STUDYFILE_ID BIGINT NOT NULL, STUDYVERSION_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "filemetadata" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYVERSION (ID SERIAL NOT NULL, ARCHIVENOTE VARCHAR(1000), ARCHIVETIME TIMESTAMP, CREATETIME TIMESTAMP, DEACCESSIONLINK VARCHAR(255), LASTUPDATETIME TIMESTAMP, RELEASETIME TIMESTAMP, VERSION BIGINT, VERSIONNOTE VARCHAR(1000), VERSIONNUMBER BIGINT, VERSIONSTATE VARCHAR(255), STUDY_ID BIGINT NOT NULL, METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studyversion" already exists
PER01000: Got SQLException executing statement "CREATE TABLE LOGINDOMAIN (ID SERIAL NOT NULL, IPADDRESS VARCHAR(255), VERSION BIGINT, USERGROUP_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "logindomain" already exists
PER01000: Got SQLException executing statement "CREATE TABLE REMOTEACCESSAUTH (ID SERIAL NOT NULL, AUTHCRED1 VARCHAR(255), AUTHCRED2 VARCHAR(255), AUTHCRED3 VARCHAR(255), AUTHCRED4 VARCHAR(255), AUTHTYPE VARCHAR(255), HOSTNAME VARCHAR(255), PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "remoteaccessauth" already exists
PER01000: Got SQLException executing statement "CREATE TABLE DATATABLE (ID SERIAL NOT NULL, CASEQUANTITY BIGINT, RECORDSPERCASE BIGINT, TYPE VARCHAR(255), UNF VARCHAR(255), VARQUANTITY BIGINT, VERSION BIGINT, VISUALIZATIONENABLED BOOLEAN, STUDYFILE_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "datatable" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDCNETWORK (ID SERIAL NOT NULL, aboutThisDataverseNetwork TEXT, ALLOWCREATEREQUEST BOOLEAN, announcements TEXT, AUTHORITY VARCHAR(255), CONTACTEMAIL VARCHAR(255), DEFAULTDVSORTCOLUMN VARCHAR(255), DEFAULTDISPLAYNUMBER BIGINT, defaultVDCAboutText TEXT, defaultVDCAnnouncements TEXT, defaultVDCFooter TEXT, defaultVDCHeader TEXT, depositTermsOfUse TEXT, DEPOSITTERMSOFUSEENABLED BOOLEAN, DISPLAYANNOUNCEMENTS BOOLEAN, DISPLAYVDCANNOUNCEMENTS BOOLEAN, DISPLAYVDCRECENTSTUDIES BOOLEAN, downloadTermsOfUse TEXT, DOWNLOADTERMSOFUSEENABLED BOOLEAN, EXPORTDAYOFWEEK INTEGER, EXPORTHOUROFDAY INTEGER, EXPORTPERIOD VARCHAR(255), HANDLEREGISTRATION BOOLEAN, NAME VARCHAR(255), networkPageFooter TEXT, networkPageHeader TEXT, PROTOCOL VARCHAR(255), REQUIREDVAFFILIATION BOOLEAN, REQUIREDVCLASSIFICATION BOOLEAN, REQUIREDVDESCRIPTION BOOLEAN, REQUIREDVSTUDIESFORRELEASE BOOLEAN, RESTRICTIONTEXT VARCHAR(255), statusnotice TEXT, termsOfUse TEXT, TERMSOFUSEENABLED BOOLEAN, TERMSOFUSEUPDATED TIMESTAMP, VERSION BIGINT, DEFAULTNETWORKADMIN_ID BIGINT, DEFAULTTEMPLATE_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "vdcnetwork" already exists
PER01000: Got SQLException executing statement "CREATE TABLE HARVESTFORMATTYPE (ID BIGINT NOT NULL, METADATAPREFIX VARCHAR(255), NAME VARCHAR(255), STYLESHEETFILENAME VARCHAR(255), PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "harvestformattype" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VARIABLEFORMATTYPE (ID BIGINT NOT NULL, NAME VARCHAR(255), PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "variableformattype" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDCGROUP (ID SERIAL NOT NULL, DEFAULTDISPLAYNUMBER BIGINT, DESCRIPTION VARCHAR(255), DISPLAYORDER INTEGER, NAME VARCHAR(255), PARENT BIGINT, VERSION BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "vdcgroup" already exists
PER01000: Got SQLException executing statement "CREATE TABLE NETWORKCONTACTSUBJECT (ID SERIAL NOT NULL, SUBJECTTEXT VARCHAR(255), VDCNETWORK_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "networkcontactsubject" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDCUSER (ID SERIAL NOT NULL, ACTIVE BOOLEAN, AGREEDTERMSOFUSE BOOLEAN, BYPASSTERMSOFUSE BOOLEAN, EMAIL VARCHAR(255), ENCRYPTEDPASSWORD text, FIRSTNAME VARCHAR(255), INSTITUTION VARCHAR(255), LASTNAME VARCHAR(255), PHONENUMBER VARCHAR(255), POSITION VARCHAR(255), TEST INTEGER, USERNAME VARCHAR(255), VERSION BIGINT, NETWORKROLE_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "vdcuser" already exists
PER01000: Got SQLException executing statement "CREATE TABLE METADATA (ID SERIAL NOT NULL, UNF TEXT, ACCESSTOSOURCES TEXT, ACTIONSTOMINIMIZELOSS TEXT, AVAILABILITYSTATUS TEXT, CHARACTERISTICOFSOURCES TEXT, CITATIONREQUIREMENTS TEXT, CLEANINGOPERATIONS TEXT, COLLECTIONMODE TEXT, COLLECTIONSIZE TEXT, CONDITIONS TEXT, CONFIDENTIALITYDECLARATION TEXT, CONTACT TEXT, CONTROLOPERATIONS TEXT, COUNTRY TEXT, DATACOLLECTIONSITUATION TEXT, DATACOLLECTOR TEXT, DATASOURCES TEXT, DATEOFCOLLECTIONEND TEXT, DATEOFCOLLECTIONSTART TEXT, DATEOFDEPOSIT TEXT, DEPOSITOR TEXT, DEPOSITORREQUIREMENTS TEXT, DEVIATIONSFROMSAMPLEDESIGN TEXT, DISCLAIMER TEXT, DISTRIBUTIONDATE TEXT, DISTRIBUTORCONTACT TEXT, DISTRIBUTORCONTACTAFFILIATION TEXT, DISTRIBUTORCONTACTEMAIL TEXT, FREQUENCYOFDATACOLLECTION TEXT, FUNDINGAGENCY TEXT, GEOGRAPHICCOVERAGE TEXT, GEOGRAPHICUNIT TEXT, HARVESTDVNTERMSOFUSE TEXT, HARVESTDVTERMSOFUSE TEXT, HARVESTHOLDINGS VARCHAR(255), KINDOFDATA TEXT, ORIGINOFSOURCES TEXT, ORIGINALARCHIVE TEXT, OTHERDATAAPPRAISAL TEXT, PLACEOFACCESS TEXT, PRODUCTIONDATE TEXT, PRODUCTIONPLACE TEXT, RESEARCHINSTRUMENT TEXT, RESPONSERATE TEXT, RESTRICTIONS TEXT, SAMPLINGERRORESTIMATE TEXT, SAMPLINGPROCEDURE TEXT, SERIESINFORMATION TEXT, SERIESNAME TEXT, SPECIALPERMISSIONS TEXT, STUDYCOMPLETION TEXT, STUDYLEVELERRORNOTES TEXT, studyVersion TEXT, SUBTITLE TEXT, TIMEMETHOD TEXT, TIMEPERIODCOVEREDEND TEXT, TIMEPERIODCOVEREDSTART TEXT, TITLE TEXT, UNITOFANALYSIS TEXT, UNIVERSE TEXT, VERSION BIGINT, VERSIONDATE TEXT, WEIGHTING TEXT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "metadata" already exists
PER01000: Got SQLException executing statement "CREATE TABLE PAGEDEF (ID SERIAL NOT NULL, NAME VARCHAR(255), PATH VARCHAR(255), VERSION BIGINT, NETWORKROLE_ID BIGINT, ROLE_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "pagedef" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYOTHERID (ID SERIAL NOT NULL, AGENCY VARCHAR(255), DISPLAYORDER INTEGER, OTHERID TEXT, VERSION BIGINT, METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studyotherid" already exists
PER01000: Got SQLException executing statement "CREATE TABLE CUSTOMQUESTION (ID SERIAL NOT NULL, HIDDEN BOOLEAN, QUESTIONSTRING VARCHAR(255), QUESTIONTYPE VARCHAR(255), REQUIRED BOOLEAN, GUESTBOOKQUESTIONNAIRE_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "customquestion" already exists
PER01000: Got SQLException executing statement "CREATE TABLE SUMMARYSTATISTICTYPE (ID BIGINT NOT NULL, NAME VARCHAR(255), PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "summarystatistictype" already exists
PER01000: Got SQLException executing statement "CREATE TABLE GUESTBOOKQUESTIONNAIRE (ID SERIAL NOT NULL, EMAILREQUIRED BOOLEAN, ENABLED BOOLEAN, FIRSTNAMEREQUIRED BOOLEAN, INSTITUTIONREQUIRED BOOLEAN, LASTNAMEREQUIRED BOOLEAN, POSITIONREQUIRED BOOLEAN, VDC_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "guestbookquestionnaire" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDY_USERGROUP (studies_ID BIGINT NOT NULL, allowedGroups_ID BIGINT NOT NULL, PRIMARY KEY (studies_ID, allowedGroups_ID))": org.postgresql.util.PSQLException: ERROR: relation "study_usergroup" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDY_VDCUSER (studies_ID BIGINT NOT NULL, allowedUsers_ID BIGINT NOT NULL, PRIMARY KEY (studies_ID, allowedUsers_ID))": org.postgresql.util.PSQLException: ERROR: relation "study_vdcuser" already exists
PER01000: Got SQLException executing statement "CREATE TABLE COLL_STUDIES (study_id BIGINT NOT NULL, vdc_collection_id BIGINT NOT NULL, PRIMARY KEY (study_id, vdc_collection_id))": org.postgresql.util.PSQLException: ERROR: relation "coll_studies" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDY_STUDYFIELD (studies_ID BIGINT NOT NULL, summaryFields_ID BIGINT NOT NULL, PRIMARY KEY (studies_ID, summaryFields_ID))": org.postgresql.util.PSQLException: ERROR: relation "study_studyfield" already exists
PER01000: Got SQLException executing statement "CREATE TABLE GROUP_GROUPTYPES (group_type_id BIGINT NOT NULL, group_id BIGINT NOT NULL, PRIMARY KEY (group_type_id, group_id))": org.postgresql.util.PSQLException: ERROR: relation "group_grouptypes" already exists
PER01000: Got SQLException executing statement "CREATE TABLE COLL_ADV_SEARCH_FIELDS (vdc_collection_id BIGINT NOT NULL, study_field_id BIGINT NOT NULL, PRIMARY KEY (vdc_collection_id, study_field_id))": org.postgresql.util.PSQLException: ERROR: relation "coll_adv_search_fields" already exists
PER01000: Got SQLException executing statement "CREATE TABLE COLL_ANY_SEARCH_FIELDS (vdc_collection_id BIGINT NOT NULL, study_field_id BIGINT NOT NULL, PRIMARY KEY (vdc_collection_id, study_field_id))": org.postgresql.util.PSQLException: ERROR: relation "coll_any_search_fields" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDC_LINKED_COLLECTIONS (linked_collection_id BIGINT NOT NULL, vdc_id BIGINT NOT NULL, PRIMARY KEY (linked_collection_id, vdc_id))": org.postgresql.util.PSQLException: ERROR: relation "vdc_linked_collections" already exists
PER01000: Got SQLException executing statement "CREATE TABLE COLL_SEARCH_RESULT_FIELDS (vdc_collection_id BIGINT NOT NULL, study_field_id BIGINT NOT NULL, PRIMARY KEY (vdc_collection_id, study_field_id))": org.postgresql.util.PSQLException: ERROR: relation "coll_search_result_fields" already exists
PER01000: Got SQLException executing statement "CREATE TABLE FLAGGED_STUDY_COMMENTS (study_comment_id BIGINT NOT NULL, user_id BIGINT NOT NULL, PRIMARY KEY (study_comment_id, user_id))": org.postgresql.util.PSQLException: ERROR: relation "flagged_study_comments" already exists
PER01000: Got SQLException executing statement "CREATE TABLE vdc_fileusergroup (allowedfilegroups_id BIGINT NOT NULL, vdc_id BIGINT NOT NULL, PRIMARY KEY (allowedfilegroups_id, vdc_id))": org.postgresql.util.PSQLException: ERROR: relation "vdc_fileusergroup" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYFILE_USERGROUP (allowedGroups_ID BIGINT NOT NULL, studyFiles_ID BIGINT NOT NULL, PRIMARY KEY (allowedGroups_ID, studyFiles_ID))": org.postgresql.util.PSQLException: ERROR: relation "studyfile_usergroup" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDCUSER_USERGROUP (userGroups_ID BIGINT NOT NULL, users_ID BIGINT NOT NULL, PRIMARY KEY (userGroups_ID, users_ID))": org.postgresql.util.PSQLException: ERROR: relation "vdcuser_usergroup" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDC_USERGROUP (allowedGroups_ID BIGINT NOT NULL, vdcs_ID BIGINT NOT NULL, PRIMARY KEY (allowedGroups_ID, vdcs_ID))": org.postgresql.util.PSQLException: ERROR: relation "vdc_usergroup" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDC_ADV_SEARCH_FIELDS (vdc_id BIGINT NOT NULL, study_field_id BIGINT NOT NULL, PRIMARY KEY (vdc_id, study_field_id))": org.postgresql.util.PSQLException: ERROR: relation "vdc_adv_search_fields" already exists
PER01000: Got SQLException executing statement "CREATE TABLE vdc_fileuser (vdc_id BIGINT NOT NULL, allowedfileusers_id BIGINT NOT NULL, PRIMARY KEY (vdc_id, allowedfileusers_id))": org.postgresql.util.PSQLException: ERROR: relation "vdc_fileuser" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDC_ANY_SEARCH_FIELDS (vdc_id BIGINT NOT NULL, study_field_id BIGINT NOT NULL, PRIMARY KEY (vdc_id, study_field_id))": org.postgresql.util.PSQLException: ERROR: relation "vdc_any_search_fields" already exists
PER01000: Got SQLException executing statement "CREATE TABLE SEARCH_RESULT_FIELDS (vdc_id BIGINT NOT NULL, study_field_id BIGINT NOT NULL, PRIMARY KEY (vdc_id, study_field_id))": org.postgresql.util.PSQLException: ERROR: relation "search_result_fields" already exists
PER01000: Got SQLException executing statement "CREATE TABLE SUMMARY_FIELDS (vdc_id BIGINT NOT NULL, study_field_id BIGINT NOT NULL, PRIMARY KEY (vdc_id, study_field_id))": org.postgresql.util.PSQLException: ERROR: relation "summary_fields" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDCGROUP_VDCS (VDC_ID BIGINT NOT NULL, VDCGROUP_ID BIGINT NOT NULL, PRIMARY KEY (VDC_ID, VDCGROUP_ID))": org.postgresql.util.PSQLException: ERROR: relation "vdcgroup_vdcs" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYFILE_VDCUSER (studyFiles_ID BIGINT NOT NULL, allowedUsers_ID BIGINT NOT NULL, PRIMARY KEY (studyFiles_ID, allowedUsers_ID))": org.postgresql.util.PSQLException: ERROR: relation "studyfile_vdcuser" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDCUSER_STUDYCOMMENT (VDCUser_ID BIGINT NOT NULL, flaggedStudyComments_ID BIGINT NOT NULL, PRIMARY KEY (VDCUser_ID, flaggedStudyComments_ID))": org.postgresql.util.PSQLException: ERROR: relation "vdcuser_studycomment" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDY ADD CONSTRAINT UNQ_STUDY_0 UNIQUE (authority,protocol,studyId)": org.postgresql.util.PSQLException: ERROR: relation "unq_study_0" already exists
PER01000: Got SQLException executing statement "ALTER TABLE PAGEDEF ADD CONSTRAINT UNQ_PAGEDEF_0 UNIQUE (path)": org.postgresql.util.PSQLException: ERROR: relation "unq_pagedef_0" already exists
PER01000: Got SQLException executing statement "ALTER TABLE PAGEDEF ADD CONSTRAINT UNQ_PAGEDEF_1 UNIQUE (name)": org.postgresql.util.PSQLException: ERROR: relation "unq_pagedef_1" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYFILE ADD CONSTRAINT FK_STUDYFILE_STUDY_ID FOREIGN KEY (STUDY_ID) REFERENCES STUDY (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyfile_study_id" for relation "studyfile" already exists
PER01000: Got SQLException executing statement "ALTER TABLE TEMPLATE ADD CONSTRAINT FK_TEMPLATE_VDC_ID FOREIGN KEY (VDC_ID) REFERENCES VDC (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_template_vdc_id" for relation "template" already exists
PER01000: Got SQLException executing statement "ALTER TABLE TEMPLATE ADD CONSTRAINT FK_TEMPLATE_METADATA_ID FOREIGN KEY (METADATA_ID) REFERENCES METADATA (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_template_metadata_id" for relation "template" already exists
PER01000: Got SQLException executing statement "ALTER TABLE LOCKSSSERVER ADD CONSTRAINT FK_LOCKSSSERVER_LOCKSSCONFIG_ID FOREIGN KEY (LOCKSSCONFIG_ID) REFERENCES LOCKSSCONFIG (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_lockssserver_lockssconfig_id" for relation "lockssserver" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYAUTHOR ADD CONSTRAINT FK_STUDYAUTHOR_METADATA_ID FOREIGN KEY (METADATA_ID) REFERENCES METADATA (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyauthor_metadata_id" for relation "studyauthor" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYTOPICCLASS ADD CONSTRAINT FK_STUDYTOPICCLASS_METADATA_ID FOREIGN KEY (METADATA_ID) REFERENCES METADATA (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studytopicclass_metadata_id" for relation "studytopicclass" already exists
PER01000: Got SQLException executing statement "ALTER TABLE VDCROLE ADD CONSTRAINT FK_VDCROLE_ROLE_ID FOREIGN KEY (ROLE_ID) REFERENCES ROLE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdcrole_role_id" for relation "vdcrole" already exists
PER01000: Got SQLException executing statement "ALTER TABLE VDCROLE ADD CONSTRAINT FK_VDCROLE_VDC_ID FOREIGN KEY (VDC_ID) REFERENCES VDC (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdcrole_vdc_id" for relation "vdcrole" already exists
PER01000: Got SQLException executing statement "ALTER TABLE VDCROLE ADD CONSTRAINT FK_VDCROLE_VDCUSER_ID FOREIGN KEY (VDCUSER_ID) REFERENCES VDCUSER (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdcrole_vdcuser_id" for relation "vdcrole" already exists
PER01000: Got SQLException executing statement "ALTER TABLE OAISET ADD CONSTRAINT FK_OAISET_LOCKSSCONFIG_ID FOREIGN KEY (LOCKSSCONFIG_ID) REFERENCES LOCKSSCONFIG (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_oaiset_lockssconfig_id" for relation "oaiset" already exists
PER01000: Got SQLException executing statement "ALTER TABLE VDCACTIVITY ADD CONSTRAINT FK_VDCACTIVITY_VDC_ID FOREIGN KEY (VDC_ID) REFERENCES VDC (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdcactivity_vdc_id" for relation "vdcactivity" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDY ADD CONSTRAINT FK_STUDY_REVIEWER_ID FOREIGN KEY (REVIEWER_ID) REFERENCES VDCUSER (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_study_reviewer_id" for relation "study" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDY ADD CONSTRAINT FK_STUDY_LASTUPDATER_ID FOREIGN KEY (LASTUPDATER_ID) REFERENCES VDCUSER (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_study_lastupdater_id" for relation "study" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDY ADD CONSTRAINT FK_STUDY_TEMPLATE_ID FOREIGN KEY (TEMPLATE_ID) REFERENCES TEMPLATE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_study_template_id" for relation "study" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDY ADD CONSTRAINT FK_STUDY_OWNER_ID FOREIGN KEY (OWNER_ID) REFERENCES VDC (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_study_owner_id" for relation "study" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDY ADD CONSTRAINT FK_STUDY_CREATOR_ID FOREIGN KEY (CREATOR_ID) REFERENCES VDCUSER (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_study_creator_id" for relation "study" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYSOFTWARE ADD CONSTRAINT FK_STUDYSOFTWARE_METADATA_ID FOREIGN KEY (METADATA_ID) REFERENCES METADATA (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studysoftware_metadata_id" for relation "studysoftware" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYOTHERREF ADD CONSTRAINT FK_STUDYOTHERREF_METADATA_ID FOREIGN KEY (METADATA_ID) REFERENCES METADATA (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyotherref_metadata_id" for relation "studyotherref" already exists
PER01000: Got SQLException executing statement "ALTER TABLE CUSTOMQUESTIONVALUE ADD CONSTRAINT FK_CUSTOMQUESTIONVALUE_CUSTOMQUESTION_ID FOREIGN KEY (CUSTOMQUESTION_ID) REFERENCES CUSTOMQUESTION (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_customquestionvalue_customquestion_id" for relation "customquestionvalue" already exists
PER01000: Got SQLException executing statement "ALTER TABLE VARGROUPTYPE ADD CONSTRAINT FK_VARGROUPTYPE_VARGROUPING_ID FOREIGN KEY (VARGROUPING_ID) REFERENCES VARGROUPING (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vargrouptype_vargrouping_id" for relation "vargrouptype" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYRELMATERIAL ADD CONSTRAINT FK_STUDYRELMATERIAL_METADATA_ID FOREIGN KEY (METADATA_ID) REFERENCES METADATA (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyrelmaterial_metadata_id" for relation "studyrelmaterial" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYACCESSREQUEST ADD CONSTRAINT FK_STUDYACCESSREQUEST_STUDY_ID FOREIGN KEY (STUDY_ID) REFERENCES STUDY (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyaccessrequest_study_id" for relation "studyaccessrequest" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYACCESSREQUEST ADD CONSTRAINT FK_STUDYACCESSREQUEST_VDCUSER_ID FOREIGN KEY (VDCUSER_ID) REFERENCES VDCUSER (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyaccessrequest_vdcuser_id" for relation "studyaccessrequest" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYKEYWORD ADD CONSTRAINT FK_STUDYKEYWORD_METADATA_ID FOREIGN KEY (METADATA_ID) REFERENCES METADATA (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studykeyword_metadata_id" for relation "studykeyword" already exists
PER01000: Got SQLException executing statement "ALTER TABLE VARGROUP ADD CONSTRAINT FK_VARGROUP_VARGROUPING_ID FOREIGN KEY (VARGROUPING_ID) REFERENCES VARGROUPING (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vargroup_vargrouping_id" for relation "vargroup" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYFIELDVALUE ADD CONSTRAINT FK_STUDYFIELDVALUE_METADATA_ID FOREIGN KEY (METADATA_ID) REFERENCES METADATA (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyfieldvalue_metadata_id" for relation "studyfieldvalue" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYFIELDVALUE ADD CONSTRAINT FK_STUDYFIELDVALUE_STUDYFIELD_ID FOREIGN KEY (STUDYFIELD_ID) REFERENCES STUDYFIELD (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyfieldvalue_studyfield_id" for relation "studyfieldvalue" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYREQUEST ADD CONSTRAINT FK_STUDYREQUEST_VDCUSER_ID FOREIGN KEY (VDCUSER_ID) REFERENCES VDCUSER (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyrequest_vdcuser_id" for relation "studyrequest" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYREQUEST ADD CONSTRAINT FK_STUDYREQUEST_STUDY_ID FOREIGN KEY (STUDY_ID) REFERENCES STUDY (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyrequest_study_id" for relation "studyrequest" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYDOWNLOAD ADD CONSTRAINT FK_STUDYDOWNLOAD_STUDY_ID FOREIGN KEY (STUDY_ID) REFERENCES STUDY (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studydownload_study_id" for relation "studydownload" already exists
PER01000: Got SQLException executing statement "ALTER TABLE TWITTERCREDENTIALS ADD CONSTRAINT FK_TWITTERCREDENTIALS_VDC_ID FOREIGN KEY (VDC_ID) REFERENCES VDC (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_twittercredentials_vdc_id" for relation "twittercredentials" already exists
PER01000: Got SQLException executing statement "ALTER TABLE ROLEREQUEST ADD CONSTRAINT FK_ROLEREQUEST_VDCUSER_ID FOREIGN KEY (VDCUSER_ID) REFERENCES VDCUSER (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_rolerequest_vdcuser_id" for relation "rolerequest" already exists
PER01000: Got SQLException executing statement "ALTER TABLE ROLEREQUEST ADD CONSTRAINT FK_ROLEREQUEST_ROLE_ID FOREIGN KEY (ROLE_ID) REFERENCES ROLE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_rolerequest_role_id" for relation "rolerequest" already exists
PER01000: Got SQLException executing statement "ALTER TABLE ROLEREQUEST ADD CONSTRAINT FK_ROLEREQUEST_VDC_ID FOREIGN KEY (VDC_ID) REFERENCES VDC (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_rolerequest_vdc_id" for relation "rolerequest" already exists
PER01000: Got SQLException executing statement "ALTER TABLE GUESTBOOKRESPONSE ADD CONSTRAINT FK_GUESTBOOKRESPONSE_VDCUSER_ID FOREIGN KEY (VDCUSER_ID) REFERENCES VDCUSER (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_guestbookresponse_vdcuser_id" for relation "guestbookresponse" already exists
PER01000: Got SQLException executing statement "ALTER TABLE GUESTBOOKRESPONSE ADD CONSTRAINT FK_GUESTBOOKRESPONSE_GUESTBOOKQUESTIONNAIRE_ID FOREIGN KEY (GUESTBOOKQUESTIONNAIRE_ID) REFERENCES GUESTBOOKQUESTIONNAIRE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_guestbookresponse_guestbookquestionnaire_id" for relation "guestbookresponse" already exists
PER01000: Got SQLException executing statement "ALTER TABLE GUESTBOOKRESPONSE ADD CONSTRAINT FK_GUESTBOOKRESPONSE_STUDYFILE_ID FOREIGN KEY (STUDYFILE_ID) REFERENCES STUDYFILE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_guestbookresponse_studyfile_id" for relation "guestbookresponse" already exists
PER01000: Got SQLException executing statement "ALTER TABLE GUESTBOOKRESPONSE ADD CONSTRAINT FK_GUESTBOOKRESPONSE_STUDY_ID FOREIGN KEY (STUDY_ID) REFERENCES STUDY (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_guestbookresponse_study_id" for relation "guestbookresponse" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYLOCK ADD CONSTRAINT FK_STUDYLOCK_USER_ID FOREIGN KEY (USER_ID) REFERENCES VDCUSER (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studylock_user_id" for relation "studylock" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYLOCK ADD CONSTRAINT FK_STUDYLOCK_STUDY_ID FOREIGN KEY (STUDY_ID) REFERENCES STUDY (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studylock_study_id" for relation "studylock" already exists
PER01000: Got SQLException executing statement "ALTER TABLE LOCKSSCONFIG ADD CONSTRAINT FK_LOCKSSCONFIG_VDC_ID FOREIGN KEY (VDC_ID) REFERENCES VDC (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_lockssconfig_vdc_id" for relation "lockssconfig" already exists
PER01000: Got SQLException executing statement "ALTER TABLE LOCKSSCONFIG ADD CONSTRAINT FK_LOCKSSCONFIG_LICENSETYPE_ID FOREIGN KEY (LICENSETYPE_ID) REFERENCES LICENSETYPE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_lockssconfig_licensetype_id" for relation "lockssconfig" already exists
PER01000: Got SQLException executing statement "ALTER TABLE VDCGROUPRELATIONSHIP ADD CONSTRAINT FK_VDCGROUPRELATIONSHIP_subgroup_id FOREIGN KEY (subgroup_id) REFERENCES VDCGROUP (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdcgrouprelationship_subgroup_id" for relation "vdcgrouprelationship" already exists
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 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 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 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 CUSTOMQUESTIONRESPONSE ADD CONSTRAINT FK_CUSTOMQUESTIONRESPONSE_GUESTBOOKRESPONSE_ID FOREIGN KEY (GUESTBOOKRESPONSE_ID) REFERENCES GUESTBOOKRESPONSE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_customquestionresponse_guestbookresponse_id" for relation "customquestionresponse" already exists
PER01000: Got SQLException executing statement "ALTER TABLE CUSTOMQUESTIONRESPONSE ADD CONSTRAINT FK_CUSTOMQUESTIONRESPONSE_CUSTOMQUESTION_ID FOREIGN KEY (CUSTOMQUESTION_ID) REFERENCES CUSTOMQUESTION (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_customquestionresponse_customquestion_id" for relation "customquestionresponse" 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 CUSTOMQUESTION ADD CONSTRAINT FK_CUSTOMQUESTION_GUESTBOOKQUESTIONNAIRE_ID FOREIGN KEY (GUESTBOOKQUESTIONNAIRE_ID) REFERENCES GUESTBOOKQUESTIONNAIRE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_customquestion_guestbookquestionnaire_id" for relation "customquestion" already exists
PER01000: Got SQLException executing statement "ALTER TABLE GUESTBOOKQUESTIONNAIRE ADD CONSTRAINT FK_GUESTBOOKQUESTIONNAIRE_VDC_ID FOREIGN KEY (VDC_ID) REFERENCES VDC (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_guestbookquestionnaire_vdc_id" for relation "guestbookquestionnaire" 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.
[root@tofino bin]# ./asadmin list-applications
DVN-web_v3_3 <ejb, web>
Command list-applications executed successfully.
I've just carried out the DVN v3.2 to v3.3 upgrade by undeploying the existing v3.2 war file, modifying the database and then deploying the new v3.3 war file. I ended up with an ostensibly functioning v3.3 system but I did get a few unsettling errors when I deployed the new war (below). Is this anything that I should be concerned about? Just checking.
//Joerg Messer - UBC Library
----
./asadmin deploy /usr/local/src/dataverse/dvn_3.3/DVN-web_v3_3.war
PER01003: Deployment encountered SQL Exceptions:
PER01000: Got SQLException executing statement "CREATE TABLE STUDYFILE (ID SERIAL NOT NULL, fileClass VARCHAR(31), ALLOWACCESSREQUEST BOOLEAN, DISPLAYORDER INTEGER, FILESYSTEMLOCATION TEXT, FILESYSTEMNAME VARCHAR(255), FILETYPE VARCHAR(255), ORIGINALFILETYPE VARCHAR(255), REQUESTACCESS BOOLEAN, RESTRICTED BOOLEAN, UNF VARCHAR(255), VERSION BIGINT, STUDY_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studyfile" already exists
PER01000: Got SQLException executing statement "CREATE TABLE TEMPLATE (ID SERIAL NOT NULL, DESCRIPTION VARCHAR(255), ENABLED BOOLEAN, NAME VARCHAR(255), VERSION BIGINT, VDC_ID BIGINT, METADATA_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "template" already exists
PER01000: Got SQLException executing statement "CREATE TABLE LOCKSSSERVER (ID SERIAL NOT NULL, IPADDRESS VARCHAR(255), VERSION BIGINT, LOCKSSCONFIG_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "lockssserver" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYAUTHOR (ID SERIAL NOT NULL, AFFILIATION VARCHAR(255), DISPLAYORDER INTEGER, IDTYPE VARCHAR(255), IDVALUE VARCHAR(255), NAME VARCHAR(255), VERSION BIGINT, METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studyauthor" already exists
PER01000: Got SQLException executing statement "CREATE TABLE ROLE (ID SERIAL NOT NULL, DESCRIPTION VARCHAR(255), NAME VARCHAR(255), PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "role" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYTOPICCLASS (ID SERIAL NOT NULL, DISPLAYORDER INTEGER, VALUE TEXT, VERSION BIGINT, VOCAB VARCHAR(255), VOCABURI VARCHAR(255), METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studytopicclass" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDCROLE (ID SERIAL NOT NULL, ROLE_ID BIGINT NOT NULL, VDC_ID BIGINT NOT NULL, VDCUSER_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "vdcrole" already exists
PER01000: Got SQLException executing statement "CREATE TABLE OAISET (ID SERIAL NOT NULL, DEFINITION TEXT, DESCRIPTION TEXT, NAME TEXT, SPEC TEXT, VERSION BIGINT, LOCKSSCONFIG_ID BIGINT UNIQUE, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "oaiset" already exists
PER01000: Got SQLException executing statement "CREATE TABLE FIELDINPUTLEVEL (ID SERIAL NOT NULL, NAME VARCHAR(255), PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "fieldinputlevel" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDCACTIVITY (ID SERIAL NOT NULL, FOREIGNSTUDYLOCALDOWNLOADCOUNT INTEGER NOT NULL, LOCALSTUDYFOREIGNDOWNLOADCOUNT INTEGER NOT NULL, LOCALSTUDYLOCALDOWNLOADCOUNT INTEGER NOT NULL, LOCALSTUDYNETWORKDOWNLOADCOUNT INTEGER NOT NULL, VDC_ID BIGINT UNIQUE, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "vdcactivity" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDY (ID SERIAL NOT NULL, AUTHORITY TEXT, CREATETIME TIMESTAMP, HARVESTIDENTIFIER VARCHAR(255), ISHARVESTED BOOLEAN, LASTEXPORTTIME TIMESTAMP, LASTINDEXTIME TIMESTAMP, LASTUPDATETIME TIMESTAMP, NUMBEROFDOWNLOADS BIGINT, PROTOCOL TEXT, REQUESTACCESS BOOLEAN, RESTRICTED BOOLEAN, STUDYID VARCHAR(255), VERSION BIGINT, CREATOR_ID BIGINT NOT NULL, LASTUPDATER_ID BIGINT, OWNER_ID BIGINT NOT NULL, REVIEWER_ID BIGINT, TEMPLATE_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "study" already exists
PER01000: Got SQLException executing statement "CREATE TABLE CONTROLLEDVOCABULARY (ID SERIAL NOT NULL, DESCRIPTION TEXT, FIELDTYPE VARCHAR(255), NAME VARCHAR(255), PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "controlledvocabulary" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYSOFTWARE (ID SERIAL NOT NULL, DISPLAYORDER INTEGER, NAME VARCHAR(255), SOFTWAREVERSION VARCHAR(255), VERSION BIGINT, METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studysoftware" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYOTHERREF (ID SERIAL NOT NULL, DISPLAYORDER INTEGER, TEXT TEXT, VERSION BIGINT, METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studyotherref" already exists
PER01000: Got SQLException executing statement "CREATE TABLE CUSTOMQUESTIONVALUE (ID SERIAL NOT NULL, VALUESTRING VARCHAR(255), CUSTOMQUESTION_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "customquestionvalue" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VARGROUPTYPE (ID SERIAL NOT NULL, NAME VARCHAR(255), VARGROUPING_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "vargrouptype" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYRELMATERIAL (ID SERIAL NOT NULL, DISPLAYORDER INTEGER, TEXT TEXT, VERSION BIGINT, METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studyrelmaterial" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYACCESSREQUEST (ID SERIAL NOT NULL, STUDY_ID BIGINT NOT NULL, VDCUSER_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studyaccessrequest" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYKEYWORD (ID SERIAL NOT NULL, DISPLAYORDER INTEGER, VALUE TEXT, VERSION BIGINT, VOCAB VARCHAR(255), VOCABURI VARCHAR(255), METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studykeyword" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VARGROUP (ID SERIAL NOT NULL, NAME VARCHAR(255), UNITS VARCHAR(255), VARGROUPING_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "vargroup" already exists
PER01000: Got SQLException executing statement "CREATE TABLE CAPTCHA (ID BIGINT NOT NULL, DOMAINNAME VARCHAR(255), PRIVATEKEY VARCHAR(255), PUBLICKEY VARCHAR(255), PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "captcha" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYFIELDVALUE (ID SERIAL NOT NULL, DISPLAYORDER INTEGER, STRVALUE TEXT, METADATA_ID BIGINT NOT NULL, STUDYFIELD_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studyfieldvalue" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYREQUEST (ID SERIAL NOT NULL, STUDY_ID BIGINT NOT NULL, VDCUSER_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studyrequest" already exists
PER01000: Got SQLException executing statement "CREATE TABLE HANDLEPREFIX (ID SERIAL NOT NULL, PREFIX VARCHAR(255), PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "handleprefix" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYDOWNLOAD (ID SERIAL NOT NULL, NUMBEROFDOWNLOADS INTEGER, STUDY_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studydownload" already exists
PER01000: Got SQLException executing statement "CREATE TABLE TWITTERCREDENTIALS (ID SERIAL NOT NULL, ACCESSTOKEN VARCHAR(255), ACCESSTOKENSECRET VARCHAR(255), VDC_ID BIGINT UNIQUE, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "twittercredentials" already exists
PER01000: Got SQLException executing statement "CREATE TABLE ROLEREQUEST (ID SERIAL NOT NULL, ROLE_ID BIGINT NOT NULL, VDC_ID BIGINT NOT NULL, VDCUSER_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "rolerequest" already exists
PER01000: Got SQLException executing statement "CREATE TABLE GUESTBOOKRESPONSE (ID SERIAL NOT NULL, DOWNLOADTYPE VARCHAR(255), EMAIL VARCHAR(255), FIRSTNAME VARCHAR(255), INSTITUTION VARCHAR(255), LASTNAME VARCHAR(255), POSITION VARCHAR(255), RESPONSETIME TIMESTAMP, SESSIONID VARCHAR(255), GUESTBOOKQUESTIONNAIRE_ID BIGINT NOT NULL, STUDY_ID BIGINT NOT NULL, STUDYFILE_ID BIGINT NOT NULL, STUDYVERSION_ID BIGINT, VDCUSER_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "guestbookresponse" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYLOCK (ID SERIAL NOT NULL, DETAIL VARCHAR(255), STARTTIME TIMESTAMP, USER_ID BIGINT NOT NULL, STUDY_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studylock" already exists
PER01000: Got SQLException executing statement "CREATE TABLE LOCKSSCONFIG (ID SERIAL NOT NULL, ALLOWRESTRICTED BOOLEAN, LICENSETEXT TEXT, SERVERACCESS VARCHAR(255), LICENSETYPE_ID BIGINT, VDC_ID BIGINT UNIQUE, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "lockssconfig" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDCGROUPRELATIONSHIP (group_id BIGINT NOT NULL, subgroup_id BIGINT NOT NULL, PRIMARY KEY (group_id, subgroup_id))": org.postgresql.util.PSQLException: ERROR: relation "vdcgrouprelationship" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VARIABLECATEGORY (ID SERIAL NOT NULL, FREQUENCY FLOAT, LABEL VARCHAR(255), MISSING BOOLEAN, VALUE TEXT, DATAVARIABLE_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "variablecategory" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDCCOLLECTION (ID SERIAL NOT NULL, DESCRIPTION TEXT, DISPLAYORDER INTEGER, LOCALSCOPE BOOLEAN, NAME VARCHAR(255), QUERY TEXT, TYPE VARCHAR(255), VERSION BIGINT, OWNER_ID BIGINT, PARENTCOLLECTION_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "vdccollection" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYCOMMENT (ID SERIAL NOT NULL, COMMENT TEXT, CREATETIME TIMESTAMP, STATUS INTEGER, COMMENTCREATOR_ID BIGINT NOT NULL, STUDYVERSION_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studycomment" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VARIABLERANGEITEM (ID SERIAL NOT NULL, VALUE DECIMAL(38), DATAVARIABLE_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "variablerangeitem" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VARGROUPING (ID SERIAL NOT NULL, GROUPINGTYPE VARCHAR(255), NAME VARCHAR(255), DATATABLE_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "vargrouping" already exists
PER01000: Got SQLException executing statement "CREATE TABLE TEMPLATEFILECATEGORY (ID SERIAL NOT NULL, DISPLAYORDER INTEGER, NAME VARCHAR(255), TEMPLATE_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "templatefilecategory" already exists
PER01000: Got SQLException executing statement "CREATE TABLE CONTACTSUBJECT (ID SERIAL NOT NULL, SUBJECTTEXT VARCHAR(255), VDC_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "contactsubject" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYFILEACTIVITY (ID SERIAL NOT NULL, DOWNLOADCOUNT INTEGER, LASTDOWNLOADTIME TIMESTAMP, STUDY_ID BIGINT NOT NULL, STUDYFILE_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studyfileactivity" already exists
PER01000: Got SQLException executing statement "CREATE TABLE TEMPLATEFIELD (ID SERIAL NOT NULL, DEFAULTVALUE VARCHAR(255), DISPLAYORDER INTEGER, FIELDINPUTLEVELSTRING VARCHAR(255), VERSION BIGINT, CONTROLLEDVOCABULARY_ID BIGINT, STUDYFIELD_ID BIGINT NOT NULL, TEMPLATE_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "templatefield" already exists
PER01000: Got SQLException executing statement "CREATE TABLE NETWORKROLEREQUEST (ID SERIAL NOT NULL, NETWORKROLE_ID BIGINT NOT NULL, VDCUSER_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "networkrolerequest" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDCNETWORKSTATS (ID SERIAL NOT NULL, FILECOUNT BIGINT, STUDYCOUNT BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "vdcnetworkstats" already exists
PER01000: Got SQLException executing statement "CREATE TABLE NETWORKROLE (ID SERIAL NOT NULL, DESCRIPTION VARCHAR(255), NAME VARCHAR(255), PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "networkrole" already exists
PER01000: Got SQLException executing statement "CREATE TABLE SUMMARYSTATISTIC (ID SERIAL NOT NULL, VALUE VARCHAR(255), DATAVARIABLE_ID BIGINT NOT NULL, TYPE_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "summarystatistic" already exists
PER01000: Got SQLException executing statement "CREATE TABLE DATAFILEFORMATTYPE (ID BIGINT NOT NULL, MIMETYPE VARCHAR(255), NAME VARCHAR(255), VALUE VARCHAR(255), PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "datafileformattype" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYABSTRACT (ID SERIAL NOT NULL, DATE VARCHAR(255), DISPLAYORDER INTEGER, TEXT TEXT, VERSION BIGINT, METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studyabstract" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYRELSTUDY (ID SERIAL NOT NULL, DISPLAYORDER INTEGER, TEXT TEXT, VERSION BIGINT, METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studyrelstudy" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYGEOBOUNDING (ID SERIAL NOT NULL, DISPLAYORDER INTEGER, EASTLONGITUDE VARCHAR(255), NORTHLATITUDE VARCHAR(255), SOUTHLATITUDE VARCHAR(255), VERSION BIGINT, WESTLONGITUDE VARCHAR(255), METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studygeobounding" already exists
PER01000: Got SQLException executing statement "CREATE TABLE HARVESTSTUDY (ID SERIAL NOT NULL, GLOBALID VARCHAR(255), LASTUPDATETIME TIMESTAMP, REMOVED BOOLEAN, SETNAME VARCHAR(255), PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "harveststudy" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYPRODUCER (ID SERIAL NOT NULL, ABBREVIATION VARCHAR(255), AFFILIATION VARCHAR(255), DISPLAYORDER INTEGER, LOGO VARCHAR(255), NAME VARCHAR(255), URL VARCHAR(255), VERSION BIGINT, METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studyproducer" already exists
PER01000: Got SQLException executing statement "CREATE TABLE LICENSETYPE (ID SERIAL NOT NULL, IMAGEURL VARCHAR(255), LICENSEURL VARCHAR(255), NAME VARCHAR(255), RDFURL VARCHAR(255), SHORTNAME VARCHAR(255), PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "licensetype" already exists
PER01000: Got SQLException executing statement "CREATE TABLE LOGINAFFILIATE (ID SERIAL NOT NULL, NAME VARCHAR(255), URL VARCHAR(255), VERSION BIGINT, USERGROUP_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "loginaffiliate" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VARIABLERANGE (ID SERIAL NOT NULL, BEGINVALUE VARCHAR(255), ENDVALUE VARCHAR(255), BEGINVALUETYPE_ID BIGINT, DATAVARIABLE_ID BIGINT NOT NULL, ENDVALUETYPE_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "variablerange" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYGRANT (ID SERIAL NOT NULL, AGENCY VARCHAR(255), DISPLAYORDER INTEGER, NUMBER TEXT, VERSION BIGINT, METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studygrant" already exists
PER01000: Got SQLException executing statement "CREATE TABLE USERGROUP (ID SERIAL NOT NULL, DESCRIPTION VARCHAR(255), FRIENDLYNAME VARCHAR(255), NAME VARCHAR(255), PINSERVICE VARCHAR(255), VERSION BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "usergroup" already exists
PER01000: Got SQLException executing statement "CREATE TABLE DATAVARIABLE (ID SERIAL NOT NULL, CONCEPT VARCHAR(255), FILEENDPOSITION BIGINT, FILEORDER INTEGER, FILESTARTPOSITION BIGINT, FORMATCATEGORY VARCHAR(255), FORMATSCHEMA VARCHAR(255), FORMATSCHEMANAME VARCHAR(255), LABEL TEXT, NAME VARCHAR(255), NUMBEROFDECIMALPOINTS BIGINT, QUESTIONTEXT TEXT, RECORDSEGMENTNUMBER BIGINT, UNF VARCHAR(255), UNIVERSE VARCHAR(255), VERSION BIGINT, WEIGHTED BOOLEAN, DATATABLE_ID BIGINT NOT NULL, VARIABLEFORMATTYPE_ID BIGINT NOT NULL, VARIABLEINTERVALTYPE_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "datavariable" already exists
PER01000: Got SQLException executing statement "CREATE TABLE CONTROLLEDVOCABULARYVALUE (ID SERIAL NOT NULL, VALUE TEXT, CONTROLLEDVOCABULARY_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "controlledvocabularyvalue" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYRELPUBLICATION (ID SERIAL NOT NULL, DISPLAYORDER INTEGER, IDNUMBER VARCHAR(255), IDTYPE VARCHAR(255), REPLICATIONDATA BOOLEAN, TEXT TEXT, URL VARCHAR(255), VERSION BIGINT, METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studyrelpublication" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYDISTRIBUTOR (ID SERIAL NOT NULL, ABBREVIATION VARCHAR(255), AFFILIATION VARCHAR(255), DISPLAYORDER INTEGER, LOGO VARCHAR(255), NAME VARCHAR(255), URL VARCHAR(255), VERSION BIGINT, METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studydistributor" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYNOTE (ID SERIAL NOT NULL, DISPLAYORDER INTEGER, SUBJECT VARCHAR(255), TEXT TEXT, TYPE VARCHAR(255), VERSION BIGINT, METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studynote" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VERSIONCONTRIBUTOR (ID SERIAL NOT NULL, LASTUPDATETIME TIMESTAMP, VERSION BIGINT, CONTRIBUTOR_ID BIGINT NOT NULL, STUDYVERSION_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "versioncontributor" already exists
PER01000: Got SQLException executing statement "CREATE TABLE DATAVARIABLEMAPPING (ID SERIAL NOT NULL, LABEL VARCHAR(255), X_AXIS BOOLEAN, DATATABLE_ID BIGINT NOT NULL, DATAVARIABLE_ID BIGINT NOT NULL, VARGROUP_ID BIGINT, VARGROUPING_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "datavariablemapping" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VISUALIZATIONDISPLAY (ID SERIAL NOT NULL, DEFAULTDISPLAY INTEGER, MEASURETYPELABEL VARCHAR(255), SHOWDATATABLE BOOLEAN, SHOWFLASHGRAPH BOOLEAN, SHOWIMAGEGRAPH BOOLEAN, SOURCEINFOLABEL VARCHAR(255), DATATABLE_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "visualizationdisplay" already exists
PER01000: Got SQLException executing statement "CREATE TABLE TERMSOFUSE (ID SERIAL NOT NULL, CREATETIME TIMESTAMP, ENABLED BOOLEAN, TERMS TEXT, VDC_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "termsofuse" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDC (ID SERIAL NOT NULL, aboutThisDataverse TEXT, AFFILIATION VARCHAR(255), ALIAS VARCHAR(255), ALLOWCONTRIBUTORREQUESTS BOOLEAN, ALLOWCONTRIBUTORSEDITALL BOOLEAN, ALLOWREGISTEREDUSERSTOCONTRIBUTE BOOLEAN, ALLOWSTUDYCOMMENTS BOOLEAN, announcements TEXT, CONTACTEMAIL VARCHAR(255), COPYRIGHT VARCHAR(255), CREATEDDATE TIMESTAMP, DEFAULTSORTORDER VARCHAR(255), termsOfUse TEXT, depositTermsOfUseEnabled BOOLEAN, DESCRIPTION VARCHAR(255), DISPLAYANNOUNCEMENTS BOOLEAN, DISPLAYINFRAME BOOLEAN, DISPLAYNETWORKANNOUNCEMENTS BOOLEAN, DISPLAYNEWSTUDIES BOOLEAN, downloadTermsOfUse TEXT, downloadTermsOfUseEnabled BOOLEAN, DTYPE VARCHAR(255), DVNDESCRIPTION VARCHAR(255), FILESRESTRICTED BOOLEAN, FIRSTNAME VARCHAR(255), footer TEXT, header TEXT, LASTNAME VARCHAR(255), LOGO VARCHAR(255), NAME VARCHAR(255), PARENTSITE VARCHAR(255), RELEASEDATE TIMESTAMP, RESTRICTED BOOLEAN, termsOfUseEnabled BOOLEAN, VERSION BIGINT, VISIBILITY VARCHAR(255), CREATOR_ID BIGINT, DEFAULTTEMPLATE_ID BIGINT, REVIEWER_ID BIGINT, HARVESTINGDATAVERSE_ID BIGINT, ROOTCOLLECTION_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "vdc" already exists
PER01000: Got SQLException executing statement "CREATE TABLE CUSTOMQUESTIONRESPONSE (ID SERIAL NOT NULL, RESPONSE VARCHAR(255), CUSTOMQUESTION_ID BIGINT NOT NULL, GUESTBOOKRESPONSE_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "customquestionresponse" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VARIABLERANGETYPE (ID BIGINT NOT NULL, NAME VARCHAR(255), PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "variablerangetype" already exists
PER01000: Got SQLException executing statement "CREATE TABLE WEIGHTEDVARRELATIONSHIP (variable_id BIGINT NOT NULL, weighted_variable_id BIGINT NOT NULL, PRIMARY KEY (variable_id, weighted_variable_id))": org.postgresql.util.PSQLException: ERROR: relation "weightedvarrelationship" already exists
PER01000: Got SQLException executing statement "CREATE TABLE METADATAFORMATTYPE (ID BIGINT NOT NULL, FORMATSCHEMA VARCHAR(255), MIMETYPE VARCHAR(255), NAME VARCHAR(255), NAMESPACE VARCHAR(255), PARTIALEXCLUDESUPPORTED BOOLEAN, PARTIALSELECTSUPPORTED BOOLEAN, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "metadataformattype" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VARIABLEINTERVALTYPE (ID BIGINT NOT NULL, NAME VARCHAR(255), PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "variableintervaltype" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYFIELD (ID SERIAL NOT NULL, ADVANCEDSEARCHFIELD BOOLEAN, ALLOWCONTROLLEDVOCABULARY BOOLEAN, ALLOWMULTIPLES BOOLEAN, BASICSEARCHFIELD BOOLEAN, CUSTOMFIELD BOOLEAN, description TEXT, DISPLAYORDER INTEGER, FIELDTYPE VARCHAR(255), name TEXT, SEARCHRESULTFIELD BOOLEAN, title TEXT, PARENTSTUDYFIELD_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studyfield" already exists
PER01000: Got SQLException executing statement "CREATE TABLE HARVESTINGDATAVERSE (ID SERIAL NOT NULL, FAILEDSTUDYCOUNT BIGINT, FAILEDSTUDYCOUNTNONZERO BIGINT, GENERATERANDOMIDS BOOLEAN, HARVESTRESULT VARCHAR(255), HARVESTTYPE VARCHAR(255), HARVESTEDSTUDYCOUNT BIGINT, HARVESTEDSTUDYCOUNTNONZERO BIGINT, HARVESTINGNOW BOOLEAN, HARVESTINGSET VARCHAR(255), LASTHARVESTTIME TIMESTAMP, LASTSUCCESSFULHARVESTTIME TIMESTAMP, LASTSUCCESSFULNONZEROHARVESTTIME TIMESTAMP, SCHEDULEDAYOFWEEK INTEGER, SCHEDULEHOUROFDAY INTEGER, SCHEDULEPERIOD VARCHAR(255), SCHEDULED BOOLEAN, SERVERURL VARCHAR(255), SUBSETRESTRICTED BOOLEAN, VERSION BIGINT, HANDLEPREFIX_ID BIGINT, HARVESTFORMATTYPE_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "harvestingdataverse" already exists
PER01000: Got SQLException executing statement "CREATE TABLE FILEMETADATA (ID SERIAL NOT NULL, CATEGORY TEXT, DESCRIPTION TEXT, LABEL VARCHAR(255), VERSION BIGINT, STUDYFILE_ID BIGINT NOT NULL, STUDYVERSION_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "filemetadata" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYVERSION (ID SERIAL NOT NULL, ARCHIVENOTE VARCHAR(1000), ARCHIVETIME TIMESTAMP, CREATETIME TIMESTAMP, DEACCESSIONLINK VARCHAR(255), LASTUPDATETIME TIMESTAMP, RELEASETIME TIMESTAMP, VERSION BIGINT, VERSIONNOTE VARCHAR(1000), VERSIONNUMBER BIGINT, VERSIONSTATE VARCHAR(255), STUDY_ID BIGINT NOT NULL, METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studyversion" already exists
PER01000: Got SQLException executing statement "CREATE TABLE LOGINDOMAIN (ID SERIAL NOT NULL, IPADDRESS VARCHAR(255), VERSION BIGINT, USERGROUP_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "logindomain" already exists
PER01000: Got SQLException executing statement "CREATE TABLE REMOTEACCESSAUTH (ID SERIAL NOT NULL, AUTHCRED1 VARCHAR(255), AUTHCRED2 VARCHAR(255), AUTHCRED3 VARCHAR(255), AUTHCRED4 VARCHAR(255), AUTHTYPE VARCHAR(255), HOSTNAME VARCHAR(255), PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "remoteaccessauth" already exists
PER01000: Got SQLException executing statement "CREATE TABLE DATATABLE (ID SERIAL NOT NULL, CASEQUANTITY BIGINT, RECORDSPERCASE BIGINT, TYPE VARCHAR(255), UNF VARCHAR(255), VARQUANTITY BIGINT, VERSION BIGINT, VISUALIZATIONENABLED BOOLEAN, STUDYFILE_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "datatable" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDCNETWORK (ID SERIAL NOT NULL, aboutThisDataverseNetwork TEXT, ALLOWCREATEREQUEST BOOLEAN, announcements TEXT, AUTHORITY VARCHAR(255), CONTACTEMAIL VARCHAR(255), DEFAULTDVSORTCOLUMN VARCHAR(255), DEFAULTDISPLAYNUMBER BIGINT, defaultVDCAboutText TEXT, defaultVDCAnnouncements TEXT, defaultVDCFooter TEXT, defaultVDCHeader TEXT, depositTermsOfUse TEXT, DEPOSITTERMSOFUSEENABLED BOOLEAN, DISPLAYANNOUNCEMENTS BOOLEAN, DISPLAYVDCANNOUNCEMENTS BOOLEAN, DISPLAYVDCRECENTSTUDIES BOOLEAN, downloadTermsOfUse TEXT, DOWNLOADTERMSOFUSEENABLED BOOLEAN, EXPORTDAYOFWEEK INTEGER, EXPORTHOUROFDAY INTEGER, EXPORTPERIOD VARCHAR(255), HANDLEREGISTRATION BOOLEAN, NAME VARCHAR(255), networkPageFooter TEXT, networkPageHeader TEXT, PROTOCOL VARCHAR(255), REQUIREDVAFFILIATION BOOLEAN, REQUIREDVCLASSIFICATION BOOLEAN, REQUIREDVDESCRIPTION BOOLEAN, REQUIREDVSTUDIESFORRELEASE BOOLEAN, RESTRICTIONTEXT VARCHAR(255), statusnotice TEXT, termsOfUse TEXT, TERMSOFUSEENABLED BOOLEAN, TERMSOFUSEUPDATED TIMESTAMP, VERSION BIGINT, DEFAULTNETWORKADMIN_ID BIGINT, DEFAULTTEMPLATE_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "vdcnetwork" already exists
PER01000: Got SQLException executing statement "CREATE TABLE HARVESTFORMATTYPE (ID BIGINT NOT NULL, METADATAPREFIX VARCHAR(255), NAME VARCHAR(255), STYLESHEETFILENAME VARCHAR(255), PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "harvestformattype" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VARIABLEFORMATTYPE (ID BIGINT NOT NULL, NAME VARCHAR(255), PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "variableformattype" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDCGROUP (ID SERIAL NOT NULL, DEFAULTDISPLAYNUMBER BIGINT, DESCRIPTION VARCHAR(255), DISPLAYORDER INTEGER, NAME VARCHAR(255), PARENT BIGINT, VERSION BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "vdcgroup" already exists
PER01000: Got SQLException executing statement "CREATE TABLE NETWORKCONTACTSUBJECT (ID SERIAL NOT NULL, SUBJECTTEXT VARCHAR(255), VDCNETWORK_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "networkcontactsubject" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDCUSER (ID SERIAL NOT NULL, ACTIVE BOOLEAN, AGREEDTERMSOFUSE BOOLEAN, BYPASSTERMSOFUSE BOOLEAN, EMAIL VARCHAR(255), ENCRYPTEDPASSWORD text, FIRSTNAME VARCHAR(255), INSTITUTION VARCHAR(255), LASTNAME VARCHAR(255), PHONENUMBER VARCHAR(255), POSITION VARCHAR(255), TEST INTEGER, USERNAME VARCHAR(255), VERSION BIGINT, NETWORKROLE_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "vdcuser" already exists
PER01000: Got SQLException executing statement "CREATE TABLE METADATA (ID SERIAL NOT NULL, UNF TEXT, ACCESSTOSOURCES TEXT, ACTIONSTOMINIMIZELOSS TEXT, AVAILABILITYSTATUS TEXT, CHARACTERISTICOFSOURCES TEXT, CITATIONREQUIREMENTS TEXT, CLEANINGOPERATIONS TEXT, COLLECTIONMODE TEXT, COLLECTIONSIZE TEXT, CONDITIONS TEXT, CONFIDENTIALITYDECLARATION TEXT, CONTACT TEXT, CONTROLOPERATIONS TEXT, COUNTRY TEXT, DATACOLLECTIONSITUATION TEXT, DATACOLLECTOR TEXT, DATASOURCES TEXT, DATEOFCOLLECTIONEND TEXT, DATEOFCOLLECTIONSTART TEXT, DATEOFDEPOSIT TEXT, DEPOSITOR TEXT, DEPOSITORREQUIREMENTS TEXT, DEVIATIONSFROMSAMPLEDESIGN TEXT, DISCLAIMER TEXT, DISTRIBUTIONDATE TEXT, DISTRIBUTORCONTACT TEXT, DISTRIBUTORCONTACTAFFILIATION TEXT, DISTRIBUTORCONTACTEMAIL TEXT, FREQUENCYOFDATACOLLECTION TEXT, FUNDINGAGENCY TEXT, GEOGRAPHICCOVERAGE TEXT, GEOGRAPHICUNIT TEXT, HARVESTDVNTERMSOFUSE TEXT, HARVESTDVTERMSOFUSE TEXT, HARVESTHOLDINGS VARCHAR(255), KINDOFDATA TEXT, ORIGINOFSOURCES TEXT, ORIGINALARCHIVE TEXT, OTHERDATAAPPRAISAL TEXT, PLACEOFACCESS TEXT, PRODUCTIONDATE TEXT, PRODUCTIONPLACE TEXT, RESEARCHINSTRUMENT TEXT, RESPONSERATE TEXT, RESTRICTIONS TEXT, SAMPLINGERRORESTIMATE TEXT, SAMPLINGPROCEDURE TEXT, SERIESINFORMATION TEXT, SERIESNAME TEXT, SPECIALPERMISSIONS TEXT, STUDYCOMPLETION TEXT, STUDYLEVELERRORNOTES TEXT, studyVersion TEXT, SUBTITLE TEXT, TIMEMETHOD TEXT, TIMEPERIODCOVEREDEND TEXT, TIMEPERIODCOVEREDSTART TEXT, TITLE TEXT, UNITOFANALYSIS TEXT, UNIVERSE TEXT, VERSION BIGINT, VERSIONDATE TEXT, WEIGHTING TEXT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "metadata" already exists
PER01000: Got SQLException executing statement "CREATE TABLE PAGEDEF (ID SERIAL NOT NULL, NAME VARCHAR(255), PATH VARCHAR(255), VERSION BIGINT, NETWORKROLE_ID BIGINT, ROLE_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "pagedef" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYOTHERID (ID SERIAL NOT NULL, AGENCY VARCHAR(255), DISPLAYORDER INTEGER, OTHERID TEXT, VERSION BIGINT, METADATA_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "studyotherid" already exists
PER01000: Got SQLException executing statement "CREATE TABLE CUSTOMQUESTION (ID SERIAL NOT NULL, HIDDEN BOOLEAN, QUESTIONSTRING VARCHAR(255), QUESTIONTYPE VARCHAR(255), REQUIRED BOOLEAN, GUESTBOOKQUESTIONNAIRE_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "customquestion" already exists
PER01000: Got SQLException executing statement "CREATE TABLE SUMMARYSTATISTICTYPE (ID BIGINT NOT NULL, NAME VARCHAR(255), PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "summarystatistictype" already exists
PER01000: Got SQLException executing statement "CREATE TABLE GUESTBOOKQUESTIONNAIRE (ID SERIAL NOT NULL, EMAILREQUIRED BOOLEAN, ENABLED BOOLEAN, FIRSTNAMEREQUIRED BOOLEAN, INSTITUTIONREQUIRED BOOLEAN, LASTNAMEREQUIRED BOOLEAN, POSITIONREQUIRED BOOLEAN, VDC_ID BIGINT, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "guestbookquestionnaire" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDY_USERGROUP (studies_ID BIGINT NOT NULL, allowedGroups_ID BIGINT NOT NULL, PRIMARY KEY (studies_ID, allowedGroups_ID))": org.postgresql.util.PSQLException: ERROR: relation "study_usergroup" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDY_VDCUSER (studies_ID BIGINT NOT NULL, allowedUsers_ID BIGINT NOT NULL, PRIMARY KEY (studies_ID, allowedUsers_ID))": org.postgresql.util.PSQLException: ERROR: relation "study_vdcuser" already exists
PER01000: Got SQLException executing statement "CREATE TABLE COLL_STUDIES (study_id BIGINT NOT NULL, vdc_collection_id BIGINT NOT NULL, PRIMARY KEY (study_id, vdc_collection_id))": org.postgresql.util.PSQLException: ERROR: relation "coll_studies" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDY_STUDYFIELD (studies_ID BIGINT NOT NULL, summaryFields_ID BIGINT NOT NULL, PRIMARY KEY (studies_ID, summaryFields_ID))": org.postgresql.util.PSQLException: ERROR: relation "study_studyfield" already exists
PER01000: Got SQLException executing statement "CREATE TABLE GROUP_GROUPTYPES (group_type_id BIGINT NOT NULL, group_id BIGINT NOT NULL, PRIMARY KEY (group_type_id, group_id))": org.postgresql.util.PSQLException: ERROR: relation "group_grouptypes" already exists
PER01000: Got SQLException executing statement "CREATE TABLE COLL_ADV_SEARCH_FIELDS (vdc_collection_id BIGINT NOT NULL, study_field_id BIGINT NOT NULL, PRIMARY KEY (vdc_collection_id, study_field_id))": org.postgresql.util.PSQLException: ERROR: relation "coll_adv_search_fields" already exists
PER01000: Got SQLException executing statement "CREATE TABLE COLL_ANY_SEARCH_FIELDS (vdc_collection_id BIGINT NOT NULL, study_field_id BIGINT NOT NULL, PRIMARY KEY (vdc_collection_id, study_field_id))": org.postgresql.util.PSQLException: ERROR: relation "coll_any_search_fields" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDC_LINKED_COLLECTIONS (linked_collection_id BIGINT NOT NULL, vdc_id BIGINT NOT NULL, PRIMARY KEY (linked_collection_id, vdc_id))": org.postgresql.util.PSQLException: ERROR: relation "vdc_linked_collections" already exists
PER01000: Got SQLException executing statement "CREATE TABLE COLL_SEARCH_RESULT_FIELDS (vdc_collection_id BIGINT NOT NULL, study_field_id BIGINT NOT NULL, PRIMARY KEY (vdc_collection_id, study_field_id))": org.postgresql.util.PSQLException: ERROR: relation "coll_search_result_fields" already exists
PER01000: Got SQLException executing statement "CREATE TABLE FLAGGED_STUDY_COMMENTS (study_comment_id BIGINT NOT NULL, user_id BIGINT NOT NULL, PRIMARY KEY (study_comment_id, user_id))": org.postgresql.util.PSQLException: ERROR: relation "flagged_study_comments" already exists
PER01000: Got SQLException executing statement "CREATE TABLE vdc_fileusergroup (allowedfilegroups_id BIGINT NOT NULL, vdc_id BIGINT NOT NULL, PRIMARY KEY (allowedfilegroups_id, vdc_id))": org.postgresql.util.PSQLException: ERROR: relation "vdc_fileusergroup" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYFILE_USERGROUP (allowedGroups_ID BIGINT NOT NULL, studyFiles_ID BIGINT NOT NULL, PRIMARY KEY (allowedGroups_ID, studyFiles_ID))": org.postgresql.util.PSQLException: ERROR: relation "studyfile_usergroup" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDCUSER_USERGROUP (userGroups_ID BIGINT NOT NULL, users_ID BIGINT NOT NULL, PRIMARY KEY (userGroups_ID, users_ID))": org.postgresql.util.PSQLException: ERROR: relation "vdcuser_usergroup" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDC_USERGROUP (allowedGroups_ID BIGINT NOT NULL, vdcs_ID BIGINT NOT NULL, PRIMARY KEY (allowedGroups_ID, vdcs_ID))": org.postgresql.util.PSQLException: ERROR: relation "vdc_usergroup" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDC_ADV_SEARCH_FIELDS (vdc_id BIGINT NOT NULL, study_field_id BIGINT NOT NULL, PRIMARY KEY (vdc_id, study_field_id))": org.postgresql.util.PSQLException: ERROR: relation "vdc_adv_search_fields" already exists
PER01000: Got SQLException executing statement "CREATE TABLE vdc_fileuser (vdc_id BIGINT NOT NULL, allowedfileusers_id BIGINT NOT NULL, PRIMARY KEY (vdc_id, allowedfileusers_id))": org.postgresql.util.PSQLException: ERROR: relation "vdc_fileuser" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDC_ANY_SEARCH_FIELDS (vdc_id BIGINT NOT NULL, study_field_id BIGINT NOT NULL, PRIMARY KEY (vdc_id, study_field_id))": org.postgresql.util.PSQLException: ERROR: relation "vdc_any_search_fields" already exists
PER01000: Got SQLException executing statement "CREATE TABLE SEARCH_RESULT_FIELDS (vdc_id BIGINT NOT NULL, study_field_id BIGINT NOT NULL, PRIMARY KEY (vdc_id, study_field_id))": org.postgresql.util.PSQLException: ERROR: relation "search_result_fields" already exists
PER01000: Got SQLException executing statement "CREATE TABLE SUMMARY_FIELDS (vdc_id BIGINT NOT NULL, study_field_id BIGINT NOT NULL, PRIMARY KEY (vdc_id, study_field_id))": org.postgresql.util.PSQLException: ERROR: relation "summary_fields" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDCGROUP_VDCS (VDC_ID BIGINT NOT NULL, VDCGROUP_ID BIGINT NOT NULL, PRIMARY KEY (VDC_ID, VDCGROUP_ID))": org.postgresql.util.PSQLException: ERROR: relation "vdcgroup_vdcs" already exists
PER01000: Got SQLException executing statement "CREATE TABLE STUDYFILE_VDCUSER (studyFiles_ID BIGINT NOT NULL, allowedUsers_ID BIGINT NOT NULL, PRIMARY KEY (studyFiles_ID, allowedUsers_ID))": org.postgresql.util.PSQLException: ERROR: relation "studyfile_vdcuser" already exists
PER01000: Got SQLException executing statement "CREATE TABLE VDCUSER_STUDYCOMMENT (VDCUser_ID BIGINT NOT NULL, flaggedStudyComments_ID BIGINT NOT NULL, PRIMARY KEY (VDCUser_ID, flaggedStudyComments_ID))": org.postgresql.util.PSQLException: ERROR: relation "vdcuser_studycomment" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDY ADD CONSTRAINT UNQ_STUDY_0 UNIQUE (authority,protocol,studyId)": org.postgresql.util.PSQLException: ERROR: relation "unq_study_0" already exists
PER01000: Got SQLException executing statement "ALTER TABLE PAGEDEF ADD CONSTRAINT UNQ_PAGEDEF_0 UNIQUE (path)": org.postgresql.util.PSQLException: ERROR: relation "unq_pagedef_0" already exists
PER01000: Got SQLException executing statement "ALTER TABLE PAGEDEF ADD CONSTRAINT UNQ_PAGEDEF_1 UNIQUE (name)": org.postgresql.util.PSQLException: ERROR: relation "unq_pagedef_1" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYFILE ADD CONSTRAINT FK_STUDYFILE_STUDY_ID FOREIGN KEY (STUDY_ID) REFERENCES STUDY (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyfile_study_id" for relation "studyfile" already exists
PER01000: Got SQLException executing statement "ALTER TABLE TEMPLATE ADD CONSTRAINT FK_TEMPLATE_VDC_ID FOREIGN KEY (VDC_ID) REFERENCES VDC (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_template_vdc_id" for relation "template" already exists
PER01000: Got SQLException executing statement "ALTER TABLE TEMPLATE ADD CONSTRAINT FK_TEMPLATE_METADATA_ID FOREIGN KEY (METADATA_ID) REFERENCES METADATA (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_template_metadata_id" for relation "template" already exists
PER01000: Got SQLException executing statement "ALTER TABLE LOCKSSSERVER ADD CONSTRAINT FK_LOCKSSSERVER_LOCKSSCONFIG_ID FOREIGN KEY (LOCKSSCONFIG_ID) REFERENCES LOCKSSCONFIG (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_lockssserver_lockssconfig_id" for relation "lockssserver" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYAUTHOR ADD CONSTRAINT FK_STUDYAUTHOR_METADATA_ID FOREIGN KEY (METADATA_ID) REFERENCES METADATA (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyauthor_metadata_id" for relation "studyauthor" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYTOPICCLASS ADD CONSTRAINT FK_STUDYTOPICCLASS_METADATA_ID FOREIGN KEY (METADATA_ID) REFERENCES METADATA (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studytopicclass_metadata_id" for relation "studytopicclass" already exists
PER01000: Got SQLException executing statement "ALTER TABLE VDCROLE ADD CONSTRAINT FK_VDCROLE_ROLE_ID FOREIGN KEY (ROLE_ID) REFERENCES ROLE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdcrole_role_id" for relation "vdcrole" already exists
PER01000: Got SQLException executing statement "ALTER TABLE VDCROLE ADD CONSTRAINT FK_VDCROLE_VDC_ID FOREIGN KEY (VDC_ID) REFERENCES VDC (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdcrole_vdc_id" for relation "vdcrole" already exists
PER01000: Got SQLException executing statement "ALTER TABLE VDCROLE ADD CONSTRAINT FK_VDCROLE_VDCUSER_ID FOREIGN KEY (VDCUSER_ID) REFERENCES VDCUSER (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdcrole_vdcuser_id" for relation "vdcrole" already exists
PER01000: Got SQLException executing statement "ALTER TABLE OAISET ADD CONSTRAINT FK_OAISET_LOCKSSCONFIG_ID FOREIGN KEY (LOCKSSCONFIG_ID) REFERENCES LOCKSSCONFIG (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_oaiset_lockssconfig_id" for relation "oaiset" already exists
PER01000: Got SQLException executing statement "ALTER TABLE VDCACTIVITY ADD CONSTRAINT FK_VDCACTIVITY_VDC_ID FOREIGN KEY (VDC_ID) REFERENCES VDC (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdcactivity_vdc_id" for relation "vdcactivity" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDY ADD CONSTRAINT FK_STUDY_REVIEWER_ID FOREIGN KEY (REVIEWER_ID) REFERENCES VDCUSER (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_study_reviewer_id" for relation "study" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDY ADD CONSTRAINT FK_STUDY_LASTUPDATER_ID FOREIGN KEY (LASTUPDATER_ID) REFERENCES VDCUSER (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_study_lastupdater_id" for relation "study" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDY ADD CONSTRAINT FK_STUDY_TEMPLATE_ID FOREIGN KEY (TEMPLATE_ID) REFERENCES TEMPLATE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_study_template_id" for relation "study" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDY ADD CONSTRAINT FK_STUDY_OWNER_ID FOREIGN KEY (OWNER_ID) REFERENCES VDC (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_study_owner_id" for relation "study" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDY ADD CONSTRAINT FK_STUDY_CREATOR_ID FOREIGN KEY (CREATOR_ID) REFERENCES VDCUSER (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_study_creator_id" for relation "study" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYSOFTWARE ADD CONSTRAINT FK_STUDYSOFTWARE_METADATA_ID FOREIGN KEY (METADATA_ID) REFERENCES METADATA (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studysoftware_metadata_id" for relation "studysoftware" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYOTHERREF ADD CONSTRAINT FK_STUDYOTHERREF_METADATA_ID FOREIGN KEY (METADATA_ID) REFERENCES METADATA (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyotherref_metadata_id" for relation "studyotherref" already exists
PER01000: Got SQLException executing statement "ALTER TABLE CUSTOMQUESTIONVALUE ADD CONSTRAINT FK_CUSTOMQUESTIONVALUE_CUSTOMQUESTION_ID FOREIGN KEY (CUSTOMQUESTION_ID) REFERENCES CUSTOMQUESTION (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_customquestionvalue_customquestion_id" for relation "customquestionvalue" already exists
PER01000: Got SQLException executing statement "ALTER TABLE VARGROUPTYPE ADD CONSTRAINT FK_VARGROUPTYPE_VARGROUPING_ID FOREIGN KEY (VARGROUPING_ID) REFERENCES VARGROUPING (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vargrouptype_vargrouping_id" for relation "vargrouptype" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYRELMATERIAL ADD CONSTRAINT FK_STUDYRELMATERIAL_METADATA_ID FOREIGN KEY (METADATA_ID) REFERENCES METADATA (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyrelmaterial_metadata_id" for relation "studyrelmaterial" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYACCESSREQUEST ADD CONSTRAINT FK_STUDYACCESSREQUEST_STUDY_ID FOREIGN KEY (STUDY_ID) REFERENCES STUDY (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyaccessrequest_study_id" for relation "studyaccessrequest" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYACCESSREQUEST ADD CONSTRAINT FK_STUDYACCESSREQUEST_VDCUSER_ID FOREIGN KEY (VDCUSER_ID) REFERENCES VDCUSER (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyaccessrequest_vdcuser_id" for relation "studyaccessrequest" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYKEYWORD ADD CONSTRAINT FK_STUDYKEYWORD_METADATA_ID FOREIGN KEY (METADATA_ID) REFERENCES METADATA (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studykeyword_metadata_id" for relation "studykeyword" already exists
PER01000: Got SQLException executing statement "ALTER TABLE VARGROUP ADD CONSTRAINT FK_VARGROUP_VARGROUPING_ID FOREIGN KEY (VARGROUPING_ID) REFERENCES VARGROUPING (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vargroup_vargrouping_id" for relation "vargroup" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYFIELDVALUE ADD CONSTRAINT FK_STUDYFIELDVALUE_METADATA_ID FOREIGN KEY (METADATA_ID) REFERENCES METADATA (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyfieldvalue_metadata_id" for relation "studyfieldvalue" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYFIELDVALUE ADD CONSTRAINT FK_STUDYFIELDVALUE_STUDYFIELD_ID FOREIGN KEY (STUDYFIELD_ID) REFERENCES STUDYFIELD (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyfieldvalue_studyfield_id" for relation "studyfieldvalue" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYREQUEST ADD CONSTRAINT FK_STUDYREQUEST_VDCUSER_ID FOREIGN KEY (VDCUSER_ID) REFERENCES VDCUSER (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyrequest_vdcuser_id" for relation "studyrequest" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYREQUEST ADD CONSTRAINT FK_STUDYREQUEST_STUDY_ID FOREIGN KEY (STUDY_ID) REFERENCES STUDY (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studyrequest_study_id" for relation "studyrequest" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYDOWNLOAD ADD CONSTRAINT FK_STUDYDOWNLOAD_STUDY_ID FOREIGN KEY (STUDY_ID) REFERENCES STUDY (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studydownload_study_id" for relation "studydownload" already exists
PER01000: Got SQLException executing statement "ALTER TABLE TWITTERCREDENTIALS ADD CONSTRAINT FK_TWITTERCREDENTIALS_VDC_ID FOREIGN KEY (VDC_ID) REFERENCES VDC (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_twittercredentials_vdc_id" for relation "twittercredentials" already exists
PER01000: Got SQLException executing statement "ALTER TABLE ROLEREQUEST ADD CONSTRAINT FK_ROLEREQUEST_VDCUSER_ID FOREIGN KEY (VDCUSER_ID) REFERENCES VDCUSER (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_rolerequest_vdcuser_id" for relation "rolerequest" already exists
PER01000: Got SQLException executing statement "ALTER TABLE ROLEREQUEST ADD CONSTRAINT FK_ROLEREQUEST_ROLE_ID FOREIGN KEY (ROLE_ID) REFERENCES ROLE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_rolerequest_role_id" for relation "rolerequest" already exists
PER01000: Got SQLException executing statement "ALTER TABLE ROLEREQUEST ADD CONSTRAINT FK_ROLEREQUEST_VDC_ID FOREIGN KEY (VDC_ID) REFERENCES VDC (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_rolerequest_vdc_id" for relation "rolerequest" already exists
PER01000: Got SQLException executing statement "ALTER TABLE GUESTBOOKRESPONSE ADD CONSTRAINT FK_GUESTBOOKRESPONSE_VDCUSER_ID FOREIGN KEY (VDCUSER_ID) REFERENCES VDCUSER (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_guestbookresponse_vdcuser_id" for relation "guestbookresponse" already exists
PER01000: Got SQLException executing statement "ALTER TABLE GUESTBOOKRESPONSE ADD CONSTRAINT FK_GUESTBOOKRESPONSE_GUESTBOOKQUESTIONNAIRE_ID FOREIGN KEY (GUESTBOOKQUESTIONNAIRE_ID) REFERENCES GUESTBOOKQUESTIONNAIRE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_guestbookresponse_guestbookquestionnaire_id" for relation "guestbookresponse" already exists
PER01000: Got SQLException executing statement "ALTER TABLE GUESTBOOKRESPONSE ADD CONSTRAINT FK_GUESTBOOKRESPONSE_STUDYFILE_ID FOREIGN KEY (STUDYFILE_ID) REFERENCES STUDYFILE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_guestbookresponse_studyfile_id" for relation "guestbookresponse" already exists
PER01000: Got SQLException executing statement "ALTER TABLE GUESTBOOKRESPONSE ADD CONSTRAINT FK_GUESTBOOKRESPONSE_STUDY_ID FOREIGN KEY (STUDY_ID) REFERENCES STUDY (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_guestbookresponse_study_id" for relation "guestbookresponse" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYLOCK ADD CONSTRAINT FK_STUDYLOCK_USER_ID FOREIGN KEY (USER_ID) REFERENCES VDCUSER (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studylock_user_id" for relation "studylock" already exists
PER01000: Got SQLException executing statement "ALTER TABLE STUDYLOCK ADD CONSTRAINT FK_STUDYLOCK_STUDY_ID FOREIGN KEY (STUDY_ID) REFERENCES STUDY (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_studylock_study_id" for relation "studylock" already exists
PER01000: Got SQLException executing statement "ALTER TABLE LOCKSSCONFIG ADD CONSTRAINT FK_LOCKSSCONFIG_VDC_ID FOREIGN KEY (VDC_ID) REFERENCES VDC (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_lockssconfig_vdc_id" for relation "lockssconfig" already exists
PER01000: Got SQLException executing statement "ALTER TABLE LOCKSSCONFIG ADD CONSTRAINT FK_LOCKSSCONFIG_LICENSETYPE_ID FOREIGN KEY (LICENSETYPE_ID) REFERENCES LICENSETYPE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_lockssconfig_licensetype_id" for relation "lockssconfig" already exists
PER01000: Got SQLException executing statement "ALTER TABLE VDCGROUPRELATIONSHIP ADD CONSTRAINT FK_VDCGROUPRELATIONSHIP_subgroup_id FOREIGN KEY (subgroup_id) REFERENCES VDCGROUP (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_vdcgrouprelationship_subgroup_id" for relation "vdcgrouprelationship" already exists
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 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 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 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 CUSTOMQUESTIONRESPONSE ADD CONSTRAINT FK_CUSTOMQUESTIONRESPONSE_GUESTBOOKRESPONSE_ID FOREIGN KEY (GUESTBOOKRESPONSE_ID) REFERENCES GUESTBOOKRESPONSE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_customquestionresponse_guestbookresponse_id" for relation "customquestionresponse" already exists
PER01000: Got SQLException executing statement "ALTER TABLE CUSTOMQUESTIONRESPONSE ADD CONSTRAINT FK_CUSTOMQUESTIONRESPONSE_CUSTOMQUESTION_ID FOREIGN KEY (CUSTOMQUESTION_ID) REFERENCES CUSTOMQUESTION (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_customquestionresponse_customquestion_id" for relation "customquestionresponse" 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 CUSTOMQUESTION ADD CONSTRAINT FK_CUSTOMQUESTION_GUESTBOOKQUESTIONNAIRE_ID FOREIGN KEY (GUESTBOOKQUESTIONNAIRE_ID) REFERENCES GUESTBOOKQUESTIONNAIRE (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_customquestion_guestbookquestionnaire_id" for relation "customquestion" already exists
PER01000: Got SQLException executing statement "ALTER TABLE GUESTBOOKQUESTIONNAIRE ADD CONSTRAINT FK_GUESTBOOKQUESTIONNAIRE_VDC_ID FOREIGN KEY (VDC_ID) REFERENCES VDC (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_guestbookquestionnaire_vdc_id" for relation "guestbookquestionnaire" 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.
[root@tofino bin]# ./asadmin list-applications
DVN-web_v3_3 <ejb, web>
Command list-applications executed successfully.
Gustavo Durand
Jan 18, 2013, 5:40:11 PM1/18/13
to dataverse...@googlegroups.com
Those are fine.
Basically on deploy the app tries to create the db tables (for a fresh
install or if new tables were added in that version). For preexisting
tables, you'll see this message, which just means it couldn't (and
didn't have to) create the table.
Basically on deploy the app tries to create the db tables (for a fresh
install or if new tables were added in that version). For preexisting
tables, you'll see this message, which just means it couldn't (and
didn't have to) create the table.
Joerg Messer
Jan 18, 2013, 7:13:50 PM1/18/13
to dataverse...@googlegroups.com
Thanks. Good to know.
Reply all
Reply to author
Forward
0 new messages