RU2 upgrade fails on DB schema - Violation of primary key
Trying to upgrade a 12.1 RU1 site to RU2. The SEPM installs fine, but when the second part runs the database schema upgrade, it fails at 3% and returns the following error:
Violation of PRIMARY KEY constraint 'PK_GUIPARMS'. Cannot insert duplicate key in object 'dbo.GUIPARMS'. The duplicate key value is (74).
I had our DBA check and all permissions are OK (full admin) for the account installing. He looked at the table in question, the output from the install script and says that the script is trying to place a new value in that table, which is the failure.
Current entry in the DB:
GUIPARMS_IDX PARAMETER VALUE USN TIME_STAMP DELETED
74 ADJUST_DATABASE_TIME 1328203091521 1 0 0
Script is attempting to write:
IF NOT EXISTS (SELECT PARAMETER FROM GUIPARMS WHERE PARAMETER = 'latest_av_defs_Symantec' ) INSERT INTO GUIPARMS (GUIPARMS_IDX, PARAMETER, VALUE) VALUES (74, 'latest_av_defs_Symantec', '')
I was forced to uninstall the SEPM and reinstall, then relink to the DB. That was successful, so we are working at RU1 stage.
I have run the dbvalidator.bat and receive "database validation passed"
I've attempted to create a support case, but all day it says it can't verify our account (even though I generated a ticket on Friday).
I have attached the data that shows up in the failure box, if it can be of help.