When updating ManageEngine SDP using the console to version 14600 from version 14505, it writes an error "The patch cannot be applied further as some exception occurred during pre-validation. Hint Refer logs for more details.". I also provide information from the log file.
Jan 23, 2025 7:37:24 PM [com.adventnet.db.adapter.postgres.DefaultPostgresDBInitializer] [INFO] : Command to be executed [C:\ManageEngine\ServiceDesk\bin\\..\pgsql\bin\postgres.exe, -V]
Jan 23, 2025 7:37:24 PM [com.adventnet.db.adapter.Jdbc20DBAdapter] [INFO] : DB Version :: 11.17
Jan 23, 2025 7:37:24 PM [com.adventnet.db.adapter.Jdbc20DBAdapter] [INFO] : DB Architecture :: 64
Jan 23, 2025 7:37:24 PM [com.adventnet.db.adapter.Jdbc20DBAdapter] [INFO] : DB Data Directory :: C:/ManageEngine/ServiceDesk/pgsql/data
Jan 23, 2025 7:37:24 PM [com.adventnet.persistence.xml.DynamicValueHandlerRepositry] [INFO] : Going to load DVH :: jar:file:/C:/ManageEngine/ServiceDesk/lib/AdvPersistence.jar!/com/adventnet/db/persistence/metadata/conf/dynamic-value-handlers.xml
Jan 23, 2025 7:37:24 PM [com.adventnet.iam.security.SecurityUtil] [WARNING] : Unable to Load LogClientThreadLocalClass . Class Name : com.zoho.logs.logclient.LogClientThreadLocal, Exception java.lang.ClassNotFoundException: com.zoho.logs.logclient.LogClientThreadLocal
Jan 23, 2025 7:37:24 PM [com.adventnet.db.persistence.metadata.MetaDataEntityResolver] [INFO] : Entered resolveEntity2 :: systemId :: [data-dictionary.dtd], publicId :: [null], name :: [[dtd]], baseURI :: [null]
Jan 23, 2025 7:37:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [INFO] : Parsing the File :: file:/C:/ManageEngine/ServiceDesk/lib/AdvPersistence.jar!/com/adventnet/db/persistence/metadata/conf/meta-dd.xml
Jan 23, 2025 7:37:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : The isBidirectional attribute is no longer supported from MICKEYLITE_5000.Please remove this attribute in foreign key[Appl_id]
Jan 23, 2025 7:37:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : Foreign key name Appl_id is same as a column name in the table TableDetails
Jan 23, 2025 7:37:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : The isBidirectional attribute is no longer supported from MICKEYLITE_5000.Please remove this attribute in foreign key[ColumnDetails_FK1]
Jan 23, 2025 7:37:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : The isBidirectional attribute is no longer supported from MICKEYLITE_5000.Please remove this attribute in foreign key[RangeValues_FK1]
Jan 23, 2025 7:37:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : The isBidirectional attribute is no longer supported from MICKEYLITE_5000.Please remove this attribute in foreign key[AllowedValues_FK1]
Jan 23, 2025 7:37:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : The isBidirectional attribute is no longer supported from MICKEYLITE_5000.Please remove this attribute in foreign key[AllowedPattern_FK1]
Jan 23, 2025 7:37:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : The isBidirectional attribute is no longer supported from MICKEYLITE_5000.Please remove this attribute in foreign key[ConstraintDefinition_FK1]
Jan 23, 2025 7:37:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : The isBidirectional attribute is no longer supported from MICKEYLITE_5000.Please remove this attribute in foreign key[UniqueKeyDefinition_FK1]
Jan 23, 2025 7:37:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : The isBidirectional attribute is no longer supported from MICKEYLITE_5000.Please remove this attribute in foreign key[UniqueKeyDefinition_FK2]
Jan 23, 2025 7:37:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : The isBidirectional attribute is no longer supported from MICKEYLITE_5000.Please remove this attribute in foreign key[PKDefinition_FK1]
Jan 23, 2025 7:37:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : The isBidirectional attribute is no longer supported from MICKEYLITE_5000.Please remove this attribute in foreign key[PKDefinition_FK2]
Jan 23, 2025 7:37:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : The isBidirectional attribute is no longer supported from MICKEYLITE_5000.Please remove this attribute in foreign key[FKDefinition_FK1]
Jan 23, 2025 7:37:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : The isBidirectional attribute is no longer supported from MICKEYLITE_5000.Please remove this attribute in foreign key[FKDefinition_FK2]
Jan 23, 2025 7:37:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : The isBidirectional attribute is no longer supported from MICKEYLITE_5000.Please remove this attribute in foreign key[FKColumnDefinition_FK1]
Jan 23, 2025 7:37:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : The isBidirectional attribute is no longer supported from MICKEYLITE_5000.Please remove this attribute in foreign key[FKColumnDefinition_FK2]
Jan 23, 2025 7:37:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : The isBidirectional attribute is no longer supported from MICKEYLITE_5000.Please remove this attribute in foreign key[FKColumnDefinition_FK3]
Jan 23, 2025 7:37:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : The isBidirectional attribute is no longer supported from MICKEYLITE_5000.Please remove this attribute in foreign key[IndexDefinition_FK1]
Jan 23, 2025 7:37:24 PM [com.adventnet.db.persistence.metadata.parser.DataDictionaryParser] [WARNING] : The isBidirectional attribute is no longer supported from MICKEYLITE_5000.Please remove this attribute in foreign key[IndexDefinition_FK2]
Jan 23, 2025 7:37:25 PM [com.adventnet.persistence.PersistenceInitializer] [INFO] : loaded the module dd :: Persistence
Jan 23, 2025 7:37:25 PM [com.adventnet.persistence.PersistenceInitializer] [INFO] : persURL :: jar:file:/C:/ManageEngine/ServiceDesk/lib/AdvPersistence.jar!/com/adventnet/db/persistence/metadata/conf/personality-configuration.xml
Jan 23, 2025 7:37:25 PM [com.adventnet.persistence.xml.XmlParser] [INFO] : Going to parse the XML :: [jar:file:/C:/ManageEngine/ServiceDesk/lib/AdvPersistence.jar!/com/adventnet/db/persistence/metadata/conf/personality-configuration.xml]
Jan 23, 2025 7:37:25 PM [com.adventnet.persistence.PersistenceInitializer] [INFO] : No Preprocessor found.
Jan 23, 2025 7:37:25 PM [com.adventnet.persistence.PersistenceInitializer] [INFO] : Going to loadErrorCodes :: [C:\ManageEngine\ServiceDesk\conf\Persistence\error-codes.xml]
Jan 23, 2025 7:37:25 PM [com.adventnet.persistence.xml.XmlParser] [INFO] : Going to parse the XML :: [file:/C:/ManageEngine/ServiceDesk/conf/Persistence/error-codes.xml]
Jan 23, 2025 7:37:25 PM [com.adventnet.persistence.PersistenceInitializer] [SEVERE] : Already an errorcode [1,217] has been defined, hence over-writing it
Jan 23, 2025 7:37:25 PM [com.adventnet.persistence.PersistenceInitializer] [SEVERE] : Already an errorcode [1,451] has been defined, hence over-writing it
Jan 23, 2025 7:37:25 PM [com.adventnet.persistence.PersistenceInitializer] [SEVERE] : Already an errorcode [547] has been defined, hence over-writing it
Jan 23, 2025 7:37:25 PM [com.adventnet.persistence.PersistenceInitializer] [INFO] : ErrorCodes :: {MySQLErrorCode={1216=1015 - ER_NO_REFERENCED_ROW, 1217=1016 - ER_ROW_IS_REFERENCED, 1058=1008 - ER_WRONG_VALUE_COUNT, 1062=1001 - ER_DUP_ENTRY, 1063=1010 - ER_WRONG_FIELD_SPEC, 1097=1014 - ER_TOO_BIG_SET, 1291=1003 - ER_DUPLICATED_VALUE_IN_TYPE, 1067=1012 - ER_INVALID_DEFAULT, 1451=1016 - ER_ROW_IS_REFERENCED, 1452=1015 - ER_NO_REFERENCED_ROW, 1166=1011 - ER_WRONG_COLUMN_NAME, 1230=1013 - ER_NO_DEFAULT, 1263=1006 - ER_WARN_NULL_TO_NOTNULL, 1231=1017 - ER_WRONG_VALUE_FOR_VAR, 1264=1018 - ER_WARN_DATA_OUT_OF_RANGE, 1232=1019 - ER_WRONG_TYPE_FOR_VAR, 1138=1005 - ER_INVALID_USE_OF_NULL, 1171=1007 - ER_PRIMARY_CANT_HAVE_NULL, 1140=1032 - ER_MIX_OF_GROUP_FUNC_AND_FIELDS, 1205=1024 - ER_LOCK_WAIT_TIMEOUT, 1206=1025 - ER_LOCK_TABLE_FULL, 1111=1031 - ER_INVALID_GROUP_FUNC_USE, 1048=1004 - ER_BAD_NULL_ERROR, 1213=1027 - ER_LOCK_DEADLOCK}, PgSQLErrorCode={23505=1001 - ER_DUP_ENTRY, 42703=1011 - ER_WRONG_COLUMN_NAME, 22001=1018 - ER_WARN_DATA_OUT_OF_RANGE, 22P02=1017 - ER_WRONG_VALUE_FOR_VAR, 22003=1014 - ER_TOO_BIG_SET, 42601=1008 - ER_WRONG_VALUE_COUNT, 23502=1004 - ER_BAD_NULL_ERROR, 23503=1015 - ER_NO_REFERENCED_ROW}, AdventNetErrorCode={1024=1024 - ER_LOCK_WAIT_TIMEOUT, 1025=1025 - ER_LOCK_TABLE_FULL, 1027=1027 - ER_LOCK_DEADLOCK, 1031=1031 - ER_INVALID_GROUP_FUNC_USE, 1032=1032 - ER_MIX_OF_GROUP_FUNC_AND_FIELDS, 1001=1001 - ER_DUP_ENTRY, 1003=1003 - ER_DUPLICATED_VALUE_IN_TYPE, 1004=1004 - ER_BAD_NULL_ERROR, 1005=1005 - ER_INVALID_USE_OF_NULL, 1006=1006 - ER_WARN_NULL_TO_NOTNULL, 1007=1007 - ER_PRIMARY_CANT_HAVE_NULL, 1008=1008 - ER_WRONG_VALUE_COUNT, 1010=1010 - ER_WRONG_FIELD_SPEC, 1011=1011 - ER_WRONG_COLUMN_NAME, 1012=1012 - ER_INVALID_DEFAULT, 1013=1013 - ER_NO_DEFAULT, 1014=1014 - ER_TOO_BIG_SET, 1015=1015 - ER_NO_REFERENCED_ROW, 1016=1016 - ER_ROW_IS_REFERENCED, 1017=1017 - ER_WRONG_VALUE_FOR_VAR, 1018=1018 - ER_WARN_DATA_OUT_OF_RANGE, 1019=1019 - ER_WRONG_TYPE_FOR_VAR}, MsSQLErrorCode={8114=1017 - ER_WRONG_VALUE_FOR_VAR, 2627=1001 - ER_DUP_ENTRY, 515=1004 - ER_BAD_NULL_ERROR, 8115=1014 - ER_TOO_BIG_SET, 547=1016 - ER_ROW_IS_REFERENCED, 8152=1018 - ER_WARN_DATA_OUT_OF_RANGE, 2601=1001 - ER_DUP_ENTRY, 109=1008 - ER_WRONG_VALUE_COUNT, 110=1008 - ER_WRONG_VALUE_COUNT, 207=1011 - ER_WRONG_COLUMN_NAME}}