Problem updationg from SD MSP 10538 to 10600

Problem updationg from SD MSP 10538 to 10600

Hi, i am trying to upgrade from 10538 to 10600 but during  patch installation i get error:
Any ideas what is  - No constraint with this name [OutgoingEWSServer_UK0] is defined

(full update log attached)
14.01.2023 17:37:40  [com.adventnet.servicedesk.updatemgr.util.SDPostProcessor]  [INFO] : Problem during installation of patch {0}com.adventnet.persistence.DataAccessException: No constraint with this name [OutgoingEWSServer_UK0] is defined
at com.adventnet.persistence.DataAccess.alterTable(DataAccess.java:3885)
at com.adventnet.persistence.DataAccess.alterTable(DataAccess.java:3615)
at com.adventnet.persistence.migration.MigrationUtil.executeQuery(MigrationUtil.java:339)
at com.adventnet.persistence.migration.MigrationUtil.applyDDLChanges(MigrationUtil.java:145)
at com.adventnet.persistence.migration.MigrationUtil.applyDDLChanges(MigrationUtil.java:86)
at com.adventnet.persistence.migration.MigrationUtil.applyDDLChanges(MigrationUtil.java:227)
at com.adventnet.persistence.DefaultPostProcessor.updateDDs(DefaultPostProcessor.java:638)
at com.adventnet.persistence.DefaultPostProcessor.installPatch(DefaultPostProcessor.java:1758)
at com.adventnet.servicedesk.updatemgr.util.SDPostProcessor.installPatch(SDPostProcessor.java:77)
at com.adventnet.persistence.DefaultPostProcessor.install(DefaultPostProcessor.java:1420)
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:1716)
at com.adventnet.tools.update.installer.Unzipper.invokePostInstallationClasses(Unzipper.java:1505)
at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPatch.java:498)
at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:286)
at java.lang.Thread.run(Thread.java:748)
Caused by: com.adventnet.db.persistence.metadata.MetaDataException: No constraint with this name [OutgoingEWSServer_UK0] is defined
at com.adventnet.db.persistence.metadata.util.LocalMetaDataInfo.validate_Table_Constraint_Name(LocalMetaDataInfo.java:1681)
at com.adventnet.db.persistence.metadata.util.LocalMetaDataInfo.validateAlterTableQuery(LocalMetaDataInfo.java:1762)
at com.adventnet.db.persistence.metadata.util.MetaDataUtil.validateAlterTableQuery(MetaDataUtil.java:1549)
at com.adventnet.persistence.DataAccess.alterTable(DataAccess.java:3738)
... 18 more

14.01.2023 17:37:40  [SYSERR]  [INFO] : com.adventnet.persistence.DataAccessException: No constraint with this name [OutgoingEWSServer_UK0] is defined
14.01.2023 17:37:40  [SYSERR]  [INFO] :  at com.adventnet.persistence.DataAccess.alterTable(DataAccess.java:3885)
14.01.2023 17:37:40  [SYSERR]  [INFO] :  at com.adventnet.persistence.DataAccess.alterTable(DataAccess.java:3615)
14.01.2023 17:37:40  [SYSERR]  [INFO] :  at com.adventnet.persistence.migration.MigrationUtil.executeQuery(MigrationUtil.java:339)
14.01.2023 17:37:40  [SYSERR]  [INFO] :  at com.adventnet.persistence.migration.MigrationUtil.applyDDLChanges(MigrationUtil.java:145)
14.01.2023 17:37:40  [SYSERR]  [INFO] :  at com.adventnet.persistence.migration.MigrationUtil.applyDDLChanges(MigrationUtil.java:86)
14.01.2023 17:37:40  [SYSERR]  [INFO] :  at com.adventnet.persistence.migration.MigrationUtil.applyDDLChanges(MigrationUtil.java:227)
14.01.2023 17:37:40  [SYSERR]  [INFO] :  at com.adventnet.persistence.DefaultPostProcessor.updateDDs(DefaultPostProcessor.java:638)
14.01.2023 17:37:40  [SYSERR]  [INFO] :  at com.adventnet.persistence.DefaultPostProcessor.installPatch(DefaultPostProcessor.java:1758)
14.01.2023 17:37:40  [SYSERR]  [INFO] :  at com.adventnet.servicedesk.updatemgr.util.SDPostProcessor.installPatch(SDPostProcessor.java:77)
14.01.2023 17:37:40  [SYSERR]  [INFO] :  at com.adventnet.persistence.DefaultPostProcessor.install(DefaultPostProcessor.java:1420)
14.01.2023 17:37:40  [SYSERR]  [INFO] :  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
14.01.2023 17:37:40  [SYSERR]  [INFO] :  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
14.01.2023 17:37:40  [SYSERR]  [INFO] :  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
14.01.2023 17:37:40  [SYSERR]  [INFO] :  at java.lang.reflect.Method.invoke(Method.java:498)
14.01.2023 17:37:40  [SYSERR]  [INFO] :  at com.adventnet.tools.update.installer.Unzipper.contextPostInstallation(Unzipper.java:1716)
14.01.2023 17:37:40  [SYSERR]  [INFO] :  at com.adventnet.tools.update.installer.Unzipper.invokePostInstallationClasses(Unzipper.java:1505)
14.01.2023 17:37:40  [SYSERR]  [INFO] :  at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPatch.java:498)
14.01.2023 17:37:40  [SYSERR]  [INFO] :  at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:286)
14.01.2023 17:37:40  [SYSERR]  [INFO] :  at java.lang.Thread.run(Thread.java:748)
14.01.2023 17:37:40  [SYSERR]  [INFO] : Caused by: com.adventnet.db.persistence.metadata.MetaDataException: No constraint with this name [OutgoingEWSServer_UK0] is defined
14.01.2023 17:37:40  [SYSERR]  [INFO] :  at com.adventnet.db.persistence.metadata.util.LocalMetaDataInfo.validate_Table_Constraint_Name(LocalMetaDataInfo.java:1681)
14.01.2023 17:37:40  [SYSERR]  [INFO] :  at com.adventnet.db.persistence.metadata.util.LocalMetaDataInfo.validateAlterTableQuery(LocalMetaDataInfo.java:1762)
14.01.2023 17:37:40  [SYSERR]  [INFO] :  at com.adventnet.db.persistence.metadata.util.MetaDataUtil.validateAlterTableQuery(MetaDataUtil.java:1549)
14.01.2023 17:37:40  [SYSERR]  [INFO] :  at com.adventnet.persistence.DataAccess.alterTable(DataAccess.java:3738)
14.01.2023 17:37:40  [SYSERR]  [INFO] :  ... 18 more

updatemgrlog0.txt.1
      • Topic Participants

      • ivan

                  New to ADSelfService Plus?