000033096 - Duplicate Workflow Stage Values After Packaging in RSA Archer 5.5.1

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

Article Content

Article Number000033096
Applies ToRSA Product Set: Archer
RSA Version/Condition: 5.5.1
IssueDuring Packaging from one instance to another instance, the mapping was unsuccessful for the Workflow Stage values and ended up creating duplicate values in the field. Workflow was turned off prior to Packaging, so therefore, users are unable to edit the Workflow Stage field or modify the values list.
ResolutionIdentify the duplicate WorkFlowStage Value from the Instance database. The scripts below will assist in identifying, working out the ID, and then deleting the duplicate value. Where ##### is found, replace with Select_Value_id value that is return from the first query.
/***Identify Duplicate WorkFlowStage ***/
FROM tblValueListValueTranslation
WHERE select_value_name like '%Duplicate Value Name';
/***Duplicate WorkFlowStage Value_ID***/
FROM tblValueListValueTranslation
WHERE select_value_id=#####
/***Delete Duplicate WorkFlowStage by Value_ID***/
DELETE FROM tblValueListValueTranslation
WHERE select_value_id=#####

After the duplicate had been removed, create a new Package and install the Package into the environment and override the application settings.