How to create a fresh server-id for Jira

[Martin Bayreuther]

We are cloning our production instance to a test / development machine every other week. During the restore process, the Server-ID is restored as well which means both instances run with the same ID. Now we are going to implement some new features and we want to test that on the development machine.

However a new application link cannot be created due to "Duplicate Server ID". This is correct. However I have a developer license as well (which is not used anywhere because the dev instance is a clone),

How can I change the dev instances server ID to my correct dev license ID?

MaBa

[Colin Goudie · Accepted solution]

Look for the propertyentry with PROPERTY_KEY=jira.sid.key and take note of its ID

e.g. One I checked as 10110

Then do a select * from propertystring where id=10110

The value returned is the Server ID

[Ritesh Shah]

Hi Colin,

Is there any chance that jira may change column name of table ?  

Thanks.

[Mark Symons]

A bit of googling for the Application Links error message...

We have already an Application Link to this application configured. Please update existing configuration.

...leads to a logged issue with a fix version scheduled:

APL-629: Using the server id is not a good way to track applinks

[Colin Goudie]

It is stored in an OSPropertyString

You can either

1. Export your JIRA instance to a zip. Unzip it, and read the entities.xml file. Change it. Reimport back

OR

2. Use the id from the above zip and change directly in the database

Give that a go

[Martin Bayreuther]

Hello Colin,

our instances ZIP file is about 150 Meg. Unzipped it is huge and therefore it is quite hard to edit in a "conventional" way. I could use awk or perl or something.

But then again it will take about 4 hours for the import. So I will look into the DB approach.

Best regards

Martin

[Martin Bayreuther]

Hello Colin or anybody else,

I cannot find the Server ID in the database. Do you happen to know where I can find the ID (which table, key for the table row).

Best regards

Martin

[Colin Goudie]

Sounds like you are after this answer - https://answers.atlassian.com/questions/28659/confluence-how-can-i-change-the-server-id-and-what-will-this-affect

[Martin Bayreuther]

Similar like that. I just need this for Jira not Confluence.

The Jira properties file does not contain the server id.

Neither does the server.xml.

I have no idea where it is stored.

[Colin Goudie]

Oops sorry. Try my other attempt :)