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

News Knowledge Base
1

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 updated. No items are visible in the Chart either.


Root Cause

The GenerateReportsJob is stuck with an Error status.

Resolution

Note: Take a backup of UiPath.Orchestrator.dll.config and database before modifying.

  1. Run the 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';

  1. Navigate to Orchestrator's installation directory (typically C:\Program Files (x86)\UiPath\Orchestrator) and open UiPath.Orchestrator.dll.config in NotePad or NotePad++
    • Search for Database.EnableAutomaticMigrations and set the value to true
    • Save the file and close it
  2. Restart IIS and launch the Orchestrator web app to see numbers updated.