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;
- Find the process GUID by name in the DWOrganizationSettings table in the DWSystem database. In this case, the Autoindex job name is "New autoindex configuration"
- Find the workflow status with the same process GUID in the DWWorkflowStatus table within the DWSystem database.
- Open the Status XML Field Viewer 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. - Copy the existing status XML from the Field Viewer 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. Use that same GUID to execute the following query:
update `dwsystem`.`DWBPSOrgMonitoring` set workstate = 2 where processGuid = 'GUIDfromabove'
- 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 MSSQL, follow KBA-36266
KBA is applicable for On-premise Organizations ONLY