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'
Option 1:
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.........
Option 2:
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