\uD83E\uDD14 Problem
When performing snapshot deployment using CMJ, the below error occurs :
“Unable to perform deployment: Unable to apply change 'type: change, old value: , new valueJiraConfigurationRoot#root/JiraFilter<Filter Name>_<user>/JiraColumnLayout# <Customfields present in coloumnlayout of the filter>, feature: columnLayout' “
Example Error :
https-jsse-nio-8443-exec-8 ERROR FGQR096 1044x132288x1 1gr9p2q 10.227.87.18 /rest/configuration-manager/1.0/deployment/6 [c.b.j.r.impl.rest.AbstractResource] com.botronsoft.jira.rollout.snapshot.SnapshotOperationFailedException: Unable to perform deployment: Unable to apply change 'type: change, old value: , new value JiraConfigurationRoot#root/JiraFilter#Monthly_gonelive_G_MIS_k1903/JiraColumnLayout#Application Name_com.atlassian.jira.plugin.system.customfieldtypes:select_BTG TEAM LEAD_com.atlassian.jira.plugin.system.customfieldtypes:userpicker_Concept Approval Date_com.atlassian.jira.plugin.system.customfieldtypes:datepicker_issuekey_summary_status_Final Go Live Date_com.atlassian.jira.plugin.system.customfieldtypes:datepicker_Count of Test Cases_com.atlassian.jira.plugin.system.customfieldtypes:textfield_FPN Amount_com.atlassian.jira.plugin.system.customfieldtypes:float_Release for UAT Date_com.atlassian.jira.plugin.system.customfieldtypes:datepicker_SIT End Date_com.atlassian.jira.plugin.system.customfieldtypes:datepicker_UAT Sign-off Date_com.atlassian.jira.plugin.system.customfieldtypes:datepicker_Total no.of bugs raised_com.atlassian.jira.plugin.system.customfieldtypes:float_Business Group_com.atlassian.jira.plugin.system.customfieldtypes:select_Executive Sponsor_com.atlassian.jira.plugin.system.customfieldtypes:select_Business Sponsor (Picklist)_com.atlassian.jira.plugin.system.customfieldtypes:select_Benefit_com.atlassian.jira.plugin.system.customfieldtypes:select_Benefit value (per anum)_com.atlassian.jira.plugin.system.customfieldtypes:float_Benefit Justification (As per Concept Note)_com.atlassian.jira.plugin.system.customfieldtypes:textarea_reporter_BTG / BSG SUPERVISOR_com.atlassian.jira.plugin.system.customfieldtypes:userpicker_Planned Go Live Date_com.atlassian.jira.plugin.system.customfieldtypes:datepicker_created_Size of Enhancement_com.atlassian.jira.plugin.system.customfieldtypes:select_Delivery Date (on-site) _com.atlassian.jira.plugin.system.customfieldtypes:datepicker_UAT Signoff Date_com.atlassian.jira.plugin.system.customfieldtypes:datepicker, target object: JiraConfigurationRoot#root/JiraFilter#Monthly_gonelive_G_MIS_k1903, feature: columnLayout' at java.base/java.util.concurrent.FutureTask.report(Unknown Source) at java.base/java.util.concurrent.FutureTask.get(Unknown Source) at com.botronsoft.jira.rollout.impl.jobs.AbstractAsyncOperation.getResult(AbstractAsyncOperation.java:61) at com.botronsoft.jira.rollout.rest.internal.snapshot.DeploymentResource.createResponse(DeploymentResource.java:865) at com.botronsoft.jira.rollout.rest.internal.snapshot.DeploymentResource.getDeploymentOperationResult(DeploymentResource.java:570) ...
The error indicates that there is more than one custom field with the same name in the column layout of a filter that the user is trying to migrate.
\uD83C\uDF31 Solution
Analyze the Atlassian Jira logs and find which custom field is causing the error as below example
Caused by: java.lang.IllegalStateException: More than one match is found for Custom field '<customfield name>'.
2. Remove the duplicate custom fields from the column of the filter.
3. Create a new snapshot and deploy.
4. If there are a large number of filters having the same set of duplicate custom fields in their column layouts, you can find all those filters by running below SQL.
select cl.id, cl.username, cl.searchrequest, sr.filtername, cli.fieldidentifier
from columnlayoutitem cli, columnlayout cl, searchrequest sr
where cli.columnlayout = cl.id
and sr.id = cl.searchrequest
and cli.fieldidentifier IN ('customfield_xxxxx', 'customfield_xxxxx', 'customfield_xxxxx')
order by cl.id, cl.searchrequest
Note: In the 5th line of the SQL query, you need to mention the duplicate custom field ids along with the original custom field id.
Run the SQL above and save the results as CSV.
Filter all custom fields different from the original custom field.
In Jira, open each filter and remove the columns with duplicate custom field names.
Recreate the snapshot and deploy.