SMP Installation or Upgrade process is failing with error 'The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time.'

book

Article ID: 157752

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

Issue/Introduction

During an upgrade or installation via Symantec Installation Manager (SIM) for the Symantec Management Platform or a Solution, the configuration process failed with the following error:

[Failed to import the item from the file [D:\Program Files\Altiris\Notification Server\Config\NS_Update.config]

And when you look at the trace section of the message, the following entry was present:

System.Data.SqlClient.SqlException caught in ImportSqlNodes. Reason: System.Data.SqlClient.SqlException: The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users. Ask the database administrator to check the lock and memory configuration for this instance, or to check for long-running transactions.

The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users. Ask the database administrator to check the lock and memory configuration for this instance, or to check for long-running transactions.

Cause

This issue was caused by a SQL Server configuration setting. The default value for 'Locks' was changed from 0 to something else (in this case to 5000). By limiting how many 'Locks' are allowed, it caused SQL Server to fail to provide the necessary Lock resources during our updates in stored procedures and other tables.

Resolution

Check the following setting and make the appropiate changes if needed:

1. Open Microsoft SQL Server Management Studio
2. Right-Click on your SQL instance and click on Properties
3. Under the Advanced page, look under the Parallelism section for 'Locks'
4. By default the 'Locks' value is 0. If it is something different, make the change back to 0
Note: If for some reason the UI doesn't take the change, run the following query to set the value to 0 again:

exec sp_configure 'show advanced options', 1;
reconfigure;
exec sp_configure 'Locks', 0;
reconfigure;

5. Restart the SQL Services
 


Applies To

Symantec Management Platform 7.1 SP2, 7.1 SP2 MP1