Hello,

I'm trying to upgrade our servicedesk application from 10.0, 10013 to SP1 and i'm getting the following error:

13-aug-2019 14:25:50 [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]

13-aug-2019 14:25:50 [com.adventnet.servicedesk.updatemgr.util.SDPatchValidatorUtil] [INFO] : tables skipped for data inconsistency checks are [mssqlerrorcode, expression, mysqlerrorcode, oracleerrorcode, pgsqlerrorcode, adventneterrorcode, servicemetatable]

13-aug-2019 14:25:51 [com.adventnet.servicedesk.updatemgr.util.SDPatchValidatorUtil] [INFO] : WorkStationRI.WORKSTATIONID has some data which is not available in SystemInfo.WORKSTATIONID, COUNT: 1

13-aug-2019 14:25:53 [com.adventnet.servicedesk.updatemgr.util.SDPatchValidatorUtil] [INFO] : Migration aborted due to data inconsistency. This may create issues during migration, so aborting now

13-aug-2019 14:25:53 [com.adventnet.persistence.DefaultPatchValidator] [SEVERE] : The Patch cannot be applied becasue of the following Reason(s):

How can i solve this?

Thanks!