More than 300k Employees results in calculation of DynamicGroup not ending (4321292)

If there are a lot of Person records (e.g. > 300k) the calculation of DynamicGroup ("Test dynamic roles" - task 'QER-K-DynamicGroupTest') does not end in the DBQueue Processor or is recognized as dead.

In User Type Table definition QBM_YDataForDelta an index on column HashKey was missing.

This is a product defect (32146).

WORKAROUND

None.

STATUS

This will be fixed in a future release of the product. If you require this immediately corrected, please contact Support for a hotfix referencing the defect ID 32146.

Execute in the following order:

1. OneIM8.1_Fix#31905,#32146_DBQueuePerformance.sql

2. QBM_PDBQueueCalculateDelta.sql