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

Rate 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

Rate this Article

Did this article resolve your issue?

Did this article save you the trouble of contacting technical support?

How can we make this article more helpful?

Email Address (Optional)


Feedback