Archer Community

KB-Sync1 · ‎2020-12-11

Article Number

000029797

Applies To

Product(s): Archer
Version(s): All Versions
Primary Deployment: On Premises

Description

After attempting to delete Application Content using the Delete Content button, the process never completes and appears hung.
The Status displays a message and no longer updates "Processing .. Step X of Y."
0EMVM000005dfhz.png

Cause

The DeleteModuleContentWorkflow job had an issue and failed to complete properly.

Resolution

Delete Pending Job

Note: Before running the DELETE SQL commands against the Instance database, it's strongly recommended performing a SQL backup of the Instance database.

1. Get the Module ID by going to Manage Applications/Questionnaires and hovering the mouse over the Name. The ID will be shown in the lower-right corner. You can also just get the ID from adding the "ID" column from the Eye button.
2. Run the following SQL statement to get the latest DeleteModuleContentWorkflow jobs that are not Complete...replace ### in the 7th line with the Module ID from step 1:

SELECT TOP 5 mj.module_id, js.job_id, js.job_status_id, jsd.job_status_name, js.update_date
FROM tblJobStatus js
JOIN tblModuleJobStatus mj ON mj.job_id = js.job_id
JOIN tblJobStatusDef jsd ON jsd.job_status_id = js.job_status_id
WHERE js.job_type_id = 7
AND js.job_status_id <> 3
AND mj.module_id = ###
ORDER BY js.update_date DESC

3. In the results that are returned, take note of the job_id for a job that failed to complete. In the following sample results, the job_id in this example is 5.
0EMVM000005dXVv.png

4. Run the following SQL statement to delete a row from tblModuleJobStatus...replace ### with the job_id in step 3:

DELETE tblModuleJobStatus WHERE job_id = ###

5. Run the following SQL statement to delete the row from tblJobStatus...replace ### with the job_id in step 3:

DELETE tblJobStatus WHERE job_id = ###

6. Reopen the Application to confirm the Delete Content button is enabled.