Upgrade from DSM version r11.2 SP4 to ITCM r12 fails with error code 1603 when the MDB is shared with Service Desk.
The install_mdb.log shows the following error:
ERROR - com.microsoft.sqlserver.jdbc.SQLServerException: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "$ca_di_r000002ac00000000". The conflict occurred in database "mdb", table "dbo.ca_asset_source", column 'asset_source_uuid'."
Please execute following queries:
As per product DTSVMG problem# 1147 it should read as follows:
If either of the queries above return results, please open an issue with ITCM/DSM Technical support to request the patch for problem # 1147.
Release: UASIT.99000-11.2-Asset Intelligence