Upgrade from 7022 to 7500 Failed - Error Uninstalling
After installing a fresh new copy of 7022 on a test server, then restoring a full backup of my production 7022 environment i tried to do an upgrade to 7500 but recieved the error - Error Uninstalling.
This was the log from the updatemgrlog0.txt, any ideas??
-----------------------------------------------------------------------------------------------
Nov 27, 2008 2:32:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : A column cannot have a unique constraint as true, if it alone participates in the PKDefinition of that tableDefinition. TableName :: RoboTaskList, columnNames :: [ROBOTASKID]
Nov 27, 2008 2:32:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : A column cannot have a unique constraint as true, if it alone participates in the PKDefinition of that tableDefinition. TableName :: RoboTaskConfig, columnNames :: [UID]
Nov 27, 2008 2:32:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : A column cannot have a unique constraint as true, if it alone participates in the PKDefinition of that tableDefinition. TableName :: RoboSuccessOptions, columnNames :: [ROBOTASKID]
Nov 27, 2008 2:32:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : A column cannot have a unique constraint as true, if it alone participates in the PKDefinition of that tableDefinition. TableName :: RoboFailureOptions, columnNames :: [ROBOTASKID]
Nov 27, 2008 2:32:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : A column cannot have a unique constraint as true, if it alone participates in the PKDefinition of that tableDefinition. TableName :: CustomFilter_Details, columnNames :: [FILTERID]
Nov 27, 2008 2:32:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : A column cannot have a unique constraint as true, if it alone participates in the PKDefinition of that tableDefinition. TableName :: CustomFilter_SQL, columnNames :: [FILTERID]
Nov 27, 2008 2:32:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : A column cannot have a unique constraint as true, if it alone participates in the PKDefinition of that tableDefinition. TableName :: GlobalViews, columnNames :: [VIEWID]
Nov 27, 2008 2:32:24 PM [com.adventnet.updatemgr.conf.DataModelUpdater] [INFO] : ISReverting : true : isJarFile false : newLocation Patch\AdventNet_ManageEngine_ServiceDesk_Plus-7.0.0-SP-3.0.0\SERVICEDESK\/applications/AdventNetServiceDesk.eear/AdventNetHelpDesk.ear/conf/data-dictionary.xml : dd : com.adventnet.db.persistence.metadata.DataDictionary@12334e4
Nov 27, 2008 2:32:24 PM [com.adventnet.updatemgr.conf.DataModelUpdater] [INFO] : *************************************************************************
Nov 27, 2008 2:32:24 PM [com.adventnet.updatemgr.conf.DataModelUpdater] [INFO] : Going to update :- applications/AdventNetServerContainer.eear/AdventNetSecurity.ear/conf/data-dictionary.xml
Nov 27, 2008 2:32:24 PM [com.adventnet.updatemgr.conf.DataModelUpdater] [INFO] : *************************************************************************
Nov 27, 2008 2:32:24 PM [com.adventnet.updatemgr.conf.DataModelUpdater] [INFO] : ISReverting : true : isJarFile false : newLocation Patch\AdventNet_ManageEngine_ServiceDesk_Plus-7.0.0-SP-3.0.0\SERVICEDESK\/applications/AdventNetServerContainer.eear/AdventNetSecurity.ear/conf/data-dictionary.xml : dd : com.adventnet.db.persistence.metadata.DataDictionary@65696b
Nov 27, 2008 2:32:24 PM [com.adventnet.updatemgr.conf.DataModelUpdater] [INFO] : ****************************************************************************
Nov 27, 2008 2:32:24 PM [com.adventnet.updatemgr.conf.DataModelUpdater] [INFO] : Going to update = com.adventnet.db.persistence.metadata.DataDictionary@bbfa4c
Nov 27, 2008 2:32:24 PM [com.adventnet.updatemgr.conf.DataModelUpdater] [INFO] : Going to update = com.adventnet.db.persistence.metadata.DataDictionary@12334e4
Nov 27, 2008 2:32:24 PM [com.adventnet.updatemgr.conf.DataModelUpdater] [INFO] : Going to update = com.adventnet.db.persistence.metadata.DataDictionary@65696b
Nov 27, 2008 2:32:24 PM [com.adventnet.updatemgr.conf.DataModelUpdater] [INFO] : ****************************************************************************
Nov 27, 2008 2:32:26 PM [com.adventnet.db.adapter.DBInitializer] [INFO] : Command to stop DB server [cmd, /c, .\\bin\stopDB.bat, 33366, root]
Nov 27, 2008 2:32:36 PM [com.adventnet.updatemgr.conf.SDPConfFilesUpdator] [INFO] : Problem during installation of patch com.adventnet.db.persistence.metadata.MetaDataException: Data model cannot be modified reverted to old
at com.adventnet.updatemgr.util.ConfUtils.applyDDChanges(ConfUtils.java:693)
at com.adventnet.updatemgr.util.ConfUtils.applyDataModelChanges(ConfUtils.java:630)
at com.adventnet.updatemgr.util.ConfUtils.invoke(ConfUtils.java:941)
at com.adventnet.updatemgr.conf.SDPConfFilesUpdator.install(SDPConfFilesUpdator.java:45)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.adventnet.tools.update.installer.Unzipper.contextPostInstallation(Unzipper.java:1405)
at com.adventnet.tools.update.installer.Unzipper.invokePostInstallationClasses(Unzipper.java:1237)
at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPatch.java:289)
at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:223)
at java.lang.Thread.run(Unknown Source)
Caused by: com.adventnet.persistence.DataAccessException: Allowed values cannot be set while adding column : newCol
<ColumnDefinition>
<tablename>SDUser</tableName>
<columnname>STATUS</columnname>
<datatype>CHAR</dataType>
<max-size>0</max-size>
<isnullable>true</isnullable>
<isunique>false</isUnique>
<defaultvalue>ACTIVE</defaultvalue>
<sequencegenerator>null</sequencegenerator>
<constraints>null</constraints>
<allowedvalues>com.adventnet.db.persistence.metadata.AllowedValues@1c8e60</allowedvalues>
</ColumnDefinition> old col
<ColumnDefinition>
<tablename>SDUser</tableName>
<columnname>STATUS</columnname>
<datatype>CHAR</dataType>
<max-size>0</max-size>
<isnullable>true</isnullable>
<isunique>false</isUnique>
<defaultvalue>ACTIVE</defaultvalue>
<sequencegenerator>null</sequencegenerator>
<constraints>null</constraints>
<allowedvalues>null</allowedvalues>
</ColumnDefinition>
at com.adventnet.persistence.SchemaUpdateUtil.genBasedOncolumn(SchemaUpdateUtil.java:730)
at com.adventnet.persistence.SchemaUpdateUtil.alterTable(SchemaUpdateUtil.java:472)
at com.adventnet.persistence.SchemaUpdateUtil.updateDataModel(SchemaUpdateUtil.java:115)
at com.adventnet.updatemgr.conf.DataModelUpdater.updateDataModel(DataModelUpdater.java:221)
at com.adventnet.updatemgr.util.ConfUtils.applyDDChanges(ConfUtils.java:659)
... 12 more
Nov 27, 2008 2:32:39 PM [com.adventnet.tools.update.installer.RevertPatch] [INFO] : lib\startupclasses.jar
Nov 27, 2008 2:32:48 PM [com.adventnet.tools.update.installer.RevertPatch] [INFO] : lib\AdventNetNPrevalent.jar
Nov 27, 2008 2:32:49 PM [com.adventnet.tools.update.installer.RevertPatch] [INFO] : server\default\lib\Authorization.jar
Nov 27, 2008 2:32:50 PM [com.adventnet.tools.update.installer.RevertPatch] [INFO] : server\default\lib\Audit.jar
Nov 27, 2008 2:32:51 PM [com.adventnet.tools.update.installer.RevertPatch] [INFO] : server\default\lib\AuthenticationFramework.jar
Nov 27, 2008 2:32:54 PM [com.adventnet.tools.update.installer.RevertPatch] [INFO] : server\default\lib\AdventNetPersistence.jar
Nov 27, 2008 2:32:58 PM [com.adventnet.tools.update.installer.RevertPatch] [INFO] : lib\SDeskWmi.dll
Nov 27, 2008 2:32:58 PM [com.adventnet.tools.update.installer.RevertPatch] [INFO] : lib\ADAuth.dll
Nov 27, 2008 2:32:58 PM [com.adventnet.tools.update.installer.RevertPatch] [INFO] : lib\WMIData.dll
Nov 27, 2008 2:32:58 PM [com.adventnet.tools.update.installer.RevertPatch] [INFO] : README.html
This was the log from the updatemgrlog0.txt, any ideas??
-----------------------------------------------------------------------------------------------
Nov 27, 2008 2:32:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : A column cannot have a unique constraint as true, if it alone participates in the PKDefinition of that tableDefinition. TableName :: RoboTaskList, columnNames :: [ROBOTASKID]
Nov 27, 2008 2:32:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : A column cannot have a unique constraint as true, if it alone participates in the PKDefinition of that tableDefinition. TableName :: RoboTaskConfig, columnNames :: [UID]
Nov 27, 2008 2:32:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : A column cannot have a unique constraint as true, if it alone participates in the PKDefinition of that tableDefinition. TableName :: RoboSuccessOptions, columnNames :: [ROBOTASKID]
Nov 27, 2008 2:32:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : A column cannot have a unique constraint as true, if it alone participates in the PKDefinition of that tableDefinition. TableName :: RoboFailureOptions, columnNames :: [ROBOTASKID]
Nov 27, 2008 2:32:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : A column cannot have a unique constraint as true, if it alone participates in the PKDefinition of that tableDefinition. TableName :: CustomFilter_Details, columnNames :: [FILTERID]
Nov 27, 2008 2:32:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : A column cannot have a unique constraint as true, if it alone participates in the PKDefinition of that tableDefinition. TableName :: CustomFilter_SQL, columnNames :: [FILTERID]
Nov 27, 2008 2:32:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : A column cannot have a unique constraint as true, if it alone participates in the PKDefinition of that tableDefinition. TableName :: GlobalViews, columnNames :: [VIEWID]
Nov 27, 2008 2:32:24 PM [com.adventnet.updatemgr.conf.DataModelUpdater] [INFO] : ISReverting : true : isJarFile false : newLocation Patch\AdventNet_ManageEngine_ServiceDesk_Plus-7.0.0-SP-3.0.0\SERVICEDESK\/applications/AdventNetServiceDesk.eear/AdventNetHelpDesk.ear/conf/data-dictionary.xml : dd : com.adventnet.db.persistence.metadata.DataDictionary@12334e4
Nov 27, 2008 2:32:24 PM [com.adventnet.updatemgr.conf.DataModelUpdater] [INFO] : *************************************************************************
Nov 27, 2008 2:32:24 PM [com.adventnet.updatemgr.conf.DataModelUpdater] [INFO] : Going to update :- applications/AdventNetServerContainer.eear/AdventNetSecurity.ear/conf/data-dictionary.xml
Nov 27, 2008 2:32:24 PM [com.adventnet.updatemgr.conf.DataModelUpdater] [INFO] : *************************************************************************
Nov 27, 2008 2:32:24 PM [com.adventnet.updatemgr.conf.DataModelUpdater] [INFO] : ISReverting : true : isJarFile false : newLocation Patch\AdventNet_ManageEngine_ServiceDesk_Plus-7.0.0-SP-3.0.0\SERVICEDESK\/applications/AdventNetServerContainer.eear/AdventNetSecurity.ear/conf/data-dictionary.xml : dd : com.adventnet.db.persistence.metadata.DataDictionary@65696b
Nov 27, 2008 2:32:24 PM [com.adventnet.updatemgr.conf.DataModelUpdater] [INFO] : ****************************************************************************
Nov 27, 2008 2:32:24 PM [com.adventnet.updatemgr.conf.DataModelUpdater] [INFO] : Going to update = com.adventnet.db.persistence.metadata.DataDictionary@bbfa4c
Nov 27, 2008 2:32:24 PM [com.adventnet.updatemgr.conf.DataModelUpdater] [INFO] : Going to update = com.adventnet.db.persistence.metadata.DataDictionary@12334e4
Nov 27, 2008 2:32:24 PM [com.adventnet.updatemgr.conf.DataModelUpdater] [INFO] : Going to update = com.adventnet.db.persistence.metadata.DataDictionary@65696b
Nov 27, 2008 2:32:24 PM [com.adventnet.updatemgr.conf.DataModelUpdater] [INFO] : ****************************************************************************
Nov 27, 2008 2:32:26 PM [com.adventnet.db.adapter.DBInitializer] [INFO] : Command to stop DB server [cmd, /c, .\\bin\stopDB.bat, 33366, root]
Nov 27, 2008 2:32:36 PM [com.adventnet.updatemgr.conf.SDPConfFilesUpdator] [INFO] : Problem during installation of patch com.adventnet.db.persistence.metadata.MetaDataException: Data model cannot be modified reverted to old
at com.adventnet.updatemgr.util.ConfUtils.applyDDChanges(ConfUtils.java:693)
at com.adventnet.updatemgr.util.ConfUtils.applyDataModelChanges(ConfUtils.java:630)
at com.adventnet.updatemgr.util.ConfUtils.invoke(ConfUtils.java:941)
at com.adventnet.updatemgr.conf.SDPConfFilesUpdator.install(SDPConfFilesUpdator.java:45)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.adventnet.tools.update.installer.Unzipper.contextPostInstallation(Unzipper.java:1405)
at com.adventnet.tools.update.installer.Unzipper.invokePostInstallationClasses(Unzipper.java:1237)
at com.adventnet.tools.update.installer.ApplyPatch.installPatch(ApplyPatch.java:289)
at com.adventnet.tools.update.installer.ApplyPatch.run(ApplyPatch.java:223)
at java.lang.Thread.run(Unknown Source)
Caused by: com.adventnet.persistence.DataAccessException: Allowed values cannot be set while adding column : newCol
<ColumnDefinition>
<tablename>SDUser</tableName>
<columnname>STATUS</columnname>
<datatype>CHAR</dataType>
<max-size>0</max-size>
<isnullable>true</isnullable>
<isunique>false</isUnique>
<defaultvalue>ACTIVE</defaultvalue>
<sequencegenerator>null</sequencegenerator>
<constraints>null</constraints>
<allowedvalues>com.adventnet.db.persistence.metadata.AllowedValues@1c8e60</allowedvalues>
</ColumnDefinition> old col
<ColumnDefinition>
<tablename>SDUser</tableName>
<columnname>STATUS</columnname>
<datatype>CHAR</dataType>
<max-size>0</max-size>
<isnullable>true</isnullable>
<isunique>false</isUnique>
<defaultvalue>ACTIVE</defaultvalue>
<sequencegenerator>null</sequencegenerator>
<constraints>null</constraints>
<allowedvalues>null</allowedvalues>
</ColumnDefinition>
at com.adventnet.persistence.SchemaUpdateUtil.genBasedOncolumn(SchemaUpdateUtil.java:730)
at com.adventnet.persistence.SchemaUpdateUtil.alterTable(SchemaUpdateUtil.java:472)
at com.adventnet.persistence.SchemaUpdateUtil.updateDataModel(SchemaUpdateUtil.java:115)
at com.adventnet.updatemgr.conf.DataModelUpdater.updateDataModel(DataModelUpdater.java:221)
at com.adventnet.updatemgr.util.ConfUtils.applyDDChanges(ConfUtils.java:659)
... 12 more
Nov 27, 2008 2:32:39 PM [com.adventnet.tools.update.installer.RevertPatch] [INFO] : lib\startupclasses.jar
Nov 27, 2008 2:32:48 PM [com.adventnet.tools.update.installer.RevertPatch] [INFO] : lib\AdventNetNPrevalent.jar
Nov 27, 2008 2:32:49 PM [com.adventnet.tools.update.installer.RevertPatch] [INFO] : server\default\lib\Authorization.jar
Nov 27, 2008 2:32:50 PM [com.adventnet.tools.update.installer.RevertPatch] [INFO] : server\default\lib\Audit.jar
Nov 27, 2008 2:32:51 PM [com.adventnet.tools.update.installer.RevertPatch] [INFO] : server\default\lib\AuthenticationFramework.jar
Nov 27, 2008 2:32:54 PM [com.adventnet.tools.update.installer.RevertPatch] [INFO] : server\default\lib\AdventNetPersistence.jar
Nov 27, 2008 2:32:58 PM [com.adventnet.tools.update.installer.RevertPatch] [INFO] : lib\SDeskWmi.dll
Nov 27, 2008 2:32:58 PM [com.adventnet.tools.update.installer.RevertPatch] [INFO] : lib\ADAuth.dll
Nov 27, 2008 2:32:58 PM [com.adventnet.tools.update.installer.RevertPatch] [INFO] : lib\WMIData.dll
Nov 27, 2008 2:32:58 PM [com.adventnet.tools.update.installer.RevertPatch] [INFO] : README.html