全局数据重新初始化故障排除Troubleshoot global data reinit

在多站点层次结构中,Configuration Manager 使用 SQL 复制在站点之间传输数据。In a multi-site hierarchy, Configuration Manager uses SQL replication to transfer data between sites. 有关详细信息,请参阅数据库复制For more information, see Database replication.

使用以下图示开始对 Configuration Manager 层次结构中的全局数据进行 SQL 复制重新初始化 (reinit) 故障排除:Use the following diagram to start troubleshooting SQL replication reinitialization (reinit) for global data in a Configuration Manager hierarchy:

对全局数据重新初始化进行故障排除的图示

查询Queries

此图示使用以下查询:This diagram uses the following queries:

检查站点复制是否尚未完成重新初始化Check if site replication hasn't finished reinit

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'

从主站点获取 TrackingGuid 和状态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'

从 CAS 获取 TrackingGuid 和状态Get the TrackingGuid & Status from the CAS

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

检查跟踪 ID 的请求状态Check request status for the tracking ID

SELECT Status FROM RCM_InitPackageRequest
WHERE RequestTrackingGUID=@trackGuid

后续步骤Next steps