Issue
The following warning appears on the Fivetran dashboard: Duplicate custom field names.
Environment
Connector: Jira
Resolution
To resolve this error, please follow the steps below:
- Rename one of the duplicate fields in Jira to be unique so that Fivetran is able to write them to the warehouse. For example,
Actual Result
could be renamed asActual Result_1
. - After renaming the duplicate field, run a historical resync on the connector to back-fill the data for the renamed column.
- Delete one of the duplicate fields in Jira if it is not needed.
- In Fivetran, from the top, right-hand side of the screen, click Dismiss Warning.
Cause
This happens when there is more than one column with the same name. These columns are read as duplicates as a result of the Fivetran naming conventions . For example :Actual Result
and Actual result
will be read as actual_result
after the naming conventions. When this happens, the fields will be skipped from the sync.