During an upgrade from 8.4 to 8.51 or above, it is common to receive and error similar to the following:
Duplicate MCS database entries have been detected.
Please contact CA support to continue with your upgrade.
The above error will cause the UIM Upgrade from 8.4 to 8.51 or above to prevent a user from proceeding.
To resolve the issue, a workaround can be issued by using a script within the file attached to this KB:
Within the file, there are three scripts:
NOTE: Make sure you have a full backup of your UIM database before proceeding.
The script is set up as a transaction that does not actually make any changes on the first run, as noted by the "Rollback" portion of each script.
Perform the following steps:
- Run the file pertaining to your DB type on the DB directly. (either MSSQL or MYSQL)
- After it is executed, if everything goes well, the result of the script should say ""It is safe to upgrade to UIM 8.51"".
- If that is the case, edit the statement in the script (at the very end of the MSSQL script, or near the end of the MYSQL script) that says ""rollback"" to ""commit"" and run the entire script again. This will then make the required updates and enable you to proceed through the upgrade installer successfully.
Your DBA will need to run the appropriate database script for either MYSQL or MSSQL as noted above to resolve this issue.
You then can move forward with the installation upgrade.
In the event that you do not receive the "It is safe to upgrade to UIM 8.51" message after running the script, or if you are running an Oracle database, please open a support case for assistance.
Additional information for Oracle:
1.Finding duplicate entries from SSRV2ConfigValue table:
select profile, field, count(*) from SSRV2ConfigValue group by profile, field having count(*) > 1
2.Check for the profile in SSRV2profile table:
Select * from SSRV2profile where profileid = profile_value
3.If there are any duplicates delete then from SSRV2ConfigValue table
delete from SSRV2ConfigValue where profile = profile_value and field is null (If field is null)
delete from SSRV2ConfigValue where profile = profile_value and field = field_value (if field value is not null)
4. use the oracle_clean_mcs_db.sql
Please reference the Release Notes for UIM 8.51 prior to upgrading