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.
ITMS 7.x, 8.x
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.
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