Forum Discussion
Dataflow refresh job failed: Job instance failed without detail error
- 1 year ago
Hi nathan-verghis ,
Thanks for the follow-up.Since the issue persists even after trying the available workarounds and there's no clear indicator from the Dataflow logs, the best next step would be to raise a support ticket with Microsoft for deeper investigation. If you've already raised a support request, please consider sharing any insights or resolutions provided by the support team here, it would be helpful for others facing the same issue.
Also thanks to miguel and Ilgar_Zarbali for addressing this and sharing your valuable insights.
Best Regards,
Vinay,
Community Support Team.
Hi all,
I just wanted to add a few things. I've seen a number of different 20302 errors on dataflow refreshes. Some I have figured out, some I haven't.
I just saw this specific version today:
"Dataflow refresh job failed with status: Failed. Error Info: { errorCode: JobInstanceStatusNotFound, message: Job instance not found, requestId: 1702ea03-eada-4865-96c2-73c4f9c6ee9b }"
I looped through all the dataflows (Gen 2 CICD) ```````````````````````````````````````````````````````````````````````````` in a workspace (all created by me, with my own connections, no one else has touched them, and 2 out of 8 failed with that message. I checked out the recent runs of those dataflows. interestingly, these 2 dataflows were still actively running. I thought maybe it was some sort of resource error or timeout error so I was looking at the durations. One of the two that caused that error in the pipeline happened after 6m 10s. The other after 5m 14 seconds. However one of the successful runs had a duration of 5m 14 seconds. I checked the job instance status later for these dataflows, and both show failed, though the logs of the runs themselves show everything succeeded.
A couple of the other errors I've seen, one with a somewhat helpful error message, one very much not.
The first has an error something like notpublishederror..I can't remember exactly. With Gen2 CICD, some folks might not yet realize that when you deploy them to a new workspace you have to 1: Manually update the data destination. There is no functionality yet to use deploymen t parameters for datasources or data destinations for Gen 2 CICD. And 2: You must Save and Run (the new "publish") the CICD once deployed. All of this, every time. Kind of annoying but it works. There just doesn't seem to be a good way to handle deployments with varying data sources and destinations by environment yet, despite these being CICD versions.
The other error will simply say "Invalid Request, Unexpected Dataflow Error". What I've learned so far is that the dataflow activity will work fine with Gen 2 CICD dataflows if you select them from the dropdown statically. Which, of course, isn't a very realistic use case. When running the dataflows dynamically and supplying the dataflow Id at runtime, the activity doesn't know that it's a CICD version, and it's missing a specific dataflow type property and value that it needs in order to process these. I have found a kind of work around where you can manually edit the pipeline json and add this property to the activity object code. And it works. But, if you open that dataflow activity and work with it and then close it, it has no overwritten your code change and defaulted back to removing that property and it will fail again. There is some good information in this Reddit thread. https://www.reddit.com/r/MicrosoftFabric/comments/1khpav5/issue_refreshing_gen_2_cicd_dataflow_in_pipeline/
Hi jcantwell ,
Thanks for engaging with Microsoft Fabric Community and for the detailed explanation.
At the moment, parameterizing the DataflowId in the Dataflow activity within Pipelines is not supported for Dataflows with CI/CD (Git integration) enabled. This is a current limitation while the feature is in preview. If you use dynamic DataflowId references in Pipelines, they will only work for legacy Dataflow Gen2 instances without CI/CD support. For now, CICD Dataflows should be referenced by selecting them directly from the dropdown in the activity configuration. As an alternative, it’s possible to trigger Dataflow Gen2 CI/CD variants using the new Fabric REST APIs.
Reference: Dataflow activity - Microsoft Fabric | Microsoft Learn
Similar discussion: How to make a Dataflow pipeline generic in Microso... - Microsoft Fabric Community
For deployments using Dataflow Gen2 with CI/CD, after deploying to a new workspace, it’s necessary to manually update the Data destination, as deployment parameters are not yet supported for data sources or destinations.
Additionally, Publish is replaced by Save and Run to finalize any changes.
These limitations are temporary, and Microsoft is working on supporting dynamic usage of CICD-enabled Dataflows and improving the deployment experience.
Hope this helps, and thanks for your patience.