Running the vendor update list from within the Patch Management Home page, under the MetaData Import Task results in an error. It appears this error was seen only after upgrading from an earlier version of the 7.5 console to Service Pack 1.
"Procedure or function spLockResource has too many arguments specified".
This is a known issue within ITMS 7.5 SP1: The spLockResource stored procedure accumulates large amounts of wait time and merge locking in concurrent threads causing delays to these threads.
Review the following resolution options:
Official resolution is provided in ITMS 7.5 SP1 HF3: Upgrade to Hot Fix 3.
Workaround: Implement the updated spLockResource stored procedure from an ITMS 7.5 SP1 HF3 environment into the affected environment:
Go to the affected SMP SQL Server Management Studio: