[SPManager] [ERROR] [6/8/2007 4:19:44 PM]: Upgrade [SharedDatabase Name=[DBName]_PROF Parent=SPDatabaseServiceInstance] failed.
[SPManager] [ERROR] [6/8/2007 4:19:44 PM]: Violation of UNIQUE KEY constraint 'IX_DataServicePropMap_ServerIDPropName'. Cannot insert duplicate key in object 'DataServicePropMap'.
Problem: Above Errors found repeatedly in upgrade.log when attempting to migrate from 2003 to 2007 using any of the 3 migration methods.
Symptoms: Errors found in upgrade.log. When attempting an inplace or gradual upgrade, upgrade fails. When attempting a SSPrestore using database migration receive error: Action 12.0.4.0 of Microsoft.SharePoint.Portal.Upgrade.ProfileDatabaseSequence failed, and SSP shows as provisioning failed.
Fix: In SQL open your _Prof DB. Open the table DataServicePropMap. Delete all the rows where bRecordIdentifier = 0. You should now be able to upgrade normally with no failures. If you are already in the middle of an upgrade just reboot your server hosting SharePoint (This restarts the upgrade job). Alternately you can got to /_layouts/1033/MgrProperty.aspx and delete any custom field you may have created.