SQL Warnings on Deployment of WAR File to Test Instance

[ofahimIQSS]

Description:
After deploying the WAR file to the test instance, the deployment completes successfully but generates a long list of SQL warnings. These warnings may indicate potential issues with schema creation or conflicts with existing database objects. The full log file is attached for analysis.

Steps to Reproduce:

1. Build the WAR file from the repository.
2. Deploy the WAR file to the test instance.
3. Review the server logs for warnings during the deployment process.

Expected Behavior:
The deployment should succeed without any SQL warnings.

Observed Behavior:
Deployment succeeded, but the server logs contain numerous SQL warnings.

Environment Details:

Deployment Instance: beehive.dataverse.org
Build: v. 6.4 build 1672-82dad99
Database: PostgreSQL
Application Server: [Specify server details]
WAR File Version: v6.4 Development

Sample Warnings:

PER01003: Deployment encountered SQL Exceptions:
PER01000: Got SQLException executing statement "CREATE TABLE EXTERNALTOOLTYPE (ID SERIAL NOT NULL, TYPE VARCHAR(255) NOT NULL, EXTERNALTOOL_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "externaltooltype" already exists
PER01000: Got SQLException executing statement "CREATE INDEX INDEX_EXTERNALTOOLTYPE_externaltool_id ON EXTERNALTOOLTYPE (externaltool_id)": org.postgresql.util.PSQLException: ERROR: relation "index_externaltooltype_externaltool_id" already exists
PER01000: Got SQLException executing statement "CREATE TABLE DATAVERSETHEME (ID SERIAL NOT NULL, BACKGROUNDCOLOR VARCHAR(255), LINKCOLOR VARCHAR(255), LINKURL VARCHAR(255), LOGO VARCHAR(255), ... PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "dataversetheme" already exists
PER01000: Got SQLException executing statement "CREATE INDEX INDEX_DATAVERSETHEME_dataverse_id ON DATAVERSETHEME (dataverse_id)": org.postgresql.util.PSQLException: ERROR: relation "index_dataversetheme_dataverse_id" already exists
PER01000: Got SQLException executing statement "CREATE TABLE DATAFILECATEGORY (ID SERIAL NOT NULL, NAME VARCHAR(255) NOT NULL, DATASET_ID BIGINT NOT NULL, PRIMARY KEY (ID))": org.postgresql.util.PSQLException: ERROR: relation "datafilecategory" already exists

Log File:
Deployment Warnings Log.txt