Autoindex job stuck in a “Running” Status MSSQL

Behavior:
Your Autoindex job has become stuck in a "Running" status, and you cannot stop or delete the job.

***Before proceeding, please make a backup of the DWSystem database.***

Solution:
Please implement the following to resolve this behavior;

1. Find the process GUID by name in the DWOrganizationSettings table in the DWSystem database. In this case, the Autoindex job name is "New unnamed autoindex"
   
    
2. Find the workflow status with the same process GUID in the DWWorkflowStatus table within the DWSystem database.
   
3. Open the Status XML in the 'status' column and check the state value:
   
   If the Status is "Running," it should be replaced with "Stopped". The whole XML must be updated.
    
4. Copy the existing status XML and execute the "UPDATE" command by replacing only the state to "Stopped":
   
   Write the correct "WHERE" clause to update only the needed row using the process GUID.
   
    

5. Use that same GUID to execute the following query:
   
   update [dwsystem].[dbo].[DWBPSOrgMonitoring] set workstate = 2 where process Guid = ' Your unique Guid '
   
   

6. Execute the query. The Autoindex job will now no longer be stuck in a "Running" state, and you will be able to delete it if needed.

For organizations that utilize MySQL, follow KBA-36273.

KBA is applicable for On-premise Organizations ONLY