Hi Experts
We have the dbqueue task recalculate approvers appearing time and time again in the dbqueue, and it never seems to do anything. It finishes, then comes back
We have about 4,500 PWOs in OrderProduct state. There are no processes running which effect PersonWantsORg, and there are also no sync projects running. The task also does not go into reset, it does finish, but then it comes back
I saw in the QBMDBQueueTask table that the query for recalculation is
select uid_personwantsorg from personwantsorg where Orderstate like N'Order%' union select uid_personwantsorg from pwohelperpwo
The above will always return the same amount of PWOs (this is a test env so the PWOs are not approved).
Is there some way to debug what is happening? There are no warnings in Journal about this task in particular, just seems that it finishes and then comes back.
Thanks
Kin
PS: Running select dbo.QBM_FGIConfigparmValue('QER\ITShop\ReducedApproverCalculation') returns an empty result