Get Approver for Request shows up in the DB Queue and it takes a long time

Question

Hello everyone, 
 
 In the DB queue, the process "Get approver for request" takes a very long time (more than 30 minutes for ~200 lines) and stops the execution of the entire queue 
 There are fixes on the One Identity Community: 
 https://support.oneidentity.com/kb/4343994/-get-approver-for-a-request-task-blocks-the-db-queue-and-nothing-else-can-process 
 https://support.oneidentity.com/kb/4295673/performance-issues-with-operation-get-approver-for-request 
 But we use Version 9.2 and this version already includes these fixes. 
 
 How can I resolve this issue? 
 Thanks

Barry Jackson · Answer

Hi, 
 Have you checked SQL server Activity Monitor for long running queries and/or head blockers? 
 Do your IT Shop requests use custom approval procedures? 
 'Get approver for a request' is calculating the entries in PWOHelperPWO based on the approval workflow tied to the item being requested so I would check that your workflow and approval procedures are good. 
 HTH, Barry.

Get Approver for Request shows up in the DB Queue and it takes a long time

Top Replies