Explore regression with Azure Machine Learning Designer - Pipeline has failed child jobs. Failed nodes: /select_columns_in_dataset, /execute_python_script.

Question

Hi

I am I am trying to follow the tutorial at this link here https://microsoftlearning.github.io/AI-900-AIFundamentals/instructions/02a-create-regression-model.html#create-training-pipeline

After performing the steps listed under create and run an interface pipeline

I get 2 failed nodes/select_columns_in_dataset, /execute_python_script as seen below.

Steps 7 mentions "Now that you’ve changed the schema of the incoming data to exclude the price field, you need to remove any explicit uses of this field in the remaining modules. Select the Select Columns in Dataset module and then in the settings pane, edit the columns to remove the price field." However, I tried to do this and I get the same errors

1. Select_column_in_Dataset:ModuleExceptionMessage:ColumnNotFound: Column with name or index "price" not found.
2. Execute_python_script:ModuleExceptionMessage:InvalidDataset: Dataset1 is not valid, reason: input path does not exist. There are several possible causes: 1. Your input is a registered dataset but the dataset is invalid; 2. Your input is the output of a reused module, but the output of the module is removed;

Please help. I tried changing this in multiple different ways but nothing has worked for me.

Answer 1

Hi @Lee, Lavinia

Following up to see my above "comment" answer helps by checking the comments section of this thread. Do let us know if you have any queries.

To reiterate the resolution here, let me jot down the gist of my comment answer above.

I suggest you to Configure & Submit (see below image) before create interface pipeline and also please check the logs of the module for more details regarding the errors.

Please have a look at the sample implementation done in the above "comment".

Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics. Thank you!

Answer 2

Thank you for your response and sorry for the delay in getting back to your response. I think there must've been a glitch in the system. I restarted my computer and it all worked out fine after that.

Answer 3

Hi @Lee, Lavinia ,

I'm glad that you were able to resolve your issue and thank you for posting your solution, so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others ", I'll repost your solution in case you'd like to accept the answer.

Question: Explore regression with Azure Machine Learning Designer - Pipeline has failed child jobs. Failed nodes: /select_columns_in_dataset, /execute_python_script.

Answer: There must've been a glitch in the system. Restart the computer and it will be work out fine after that.

Thank you!

---

Please click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.