JIRA SERVER

In the Exalate 4.x for JIRA Server, we've disabled possibility to edit the Destination Instance URL to avoid complicated situations.

But there are valid scenarios where you might need to change the URL of the Connection with the Destination Instance.

For example: 

  1. When staging production into the testing environment
  2. If the URL of the Destination Instance changed: for example they've introduced https

 

To change the Connection URL use following steps:

  1. Execute the SQL query below:

    UPDATE AO_08F1AF_INSTANCE
    /* Change the XXX to your new URL */
    SET URL = 'XXX'
    WHERE ID IN (
      SELECT INSTANCE_ID
      FROM AO_08F1AF_RELATION
    /* Change YYY to the relevant Connection name */
      WHERE NAME = 'YYY'
    );

    For Postgres
    UPDATE "AO_08F1AF_INSTANCE"
    /* Change the XXX to your new URL */
    SET "URL" = 'XXX'
    WHERE "ID" IN (
      SELECT "INSTANCE_ID"
      FROM "AO_08F1AF_RELATION"
    /* Change YYY to the relevant Connection name */
      WHERE "NAME" = 'YYY'
    );
  2. Navigate to edit the Connection and click Save.