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.