PMImport Fails after Patch Management solution repair: Invalid object Inv_Software_Update in log files
Last Updated November 20, 2017
Repaired Patch Management Solution 7.x per HOWTO47868 and found the PMImport failed with numerous error entries in the SMP Log Viewer; one for each bulletin being imported.
Also found the same error was thrown when opening the Console > Actions > Software > Patch Remediation Center; highlight Software Bulletin > Right-click > Download/Recreate Packages.
Patch Management 7.5.x
An unexpected exception occured (GUID: 74b5cf1e-d756-4ea1-8efd-83eaf5af9176) DataClassTable: Inv_Software_Update, Eception: System.Data.SqlClient.SqlException: Invalid object name 'Inv_Software_Update'
The repair was unable to successfully restore associations from the Inv_Software_Update table to the DataClass resources.
Worked through the following remedial steps:
RDP to a working SMP with the same ITMS Version
Opened the Console > Settings > All Settings > Notification Server > Resource and Data Class Settings > Data Classes > Software Management > Patch Management > Global
Highlighted the Software Update DataClass, right-click > Export; saved file
Imported the saved Software Update DataClass to non-working SMP Console > Settings > All Settings > Notification Server > Resource and Data Class Settings > Data Classes > Software Management > Patch Management > Global
Worked through the repair process outlined on HOWTO47868
Confirmed restored resource associations; PMImport completed download process and Software Updates able to download in the PRC
Imported Document ID: TECH174212
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe