Pipeline 'X' cannot have cycles

D-3327 1 Reputation point
2022-08-04T14:42:19.883+00:00

I'm trying to validate my pipeline and am getting the above error. This seems to be new behaviour as I've only begun to see this in the last week. Any suggestions? Not exactly sure what this even means. It takes me to the offending portion of the pipeline, which is a for each.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,625 questions
{count} votes

3 answers

Sort by: Most helpful
  1. MartinJaffer-MSFT 26,236 Reputation points
    2022-08-04T16:51:04.907+00:00

    Hello @DaveOdom-3327,
    Thanks for the question and using MS Q&A platform.

    As we understand the ask here is an explanation of "Pipeline cannot have cycles".

    A cycle is activities connected in such a way that it goes in a circle or loop. If you follow the connection lines, you eventually end up where you start. This is a cycle, like a wheel on a bicycle. Picture below

    228273-image.png

    The problem with this, is you could make an activity run more than once, and the pipeline would never end, continuing again and again. So, to protect both your wallet and our computers, we disallow such endless behavior. The validator checks for this sort of cycle, as well as execute pipeline trying to call itself, and variables assigning to itself.

    Since the UI is highlighting a for each, maybe the offending portion is inside the for each, as child activities?

    Does this help?

    Please do let me if you have any queries.

    Thanks
    Martin


    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
      • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators
    0 comments No comments

  2. D-3327 1 Reputation point
    2022-08-04T17:50:16.007+00:00

    228301-image.png

    This is what is in this particular pipeline. There are two foreaches, but it wouldn't create a loop. One foreach looks at rows with a certain criteria, the other diff criteria. If i remove the copy ForEach, then it validates. Another thing I've noticed, is I receive this error even if I clone then entire pipeline..though that may be something else.

    0 comments No comments

  3. D-3327 1 Reputation point
    2022-08-04T18:28:20.51+00:00

    Ok, not sure why, but I duplicated the pipeline, made the same changes to add the second ForEach and now this one validates just fine...not exactly sure why. I looked at the JSON and they look identical. Not very helpful in determining, but maybe if others have a similar issue, try duplicating the pipeline without the changes, then make the changes in the new pipeline and see if it's just something odd in the original?!

    Thanks for looking at this.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.