The installation is hanging on ?installation progress? in ?Configuring SC components? phase.

Document ID : KB000046167
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue/Problem/Symptoms: 

Installing CA Service Catalog(SC) on a shared mdb.

The installation is hanging on ‘installation progress’ in ‘Configuring SC components’ phase.

 

Environment:  

Windows, running/installing CA Service Catalog R14.1 release.

Installing CA Service Catalog(SC) with CA Service Desk Manager(SDM) on a shared mdb(the mdb database size is 120GB).

The SC is on separate server.

 

Cause: 

A duplicate row exists in mdb database > ca_contact table for userid=spadmin.

To verify and confirm this, execute the below query onto the mdb database:

SELECT contact_uuid,last_name,first_name,email_address,inactive,userid FROM ca_contact where userid='spadmin'

More than 1 rows get returned in the query-result.

 

Resolution/Workaround:

First double check the contentof the mdb/table/row(s) by executing this query:

SELECT contact_uuid,last_name,first_name,email_address,inactive,userid FROM ca_contact where userid='spadmin'

 

* When the result shows more than one row with an active userid (the column 'inactive' has value zero(0)):

Delete one of the 'active' rows for userid='spadmin' by executing this query:

The original and ootb details for userid-spadmin are: first_name='Service Delivery' last_name='Administrator'.

So, this row needs to be kept in the ca_contact table.

The 'other' rows can then be deleted:

delete from ca_contact where userid='spadmin' and contact_uuid = 0x.........   

 

* When the result shows more than one row with an INactive userid (the column 'inactive' has value one(1)):

Delete the 'INactive' rows for userid='spadmin' by executing this query:

delete from ca_contact where userid='spadmin' and inactive=1

 

After the delete query completed successfully, you can rerun the CA Service Catalog installation.

You can restart the component setup through the below scenario:

1. Start the SC-Setup Utility(login) and select the Components module

2. Select (all) you need and click 'save'

3. When done, click 'finish'/'OK' to restart the service(s)

4. Logout of the SC Setup Utility

5. Check the SC-UI/catalog/forms/forms for its content