-
Bug
-
Resolution: Fixed
-
Low
-
3.0.0, 4.0.0, 5.0.0, 5.17.2
-
1
-
Severity 3 - Minor
-
0
-
Problem
Deleting a custom field does not remove it from the "AO_54307E_VIEWPORTFIELD" table, which holds the fields for the JSM Request Types.
Suggested Solution
When removing a custom field that is not in use anymore, any reference to it should also be removed from the database
Why This Is Important
Although no apparent issue or loss of functionality is noticed within Jira itself, some third-party apps such as Project Configurator may be impacted by those "orphaned" references and throw errors in the logs as below:
2024-07-23 15:49:57,873-0300 JiraTaskExecutionThread-3 ERROR user [c.a.projectconfigurator.projectconfigserialize.ProjectConfigSerializingContext] [Project ITP] [Service desk ITP] [Request Type Desktop/Laptop support@@Service Request] Trying to export Request Type found problem: Could not find object: Field with ID 'customfield_10900' used by Request Type 'Desktop/Laptop support' com.awnaba.projectconfigurator.utils.errorhandling.ObjectNotFoundException: Could not find object: Field with ID 'customfield_10900' used by Request Type 'Desktop/Laptop support'
Workaround
- A possible workaround is to manually delete the records from the "AO_54307E_VIEWPORTFIELD" table. However, please be careful when doing so, as that table holds data related to all custom fields in use by any Request Type. You can find the detailed steps on how to do that in the KB article https://confluence.atlassian.com/jirakb/error-occurs-on-deleted-customfield-when-migrating-jira-projects-by-using-project-configurator-for-jira-1360661228.html
- Other than that, another approach would be to actually reach out to the third-party app developer for assistance on how to proceed with those errors.
- links to
| Form Name | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
[JSDSERVER-15464] Deleting custom fields used in Request types leaves information in the Jira database that should be removed
| Resolution | New: Fixed [ 1 ] | |
| Status | Original: Waiting for Release [ 12075 ] | New: Closed [ 6 ] |
| Fix Version/s | New: 10.6.0 [ 110418 ] |
| Status | Original: In Progress [ 3 ] | New: Waiting for Release [ 12075 ] |
| Status | Original: Short Term Backlog [ 12074 ] | New: In Progress [ 3 ] |
| Assignee | New: Luke Ellis [ cfd0dcced0d7 ] |
| Status | Original: Gathering Impact [ 12072 ] | New: Short Term Backlog [ 12074 ] |
| UIS | Original: 1 | New: 0 |
| Labels | New: ril |
| Remote Link | New: This issue links to "Internal ticket (Web Link)" [ 956109 ] |
| UIS | New: 1 |