When you upgrade to Ektron 9.00 SP2, the database portion of the upgrade displayed the following error:
ERROR! Failed to execute script! Error[cms_SetupDefaultNotificationPreferencesForActivity}: Violation of PRIMARY KEY constraint 'PK_notification_publish_preference_tbl'. Cannot insert duplicate key in object 'dbo.notification_publish_preference_tbl'. The duplicate key value is (10082,4).
An association between a user and an activity type already exists.
After the error occurs, run the following SQL script in SQL Management Studio while pointing to the target database:
DELETE FROM notification_publish_preference_tbl WHERE ActivityTypeId = 4 and UserId in
(SELECT userId FROM User_Default_Preference_tbl WHERE UseDefaultPublishSettings = 0)
ActivityTypeId is 4 so that any user associated with that ID is removed.
After running the script, re-run the upgrade script, which adds the associations back into the table. The upgrade script is located at
C:\Program Files (x86)\Ektron\CMS400v9xx\Utilities\SiteSetup\Database\cms400_upgrade_data.sql