Upgrade an Old Version of the Veracode Integration for Jira

Use this procedure only if you are upgrading to the latest version of the Veracode Integration for Jira from a version earlier than 3.5.0.

1. Log in to Jira as administrator and uninstall any previous versions of the Veracode Link plugin.
   Note: Do not remove the Veracode Link custom field that the integration created during installation.
2. Run the following SQL query in the Jira database to confirm that there is only one record for the Veracode Link custom field:

   SELECT
       ID, CUSTOMFIELDTYPEKEY, CUSTOMFIELDSEARCHERKEY
   FROM
       customfield
   WHERE
       cfname = 'Veracode Link';

   If the SQL query returns multiple records for the Veracode Link custom field, as shown in this example, before continuing to the next step, you must remove the duplicate Jira issues.

   
   
   
3. Stop the Jira server.
4. Create a backup of your current Jira database, including triggers, stored procedures, functions, and events.
5. Delete these files from directory <jira-directory>/atlassian-jira/WEB-INF/lib:
   • Any previous versions of the Veracode Jira import plugin file veracode-jira-flaws-synchronizer*.jar
   • vosp-api-wrapper-java{version}.jar
   • esapi.jar
   • ESAPI.properties
6. Run the following SQL query in the Jira database to remove any unnecessary Veracode Link custom field definitions:

   DELETE FROM customfield
   WHERE CUSTOMFIELDTYPEKEY='com.veracode.jira.plugin.synchronize.veracode-jira-flaws-synchronizer:veracode-link-field' 
   AND CUSTOMFIELDSEARCHERKEY='com.veracode.jira.plugin.synchronize.veracode-jira-flaws-synchronizer:veracode-link-searcher';

7. Run the following SQL query in the Jira database to update the Veracode Link custom field definition:

   UPDATE customfield
   SET CUSTOMFIELDTYPEKEY='com.veracode.jira.plugin.synchronize.veracode-jira-flaws-synchronizer:veracode-link-field',
   CUSTOMFIELDSEARCHERKEY='com.veracode.jira.plugin.synchronize.veracode-jira-flaws-synchronizer:veracode-link-searcher'
   WHERE CUSTOMFIELDTYPEKEY='com.veracode.jira.plugin.link.VeracodeLink:veracode-link-field'
       AND CUSTOMFIELDSEARCHERKEY='com.veracode.jira.plugin.link.VeracodeLink:veracode-link-searcher';

8. Commit the changes to the Jira database.
9. Start and re-index the Jira server.