000037359 - How To identify Archer Campaigns in Retired/Archived Questionnaires that are wasting server resources (Performance) in RSA Archer

Document created by RSA Customer Support Employee on Apr 24, 2019
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000037359
Applies ToRSA Product Set: Archer
RSA Product/Service Type: Questionnaire Campaign
RSA Version/Condition: 5..x, 6.x
Platform: Windows
IssueWhen modules are retired without inactivating the campaign inside of the related questionnaire, then the campaign will still continue to execute but will never process any data due to the status of the modules.
  1. Administration -> Application Builder -> Questionnaires
  2. Edit retired or archived questionnaire
  3. Properties Tab
  4. Campaigns Tab
  5. Edit the "Active" campaign
  6. Set campaign status to "Inactive"
  7. Repeat steps 5-6 for each campaign in this questionnaire
  8. Repeat steps 1-7 for all Retired and Archived Questionnaires.


  1. Identify campaigns that are wasting server resources with the below SQL query.

    --Find Active Campaigns tied to Retired/Archived questionnaires that target Development/Production applications.
    select mt.module_name as Questionnaire, mt.module_id as 'Questionnaire module_id', c.campaign_name, c.campaign_id, mt2.module_name as 'Target', mt2.module_id as 'Target module_id' from tblCampaign c with(nolock)
    JOIN tblModuleTranslation mt with(nolock) on mt.module_id = c.module_id
    JOIN tblModule m with(nolock) on m.module_id = mt.module_id
    JOIN tblLevel l with(nolock) on l.level_id = m.target_level_id
    JOIN tblModuleTranslation mt2 with(nolock) on mt2.module_id = l.module_id
    JOIN tblModule m2 with(nolock) on m2.module_id = mt2.module_id
    where c.campaign_type_id = '2' and c.is_active = '1' and m.status_id in ('2','3') and m2.status_id in ('0','1')

  2. Edit the Retired/Archived Questionnaire and inactivate the campaign that was returned by the above query.
ResolutionData feeds and questionnaires associated with the retired questionnaire continue to use system resources.
Prior to retiring a questionnaire, RSA recommends the following: 
  • Deactivate all data feeds that target retired questionnaire
  • Deactivate all campaigns within the questionnaire
For more information, please see the Archer Help topic "Changing the Questionnaire Status"