Error importing projects due to Gantt's issue link type style error
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
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
When attempting to import issues on Jira a user or admin may be presented with the following error message:
The Issue Link Type 'Gantt Dependency' has style 'Gantt' in the backup, but has no style in the current system. The Issue Link Type 'Gantt: finish-finish' has style 'Gantt' in the backup, but has no style in the current system. The Issue Link Type 'Gantt: start-finish' has style 'Gantt' in the backup, but has no style in the current system. The Issue Link Type 'Gantt: start-start' has style 'Gantt' in the backup, but has no style in the current system.
Environment
8.13.9
Diagnosis
When doing the import, the error from Summary is presented and it prevents import.
By reviewing the results of the query below you'll find that the Issue Link Types from the error message do not have the expected "pstyle" value.
select * from issuelinktype; Cause
It's unclear whether it's a conflict between two plugins specifically BigGantt - Gantt Chart for Jira and BigGantt - Gantt Chart for Jira coupled with expectations from the importer.
Solution
The solution involves updating the issuelinktype entries so they have the expected value.
Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
The actual values in the {update statement linkname below may change depending on your error message. This article only applies to Gantt link types.
1. Stop Jira.
2. Update database.
update issuelinktype set pstyle='Gantt' where linkname in ('Gantt Dependency','Gantt: start-start','Gantt: start-finish','Gantt: finish-finish');3. Restart Jira.