Upgrade failed from 11129 to 11200
in upgrade from 11129 to 11200 , got error in every try , the error in section dropping tables & specific UserAdditionalFileds Table , i drop any data in this table and any additional filed in application , but every time run updatemanager , i got this error :
Jul 12, 2023 2:27:55 AM [SYSERR] [INFO] : com.adventnet.persistence.DataAccessException: This table [UserAdditionalFields] cannot be dropped because it has these [UserAdditionalFields_multiselect, UserAdditionalFields_history] tables dependent on it.
Jul 12, 2023 2:27:55 AM [SYSERR] [INFO] : at com.adventnet.persistence.DataAccess.dropTable(DataAccess.java:3971)
Jul 12, 2023 2:27:55 AM [SYSERR] [INFO] : at com.adventnet.persistence.DataAccess.dropTable(DataAccess.java:3943)
Jul 12, 2023 2:27:55 AM [SYSERR] [INFO] : at com.adventnet.persistence.migration.MigrationUtil.executeQuery(MigrationUtil.java:455)
Jul 12, 2023 2:27:55 AM [SYSERR] [INFO] : at com.adventnet.persistence.migration.MigrationUtil.applyDDLChanges(MigrationUtil.java:158)
Jul 12, 2023 2:27:55 AM [SYSERR] [INFO] : at com.adventnet.persistence.migration.MigrationUtil.applyDDLChanges(MigrationUtil.java:87)
Jul 12, 2023 2:27:55 AM [SYSERR] [INFO] : at com.adventnet.persistence.migration.MigrationUtil.applyDDLChanges(MigrationUtil.java:228)
Jul 12, 2023 2:27:55 AM [SYSERR] [INFO] : at com.adventnet.persistence.DefaultPostProcessor.updateDDs(DefaultPostProcessor.java:658)
Jul 12, 2023 2:27:55 AM [SYSERR] [INFO] : at com.zoho.iam.migration.IAMPostProcessor.updateDDs(IAMPostProcessor.java:30)
Jul 12, 2023 2:27:55 AM [SYSERR] [INFO] : at com.zoho.mickeyclient.migration.MickeyClientPostProcessor.updateDDs(MickeyClientPostProcessor.java:110)
Jul 12, 2023 2:27:55 AM [SYSERR] [INFO] : at com.manageengine.servicedesk.updatemgr.util.ESMPostProcessor.updateDDs(ESMPostProcessor.java:56)
Jul 12, 2023 2:27:55 AM [SYSERR] [INFO] : at com.adventnet.persistence.DefaultPostProcessor.installPatch(DefaultPostProcessor.java:2069)
Jul 12, 2023 2:27:55 AM [SYSERR] [INFO] : at com.adventnet.servicedesk.updatemgr.util.SDPostProcessor.installPatch(SDPostProcessor.java:73)
Jul 12, 2023 2:27:55 AM [SYSERR] [INFO] : at com.adventnet.persistence.DefaultPostProcessor.install(DefaultPostProcessor.java:1424)
Jul 12, 2023 2:27:55 AM [SYSERR] [INFO] : at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
Jul 12, 2023 2:27:55 AM [SYSERR] [INFO] : at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
Jul 12, 2023 2:27:55 AM [SYSERR] [INFO] : at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
Jul 12, 2023 2:27:55 AM [SYSERR] [INFO] : at java.lang.reflect.Method.invoke(Method.java:498)
Jul 12, 2023 2:27:55 AM [SYSERR] [INFO] : at com.adventnet.tools.update.installer.Unzipper.contextPostInstallation(Unzipper.java:1698)
Jul 12, 2023 2:27:55 AM [SYSERR] [INFO] : at com.adventnet.tools.update.installer.Unzipper.invokePostInstallationClasses(Unzipper.java:1494)
Jul 12, 2023 2:27:55 AM [SYSERR] [INFO] : at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPatch.java:415)
Jul 12, 2023 2:27:55 AM [SYSERR] [INFO] : at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:266)
Jul 12, 2023 2:27:55 AM [SYSERR] [INFO] : at java.lang.Thread.run(Thread.java:748)
Jul 12, 2023 2:27:55 AM [com.adventnet.persistence.DefaultPostProcessor] [INFO] : Invoking postInstall() method
Jul 12, 2023 2:27:55 AM [com.adventnet.persistence.DefaultPostProcessor] [INFO] : Going to take backup of jreCorrector script files.
Jul 12, 2023 2:27:55 AM [com.adventnet.persistence.DefaultPostProcessor] [INFO] : Creating backup of wrapper conf before updating classpath
Jul 12, 2023 2:27:55 AM [com.zoho.framework.utils.FileUtils] [INFO] : Entered into copyFile :: sourceFile :: [C:\ManageEngine\ServiceDesk\conf\wrapper.conf], destinationFile :: [Patch\AdventNet_ManageEngine_ServiceDesk_Plus-11.1.0-SP-1.0.0\SERVICEDESK\wrapperConf\wrapper.conf]
Jul 12, 2023 2:27:55 AM [com.adventnet.persistence.DefaultPostProcessor] [INFO] : Conf.jar entry is already present in wrapper.conf
Jul 12, 2023 2:27:55 AM [com.adventnet.persistence.DefaultPostProcessor] [INFO] : Creating backup of wrapper conf before updating classpath
Jul 12, 2023 2:27:55 AM [com.zoho.framework.utils.FileUtils] [INFO] : Entered into copyFile :: sourceFile :: [C:\ManageEngine\ServiceDesk\conf\wrapper_linux.conf], destinationFile :: [Patch\AdventNet_ManageEngine_ServiceDesk_Plus-11.1.0-SP-1.0.0\SERVICEDESK\wrapperConf\wrapper_linux.conf]
Jul 12, 2023 2:27:55 AM [com.adventnet.persistence.DefaultPostProcessor] [INFO] : Conf.jar entry is already present in wrapper_linux.conf
Jul 12, 2023 2:27:55 AM [com.adventnet.persistence.DefaultPostProcessor] [INFO] : Returning from DefaultPostProcessor install with the value :: 9
Jul 12, 2023 2:27:55 AM [com.adventnet.tools.update.installer.RevertPatch] [INFO] : Uninstalling post invocation classes
Jul 12, 2023 2:27:55 AM [com.adventnet.tools.update.installer.RevertPatch] [INFO] : Executing class:com/adventnet/servicedesk/updatemgr/util/SDPostProcessor.class
Jul 12, 2023 2:27:55 AM [com.manageengine.servicedesk.updatemgr.util.ESMPostProcessor] [SEVERE] : Inside ESMPostProcessor()
Jul 12, 2023 2:27:55 AM [com.adventnet.servicedesk.updatemgr.util.SDPostProcessor] [SEVERE] : Inside SDPostProcessor()
Jul 12, 2023 2:27:55 AM [com.adventnet.servicedesk.updatemgr.util.SDPostProcessorUtil] [SEVERE] : Inside SDPostProcessor.
Jul 12, 2023 2:27:55 AM [com.adventnet.persistence.DefaultPostProcessor] [INFO] : Entering Into :: DefaultPostProcessor :: revert
Jul 12, 2023 2:27:55 AM [com.adventnet.persistence.DefaultPostProcessor] [INFO] : properties in DefaultPostProcessor :: revert :: {version=11.0.0, patchversion=AdventNet_ManageEngine_ServiceDesk_Plus-11.1.0-SP-1.0.0, context=SERVICEDESK, doxml.listener=com.adventnet.servicedesk.updatemgr.util.SDPDOXMLChangeListener, ddxml.listener=com.adventnet.persistence.SDPDDChangeListener, product=AdventNet ManageEngine ServiceDesk Plus, mode=true, home=C:\ManageEngine\ServiceDesk}
Jul 12, 2023 2:27:55 AM [com.adventnet.persistence.DefaultPostProcessor] [INFO] : Invoking preRevert() method.
Jul 12, 2023 2:27:55 AM [com.adventnet.servicedesk.updatemgr.util.SDPostProcessor] [SEVERE] : Inside preRevert() of SDPostProcessor
Jul 12, 2023 2:27:55 AM [com.adventnet.servicedesk.updatemgr.util.MigrationUtil] [INFO] : INFO mesaage --->Failure , Please check the link
Jul 12, 2023 2:27:55 AM [com.adventnet.servicedesk.updatemgr.util.MigrationUtil] [INFO] : INFO mode --->true
Jul 12, 2023 2:27:55 AM [com.adventnet.servicedesk.updatemgr.util.MigrationUtil] [INFO] : INFO messageType --->showMessageDialog
Jul 12, 2023 2:28:00 AM [com.adventnet.servicedesk.updatemgr.util.MigrationUtil] [INFO] : CurrentBuildNo :11200 PreviousBuildNo:null