ACS collector generating 4618 errors after upgrade to SCOM 2012 R2

Symptom

===========
 Message: [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of UNIQUE KEY constraint 'unPrincipal_e85082db_9ba3_47c0_aaa6_ee9e68606a0e'. Cannot insert duplicate key in object 'dbo.dtPrincipal_e85082db_9ba3_47c0_aaa6_ee9e68606a0e'. 

Cause
=======

SQL files not updated when updating the ACS Component. Tables are created using the older scripts. 

Resolution
=========

Stopped the AdtServer service, Copied the new SQL files from the SCOM 2012 R2 setup and pasted them into the c:\windows\system32\security\adtserver folder replacing the old files.

On the SCOM ACS Database ran the following query:

USE OperationsManagerAC

GO

UPDATE dtpartition

SET status=2

WHERE partitionid='e85082db_9ba3_47c0_aaa6_ee9e68606a0e'

GO

Restarted the AdtServer service.