Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Chelly
Frequent Visitor

Error Encountered During Data Factory Pipeline Execution

Hello, I'm currently working on the 'Get Started with Fabric' exercise, specifically in the 'Modify the pipeline' section of using Data Factory pipelines in Microsoft Fabric. After running the pipeline, I encountered an error with the notebook activities. Despite retrying the exercise, I consistently face the same error message:

Operation on target 'Load Sales notebook' failed: Notebook execution encountered an error at the Notebook service with HTTP status code - '200'. Please review the Run logs on the Notebook for additional details. Error details: 'Error name - AnalysisException, Error value - org.apache.hadoop.hive.ql.metadata.HiveException: MetaException(message: Spark SQL queries are only possible in the context of a lakehouse. Please attach a lakehouse to proceed.)
Thanks

2 ACCEPTED SOLUTIONS
v-nikhilan-msft
Community Support
Community Support

Hi @Chelly 
Thanks for using Fabric Community.
Can you please follow the below steps and retry :

At the leftside of the notebook please click on lakehouses.

vnikhilanmsft_1-1709809452832.png


Click on Add lakehouse.

vnikhilanmsft_2-1709809483757.png

Select the lakehouse where the table resides. Attach the lakehouse to the notebook.

vnikhilanmsft_3-1709809529897.png


Now try to run the pipeline. Please let me know if the issue still persists.

 

View solution in original post

Tini
Frequent Visitor

Hello

I encountered the same issue, and the solution that worked for me was to navigate to the notebook, go to "Lakehouses," select "Remove all lakehouses," and then add the same lakehouse back.

Tini_1-1709815108325.png


After doing this, the pipeline ran fine for me.


View solution in original post

5 REPLIES 5
Tini
Frequent Visitor

Hello

I encountered the same issue, and the solution that worked for me was to navigate to the notebook, go to "Lakehouses," select "Remove all lakehouses," and then add the same lakehouse back.

Tini_1-1709815108325.png


After doing this, the pipeline ran fine for me.


Yep it worked to remove and add back
v-nikhilan-msft
Community Support
Community Support

Hi @Chelly 
Thanks for using Fabric Community.
Can you please follow the below steps and retry :

At the leftside of the notebook please click on lakehouses.

vnikhilanmsft_1-1709809452832.png


Click on Add lakehouse.

vnikhilanmsft_2-1709809483757.png

Select the lakehouse where the table resides. Attach the lakehouse to the notebook.

vnikhilanmsft_3-1709809529897.png


Now try to run the pipeline. Please let me know if the issue still persists.

 

I have the same problem but removing and adding the lakehouse doesn't solve it. It worked fine until recently, any suggestions on what I can try.

Hi @Chelly 
Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

November Update

Fabric Monthly Update - November 2024

Check out the November 2024 Fabric update to learn about new features.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.