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

book

Article ID: 52497

calendar_today

Updated On:

Products

CA Automation Suite for Data Centers - Configuration Automation CA Client Automation - Asset Management CA Client Automation - IT Client Manager CA Client Automation CA Client Automation - Remote Control CA Client Automation - Asset Intelligence CA Client Automation - Desktop Migration Manager CA Client Automation - Patch Manager CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER CA Server Automation CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

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.

Environment

Release: UASIT.99000-11.2-Asset Intelligence
Component: