Request Type doesn't refresh after deleting Custom Field - PCJ
Problem
When a custom field is deleted, the Request type doesn't refresh its own references. Jira works in this way. Therefore you need to do it manually.
Error example:
“Trying to export Request Type found problem: Could not find object: Field with ID 'customfield_XXXXX' used by Request Type 'XXXX' “
Solution
Please execute the following query:-
DELETE FROM AO_54307E_VIEWPORTFIELD WHERE FIELD_ID = 'customfield_XXXXX'Please make sure to take a backup of the database before executing any delete queries
Note: replace XXXXX with the custom field number
Related articles
Example
A customer exporting a Jira Service Management project saw the following Project Configurator error:
“Trying to export Request Type found problem: Could not find object: Field with ID 'customfield_16824' used by Request Type 'Release to Production'”
In this case, the custom field customfield_16824 had already been deleted from Jira, but the request type Release to Production still had a stale reference to that field in the Jira Service Management request type configuration table.
To confirm the stale reference, check the request type field table for rows matching the missing field ID:
SELECT *
FROM AO_54307E_VIEWPORTFIELD
WHERE FIELD_ID = 'customfield_16824';If the returned rows only reference the deleted custom field, remove the stale request type field reference with:
DELETE FROM AO_54307E_VIEWPORTFIELD
WHERE FIELD_ID = 'customfield_16824';Important: Always take a database backup before running any delete query. If possible, test the change in a non-production environment first.
After removing the stale reference, retry the Project Configurator export.
Related articles