KNOWN ISSUE: The ResourceTargetContainerChanges table is growing very large

Article:TECH157997  |  Created: 2011-04-13  |  Updated: 2012-10-31  |  Article URL http://www.symantec.com/docs/TECH157997
NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.
Article Type
Technical Solution


Issue



Over time the ResourceTargetContainerChanges table grows out of control into the GB of wasted space. The busier the NS the quicker this table grows.
----

Steps to duplicate:
1. Create a saved target and make sure it is not applied to any policies
2. Run the Patch Management Solution for Windows PMImport. 
3. Stage a bulletin after the PMImport has completed.
4. Look at the ResourceTargetContainerChanges table to see that there are a large number of resources that should not be in a target such as files and inventory rules.
5. Run the NS.Complete Resource Membership update schedule to cleanup the table.
6. Look at the contents of the table again to verify that there is data that should not exist.
 

The following queries can be run to verify the issue:

--Count of Filters\Targets by Target\Filter
SELECT
 i.Name,
 rtcc.ResourceTargetGuid,
 COUNT (rtcc.ResourceTargetGuid)
FROM ResourceTargetContainerChanges rtcc
 JOIN Item i ON i.Guid = rtcc.ResourceTargetGuid
GROUP BY i.Name, rtcc.ResourceTargetGuid
ORDER BY i.Name

--Name of target and resource
SELECT
 tar.Name,
 res.Name
FROM ResourceTargetContainerChanges rtcc
 LEFT JOIN vItem tar
  ON tar.Guid = rtcc.ResourceTargetGuid
 LEFT JOIN vItem res
  ON res.Guid = rtcc.ResourceGuid
order by tar.name

--total count of the table
select COUNT (1)
from ResourceTargetContainerChanges

--Resource Targets that do not have a policy applied to them.
SELECT *
FROM ResourceTargetContainerChanges rtcc
 LEFT JOIN ItemAppliesTo iat ON iat.ResourceTargetGuid =
rtcc.ResourceTargetGuid
WHERE iat.ResourceTargetGuid IS NULL

--Count of resources that are not a computer or user.
SELECT COUNT (1)
FROM ResourceTargetContainerChanges rtcc
 LEFT JOIN vResource r ON r.Guid = rtcc.ResourceGuid
  AND r.ResourceTypeGuid IN
   ('493435F7-3B17-4C4C-B07F-C23E7AB7781F',--Computer
    '2C3CB3BB-FEE9-48DF-804F-90856198B600',--Virtual
Computer
    '4C94C174-795B-4DF1-B6E8-D6F1A9B1017D',--Computer
    'FD864F19-4437-4A4F-8709-58EB5E3AE0A4')--User
 LEFT JOIN ItemAppliesTo iat ON iat.ResourceTargetGuid =
rtcc.ResourceTargetGuid
WHERE iat.ResourceTargetGuid IS NULL
AND r.Guid IS NULL


Environment



Symantec Management Platform 7.0 SP5 and earlier, 7.1


Cause



The ResourceTargetContainerChanges table is getting populated with items that are not resources and targets\filters that are not applied to a policy.
 


Solution



This issue has been reported to Symantec Development Team. A fix is targeted for the next release (SMP 7.0 MR4 and SMP 7.1 MP1)

 In the meantime,  you can truncate ResourceTargetContainerChanges table in order to regain space, if you follow with an iisreset after the truncation.


Supplemental Materials

SourceETrack
Value2236604, 2207371



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


Terms of use for this information are found in Legal Notices