Versions Compared

Old Version 3

changes.mady.by.user Catch Admin

Saved on

compared with

New Version 4

changes.mady.by.user Catch Admin

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

If you are migrating a JIRA server to a new location, and as a result, the URL of the server changes, then you will need to manually repair some data in the database to make Enterprise Tester aware of these changes.

For the purpose of this KB article, we will assume that from and to URL's for JIRA are:

...

  • Login to Enterprise Tester as an administrator, and configure the defect tracker link(s) being updated to all be disabled (accessed via the Admin tab).
  • Change the URL in each defect tracker to point to the new server and save, this will cause the details to be validated confirming the new server is accessible.
  • Stop IIS, from an Administrator command prompt on the ET Enterprise Tester server you can execute the following command:  iisreset /stop
  • Backup your ET Enterprise Tester database.

Updating Incidents

Incidents within the ET Enterprise Tester database are stored across a number of tables. The table that needs updating when changing the JIRA URL is called "IncidentDetails", and in particular, a column called "TicketKey".

You will need the assistance of your DBA to run these queries against your Enterprise Tester Database.

Database Type

 

Sql Server

UPDATE IncidentDetails
SET TicketUrl = replace(TicketUrl, 'http://jirasvr/', 'http://mycorp.com/jira/')
WHERE TicketUrl IS NOT NULL

Oracle

UPDATE INCIDENTDETAILS
SET TICKETURL = REPLACE(TICKETURL , 'http://jirasvr/', 'http://mycorp.com/jira/')
WHERE TICKETURL IS NOT NULL

MySql

UPDATE IncidentDetails
SET TicketUrl = replace(TicketUrl, 'http://jirasvr/', 'http://mycorp.com/jira/')
WHERE TicketUrl IS NOT NULL

PostgreSql

UPDATE IncidentDetails
SET TicketUrl = replace(TicketUrl, 'http://jirasvr/', 'http://mycorp.com/jira/')
WHERE TicketUrl IS NOT NULL

 

Updating Requirements

Version 4.4 and below

For requirements synchronized to JIRA, the JIRA information is stored in a table called "ExternalSystemReferences". number of  tables.  As with incidents above, it is necessary to search and replace the values of the old server name with the new server name but instead using the column "ExternalUrl". 

...

You will need the assistance of your DBA to run these queries against your Enterprise Tester Database.


SQL Server

 

Sql Server
ExternalSystemReferencesUPDATE ExternalSystemReferences
SET ExternalUrl= replace(ExternalUrl, 'http://jirasvr/', 'http://mycorp.com/jira/')
WHERE ExternalUrl IS NOT NULL

OracleExternalIconUrl

UPDATE EXTERNALSYSTEMREFERENCESExternalSystemReferences
SET EXTERNALURL ExternalIconUrl= REPLACEreplace(EXTERNALURL ExternalIconUrl, 'http://jirasvr/', 'http://mycorp.com/jira/')
WHERE EXTERNALURL IS WHERE ExternalIconUrl IS NOT NULL

ExternalStatusIconUrl

 MySql

UPDATE ExternalSystemReferences
SET ExternalUrl SET ExternalStatusIconUrl= replace(ExternalUrlExternalStatusIconUrl, 'http://jirasvr/', 'http://mycorp.com/jira/')
WHERE ExternalUrl IS WHERE ExternalStatusIconUrl IS NOT NULL

ExternalStatusIconLink

 PostgreSql

UPDATE ExternalSystemReferences
SET ExternalUrl SET ExternalStatusIconLink= replace(ExternalUrlExternalStatusIconLink, 'http://jirasvr/', 'httphhttp://mycorp.com/jira/')
WHERE ExternalUrl IS WHERE ExternalStatusIconLink IS NOT NULL

 

Additional Steps for Version 4.5. and Above

In version 4.5 and above of Enterprise Tester, additional columns store URLs to other assets associated with JIRA for requirement sync:

...

Oracle

 

SQL Server

 

UPDATE ExternalSystemReferences ExternalIconUrl replaceExternalIconUrl WHERE ExternalIconUrl IS
ExternalSystemReferences

ExternalIconUrl

UPDATE EXTERNALSYSTEMREFERENCES
SET 		EXTERNALURL = REPLACE(EXTERNALURL , 'http://jirasvr/', 'http://mycorp.com/jira/')
 WHERE EXTERNALURL IS NOT NULL

ExternalStatusIconUrl

 ExternalIconUrl

UPDATE ExternalSystemReferencesEXTERNALSYSTEMREFERENCES
SET ExternalStatusIconUrlEXTERNALICONURL = replaceREPLACE(ExternalStatusIconUrlEXTERNALICONURL , 'http://jirasvr/', 'http://mycorp.com/jira/')
WHERE ExternalStatusIconUrl EXTERNALICONURL IS NOT NULL

ExternalStatusIconLinkExternalStatusIconUrl

 

UPDATE ExternalSystemReferencesEXTERNALSYSTEMREFERENCES
SET ExternalStatusIconLinkEXTERNALSTATUSICONURL = replaceREPLACE(ExternalStatusIconLinkEXTERNALSTATUSICONURL , 'http://jirasvr/', 'hhttphttp://mycorp.com/jira/')
WHERE ExternalStatusIconLink EXTERNALSTATUSICONURL IS NOT NULL

...

ExternalStatusIconLink

Oracle

 

ExternalIconUrl

UPDATE EXTERNALSYSTEMREFERENCES
SET EXTERNALICONURL EXTERNALSTATUSICONLINK = REPLACE(EXTERNALICONURL EXTERNALSTATUSICONLINK, 'http://jirasvr/', 'httphhttp://mycorp.com/jira/')
WHERE EXTERNALICONURL IS WHERE EXTERNALSTATUSICONLINK IS NOT NULL

ExternalStatusIconUrl

 

 

My SQL

EXTERNALSYSTEMREFERENCES SET EXTERNALSTATUSICONURL REPLACEEXTERNALSTATUSICONURL WHERE EXTERNALSTATUSICONURL IS
ExternalSystemReferencesUPDATE ExternalSystemReferences
 SET ExternalUrl= replace(ExternalUrl, 'http://jirasvr/', 'http://mycorp.com/jira/')
 WHERE ExternalUrl IS NOT NULL

ExternalStatusIconLinkExternalIconUrl

 

UPDATE EXTERNALSYSTEMREFERENCESExternalSystemReferences
SET EXTERNALSTATUSICONLINK SET ExternalIconUrl= REPLACEreplace(EXTERNALSTATUSICONLINKExternalIconUrl, 'http://jirasvr/', 'hhttphttp://mycorp.com/jira/')
WHERE EXTERNALSTATUSICONLINK IS WHERE ExternalIconUrl IS NOT NULL

ExternalStatusIconUrl

 

My SQL

ExternalIconUrl

UPDATE ExternalSystemReferences
SET ExternalIconUrl SET ExternalStatusIconUrl= replace(ExternalIconUrlExternalStatusIconUrl, 'http://jirasvr/', 'http://mycorp.com/jira/')
WHERE ExternalIconUrl IS WHERE ExternalStatusIconUrl IS NOT NULLExternalStatusIconUrl

ExternalStatusIconLink

 

UPDATE ExternalSystemReferences
SET ExternalStatusIconUrlExternalStatusIconLink= replace(ExternalStatusIconUrlExternalStatusIconLink, 'http://jirasvr/', 'httphhttp://mycorp.com/jira/')
WHERE ExternalStatusIconUrl ExternalStatusIconLink IS NOT NULLExternalStatusIconLink

 

PostgresSQL

 

SET ExternalStatusIconLinkExternalStatusIconLinkhhttp WHERE ExternalStatusIconLink IS
ExternalSystemReferencesUPDATE ExternalSystemReferences
 SET ExternalUrl= replace(ExternalUrl, 'http://jirasvr/', 'http://mycorp.com/jira/')
 WHERE ExternalUrl IS NOT NULL

 

...

 

ExternalIconUrl

UPDATE ExternalSystemReferences
SET ExternalIconUrl= replace(ExternalIconUrl, 'http://jirasvr/', 'http://mycorp.com/jira/')
WHERE ExternalIconUrl IS NOT NULL

ExternalStatusIconUrl

 

UPDATE ExternalSystemReferences
SET ExternalStatusIconUrl= replace(ExternalStatusIconUrl, 'http://jirasvr/', 'http://mycorp.com/jira/')
WHERE ExternalStatusIconUrl IS NOT NULL

ExternalStatusIconLink

 

UPDATE ExternalSystemReferences
SET ExternalStatusIconLink= replace(ExternalStatusIconLink, 'http://jirasvr/', 'hhttp://mycorp.com/jira/')
WHERE ExternalStatusIconLink IS NOT NULL

 

Also from v4.5 and above of Enterprise Tester, the log Log messages stored for synchronization may also contain hyperlinks. These can be replaced as follows:

...

Once you have searched and replaced all the data, execute some SELECT statements across the tables you have updated and confirm the URLs have been replaced correctly.

We suggest running the following statement:

...

  • Restart IIS, from an administrator command prompt, run the command iisreset /start
  • Login to ET Enterprise Tester (it may take a couple of minutes to start up).
  • Re-enable previously disabled defect links.

  • Try the following tests:

    • Create a new test incident in a project and confirm it synchronizes to JIRA in its new location correctly.
    • Update an existing test incident within a project and confirm it synchronizes to JIRA and has the correctly URL etc. when clicking on the external link displayed in top right corner of the edit incident window.
  • If everything looks OK, go live.  However, if you are now having issues, please Please contact the Catch Support Team and include Team if there are any issues.  Include details of all the steps performed and scripts you executed and any other relevant information such as ET Enterprise Tester log files.