One Queue Is Not Updated In Orchestrator When The Process Robot Is Run

How to resolve when one queue is not updated in Orchestrator, when the process Robot is running fine and transactions are being updated?

Issue Description: One queue is not updated in Orchestrator, when the process bot is running fine and transactions are being update. No items visible in Chart as well.


Resolution: This issue is due to the GenerateReportsJob is stuck with the Error status.

Follow below mentioned steps:

Note: Take the backup of web.config and database before modifying.

  • Run below query to change the TRIGGER_STATE from ERROR to WAITING
    • Update [Databasename].[quartz].[QRTZ_TRIGGERS] set TRIGGER_STATE = 'WAITING' where JOB_NAME = 'GenerateReportsJob' AND TRIGGER_STATE='ERROR';
  • Navigate to Orchestrator's installation directory (typically C:\Program Files (x86)\UiPath\Orchestrator) and open web.config in NotePad or NotePad++
    • Search for Database.EnableAutomaticMigrations and set the value to true
    • Save the file and close it
    • Restart IIS and launch Orchestrator web app to see numbers updated .