ERRORCODE:1008: Data inconsistency in Application tables
Hello,
I'm trying to upgradeour servicedesk application from 10.0 Compilación 10015 to 10.0Compilaton 10500 and I'm getting the following error:
15-ago-2019 18:00:59 [com.adventnet.servicedesk.server.utils.SDDataManager] [Informaci.n] : rootDir :: .\\
15-ago-2019 18:00:59 [com.adventnet.servicedesk.server.utils.SDDataManager] [Informaci.n] : Root Directory in readBuildData method of SDDataManagerClass :---> .\\
15-ago-2019 18:00:59 [com.adventnet.servicedesk.server.utils.SDDataManager] [Informaci.n] : Reading Build Info file :---> .\\\conf\buildInfo.xml
15-ago-2019 18:00:59 [com.adventnet.servicedesk.server.utils.SDDataManager] [Informaci.n] : netutilsData :: {RELEASE={version=10.0}, BUILD={number=10015}}
15-ago-2019 18:00:59 [com.adventnet.servicedesk.server.utils.SDDataManager] [Informaci.n] : rebrandData :: {ADSELFSERVICE={name=ADSelfService Plus}, OPMANAGER={name=OpManager}, PRODUCT={name=ManageEngine ServiceDesk Plus}, ADMANAGER={name=ADManager Plus}}
15-ago-2019 18:01:09 [com.adventnet.servicedesk.updatemgr.util.SDPatchValidatorUtil] [Informaci.n] : Size of Postgres folder in bytes : 1494.62
15-ago-2019 18:01:09 [com.adventnet.servicedesk.updatemgr.util.SDPatchValidatorUtil] [Informaci.n] : Installed drive free space in bytes : 75471.88
15-ago-2019 18:01:09 [com.adventnet.servicedesk.updatemgr.util.SDPatchValidatorUtil] [Informaci.n] : Inside checkTableViewExistInDB method
15-ago-2019 18:01:09 [com.adventnet.servicedesk.updatemgr.util.SDPatchValidatorUtil] [Informaci.n] : Database name ### : postgres
15-ago-2019 18:01:09 [com.adventnet.servicedesk.updatemgr.util.SDPatchValidatorUtil] [Informaci.n] : Going to execute the SQL :: [SELECT APPL_ID FROM SB_Applications WHERE APPL_NAME IN ('MetaPersistence', 'Persistence', 'I18n', 'Audit', 'Authentication', 'Authorization', 'CustomView', 'ClientFramework', 'TaskEngine', 'ClientComponents')]
15-ago-2019 18:01:09 [com.adventnet.servicedesk.updatemgr.util.SDPatchValidatorUtil] [Informaci.n] : Exiting doBackUp() method
15-ago-2019 18:01:09 [com.adventnet.servicedesk.updatemgr.util.SDPatchValidatorUtil] [Informaci.n] : 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 (1, 2, 3, 4, 5, 6, 7, 8, 9, 10)) order by FKColumnDefinition.FK_CONSTRAINT_ID]
15-ago-2019 18:01:09 [com.adventnet.servicedesk.updatemgr.util.SDPatchValidatorUtil] [Informaci.n] : tables skipped for data inconsistency checks are [mssqlerrorcode, expression, mysqlerrorcode, oracleerrorcode, pgsqlerrorcode, adventneterrorcode, servicemetatable]
15-ago-2019 18:01:26 [com.adventnet.servicedesk.updatemgr.util.SDPatchValidatorUtil] [Informaci.n] : Going to execute the SQL :: [SELECT APPL_ID FROM SB_Applications WHERE APPL_NAME IN ('Asset', 'CMDB', 'Helpdesk', 'HelpDeskDynamic', 'ServiceDesk_Client')]
15-ago-2019 18:01:26 [com.adventnet.servicedesk.updatemgr.util.SDPatchValidatorUtil] [Informaci.n] : Exiting doBackUp() method
15-ago-2019 18:01:26 [com.adventnet.servicedesk.updatemgr.util.SDPatchValidatorUtil] [Informaci.n] : 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]
15-ago-2019 18:01:26 [com.adventnet.servicedesk.updatemgr.util.SDPatchValidatorUtil] [Informaci.n] : tables skipped for data inconsistency checks are [mssqlerrorcode, expression, mysqlerrorcode, oracleerrorcode, pgsqlerrorcode, adventneterrorcode, servicemetatable]
15-ago-2019 18:01:29 [com.adventnet.servicedesk.updatemgr.util.SDPatchValidatorUtil] [Informaci.n] : UserDepartment.CIRELATIONSHIPID has some data which is not available in CIRelationships.CIRELATIONSHIPID, COUNT: 15
15-ago-2019 18:02:46 [com.adventnet.servicedesk.updatemgr.util.SDPatchValidatorUtil] [Informaci.n] : Migration aborted due to data inconsistency. This may create issues during migration, so aborting now
15-ago-2019 18:02:46 [com.adventnet.persistence.DefaultPatchValidator] [Grave] : The Patch cannot be applied becasue of the following Reason(s):
ERRORCODE:1008: Data inconsistency in Application tables
How can i solve this?
Thanks!