How to fix the error - executeJobPreviewDataQuery no active stream for job=<job run id>

Question

Hello,

I am receiving this error while doing the Data Flow Data Preview in Debug.

It's not consistent. Sometimes it will appear at the first step, sometimes somewhere along the flow, for previewing data of as simple as a Select step.

We have checked the source and all other connectors, redid everything however the issue still remains unresolved.

Any guidance is highly appreciated.

Regards,

Pallavi

Answer 1

Hello @Pallavi Rajan Chincholkar Thanks for posting this query on this forum.
Please do post the outcome from the support ticket on this forum, which will be helpful to other community members, thanks for your understanding!

Some of the troubleshooting steps are:

Sometimes the error was observed if we started using a conditional split transformation, but the issue was already addressed by the product team, if this is the case, then please do comment in the below section and we will be in touch with you to help further.

If you do run into issues with loading a Flowlet, either using the refresh button within ADF or on the browser has been likely to resolve it.

Derived column transformation to replace the flowlet and it works.

Data preview for Flowlets is only supported in output transformation and requires that you specify all of the input data for that output transformation.

Answer 2

The error in Azure Data Factory suggests an inconsistency in fetching or streaming data for preview. This can be due to transient network issues, hitting service limits, or issues with the source data. Ensure there are no connectivity issues on your end and that you're not exceeding any service quotas. Clearing your browser cache, trying different browsers, and refreshing metadata can sometimes solve these glitches. Additionally, enabling logging can provide more insight. If none of these solutions work, consider recreating the affected resources or reaching out to Azure Support for more specific assistance.