Software Update Packages fail to download following 7.6 HF7 upgrade

Products

• Patch Management Solution for Windows

Issue/Introduction

Upgraded ITMS from 7.5 SP1 HF5 to 7.6 HF7; found Software Updates failed to download via the Console > Patch Remediation Center (PRC).

• Confirmed NS.Windows Patch Remediation Settings scheduled task not present in the Task Scheduler Library
• Confirmed Patch Management policies/tasks present in the Console
• Confirmed Patch Management Solution set to product uninstalled in the Symantec_CMDB Database

Ran repair/reconfig of Patch Management per HOWTO47868; failed with errors pertaining to Stored Procedure: spItemClassUserCreatableDelete

Download Software Updates related errors:

• Error to create the Software Installation File Resources for Software Update Package '7z1604.msi' - '64c59e05-6fb0-4bc0-b4e3-ab9e7f984f71'. Item save failed: 2f0dea19-6b86-4d43-9ece-dfe03dcda43d
  • File E:\Altiris\Patch Management\Packages\Updates\7ZIP-009\{64c59e05-6fb0-4bc0-b4e3-ab9e7f984f71} does not exist
     
• Item save to DB failed: 2f0dea19-6b86-4d43-9ece-dfe03dcda43d, (fromClone=False, user=altecnt\altirismgr)
  • File E:\Altiris\Patch Management\Packages\Updates\7ZIP-009\{64c59e05-6fb0-4bc0-b4e3-ab9e7f984f71} does not exist

Reconfig related errors:

• Failed to InstallProduct on "E:\Altiris\Patch Management\Core\Config\PatchManagementCore.config".
   
• Failed to configure the user creatable item classes. 
  • Exception:Altiris.Database.InvalidDatabaseContextException: Database context invalidated by inner exception ---> System.Data.SqlClient.SqlException: 
  • XML datatype instance has too many levels of nested nodes. Maximum allowed depth is 128 levels.
     
• Failed to install product. The current database context is invalid due to a previous critical error. Inner exception is the original processed exception which caused the database context to be marked invalid.
  • XML datatype instance has too many levels of nested nodes. Maximum allowed depth is 128 levels.
  • SQL Exception details: code=6335, line=5, procedure=spItemClassUserCreatableDelete

Environment

Patch Management 7.5 SP1 HF5

Patch Management 7.6 HF7

Cause

Confirmed database corruption present for Patch xml items, and the Stored Procedure: spItemClassUserCreatableDelete was not able to execute in current state, which failed to build associations to Software Update packages.

Resolution

Worked through the following remedial steps:

1. Modified Stored Procedure: spItemClassUserCreatableDelete; added a top row count which allowed the max allowed depth above 128 levels.
2. Ran reconfig CMDs from HOWTO47868; restored NS.Windows Patch Remediation Settings scheduled task and refresh Patch related .xml files.
3. Ran upgrade for 7.6 HF7 in SIM; updated Patch files and Console segments.
4. Ran Full PMImport; restored Software Update resource associations.

Confirmed able to download Software Update Packages moving forward.