We have uncovered a very interesting issue with our Forms process. Our process is kicked off by Workflow when a document is brought into the repository and the entry id of the document is passed to the Forms instance so the document can be shown with an embedded Web Client. We had an instance that shows in Monitor that it has been assigned to a user since June of 2020. For whatever the reason they asked about the document today so we did some digging since they reported it wasn't showing in the Forms Inbox. The Workload report did not show it assigned to the user that Monitor showed it was assigned to. After assigning it to myself and then back to the user it showed for the user correctly. I have since found a handful of such cases. How would this happen? Is there a faster way to correct this than manually checking? We are using Forms 10.4.4.444.
We have confirmed the bug that workload report did not show tasks assigned to removed users, and we will fix it in next release, sorry for the inconvenience.
The SQL query to find all tasks assigned to removed users could be:
SELECT wr.resume_id, us.username FROM [cf_bp_worker_instnc_to_resume] wr INNER JOIN [cf_user_snapshot] us on wr.owner_snapshot_id = us.id WHERE us.user_id is NULL
When users are removed from system security they are removed from [cf_users] table but the info in [cf_user_snapshot] is still kept so you could still see it on monitor page. And if you add this user back and synchronize on forms, the tasks are still assigned to that user.
So if you would like to bulk reassign those tasks to a different user, you could try script like this:
UPDATE [cf_bp_worker_instnc_to_resume] SET owner_snapshot_id = NEW_USER_SNAPSHOT_ID WHERE resume_id in ( SELECT wr.resume_id FROM [cf_bp_worker_instnc_to_resume] wr INNER JOIN [cf_user_snapshot] us on wr.owner_snapshot_id = us.id WHERE us.user_id is NULL)
We are still working on narrowing down this issue. From what we can tell, it appears that if the user does not show in the Administration -> System Security page, but is assigned a task, it does not show the user as having a task in the Workload report, but does show in Monitor.
I am curious why when a user has their license removed that the system does not suspend all tasks for that user?
We've encountered the same thing. It's been rare enough that I haven't worried about it too much, but it definitely does happen to where it says it is assigned, but when we have the user log into forms it definitely isn't showing in their Inbox tasks.
The solution has been as you described, assigning it to ourselves then back to the user and so far I haven't really found any other way to handle the issue.
What I usually find myself doing is periodically checking for tasks that have been sitting for an unusually long period then reassigning them back to the original team/user, but it would be nice to have a better option or if the underlying issue was resolved.