Troubleshoot global data reinitialization

In a multi-site hierarchy, Configuration Manager uses Database Replication Service (DRS) to transfer data between sites. For more information, see Database replication.

Use the following diagram to start troubleshooting DRS reinitialization (reinit) for global data in a Configuration Manager hierarchy:

Queries

This diagram uses the following queries:

Check if reinit isn't finished for global replication

SELECT * FROM RCM_DrsInitializationTracking dt
INNER JOIN ReplicationData rg
ON dt.ReplicationGroup = rg.ReplicationGroup
WHERE dt.InitializationStatus NOT IN (6,7)
AND rg.ReplicationPattern=N`Global'

Get the TrackingGuid & Status from the primary site

SELECT RequestTrackingGUID, InitializationStatus
FROM RCM_DrsInitializationTracking dt
INNER JOIN ReplicationData rg
ON dt.ReplicationGroup = rg.ReplicationGroup
WHERE dt.InitializationStatus NOT IN (6,7)
AND rg.ReplicationPattern=N`Global'

Get the TrackingGuid & Status from the CAS

SELECT RequestTrackingGUID, InitializationStatus
FROM RCM_DrsInitializationTracking dt
WHERE RequestTrackingGUID=@trackingGuid

Check request status for the tracking ID

SELECT Status FROM RCM_InitPackageRequest
WHERE RequestTrackingGUID=@trackGuid

Next steps

• Reinit missing message