Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,196 questions
Why in switch activity case name change to default?
![](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(38.4, 98%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Anuganti Suresh
200
Reputation points
I have one nested json and wants generate 15 tables out of that to Azure SQL. Used switch activity to satisfy condition that once pipeline fails (assume that 5 tables completed and while running 6th table got failed) & while rerunning pipeline need to run from failed table.
While doing this task facing two issues:
- Getting below error while debug the pipeline. But if i debug untill 3rd Lookup getting success. It failing for entire pipeline.
a) debug untill 3rd Lookup (success)
b) debug for entire pipeline (Getting Below error)
- In switch activity added 15 cases for 15 different data flows. When you open data flow under switch activity case name disabled and set it to default. But while creating pipeline all 15 cases it showing table names.
{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(240, 77%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Richard Swinbank 372 Reputation points MVP2024-02-10T13:02:17.69+00:00 Can you provide the detail of the error reported in 1(b)? (What's behind the "View error detail" link in the "Run failed" dialog?)
Which case is displayed in your last screen shot? The breadcrumb trail suggests the case value is "actorroles" but I notice your case list includes an "actor_roles" case (with an underscore). Assuming you don't have both of these, I'm wondering if ADF Studio has some issue — what happens if you try Ctrl + F5 to reload your ADF Studio session?
-
Anuganti Suresh 200 Reputation points
2024-02-10T15:57:40.95+00:00 @Anonymous , Below is the Error getting for 1(b).
-
Anuganti Suresh 200 Reputation points
2024-02-10T16:20:06.43+00:00 @Anonymous , Below is the screenshot of switch activity with 13 cases. Only actor dataflow is showing correctly and remaining showing as default.
-
Richard Swinbank 372 Reputation points MVP
2024-02-11T13:00:33.0433333+00:00 Is your pipeline passing validation? If it won't run at all that may indicate that it has some validation error.
-
Anuganti Suresh 200 Reputation points
2024-02-11T15:23:33.9266667+00:00 @Anonymous , It passing validation.
-
Richard Swinbank 372 Reputation points MVP
2024-02-11T15:48:04.1866667+00:00 Are you able to share the JSON code for the pipeline? Please only do this if it contains no personal or sensitive information. You can access the code by clicking the "{ }" icon in the top right of the design surface.
-
Anuganti Suresh 200 Reputation points
2024-02-11T16:14:11.14+00:00 @Anonymous , pipeline json file attached. Error 04.txt
-
Richard Swinbank 372 Reputation points MVP
2024-02-11T17:55:15.4033333+00:00 I'm getting the same behaviour as you for the second issue (display of "Default") — it looks like an ADF Studio bug to me.
- If I select a case label without underscores, like "actor", the case label is displayed as expected on the pipeline page for the case
- If I select a case label containing underscores, like "actor_roles", the breadcrumb trail shows the label without the underscore ("actorroles") and the pipeline page for the case shows the "Default" label, grayed out
I notice that the correct data flow activity for the selected case is always displayed, however, so I'm not sure if this would cause your pipeline to fail (or if it's just a display issue in ADF Studio).
Can you remove underscores from your case labels? I want to find out two things:
- whether removing underscores makes ADF Studio display cases normally
- whether or not this allows the pipeline to run
I think you're only using
ObjectTypeas a source of case labels so you couldSELECT REPLACE(ObjectType, '_', '') AS ObjectType , LoadStatus FROM [dbo].[TBL_LOG_FAILURE_PIPELINE] ...in your Lookup activity.
-
Anuganti Suresh 200 Reputation points
2024-02-11T18:30:42.0533333+00:00 @Anonymous Lookup table created as below:
recreated switch activity cases without underscore but still getting error as in 1b.
-
Richard Swinbank 372 Reputation points MVP
2024-02-11T19:40:21.8533333+00:00 I wondered if that might happen. Has it at least fixed the display issue (2)?
-
Anuganti Suresh 200 Reputation points
2024-02-12T06:17:14.2666667+00:00 @Anonymous ,
After avoiding underscore in case names able to fix display issue. -
![](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,620 Reputation points Microsoft Vendor2024-02-14T13:10:16.9833333+00:00 Anuganti Suresh Following up to see if the above suggestion was helpful. And, if you have any further query do let us know.
Sign in to comment