Service Catalog install: configuring components failed

book

Article ID: 106969

calendar_today

Updated On:

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. 

Attachments

1558536593973SQL_queries.zip get_app