Synchronizing Roles of Queue Participants
- Last UpdatedSep 11, 2024
- 2 minute read
When a user role is first made a participant in a queue, AVEVA Work Tasks internally stores all users with that role for allocation of work items assigned to the queue. As the resource database changes, with new users added to the role and changes in roles, the repository of users for the role need to be synchronized with the resource database. This synchronization is done based on an entry in the table SKROLEREFRESH for the resource handler.
The columns in this table are:
-
ID - a system-generated field.
-
Resource handler - the name of the resource handler for which the refresh setting is specified.
-
RoleRefreshInterval - the interval specified in dd.hh:mm:ss at which the synchronization must be done.
-
IsActive - This field must be initially set to False; This is later updated to True by the system when a Queue is created or edited.
-
TaskId - the corresponding ID of the refresh task in the task scheduler. This field is updated by the system.
-
LastUpdatedDateTime - The time stamp of the last update. This field is updated by the system.
When roles are refreshed, and there is a change in the users of a role that is a queue participant, all open items of users who are not longer a part of the role which the user has not taken ownership of are automatically moved back to the queue. Items that the user has taken ownership continue to stay in his work list. However, these items will no longer be considered a part of the queue. For example, a queue for processing Invoice Payments has the role Process Associate as a participant and John Smith as a Process Associate has 5 open items from this queue. John Smith is promoted to Manager and the role change is effected in the resource database. When the synchronization happens, John has 5 open items 3 of which has already started to process. The 2 open items that has not taken ownership of are moved back to the queue for reallocation while the 3 items that has started to process are not complete continue to stay in his work list.
Deleting Synchronization Settings
To temporarily discontinue refresh or to delete the setting, delete the entry in the table.