|Applies To||RSA Product Set: Archer|
RSA Version/Condition: 5.x,6.x
|Issue||A questionnaire campaign is stuck in 'In Process' state. There is no relevant job waiting to be run or running in the Job engine Manager.|
|Resolution||Note: Please take backup of the database before running the below scripts.|
Step 1: Identify the job_id for the campaign that is still 'In Process'. In the where clause in the below query, you will have to insert the name of the campaign that is stuck.
Step 2: Decide whether you want to set the campaign status to “Complete” or “Error”. You should run only ONE of the scripts below:
- If you want to set the campaign to “Complete”, run the following query. You will have to insert the job id found in step 1.
- If you want to set the campaign to “Error”, run the following query. You will have to insert the job id found in step 1.