24148 The User Manager 127.0.0.1 returned an empty queue

Frequent "UMEmptyQError" in Hostserver Log: Troubleshooting Steps

Understanding the Error:

• The error "Error","General","24148","UMEmptyQError","K2DestQueue.RunDestQueue","24148 The User Manager 127.0.0.1 returned an empty queue" indicates an issue with empty destination queues in K2 workflows.

Troubleshooting:

1. Invalid Role Entry:

   • Check for invalid roles:
     SQL

     SELECT * FROM [Server].[DestQueue]
     WHERE [Name] NOT IN (SELECT [Name] FROM [Authorization].[Role])

   • Delete invalid entries: Remove any invalid roles found in the [Server].[DestQueue] table.

2. Valid Role with Empty Membership:

   • Identify roles with empty membership:
     SQL

     SELECT * FROM [Server].[DestQueue]
     WHERE [ID] NOT IN (SELECT DISTINCT [QueueID] FROM [Server].[DestQueueUser])

   • Add users to empty roles: Assign at least one valid user or placeholder user to each empty role.

Additional Considerations:

• Deletion Order: If a role was recently deleted, remove any associated entries in the [Server].[DestQueueUser] table before deleting from the [Server].[DestQueue] table.
• Deployment Processes: Roles created through package and deployment might have empty memberships. Ensure users are added to these roles.
• Database Backup: Back up your database before making any changes to the tables.

Contact Support for Further Assistance:

If you continue to face this error after following these steps, please contact K2 support for additional guidance.