Orchestrator Event Viewer Logs Show Error " System.Data.SqlClient.SqlException (0x80131904): Cannot find the object "Queue Processing Records" because it does not exist or you do not have permissions"

How to resolve when the Orchestrator event viewer logs show the following error: System.Data.SqlClient.SqlException (0x80131904): Cannot find the object "QueueProcessingRecords" ?

Issue Overview : The Orchestrator event viewer logs show the following error: System.Data.SqlClient.SqlException (0x80131904): Cannot find the object "QueueProcessingRecords" because it does not exist or you do not have permissions.

Resolution :

  1. Verify that the DB user has the correct permissions. The easiest way to do that is to go through the steps of setting up the user permissions (querying the permissions is more work than just resetting them)
  2. Go through the SQL Server Configuration that outlines Orchestrator SQL settings
  3. Make sure the SQL user has the DB owner role. If security policies do not allow this, follow manual workaround outlined in the above SQL Server Configuration link.
  4. If the issue still occurs after following the above steps, please open a ticket with UiPath Support. Let them know the above steps have been followed and include the Orchestrator event logs.