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.