KNOWN ISSUE: The Inv_Applicable_Microsoft_Software_Update table is very large.

Article:TECH122333  |  Created: 2010-03-16  |  Updated: 2010-05-19  |  Article URL http://www.symantec.com/docs/TECH122333
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



The Inv_Applicable_Microsoft_Software_Update is very large.  Truncating the table does not help as the data comes back in from the clients.

Environment



Patch Management Solution for Windows 6.2 SP1

Cause



Software releases exclusions have been defined for operating systems as well as software. 

This causes the problem because most applicable rules are simply "True" when associated to different software releases, such as Office, .net or operating systems like XP.  Since many of these no longer exist the association portion of the rule no longer has anything to check against so the only check is the rule which simply declares itself as "True"

Note: The more languages being managed the greater the impact will be.

Solution



This is fixed in version 7 of Patch Management Solution for windows.

For Patch Management Solution 6.2 please run the attached SQL script 'spPMCore_RemoveBadResourceAssociations.sql.' This will clear the missing associations.  The steps to resolve the issue are:
     ~ Run the spPMCore_RemoveBadResourceAssociations
     ~ Run a full PMImport
     ~ Clear the IAD file on the client machine.


Supplemental Materials

SourceDEFECT
ValueETK 1995719
DescriptionLogged in Etrack (Symantec) database

Legacy ID



51952


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


Terms of use for this information are found in Legal Notices