KNOWN ISSUE: Delta Resource Membership Update doesn't refresh filters that have recently been replicated

Article:TECH199728  |  Created: 2012-11-14  |  Updated: 2013-05-31  |  Article URL http://www.symantec.com/docs/TECH199728
Article Type
Technical Solution


Issue



When the parent replicates a filter, it replaces the filter on the child server and nulls the filter's membership. When the next "delta resource membership update" runs, only partial membership is updated. The customer has to run a complete resource membership update or update the filter manully via the console. This causes a big problem specifically when the "Software Portal Plug-in Policy" gets replicated. It uses the "Windows Computers with installed Software Management Plug-in" which has a guid of '091daff5-...'

 


Environment



ITMS 7.1 SP2 V4


Cause



The Delta Resource Membership Update populates memberships of those computers that have had a change in the inventory class data since the last Delta Resource Membership Update process. The update process looks at the modified dates of all resources in the resourceupdatesummary table and builds the collection base from the result set on this data. It then joins the filter descriptor with this data to determine the actual membership to be updated for a given filter.

It is very unlikely that ALL computers that belong to a filter will have a change in data since the last Delta Resource Membership Update process.

Below is the process that the "delta resource membership update" uses.

insert #ModifiedResources
select distinct Resourceguid as Guid from ResourceUpdateSummary where DataLastChangedDate > @minupdatedate --'2012-09-14 08:14:39.733'

--minidupdatedate is the last time the delta update ran. If the computer hasn't had any updates to its data classes since the last delta update, it won't be inserted into #ModifiedResources


insert #vRM_Computer
select * from vRM_Computer where Guid in (select m.guid from #ModifiedResources m)

/*******/
DECLARE @now datetime
SET nocount on
SET @now = GetDate()
TRUNCATE TABLE #CurrentCollectionEval


INSERT INTO #CurrentCollectionEval
SELECT DISTINCT Guid FROM (SELECT c.[Guid]
FROM #vRM_Computer c
JOIN Inv_AeX_AC_Client_Agent s ON s._ResourceGuid = c.[Guid]
WHERE c.IsManaged = 1
AND s.[Agent Class Guid] = '6E7FDCA4-E61F-4F5B-BE67-CE6E4E1774E1'
AND ( s.[Product Version] LIKE '7.1.%' AND s.[Build Number] > 1600 )
) dsQuery
SET nocount off SELECT @now

set nocount on

execute spDeltaUpdateCollection  @collectionguid = '091daff5-bca2-40aa-a839-28a0416cddc3'

 


Solution



Pointfix 2947893 was created to fix this issue

 

This Point-fix targets issue described in the incident 2947893: Delta Resource Membership Update doesn't refresh filters that have recently been replicated. This PointFix is intended to solve the issue with Delta Membership Update task, which may not update filers that were recently replicated from Parent NS.

 

MINIMUM REQUIREMENT

 

Configured Hierarchy environment ITMS 7.1 SP2 with rollup v4

 

HOW TO INSTALL THIS POINTFIX

  1. Extract files from the archive to the NS hard drive. Make sure PointFix is not extracted to Altiris install directory (or any subfolder to it).
  2. Execute PFInstaller.exe under user with administrative privileges (right-click > Run as administrator).
  3. Accept UAC (User Account Control) prompt, select Install Files.

Contact Support if this pointfix is needed. This fix is for v4. A permanent fix will be in 7.1 Sp2 MP1 v2


Supplemental Materials

SourceETrack
Value2947893


Article URL http://www.symantec.com/docs/TECH199728


Terms of use for this information are found in Legal Notices