Recovery Solution 7.1.3919 - Scan for applied critical patches is locking up NS
| Article:TECH176254 | | | Created: 2011-12-06 | | | Updated: 2012-06-18 | | | Article URL http://www.symantec.com/docs/TECH176254 |
Problem
Scan for applied critical patches locking up NS.
Environment
Applies to RS 7.1.3919
Cause
sp_RS_PopulateAppliedBulletins along with sp_RS_UpdateAppliedBulletins are causing massive deadlocks.
Solution
Prior to release of RS 7.1 decision has been made to drop support for integration of RS with Patch Management. At the same time the corresponding stored procedures were left there intact. If you are experiencing deadlocks recommendation is to replace the corresponding stored procedures with zero functionality for those.
Please execute the following query against the SMP database in order to drop the existing sp_RS_PopulateAppliedBulletins and sp_RS_UpdateAppliedBulletings and recreate similar ones with zero functionality:
DROP PROCEDURE [dbo].[sp_RS_PopulateAppliedBulletins]
CREATE PROCEDURE [dbo].[sp_RS_PopulateAppliedBulletins]
@nTimeDiff int = 0
AS
DROP PROCEDURE [dbo].[sp_RS_UpdateAppliedBulletins]
CREATE PROCEDURE [dbo].[sp_RS_UpdateAppliedBulletins]
@nTimeDiff int = 0
AS
|
|
Article URL http://www.symantec.com/docs/TECH176254
Terms of use for this information are found in Legal Notices
Thank you.