Why is it not possible to disable or remove triggers after upgrading Orchestrator?
Issue Description: After successfully upgrading Orchestrator from version 22.4 to 23.4.2, users are unable to disable or remove triggers from Orchestrator, and the following error message is thrown in the Event Viewer logs:
Microsoft.Data.SqlClient.SqlException (0x80131904): Index "IX_RobotJobsBackgroundTasks_DeduplicationScope_HandlerType" on table "dbo.RobotJobsBackgroundTasks" (specified in the FROM clause) is disabled or resides in a filegroup which is not online.
Root Cause: The error message indicates that an index on a table in the database used by Orchestrator is either disabled or resides in a filegroup which is not online.
Resolution: Enable the database index "IX_RobotJobsBackgroundTasks_DeduplicationScope_HandlerType". The following steps detail how to do this:
To enable a disabled index
Option 1:
- In Object Explorer, click the plus sign to expand the database that contains the table on which it is required to enable an index
- Click the plus sign to expand the Tables folder
- Click the plus sign to expand the table on which to enable an index
- Click the plus sign to expand the Indexes folder
- Right-click the index to enable and select Rebuild
- In the Rebuild Indexes dialog box, verify that the correct index is in the Indexes to rebuild grid and click OK.
Option 2:
- To enable the index, use the following SQL command:
ALTER INDEX IX_RobotJobsBackgroundTasks_DeduplicationScope_HandlerType ON dbo.RobotJobsBackgroundTasks REBUILD
- Run the command above in the New Query window of the database
After performing these steps and ensuring that the index is enabled, it should be possible to disable or remove triggers in UiPath Orchestrator without encountering this error.
Note: Make a database back up, This task should be performed by a Database Administrator or someone with sufficient permissions and knowledge of SQL Server.