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.
Before You Begin
You must have Jira administrator permissions.
Steps
-
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.
-
Run this 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, before continuing to the next step, you must remove the duplicate Jira issues.
-
Stop the Jira server.
-
Create a backup of your current Jira database, including triggers, stored procedures, functions, and events.
-
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
- Any previous versions of the Veracode Jira import plugin file
-
Run this 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';
-
Run this 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';
-
Commit the changes to the Jira database.
-
Start and re-index the Jira server.
Next Steps
Install the latest version of the Veracode Integration for Jira.