Service Catalog install: configuring components failed

Products

• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

While performing the installation of CA Service Catalog 17.1 it can fail at the "Configuring Components" task if there are existing stored procedures and configurations in the database from previous installs.

Environment

Release:
Component: USVCT

Resolution

> Step 1: 

Run the following query on MDB using MS SQL server management studio: 

delete from ca_application_registration where product_code in(2007,2012) 

> Step 2: 

Now Open USMHOME/config.properties and make following changes: 

setup.utility.active = true 
setup.components.installed = WEBSERVER 
component.catalog = false 

> Step 3: 

Now Open USMHOME/view/conf/config.properties and make following changes: 

setup.utility.active = true 
setup.components.installed = WEBSERVER 
component.catalog = false 

> Step 4: 

Find the file attached to and extract it to have the following: 

- SQLQuery1.sql 
- SQLQuery2.sql 
- SQLQuery3.sql 

Now connect to the MDB using MS SQL server management studio and execute them in the same order as listed above, note that you need to execute them in the same order as above. 

Now relaunch the common installer and proceed further.