Service Catalog install: configuring components failed

Document ID : KB000106969
Last Modified Date : 18/07/2018
Show Technical Document Details
Issue:
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.
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. 
File Attachments:
SQL queries.zip