Software Updates are generating errors for the client policy xml files.

Did this article resolve your issue?

Thank you for your feedback!

Provide feedback on this article

Download Files

This SQL script is utilized for PM 7.1 SP1, SP2, MP1.x and 7.5

SQL Query - Find missing Software Update resource associations.txt (726.0 B)

Resource Association - Wipe out through SQL Script.txt (1.8 KB)

These updated Stored Procedures will resolve the SQL Deadlocking that takes place during PMImport run that causes the bad codebases during the recreate process. Rename existing SP's to .old and run these to CREATE the SP's. **ENSURE A BACKUP OF THE DATABASE WAS RECENTLY PERFORMED!** for PM 7.1 SP1+ to 7.5

PMImport_Deadlock_Fix.zip (1.7 KB)

These updated Stored Procedures may also make a difference in environments that the 'PMImport_Deadlock_Fix.zip' does not resolve alone. Rename existing SP's to .old and run these to CREATE the SP's. **ENSURE A BACKUP OF THE DATABASE WAS RECENTLY PERFORMED!** for PM 7.1 SP1+ to 7.5

PMImport_Optional_PerformanceEnhancements.zip (4.4 KB)

Print Article
Products
Subscribe to this Article
Manage your Subscriptions
Search Again

Situation

Error

Cause

Solution

Legacy ID

Download Files


Feedback