One Identity has received feedback from a small subset of customers and partners in reference to DBQueue performance following an upgrade to One Identity Manager version 7.1.4 (Service Pack 4).
The current feedback is around the following development backlog items:
DBQueue processor may calculate QER-K-ShoppingRackCheckDecision before QER-K-ShoppingRackPWOHelperPWO is finished, potentially leading to incorrectly aborted PWOs
QBM_PDBQueueDeadSlotReset to log when it encounters dead slots
Dead DBQueue slot detection erroneous when SQL server reuses SPID
DBQueueSlot filling sub-optimal with busy DBQueue
QBM_PDBQueueOverviewFill used with @IgnoreLastFillDate too often
QER_PITShopPersonHasObjectFill should only be generated when required for compliance calculation
Incorrect and nonperforming joins for update trigger on PersonWantsOrg and SAPUser, in stored procedure ACN_PFillBudget and view SP0_VElementAndRoot
DBQueue tasks can "overtake" each other
While the reports were based on 7.1.4, the issues listed above, with the exception of 29330, are present in 8.0.2 as well.
Please note, versions 7.1.3 and 7.1.4 also introduced a change to some table functions generated as inline table-valued functions. This is not a product defect but in uncommon occasions this can cause issues with the DBQueue task QER-K-ShoppingRackPWOHelperPWO in conjunction with non-performing customer statements for CD (Calculated Decision) conditions or custom approval procedures. More information can be found here: Performance issues around calculation for PWODecisionRuleRulerDetect table functions following an upgrade to One Identity Manager 7.1.3 or 7.1.4.
The Development team has created consolidated hotfix packages for 7.1.4 and 8.0.2 based on the backlog item 31359 that addresses the aforementioned issues. Please find the hotfix packages here: