Has anyone seen this on a DA9 SP4 -> DA10 SP1 Upgrade?

[JesusWept3]

I did an upgrade from DA2007 SP6 -> DA9 SP4 -> DA10 SP1
When attempting to do the final service upgrade, it failed with

APP AS - Customer ID: 0 - Failed to update database. System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_tblConfigurationDefinition_Name'. Cannot insert duplicate key in object 'dbo.tblConfigurationDefinition'.
The statement has been terminated.

The Script that failed is as follows

 

APP AS - Customer ID: 0 - Error Executing : C:\Program Files (x86)\Enterprise Vault Business Accelerator\ConfigurationDataUpdateV10SP1.sql
Line: 65
Failed to Execute the following command: 

--V 10.0.1 keys to start from 1157
--
-- Configuration to delete vault interest
IF NOT EXISTS(SELECT * FROM tblConfigurationDefinition WHERE ConfigurationID = 1157)
BEGIN
	INSERT INTO 
		tblConfigurationDefinition( 
			[ConfigurationID] ,
			[Name] ,
			[Description],
			[TypeID],
			[Minimum],
			[Maximum],
			[DefaultVal],
			[RestartRequired],
			[Visible],
			[ConfigurationSection],
			[ApplicationType],
			[Scope],
			[ResourceID],
			[ResourceState]) 
	VALUES 
		( 
			1157, 
			N'Discard existing archive registrations after you turn off ''Enable archive registration task''', 
			N'Specifies whether to keep or discard any existing archive registrations if you choose to disable the archive registration task. By default, Enterprise Vault keeps the existing archive registrations after you disable the task.', 
			97, -- Integer Data type
			NULL, -- Minimum
			NULL, -- Maximum
			N'0', -- Default
			2, -- Restart required
			1, -- Visible
			16, -- General Config section
			3, -- Both for CA and DA(ApplicationType)
			1, -- Scope : Customer level
			'tblConfigurationDefinition_RemoveVaultInterest',
			1 -- Resource state translatable
		)
END

So it was saying that the following Name already existed in the DB
Discard existing archive registrations after you turn off 'Enable Archive Registrations'

Doing a "SELECT * FROM tblConfigurationDefinition WHERE Name = ...." I was able to see that the Name existed under ConfiguationID 1149 and not 1157.....i'm *assuming* that it was added as 1149 under EV9 SP4, and when the Query runs to see if it should add it, purely looked at the ConfigurationID 1157 which didn't exist, but the name did , hency why the UNIQUE KEY CONSTRAINT was thrown.

Has anyone else seen this before? in their upgrades?

To get around it i simply changed the name, to be '...registration' instead of '...registrations'
It worked like a charm and the install completed

[JesusWept3 · Accepted solution]

nevermind, EV9 SP4 to 10 SP1 is not a supported upgrade
blimey!