Unable to download Software Updates from Microsoft to the SMP Server

Products

• Patch Management Solution for Windows

Issue/Introduction

Opened the Console > Actions > Software > Patch Remedation Center; highlighted the current Software Bulletin to be deployed, right-click > Distribute Packages, and the process fails to complete. 
 

<event date="12/02/2014 14:37:14.4200582 -05:00" severity="1" hostName="Server1" source="Altiris.PatchManagementCore.Resources.PatchSoftwareUpdateResource.createPackage" module="AtrsHost.exe" process="AtrsHost" pid="6152" thread="82" tickCount="48110989"><![CDATA[Error Setting Package Name/Description : System.InvalidOperationException: Update {9b08b3cd-854f-4fe4-af3c-175d5cf04a71} does not have a designated primary data row.
   at Altiris.PatchManagementCore.Resources.PatchSoftwareUpdateResource.EnsurePrimaryDataRow()
   at Altiris.PatchManagementCore.Resources.PatchSoftwareUpdateResource.createPackage()
</event>

<event date="12/02/2014 14:37:14.8724698 -05:00" severity="1" hostName="Server1" source="Resource.SaveResourceToDatabase" module="AtrsHost.exe" process="AtrsHost" pid="6152" thread="82" tickCount="48111441"><![CDATA[Item save to DB failed: 869035de-8f0f-4cac-8336-1ff7a569ca69, (fromClone=False, user=DOMAIN\AltirisAdmin)
File C:\Program Files\Altiris\Patch Management\Packages\Updates\MS14-064\{9b08b3cd-854f-4fe4-af3c-175d5cf04a71} does not exist
   [System.IO.FileNotFoundException @ Altiris.PatchManagement]
   at Altiris.PatchManagement.Resources.Win32SoftwareInstallationFileResource.DetermineSoftwareInstallationType()
   at Altiris.PatchManagement.Resources.Win32SoftwareInstallationFileResource.OnSave(Boolean bExistingItem)
   at Altiris.NS.ItemManagement.Item.Save()
</event>
 

<event date="12/02/2014 14:37:14.8880702 -05:00" severity="1" hostName="Server1" source="Altiris.PatchManagementCore.Resources.PatchSoftwareUpdateResource.createSoftwareInstallationFileForPackage" module="AtrsHost.exe" process="AtrsHost" pid="6152" thread="82" tickCount="48111457"><![CDATA[Error to create the Software Installation File Resources for Software Update Package 'Windows8-RT-2012-KB3010788-x64.msu' - '9b08b3cd-854f-4fe4-af3c-175d5cf04a71'.
Item save failed: 869035de-8f0f-4cac-8336-1ff7a569ca69
   [Altiris.NS.Exceptions.AeXException @ Altiris.NS]
   at Altiris.NS.ItemManagement.Item.Save()
   at Altiris.NS.ItemManagement.Item.Create(Guid productGuid)
   at Altiris.NS.ResourceManagement.Resource.Create(Guid productGuid)
   at Altiris.PatchManagement.Resources.Win32SoftwareInstallationFileResource.CreateWin32InstFileResource(Guid PackageGuid)
   at Altiris.PatchManagement.Policies.VendorPolicyWindows.CreateNewSoftwareInstallationFile(PatchSoftwareUpdateResource swu)
   at Altiris.PatchManagementCore.Resources.PatchSoftwareUpdateResource.<>c__DisplayClassf.<createSoftwareInstallationFileForPackage>b__9(IDatabaseContext ac)
   at Altiris.Database.DatabaseContext`1.RetryAction(Int32 retries, Boolean transacted, Getter`1 getContext, Action`1 action, Action`1 retry, DeadlockRetryArgs& re, Exception& exception, Boolean inTransaction)
   </event>
 

Environment

Patch Management 8.x

Cause

Missing Dataclass and/or Resource Associations to build the Software Update Package and/or Policy

Resolution

Solution 1:

• Standalone SMP Servers:
  • Run a reconfigure of Patch Management to recreate the missing dataclass
    • See KB 180404
• Hierarchy SMP Server:
  • Missing on Parent NS - Run a reconfigure of Patch Management to recreate the Dataclass and/or Resources
    • See KB 180404
  • Missing on Child NS - Run a Full Replication from Parent to Child to replicate the Import Patch Data for Windows
    • See KB 181686

Solution 2:

• Open the Console > Manage > Jobs and Tasks > System Jobs and Tasks > Software > Patch Management > Import Patch Data for Windows
  • Expand the Vendors and Software segment
    • Enable any wanted Vendor data to be included
    • Disable any unwanted Vendor data to be excluded
  • Configure to ensure the unnecessary resources are cleared and the associations are able to build and execute on schedule or Now as able: