When trying to apply the Incidents database from Configuration > Server Settings > Notification Server Settings > Incident Settings, the following error is shown.
The operation did not complete successfully, table 'schema_version' already has a primary key defined, see previous errors.
A Primary Key was already manually created for the schema_version table using Enterprise Manager. (The primary key name had a random number appended to the end.) The Helpdesk upgrade checked for the existence of the known primary key name and was not able to find the key name expected, so it is trying to create it; however, the table already had a primary key (there can only be one) by a different name which prevented the creation of the new primary key.
Remove the manually created primary key from the schema_version table and reapply the Incident settings.
Applies To Upgrading to Helpdesk 6.0.297
Rate this Article
This is machine translated content
Login to Subscribe
Please login to set up your subscription.
Didn't find the article you were looking for? Try these resources.