Error in policypv.log after upgrade to ConfigMgr 2012 R2

Ran into an interesting error today after updating ConfigMgr 2012 SP1 to ConfigMgr 2012 R2. The hierarchy is a CAS and 3 primary sites (but I do not believe that the error is releated to having multiple primary sites).

*** insert DepPolicyAssignment (PADBID, PolicyAssignmentID, PolicyID, DepPADBID, DepPolicyAssignmentID, DepPolicyID, IsTombstoned, LastUpdateTime) values (67118015, N'{ccff0eb1-db33-49c3-9dd3-c704c3a638f8}’, N’PS120012-PS10013D-6F6BCC28′, 67689129, N'{060a13d7-7ed8-46ae-927f-4420b0fefdcb}’, N’DEP-PS120012-PS1002B1-6F6BCC28′, 0, GetUTCDate())

*** [23000][547][Microsoft][SQL Server Native Client 11.0][SQL Server]The INSERT statement conflicted with the FOREIGN KEY constraint "DepPolicyAssignment_1_FK". The conflict occurred in database "CM_PS1", table "dbo.PolicyAssignment", column ‘PADBID’.

Failed to create policy and policy assignment based on package PS1002B1, program * and offer PS120012

After a little investigation it turned out that the package being referenced was a boot image and the “offer” aka “deployment” was a task sequence deployment using the package. After changing the boot image in the task sequence to a new boot image, and deleting the deployment (deployment name started with an “_”) – all went back to normal.

By | 2013-11-12T20:32:56+00:00 November 12th, 2013|Configuration Manager (SCCM)|1 Comment

About the Author:

Kent Agerlund
Microsoft Regional Director, Enterprise Mobility MVP. Microsoft Certified Trainer and Principal consultant. I have been working with Enterprise client management since 1992. Co-founder of System Center User Group Denmark in 2009. Certified MCITP: Enterprise Administrator, MCSA+Messaing, and much more. Member of: Microsoft Denmark System Center Partner Expert Team The Danish Technet Influencers program System Center Influencers Program.

One Comment

  1. kevin April 18, 2016 at 3:27 - Reply

    great article! had a similar issue upgrading to configmgr 1511. where I had sms_policy_provider errors in the database.
    Ended up deleting the deployments and task sequence that wasn’t being used.

Leave A Comment