Exporting test sessions for JIRA Capture

Question

We are migrating projects from JIRA 6.1.4 to a target instance JIRA 6.4.11. The target JIRA 6.4.11 is in a production environment, it contains some other projects. So, we can only use the import project functionality instead of the restore backup system.
We have done this migration through the steps indicated by the Atlassian Support:
1. Create a new intermediate instance of the same version as the source JIRA 6.1.4.
2. Restore this intermediate instance with the backup exported from the source instance 6.1.4.
3. Upgrade the intermediate instance to the same version as the target instance 6.4.11.
4. Import the projects from the intermediate instance to the target instance.
The Intermediate instance contains the test sessions used by JIRA Capture, but the target instance does not.
How can we import the test sessions to the target JIRA?

Thank you so much for your help.

Ignat · Answer

Hi,

This is not an official upgrade or recommended migration path - so please proceed with a migration at your own risk.

Unfortunately there is no out-of the box migration solution available for JIRA Capture data. You would have to locate and copy the Capture related properties manually.

JIRA Capture stores it's data in JIRA Properties, they must be stored in the OS_PROPERTYENTRY.

In the OS_PROPERTYENTRY table you'll see properties with entity names:

* Excalibur.* (e.g. Excalibur.Session.Storage)

* Bonfire.* (e.g. Bonfire.Active.Session.Id)

Before proceeding on any of the environment, please prepare a database and/or JIRA backup.

Please ensure it works as you expect in the intermediate JIRA instance before applying to the production instance.

Afterwards you may need to update the related sequence values for the table (so the newly created rows would not overwrite the existing properties).

I also recommend to shut down JIRA while you manipulate the properties tables, as these might be cached on JIRA side.

--
Cheers,
Ignat.

Sanaa Marmar · Answer

Hi Ignat,

Thank you for the prompt reply.

Yes, we have upgrade the intermediate instance with the whole JIRA backup. Unlike the target JIRA instance where we have imported the projects using the import project functionality. That's why we can see the test sessions in the intermediate JIRA instance but not in the target JIRA instance. We can not perform a restore backup in the target system as we have done in the intermediate JIRA instance, because we won't loose the already existing projects.

Is there any way to import the test sessions in the target JIRA instance? Using some add-on, or doing with some sql scripts? what JJIRA database tables are used by the test sessions?

Thank you so much!

Ignat · Answer

Hi,

Have you upgraded the intermediate instance with the whole JIRA backup or via the project export?

I assume you have upgraded via JIRA backup and that's why you see the Test Sessions there, but not into the production instance.

Cheers,
Ignat.