After upgrading Jira 8.x to 9.x Datacenter Advanced Roadmaps is not available
Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.
Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles for non-Data Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Advanced Roadmaps is part of Jira Software Data Center from Jira version 8.15 or later; after upgrading Jira to 8.20.x and applying the Datacenter license, Advanced Roadmaps is not available to users.
Environment
Jira Datacenter 8.20.X.
Diagnosis
Check that the Jira version is correctly updated in the propertystring table by running the below SQL in the Jira database :
select * from propertystring where id = (select id from propertyentry where property_key = 'jira.version.patched');
select * from propertystring where id = (select id from propertyentry where property_key = 'jira.version');If you see an incorrect value of "jira.version.patched" and "jira. version" in the SQL results, then proceed with Solution.
Cause
The problem is with the build version not getting updated in the database during upgrading Jira.
Solution
Manually update the Jira version
As with all recommendations made by Atlassian Support, please follow best practices for Change Management and test and validate these settings in a Development/Test and Staging environment prior to rolling any changes into a Production environment. It's also advised to have a recent database backup prior to manual database intervention.
Take Database Backup
- Update correct versions by running the below update query against Jira DB:
update propertystring set propertyvalue = '820100' where id = (select id from propertyentry where property_key = 'jira.version.patched');
update propertystring set propertyvalue = '8.20.10' where id = (select id from propertyentry where property_key = 'jira.version');3. Try Accessing Advanced Road maps after some time.