000031482 - How to delete Module Content and restart Application ID numbering in RSA Archer

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 14, 2017
Version 4Show Document
  • View in full screen mode

Article Content

Article Number000031482
Applies ToRSA Product Set: Archer
RSA Version/Condition: All
IssueThis script will update next application ID to the lowest possible. 
Only works for Applications and Questionnaires...not Sub-Forms.
If you want to reset back to 1, all content needs to be deleted from the module.
Before running any data modification script you should make a backup of the database.
Resolution
  1. Perform a SQL Backup of the Instance database in case a restore is required.
  2. Confirm the Tracking ID is configured for Application ID and not System ID.
  3. Delete all records from the module.
  4. Confirm there are zero records in module.
  5. Download and run the attached script against the Instance database.

Outcomes