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

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

Parents
  • 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.

Reply
  • 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.

Children
No Data