23.05.2019 22:34:04 [com.adventnet.servicedesk.updatemgr.util.SDPatchValidatorUtil] [INFO] : Going to execute the SQL :: [select t1.TABLE_NAME as LOCALTABLE, c1.COLUMN_NAME as LOCALCOLUMN, t2.TABLE_NAME AS REFTABLE, c2.COLUMN_NAME AS REFCOLUMN, FKColumnDefinition.FK_CONSTRAINT_ID from FKColumnDefinition inner join ColumnDetails c1 on FKColumnDefinition.FK_LOCAL_COL_ID=c1.COLUMN_ID inner join ColumnDetails c2 on FKColumnDefinition.FK_REF_COL_ID=c2.COLUMN_ID inner join TableDetails as t1 on c1.TABLE_ID=t1.TABLE_ID inner join TableDetails t2 on c2.TABLE_ID=t2.TABLE_ID inner join FKDefinition on FKColumnDefinition.FK_CONSTRAINT_ID=FKDefinition.FK_CONSTRAINT_ID where FKDefinition.FK_REF_TABLE_ID in (SELECT TABLE_ID FROM TableDetails WHERE APPL_ID IN (11, 12, 13, 14, 15)) order by FKColumnDefinition.FK_CONSTRAINT_ID] 23.05.2019 22:34:04 [com.adventnet.servicedesk.updatemgr.util.SDPatchValidatorUtil] [INFO] : tables skipped for data inconsistency checks are [mssqlerrorcode, expression, mysqlerrorcode, oracleerrorcode, pgsqlerrorcode, adventneterrorcode, servicemetatable, recentitems, audithistory, auditoperation, aaaaccsessionaudit, aaaacchttpsession, aaaaccsessionprop, aaaaccsession, auditrecord, operationauditrecord, auditresultproperty, auditresourceprop, auditoperproperty] 23.05.2019 22:34:20 [com.adventnet.servicedesk.updatemgr.util.SDPatchValidatorUtil] [INFO] : BaseElement.CIID has some data which is not available in CI.CIID, COUNT: 1 23.05.2019 22:34:22 [com.adventnet.servicedesk.updatemgr.util.SDPatchValidatorUtil] [INFO] : Migration aborted due to data inconsistency. This may create issues during migration, so aborting now 23.05.2019 22:34:22 [com.adventnet.persistence.DefaultPatchValidator] [SEVERE] : The Patch cannot be applied becasue of the following Reason(s): ERRORCODE:1008: Data inconsistency in Application tables To find solutions for these error codes, check here. https://www.manageengine.com/products/service-desk/faq-general-modules.html#Validation |