Some users may have issues creating a community account. For more information, please click here.

Inventory Deletion fails due to Database lock issue

Inventory Deletion fails due to Database lock issue

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.

 

Solution:

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

 

 

Labels (2)
Was this article helpful? Yes No
No ratings
Version history
Revision #:
1 of 1
Last update:
‎Mar 23, 2021 03:06 PM
Updated by:
 
Contributors