Inventory Deletion fails due to Database lock issue
1. Deleting Normalize Inventory via Admin Console UI -> Inventory fails.
2. Run below SQL statement to delete Inventory via BDNA_PUBLISH database will fail with below error:
-- SQL Statement
EXECUTE PUBLISH_CLEARDATA @inv_id = 284738196, @task_id = NULL Note:284738196 is the inventory ID of a normalize inventory that you want to delete
-- Errors when running the above SQL statement
Msg 1204, Level 19, State 4, Procedure PUBLISH_CLEARDATA, Line 210 [Batch Start Line 0] 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.
1. Follow below steps to re-configure the Database is configured to increase the locks numbers automatically.
-> Right click on the connected SQL Instance -> Properties > Advanced > Locks -> Change numbers to 0
2. Run below SQL Statement in BDNA_PUBLISH database to restore the value of "Max Server Memory" to the default one.
exec sp_configure 'max server memory (MB)',2147483647 go reconfigure go