We're using BlackPearl 4.6.6 and are trying to remove a role from workspace but receive the dreaded, "Role has dependencies. Cannot Delete" message when right-click deleting. The problem is FINDING the dependencies. Is there a way of finding what might be tied to this role without having to hunt and peck through every process instance and versions?
Is there a table on the backend that would contain the role reference and the associated process or object that we can query?
Thanks!
When a role is associated with a process a row is added to the K2Server.._DestQueue table and row for each user in the role is added to the K2Server.._DestQueueUser table. The role cannot be deleted to due this dependency.
If you know for a fact the role was manually added to the process but was never used or not being used you could delete it from the database as follows:
1. Query the K2Server.._DestQueue table to find the ID of the role. There is Name and ID column.
2. Delete the users for the role from the K2Server.._DestQueueUser table based on the ID:
delete from K2Server.._DestQueueUser where ID = ID From Step 1]
3. Delete the row from the K2Server.._DestQueue table for the role based on the ID:
delete from K2Server.._DestQueue where ID = ID From Step 1]
4. Delete the Role from the Roles node via Workspace Management console.
Please remember to backup DB’s before!!!!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.