Stream: troubleshooting

Topic: Error in installation

view this post on Zulip Santiago Moreno (May 10 2025 at 15:50):

I am having the following problem when installing dataverse
PER01003: Deployment encountered SQL Exceptions:
PER01000: Got SQLException executing statement "ALTER TABLE fileaccessrequests ADD CONSTRAINT FK_fileaccessrequests_DATAFILE_ID FOREIGN KEY (DATAFILE_ID) REFERENCES DVOBJECT (ID)": org.postgresql.util.PSQLException: ERROR: constraint "fk_fileaccessrequests_datafile_id" for relation "fileaccessrequests" already exists
Command deploy failed.
Failed to deploy the application!
I tried reinstalling Postgress, deleting the dvndb database, deleting the cache, and the error persists.
I don't know what else to do :'c

view this post on Zulip Philip Durbin 🚀 (May 12 2025 at 11:54):

@Santiago Moreno can you please attach your server.log file?

view this post on Zulip Don Sizemore (May 12 2025 at 16:30):

@Santiago Moreno the "already exists" error should print for most everything in the database. what version are you installing, and have you looked for ConfigCheck errors farther up in server.log?

view this post on Zulip Notification Bot (Jun 16 2025 at 13:00):

This topic was moved here from #community > Error in installation by Dimitri Szabo.

view this post on Zulip Dimitri Szabo (Jun 16 2025 at 13:00):

While this is being solved, moving into troubleshoting :)

Last updated: Oct 30 2025 at 05:14 UTC