000029797 - Delete Content button status displays "Processing .. Step X of Y." and no longer updates in RSA Archer

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support on Mar 11, 2019
Version 11Show Document
  • View in full screen mode

Article Content

Article Number000029797
Applies ToRSA Product Set: Archer
RSA Product Version: 5.x to 6.x
IssueAfter 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. 

User-added image

Unable to change the Status from Retired for an Application.

User-added image

CauseThe DeleteModuleContentWorkflow job had an issue and failed to complete properly by the Job Engine.
ResolutionBefore 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.
  2. Run the following SQL statement to get the latest DeleteModuleContentWorkflow jobs that are not Complete...replace ### 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 is 2447.        User-added image
  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 and the Application's Status can be changed.