Forum Discussion

aAmirkHan's avatar
aAmirkHan
Helper III
2 years ago
Solved

Notebook execution failed at Notebook service with http status code - '200'

I follow the steps instructively mentioned in Microsoft Learn Lab " Ingest data with a pipeline in Microsoft Fabric".

However, I am still getting errors while following the same steps in "Modify the pipeline" in the lab. 

 

Notebook execution failed at Notebook service with HTTP status code - '200', please check the Run logs on Notebook, additional 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.)' 

Can you please help me with this and how to fix it?

 

 

 

 

data engineering

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi aAmirkHan 

    Thanks for using Fabric Community.

    Can you please try to create a new notebook and then attach the lakehouse. Now try to run this notebook from the pipeline. If the issue still persists please do let me know. This way there wont be a grey out option and you can attach or detach the lakehouse.

     


    Did you try to set the target lakehouse as the default lakehouse? Default lakehouse is identified by the pin icon.

     

     

    You can refer to this link for more help

    https://community.fabric.microsoft.com/t5/General-Discussion/Notebook-fails-with-error-200-when-run-from-Pipeline/m-p/3756263#M5024

     

    Hope this helps. 

  • aAmirkHan's avatar
    aAmirkHan
    Helper III
    2 years ago

    Hi Anonymous ,

     

    Thank you for your quick response to my query. I have tried your suggestion, where I can see data in the lakehouse.

     

    However, I am following up with Microsoft Lab "Use Data Factory pipelines in Microsoft Fabric".

    I am in doubt at this stage and maybe I am getting errors due to these steps.

     

    Can you please help what I should select in the base parameters?

     

     

    Thank you once again