The software package and detection rules have not replicated down to child SMP and is causing errors
Last Updated September 05, 2018
The software package and detection rules have not replicated down to child SMP. The software package has replicated down to the child SMP but the associated detection rule has not replicated down and is causing errors.
In every case the Detection Rule is replicated later in the next replication job which maybe be the next day.
If you want to force the replication, try to find the item in the Console and do a right-click -> Replicate Now and see if it works.
As well you may want to use this generic query that should reset Replication for an individual item:
--Run the following query on Parent and Child(ren) --Stop NS services and replace the @GUID variable below with the GUID of the item that you want to reset.
DECLARE @ThisNS nVarchar (36) DECLARE @Guid Uniqueidentifier DECLARE @StateXML XML
SET @Guid='<Your Guid>'
SELECT @ThisNS=[Value] FROM [ServerSettingGuids] WHERE [Name]='OwnerNSGuid' SELECT @StateXML=CAST(State as XML) FROM Item WHERE Guid=@Guid IF @StateXML IS NOT NULL BEGIN SET @StateXML.modify('delete /item/originNS') SET @StateXML.modify('delete /item/sourceNS') SET @StateXML.modify('delete /item/ownerNS') END UPDATE Item SET OwnerNSGuid=@ThisNS,State=CAST(@StateXML as nVarchar(max)) WHERE Guid=@Guid UPDATE ItemImportMethod SET ItemImportMethod.[ImportMethod] = 0 WHERE [ImportMethod] = 3 and Guid=@Guid UPDATE ItemNSSource SET OriginNSSourceNSID=a.ID FROM ItemNSSource cross join originNSSourceNS a WHERE a.OriginNSGuid=a.SourceNSGuid and a.OriginNSGuid=@thisNS and ItemGuid=@Guid DELETE FROM ItemReplication WHERE ItemGuid=@Guid DELETE FROM HierarchyPublished WHERE Guid=@Guid DELETE FROM [ReplicationItemReplicableCache] WHERE Guid=@Guid DELETE FROM [ReplicationItemDependencyCache] WHERE Guid=@Guid DELETE FROM [ReplicationItemMandatoryItemCache] WHERE Guid=@Guid
Imported Document ID: TECH207711
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe