Why is the Resource request not following the correct workflow?

SYMPTOMS

Resource requests sometimes seem to take a wrong route in the workflow. The workflow checks at some places if a resource is a resource manager and then routes accordingly.

RESOLUTION

The following query can be used to check for which workgroups a resource is resource manager. This will then allow to see if the workflow has followed the correct process:

select w.name, dbo.F_isRM_ForWorkgroup('<resourceid>', w.workgroupid) IsManager
from workgroup w
where w.deleted=0 and dbo.F_isRM_ForWorkgroup('<resourceid>', w.workgroupid)=1
order by w.obs