Unable to perform deployment: Update/create failed for request type field, custom field, due to unsupported field type

Problem

Deployment fails with an error "Unable to perform deployment: Update/create failed for request type field customfield_1000 of request type <request type name> in project <project_name>" due to unsupported field type.


Example error code:

com.botronsoft.jira.jiraservicedeskintegration.api.ServiceDeskIntegrationException: Update/create failed for request type field customfield_1000 of request type request1 in project project1. Fant ikke feltet i Jira.com.botronsoft.jira.jiraservicedeskintegration.api.ServiceDeskIntegrationException: Update/create failed for request type field customfield_1000 of request type request1 in project project1. Fant ikke feltet i Jira. at


This happens while searching for the Customer request type field for which the fieldType value is unsupported.

Solution:

The problem would possibly be in the AO_54307E_VIEWPORTFIELD table in the source instance. Verify that by searching for the below request types in the AO_54307E_VIEWPORTFORM table. Once the IDs are found in the table, AO_54307E_VIEWPORTFORM, query the AO_54307E_VIEWPORTFIELD table. Now check to see if the FIELD_TYPE for any fields is 'unsupported'. 

If any found, it is suggested to either delete the request type fields or fix them, depending on whether they are used or not. If they are used anywhere, update their type in the AO_54307E_VIEWPORTFIELD table to the expected value. To be sure what the exact value should be, check other fields of the same type (or create a new one of the same type).


As a general precaution, before any direct database update, it is recommended to take a database backup. After the update, run a cache refresh for the changes to take effect (this can be done from CMJ's Advanced page)