I'm receiving error when trying to upgrade service desk plus from 11200 to 12000, below is updatemgrlog0 file error log:
10/01/2022 12:57:52 [com.adventnet.persistence.migration.MigrationUtil] [INFO] : Going to execute query :: ALTER TABLE Lifecycle DROP CONSTRAINT IF EXISTS Lifecycle_UK1, isExecutable :: true
10/01/2022 12:57:52 [com.adventnet.persistence.migration.MigrationUtil] [INFO] : Invoking PreListener
10/01/2022 12:57:52 [com.adventnet.persistence.SDPDDChangeListener] [INFO] : PreInvokeForAlterTable : Table Name ----> Lifecycle
10/01/2022 12:57:52 [com.adventnet.persistence.SDPDDChangeListener] [INFO] : PreInvokeForAlterTable : HelpdeskId ----> null
10/01/2022 12:57:52 [com.adventnet.persistence.SDPDDChangeListener] [INFO] : PreInvokeForAlterTable : Operation ----> 5
10/01/2022 12:57:52 [com.adventnet.persistence.migration.MigrationUtil] [INFO] : PreListener reteurns true
10/01/2022 12:57:52 [SYSERR] [INFO] : com.adventnet.persistence.DataAccessException: No constraint with this name [Lifecycle_UK1] is defined
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.DataAccess.alterTable(DataAccess.java:3883)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.DataAccess.alterTable(DataAccess.java:3610)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.migration.MigrationUtil.executeQuery(MigrationUtil.java:340)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.migration.MigrationUtil.applyDDLChanges(MigrationUtil.java:158)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.migration.MigrationUtil.applyDDLChanges(MigrationUtil.java:87)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.migration.MigrationUtil.applyDDLChanges(MigrationUtil.java:228)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.DefaultPostProcessor.updateDDs(DefaultPostProcessor.java:658)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.zoho.iam.migration.IAMPostProcessor.updateDDs(IAMPostProcessor.java:30)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.zoho.mickeyclient.migration.MickeyClientPostProcessor.updateDDs(MickeyClientPostProcessor.java:110)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.manageengine.servicedesk.updatemgr.util.ESMPostProcessor.updateDDs(ESMPostProcessor.java:65)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.DefaultPostProcessor.installPatch(DefaultPostProcessor.java:2069)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.servicedesk.updatemgr.util.SDPostProcessor.installPatch(SDPostProcessor.java:78)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.DefaultPostProcessor.install(DefaultPostProcessor.java:1424)
10/01/2022 12:57:52 [SYSERR] [INFO] : at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
10/01/2022 12:57:52 [SYSERR] [INFO] : at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
10/01/2022 12:57:52 [SYSERR] [INFO] : at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
10/01/2022 12:57:52 [SYSERR] [INFO] : at java.lang.reflect.Method.invoke(Method.java:498)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.tools.update.installer.Unzipper.contextPostInstallation(Unzipper.java:1698)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.tools.update.installer.Unzipper.invokePostInstallationClasses(Unzipper.java:1494)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPatch.java:415)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:266)
10/01/2022 12:57:52 [SYSERR] [INFO] : at java.lang.Thread.run(Thread.java:748)
10/01/2022 12:57:52 [SYSERR] [INFO] : Caused by: com.adventnet.db.persistence.metadata.MetaDataException: No constraint with this name [Lifecycle_UK1] is defined
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.db.persistence.metadata.util.LocalMetaDataInfo.validate_Table_Constraint_Name(LocalMetaDataInfo.java:1682)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.db.persistence.metadata.util.LocalMetaDataInfo.validateAlterTableQuery(LocalMetaDataInfo.java:1763)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.db.persistence.metadata.util.MetaDataUtil.validateAlterTableQuery(MetaDataUtil.java:1554)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.DataAccess.alterTable(DataAccess.java:3733)
10/01/2022 12:57:52 [SYSERR] [INFO] : ... 21 more
10/01/2022 12:57:52 [com.adventnet.persistence.migration.MigrationUtil] [INFO] : Invoking handleException
10/01/2022 12:57:52 [SYSERR] [INFO] : com.adventnet.persistence.DataAccessException: No constraint with this name [Lifecycle_UK1] is defined
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.DataAccess.alterTable(DataAccess.java:3883)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.DataAccess.alterTable(DataAccess.java:3610)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.migration.MigrationUtil.executeQuery(MigrationUtil.java:340)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.migration.MigrationUtil.applyDDLChanges(MigrationUtil.java:158)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.migration.MigrationUtil.applyDDLChanges(MigrationUtil.java:87)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.migration.MigrationUtil.applyDDLChanges(MigrationUtil.java:228)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.DefaultPostProcessor.updateDDs(DefaultPostProcessor.java:658)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.zoho.iam.migration.IAMPostProcessor.updateDDs(IAMPostProcessor.java:30)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.zoho.mickeyclient.migration.MickeyClientPostProcessor.updateDDs(MickeyClientPostProcessor.java:110)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.manageengine.servicedesk.updatemgr.util.ESMPostProcessor.updateDDs(ESMPostProcessor.java:65)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.DefaultPostProcessor.installPatch(DefaultPostProcessor.java:2069)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.servicedesk.updatemgr.util.SDPostProcessor.installPatch(SDPostProcessor.java:78)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.DefaultPostProcessor.install(DefaultPostProcessor.java:1424)
10/01/2022 12:57:52 [SYSERR] [INFO] : at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
10/01/2022 12:57:52 [SYSERR] [INFO] : at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
10/01/2022 12:57:52 [SYSERR] [INFO] : at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
10/01/2022 12:57:52 [SYSERR] [INFO] : at java.lang.reflect.Method.invoke(Method.java:498)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.tools.update.installer.Unzipper.contextPostInstallation(Unzipper.java:1698)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.tools.update.installer.Unzipper.invokePostInstallationClasses(Unzipper.java:1494)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPatch.java:415)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:266)
10/01/2022 12:57:52 [SYSERR] [INFO] : at java.lang.Thread.run(Thread.java:748)
10/01/2022 12:57:52 [SYSERR] [INFO] : Caused by: com.adventnet.db.persistence.metadata.MetaDataException: No constraint with this name [Lifecycle_UK1] is defined
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.db.persistence.metadata.util.LocalMetaDataInfo.validate_Table_Constraint_Name(LocalMetaDataInfo.java:1682)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.db.persistence.metadata.util.LocalMetaDataInfo.validateAlterTableQuery(LocalMetaDataInfo.java:1763)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.db.persistence.metadata.util.MetaDataUtil.validateAlterTableQuery(MetaDataUtil.java:1554)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.DataAccess.alterTable(DataAccess.java:3733)
10/01/2022 12:57:52 [SYSERR] [INFO] : ... 21 more
10/01/2022 12:57:52 [com.adventnet.persistence.DefaultPostProcessor] [INFO] : Reverting Module changes started.....
10/01/2022 12:57:52 [com.adventnet.persistence.DefaultPostProcessor] [INFO] : Reverting Module changes completed.....
10/01/2022 12:57:52 [SYSERR] [INFO] : com.adventnet.persistence.DataAccessException: No constraint with this name [Lifecycle_UK1] is defined
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.DataAccess.alterTable(DataAccess.java:3883)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.DataAccess.alterTable(DataAccess.java:3610)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.migration.MigrationUtil.executeQuery(MigrationUtil.java:340)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.migration.MigrationUtil.applyDDLChanges(MigrationUtil.java:158)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.migration.MigrationUtil.applyDDLChanges(MigrationUtil.java:87)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.migration.MigrationUtil.applyDDLChanges(MigrationUtil.java:228)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.DefaultPostProcessor.updateDDs(DefaultPostProcessor.java:658)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.zoho.iam.migration.IAMPostProcessor.updateDDs(IAMPostProcessor.java:30)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.zoho.mickeyclient.migration.MickeyClientPostProcessor.updateDDs(MickeyClientPostProcessor.java:110)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.manageengine.servicedesk.updatemgr.util.ESMPostProcessor.updateDDs(ESMPostProcessor.java:65)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.DefaultPostProcessor.installPatch(DefaultPostProcessor.java:2069)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.servicedesk.updatemgr.util.SDPostProcessor.installPatch(SDPostProcessor.java:78)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.DefaultPostProcessor.install(DefaultPostProcessor.java:1424)
10/01/2022 12:57:52 [SYSERR] [INFO] : at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
10/01/2022 12:57:52 [SYSERR] [INFO] : at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
10/01/2022 12:57:52 [SYSERR] [INFO] : at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
10/01/2022 12:57:52 [SYSERR] [INFO] : at java.lang.reflect.Method.invoke(Method.java:498)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.tools.update.installer.Unzipper.contextPostInstallation(Unzipper.java:1698)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.tools.update.installer.Unzipper.invokePostInstallationClasses(Unzipper.java:1494)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPatch.java:415)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:266)
10/01/2022 12:57:52 [SYSERR] [INFO] : at java.lang.Thread.run(Thread.java:748)
10/01/2022 12:57:52 [SYSERR] [INFO] : Caused by: com.adventnet.db.persistence.metadata.MetaDataException: No constraint with this name [Lifecycle_UK1] is defined
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.db.persistence.metadata.util.LocalMetaDataInfo.validate_Table_Constraint_Name(LocalMetaDataInfo.java:1682)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.db.persistence.metadata.util.LocalMetaDataInfo.validateAlterTableQuery(LocalMetaDataInfo.java:1763)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.db.persistence.metadata.util.MetaDataUtil.validateAlterTableQuery(MetaDataUtil.java:1554)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.DataAccess.alterTable(DataAccess.java:3733)
10/01/2022 12:57:52 [SYSERR] [INFO] : ... 21 more
10/01/2022 12:57:52 [com.adventnet.servicedesk.updatemgr.util.SDPostProcessor] [INFO] : Problem during installation of patch {0}com.adventnet.persistence.DataAccessException: No constraint with this name [Lifecycle_UK1] is defined
at com.adventnet.persistence.DataAccess.alterTable(DataAccess.java:3883)
at com.adventnet.persistence.DataAccess.alterTable(DataAccess.java:3610)
at com.adventnet.persistence.migration.MigrationUtil.executeQuery(MigrationUtil.java:340)
at com.adventnet.persistence.migration.MigrationUtil.applyDDLChanges(MigrationUtil.java:158)
at com.adventnet.persistence.migration.MigrationUtil.applyDDLChanges(MigrationUtil.java:87)
at com.adventnet.persistence.migration.MigrationUtil.applyDDLChanges(MigrationUtil.java:228)
at com.adventnet.persistence.DefaultPostProcessor.updateDDs(DefaultPostProcessor.java:658)
at com.zoho.iam.migration.IAMPostProcessor.updateDDs(IAMPostProcessor.java:30)
at com.zoho.mickeyclient.migration.MickeyClientPostProcessor.updateDDs(MickeyClientPostProcessor.java:110)
at com.manageengine.servicedesk.updatemgr.util.ESMPostProcessor.updateDDs(ESMPostProcessor.java:65)
at com.adventnet.persistence.DefaultPostProcessor.installPatch(DefaultPostProcessor.java:2069)
at com.adventnet.servicedesk.updatemgr.util.SDPostProcessor.installPatch(SDPostProcessor.java:78)
at com.adventnet.persistence.DefaultPostProcessor.install(DefaultPostProcessor.java:1424)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at com.adventnet.tools.update.installer.Unzipper.contextPostInstallation(Unzipper.java:1698)
at com.adventnet.tools.update.installer.Unzipper.invokePostInstallationClasses(Unzipper.java:1494)
at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPatch.java:415)
at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:266)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.adventnet.db.persistence.metadata.MetaDataException: No constraint with this name [Lifecycle_UK1] is defined
at com.adventnet.db.persistence.metadata.util.LocalMetaDataInfo.validate_Table_Constraint_Name(LocalMetaDataInfo.java:1682)
at com.adventnet.db.persistence.metadata.util.LocalMetaDataInfo.validateAlterTableQuery(LocalMetaDataInfo.java:1763)
at com.adventnet.db.persistence.metadata.util.MetaDataUtil.validateAlterTableQuery(MetaDataUtil.java:1554)
at com.adventnet.persistence.DataAccess.alterTable(DataAccess.java:3733)
... 21 more
10/01/2022 12:57:52 [SYSERR] [INFO] : com.adventnet.persistence.DataAccessException: No constraint with this name [Lifecycle_UK1] is defined
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.DataAccess.alterTable(DataAccess.java:3883)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.DataAccess.alterTable(DataAccess.java:3610)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.migration.MigrationUtil.executeQuery(MigrationUtil.java:340)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.migration.MigrationUtil.applyDDLChanges(MigrationUtil.java:158)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.migration.MigrationUtil.applyDDLChanges(MigrationUtil.java:87)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.migration.MigrationUtil.applyDDLChanges(MigrationUtil.java:228)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.DefaultPostProcessor.updateDDs(DefaultPostProcessor.java:658)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.zoho.iam.migration.IAMPostProcessor.updateDDs(IAMPostProcessor.java:30)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.zoho.mickeyclient.migration.MickeyClientPostProcessor.updateDDs(MickeyClientPostProcessor.java:110)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.manageengine.servicedesk.updatemgr.util.ESMPostProcessor.updateDDs(ESMPostProcessor.java:65)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.DefaultPostProcessor.installPatch(DefaultPostProcessor.java:2069)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.servicedesk.updatemgr.util.SDPostProcessor.installPatch(SDPostProcessor.java:78)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.DefaultPostProcessor.install(DefaultPostProcessor.java:1424)
10/01/2022 12:57:52 [SYSERR] [INFO] : at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
10/01/2022 12:57:52 [SYSERR] [INFO] : at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
10/01/2022 12:57:52 [SYSERR] [INFO] : at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
10/01/2022 12:57:52 [SYSERR] [INFO] : at java.lang.reflect.Method.invoke(Method.java:498)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.tools.update.installer.Unzipper.contextPostInstallation(Unzipper.java:1698)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.tools.update.installer.Unzipper.invokePostInstallationClasses(Unzipper.java:1494)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPatch.java:415)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:266)
10/01/2022 12:57:52 [SYSERR] [INFO] : at java.lang.Thread.run(Thread.java:748)
10/01/2022 12:57:52 [SYSERR] [INFO] : Caused by: com.adventnet.db.persistence.metadata.MetaDataException: No constraint with this name [Lifecycle_UK1] is defined
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.db.persistence.metadata.util.LocalMetaDataInfo.validate_Table_Constraint_Name(LocalMetaDataInfo.java:1682)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.db.persistence.metadata.util.LocalMetaDataInfo.validateAlterTableQuery(LocalMetaDataInfo.java:1763)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.db.persistence.metadata.util.MetaDataUtil.validateAlterTableQuery(MetaDataUtil.java:1554)
10/01/2022 12:57:52 [SYSERR] [INFO] : at com.adventnet.persistence.DataAccess.alterTable(DataAccess.java:3733)
10/01/2022 12:57:52 [SYSERR] [INFO] : ... 21 more
10/01/2022 12:57:52 [com.adventnet.persistence.PersistenceInitializer] [INFO] : Going to stop the DBServer
10/01/2022 12:57:52 [com.adventnet.persistence.PersistenceInitializer] [INFO] : Template replaced url :: jdbc:postgresql://localhost:65432/servicedesk?charSet=UTF-8&loginTimeout=5&socketTimeout=1200&connectTimeout=5
10/01/2022 12:57:52 [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : C:\Program Files\ManageEngine\ServiceDesk\bin\..\pgsql\bin\pg_isready.exe isExists :: true
10/01/2022 12:57:52 [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Stopping PgSQL Server ...