Activity run fails with "BadRequest" in published mode, succeeds in debug mode

Akshay Mahajan 21 Reputation points

Hello, we have a pipeline, in which an activity constantly fails with the following reason code

Error: The request failed with status code '"BadRequest"'.

This pipeline runs just fine in debug mode. And I have verified that there are no changes yet to be published. Here are the run IDs.

Activity run id: 6a89b05e-7beb-4fc4-b1a4-336e8576d96d
Pipeline run id: cb497967-883f-4eaf-99eb-176b8c582683

I had submitted these details via the feedback option in data factory UI, here is their latest feedback.

"I looked into our logs and I do see your DataFlow activity failed. Can you try rerunning to ensure this is not a transient issue?
If the issue persist, please file a support ticket with your activity run id for us to look into this further."

update: We have also tried to make a few changes, and re-merge those changes into master and publish, to rule out any code merge issues. The issue still persists.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,509 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Akshay Mahajan 21 Reputation points

    As a workaround, we were able to fix this by creating a new Integration Runtime and attaching to the existing pipeline. The exact root cause is not known though.