Unable to download Software Updates with error: Update does not have a designated primary data row
search cancel

Unable to download Software Updates with error: Update does not have a designated primary data row

book

Article ID: 161497

calendar_today

Updated On:

Products

Patch Management Solution for Windows Client Management Suite IT Management Suite

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. 

[CDATA[Error Setting Package Name/Description : System.InvalidOperationException: Update {9b08b3cd-854f-4fe4-af3c-175d5cf04a71} does not have a designated primary data row.

[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\[Update Name]\{9b08b3cd-854f-4fe4-af3c-175d5cf04a71} does not exist

[CDATA[Error to create the Software Installation File Resources for Software Update Package '[InstallationFile.msu]' - '9b08b3cd-854f-4fe4-af3c-175d5cf04a71'.
Item save failed: 869035de-8f0f-4cac-8336-1ff7a569ca69

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
  • Hierarchy SMP Server:
    • Missing on Parent NS - Run a reconfigure of Patch Management to recreate the Dataclass and/or Resources
    • Missing on Child NS - Run a Full Replication from Parent to Child to replicate the Import Patch Data for Windows

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: