Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,976 questions
Azure Data Factory - Jira Connector Schema Change / missing data
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 62%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJ%3C/text%3E%3C/svg%3E)
Jose
0
Reputation points
Hi All,
We have been using ADF to ingest Jira into our data lake for several months now. The connector has worked with no issues and we have been able to pull all issues and all the custom fields, etc from Jira. Our Monday refresh failed due to a schema change in platform API issue and extra API issue. Now all the data is no longer being returned from the extra.api_issue. We are only getting a subset of total issues in Jira.
Is anyone aware of API changes that would break the ADF connector? Is there any other table in the ADF connector that would give me the custom fields? Story points and other values are driven in there for us.
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu 12,010 Reputation points Microsoft Vendor2024-06-19T10:08:40.58+00:00 Hi @Jose
Thank you for reaching out to the community forum with your query. Regarding your issue with the Azure Data Factory Jira Connector. Based on your description, it seems that the schema change in the platform API issue and extra API issue has caused the ADF connector to stop returning data from the extra.api_issue. To answer your question, there have been no API changes that would break the ADF connector. However, it is possible that the schema change in the platform API issue and extra API issue has caused the connector to stop working as expected. To resolve this issue, you can try the following steps:1. Check the Jira API documentation to see if there have been any changes that could affect the ADF connector.1. Check the ADF connector configuration to ensure that it is set up correctly and that the correct API endpoints are being used.
- Check the ADF connector logs to see if there are any error messages that could provide more information about the issue.
- Try recreating the ADF connector to see if that resolves the issue.
Regarding your question about custom fields, you can try using the Jira API to retrieve the custom fields data. You can find more information about retrieving custom fields data from Jira.
I hope this helps. Let me know if you have any further questions.
-
Jose 0 Reputation points
2024-06-19T17:13:58.45+00:00 Thanks for your answer but this does not help. The Jira Connector in Azure Data Factory is a native integration provided by Microsoft. Either something has broken with this integration that is in a prod release of Azure Data Factory or Jira has changed API calls and Microsoft needs to update the connector. If these is a known issue with this connector in ADF then this needs to be made known.
-
Jose 0 Reputation points
2024-06-19T17:14:42.1666667+00:00 comment posted duplicate..
-
Smaran Thoomu 12,010 Reputation points Microsoft Vendor
2024-06-21T07:42:08.4533333+00:00 Hi @Jose
Thank you for your response. I apologize for any confusion caused by my previous response. You are correct that the Jira Connector in Azure Data Factory is a native integration provided by Microsoft, and if there is a known issue with the connector in ADF, it should be made known.
Additionally, I checked internally there is no issue found related to the Jira connector. Can you try reaching out to Microsoft support for further assistance in troubleshooting the issue.I hope this helps. Let me know if you have any further questions or concerns.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 36%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Kelly Mathison 20 Reputation points2024-06-21T15:26:50.47+00:00 I am also experiencing this exact same issue this week, any update on what exactly is going on?
-
Jose 0 Reputation points
2024-06-24T19:55:05.21+00:00 I have a ticket open with Azure support. Our dashboards have been down for a week now. Atlassian was no help with their support.
-
Smaran Thoomu 12,010 Reputation points Microsoft Vendor
2024-06-25T09:22:33.3066667+00:00 @Jose If you have opened a support ticket, a reference to the ticket number would be greatly appreciated. This will allow us to track the progress of your request and ensure you receive the most efficient support possible.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(121.6, 98%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Martin McLaren 0 Reputation points2024-06-27T13:26:46.5166667+00:00 I am experiencing the same issue as well. An update would be appreciated.
-
Jose 0 Reputation points
2024-06-28T13:42:36.26+00:00 @Smaran Thoomu This is the support ticket TrackingID#2406200040011082
Sign in to comment