Lifetime: Unable to upgrade database schema

Lifetime: Unable to upgrade database schema

I just pushed our DEV changes to TEST and PROD using Lifetime. TEST had no problems but in PROD, the deployment was completed but with the following errors:

1. Unable to upgrade database schema. Error trying to create foreign key on database field 'OSUSR_9se_WfApprovalPolicy.ICONNAME'.
2. Unable to find the specified file.
Details : System.IO.FileNotFoundException: Unable to find the specified file.
   at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
   at System.IO.FileInfo.MoveTo(String destFileName)
   at OutSystems.HubEdition.ServerCommon.Utils.PlatformUtils.FileMove(String fromFile, String toFile)
   at #2bo.#Hio.#68l.#Oio(String finalSuffix)
   at #2bo.#Hio.#oio(String eSpaceName, String testAreaName, String initialSuffix, String finalSuffix)
   at #2bo.#uJk.#gfo(String eSpaceName, Boolean forRedeployOnly, Int32 eSpaceVersionId, String userName, Boolean partial, String uniqueId, Boolean fromSS)

The second error happened aftter the log: Deploying 'ERP_WF_Model', which is the eSpace containing the entity for WfApprovalPolicy.

I checked the DEV and TEST database
have their tables correctly deployed:

While PROD is a different story: