Upgrading From an Older Version of the Veracode Integration for Jira

Ticketing Systems

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

Before you begin

You must have administrator permissions to perform this task.

About this task

To upgrade to the latest version of the Veracode Integration for Jira:

Procedure

  1. Log in to Jira as administrator and uninstall any previous versions of the Veracode Link plugin.
    Note: It is important that you do not remove the Veracode Link custom field that the plugin creates.
  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';
    Note: As in the example below, if this SQL query returns multiple records for the Veracode Link custom field, you must follow the Duplicate Jira Issues procedure before continuing.


  3. Stop the Jira server.
  4. Create a backup of your current Jira database, including triggers, stored procedures, functions, and events.
  5. Delete the following files from the <jira-directory>/atlassian-jira/WEB-INF/lib folder:
    • Any previous versions of the Veracode Jira import plugin file veracode-jira-flaws-synchronizer*.jar
    • VeracodeJavaAPI.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.
  10. Install the latest version of the Veracode Integration for Jira.