Symptoms

Call of SetResourceUsage_API results in the following error:

Code: 1000. ERROR:  deadlock detected
DETAIL:  Process 19513 waits for ShareLock on transaction 1925210227; blocked by process 19474.
Process 19474 waits for ExclusiveLock on tuple (83743,83) of relation 184006 of database 182332;     blocked by process 11913.
Process 11913 waits for ShareLock on transaction 1925209985; blocked by process 19513.
HINT:  See server log for query details.

Cause

The issue is caused by PBA-81044 "Deadlock is possible when running DUMMYGATE.SetResourceUsage_API for different subscriptions".

Resolution

PBA-81044 is fixed in OA 7.2 and 7.3 in the scope of hotfixes BA 7.2.0 HOTFIX 132287 BM CORE v1 and BA 7.3.0 HOTFIX 132463 BM CORE v1 accordingly. Please contact your Technical Account Manager or a member of Pooled Technical Associates Team to schedule the hotfix installation procedure.

Taking into consideration that the issue occurrs in case if SetResourceUsage_API is executed for several subscritpions simultaneously, as a workaround, a delay can be set between the API method calls.

Internal content