-
Re: Orion NPM Upgrade Error - Violation of PRIMARY KEY constraint
mharvey Oct 11, 2012 4:13 PM (in response to phorensic)1 of 1 people found this helpfulThere's probably going to be a bit more to that, you'd first need to find the table that this primary key is on. To do this, do a search on your server for the ConfigurationWizard.log and look for that error to see what table this is coming from. Once that is determined, you should be able to remove the key and reconfigure to have that key re-added and continue you upgrade.
Regards,
Matthew Harvey
Loop1 Systems
-
Re: Orion NPM Upgrade Error - Violation of PRIMARY KEY constraint
phorensic Oct 11, 2012 4:18 PM (in response to mharvey)Well it's telling me in the error that it's having trouble working with the APM_Tag table. I'm assuming that's where the primary key is as well? That article I linked to was the same error on a different table, figured it would work if I substituted the table names.
-
-
Re: Orion NPM Upgrade Error - Violation of PRIMARY KEY constraint
phorensic Oct 11, 2012 5:12 PM (in response to phorensic)Just FYI in case anyone else ever encounters this error, this is the exact command I ran on the SQL server to fix the problem and let the configuration wizard complete everything. I'm good to go now.
IF EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[APM_Tag]') AND name = N'PK_APM_Tag')
ALTER TABLE [dbo].[APM_Tag] DROP CONSTRAINT [PK_APM_Tag]If you look at the contents of the APM_Tag table it is really trivial content anyway. I won't even add back the constraint, if the config wizard didn't do it already.