I was wondering why i could not get deferred items from a queue, so i drilled down just a little bit the BP Database in order to see all deferred items
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi60SPf6XpVz9CBxjH_0hSPSExy76GTysFTlARpkB9bH02u3oLMaN_ygonyGlHPWGQh2Btgl1eu13Q5Lybr6LizD-QVY6g9jwQJOqGeTg4z3vpL_-I8tay5EVMfie0c_9tLjbpvyeMHrasR/s320/20180308+%25283%2529.png) |
Just watching the queue |
So i dumped data before and after completion of the object just to understand how the DB row is updated
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh5bDvhAMhYzllMoC0WNmOu3Xl5vt85VKhRhR5V61qje7_G0hQzVGWZEK1fm441ejxKycuBExb6HiyduWE683_N7h3_KYYyCq-8LcmAjkezM473LTiUeW9lOS5JeFiWIMrCHirvDaxabpOb/s320/20180308+%25282%2529.png) |
Old VS New |
After that, we made a little action that inject SQL code from BP in order to get deferred items.
select
*
from
BPAWorkQueue as q join BPAWorkQueueItem as i
on q.id = i.queueid
where q.name = 'QueueName'
and i.deferred IS NOT NULL
and i.completed IS NULL
and i.exception IS NULL
And this is how Claudia Musio (thanks for everything) and me, solved the problem.
0 commenti:
Post a Comment
Because of a lot of SPAM about courses, I need to moderate all comments here.
I ensure you that I will answer whenever possible (if you are not a spammer).