Configuration Manager clients do not receive policy data after you recover a primary site from a CAS

Applies to: System Center Configuration Manager 1710

Symptoms


Consider the following scenario:

  • You're running Microsoft System Center Configuration Manager (current branch) in your hierarchy.
  • The instance of Microsoft SQL Server that's hosting the database for the primary site is lost.
  • You recover a primary site from a Central Administration Site (CAS) on a newly installed SQL Server instance (for the primary site).

In this scenario, Configuration Manager clients do not receive policy data, and the Configurations tab in client properties is blank (that is, baselines are not visible). Applications and software update deployments that were created before the recovery may also not work.

Cause


This problem occurs because the Last Row Version registry entry for the Object Replication Manager and Policy Provider has a higher value than that of the rowversion entry in the site database.

Resolution


To fix this issue, follow these steps:

  1. Stop the SMS_Executive service on the primary site server.
  2. Run the following query on the recovered primary database to obtain the current value for rowversion:

    select min(rowversion) from CI_CIAssignments
  3. Update the Last Row Version value at the following location to match the value that's returned from the SQL query:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\COMPONENTS\SMS_OBJECT_REPLICATION_MANAGER\CI Assignment\Last Row Version
  4. Run the following query on the recovered primary database to obtain the current value for rowversion:

    select min(rowversion) from PolicyCollMap 

  5. Update the Last Row Version value at the following location to match the value that's returned from the SQL query:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\COMPONENTS\SMS_POLICY_PROVIDER\PolicyTargetEval\Last Row Version

  6. Start the SMS_Executive service on the primary site server.

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.