Upgrade from DSM version r11.2 SP4 to ITCM r12 fails with error code "1603".

Document ID : KB000052497
Last Modified Date : 14/02/2018
Show Technical Document Details

Description

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'."

Solution

Please execute following queries:

As per product DTSVMG problem# 1147 it should read as follows:

  1. SELECT asset_source_uuid FROM ca_discovered_hardware WHERE asset_source_uuid NOT IN (SELECT asset_source_uuid FROM ca_asset_source)

  2. Select asset_source_uuid from ca_discovered_software where asset_source_uuid NOT IN(select asset_source_uuid from ca_asset_source)

If either of the queries above return results, please open an issue with ITCM/DSM Technical support to request the patch for problem # 1147.