Symptoms:

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.