Posts Tagged "SQL"

Cannot insert duplicate key error while upgrading SCCM 2012 to SP1

Posted by Norman Bauer on Feb 5, 2013 in SC Configuration Manager, SQL Server, Transact-SQL | 1 comment

The following error occurred during SP1 update of Microsoft System Center 2012 Configuration Manager: ERROR: SQL Server error: [23000][2627][Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of PRIMARY KEY constraint ‘CollectionQueryRuleTables_PK’. Cannot insert duplicate key in object ‘dbo.CollectionQueryRuleTables’. The duplicate key value is (16777228, 1, vSMS_R_System). Configuration Manager Setup 05.02.2013 09:12:18 4084 (0x0FF4) The easiest way would be to delete the corresponding rows from CollectionQueryRuleTables table in your SCCM database. This...