topic Re: Notebook execution failed at Notebook service with http status code - '200' in Data Engineering

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

DTTeam4 — Thu, 04 Apr 2024 15:46:45 GMT

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:Unable to fetch mwc token)' :

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

Anonymous — Fri, 05 Apr 2024 05:18:23 GMT

Hi @DTTeam4
Thanks for using Fabric Community.
Can you please provide the code which you are running in the Notebook? This helps me in understanding the issue better.
The error refers to a Managed Workload Center (MWC) token, which is used for authorization when accessing resources like Hive within a secured cluster.

Possible Causes:

Missing MWC Token Configuration: Your notebook might not be configured to retrieve the MWC token needed for Hive access.
Incorrect MWC Token Permissions: Even if configured, the MWC token might lack the necessary permissions to access Hive resources.

Troubleshooting Steps:

Check Notebook Configuration: Review your notebook code for any sections related to MWC token configuration. Ensure it's set up correctly to retrieve the token before accessing Hive.
Verify MWC Token Permissions: Investigate the permissions associated with the MWC token being used. It needs to have read/write access to the Hive Metastore and any relevant databases/tables you're trying to access.

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

Anonymous — Mon, 08 Apr 2024 20:04:03 GMT

Hi @DTTeam4
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution, please do share that same with the community as it can be helpful to others. Otherwise, will respond back with the more details and we will try to help.
Thanks

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

Anonymous — Wed, 10 Apr 2024 17:16:27 GMT

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

scca — Wed, 08 May 2024 00:30:53 GMT

I have the same issue. It's a notebook that I schedule to run on parallel for multiple data sources. Out of all runs, only one failed with this error. I have read the suggestions and it points to notebook configurations but since other runs of the same notebook went through successfully, it proves that it is not an issue caused by the user (e.g. configuration). Not to mention, notebook configuration is quite limited to users in the first place.

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

Lado_Kvara — Wed, 08 May 2024 21:01:57 GMT

I'm encountering the same issue with pipeline execution. The pipeline runs the notebook, of which I am the creator and therefore the owner. The notebook is located in Workspace A, but it references a table in Workspace B.

If I'm absent from work and my colleague executes the pipeline without access to Workspace B, it fails with the error: 'table or view does not exist, or a column within a table or view that does not exist.'

What would be the appropriate approach to address this issue?

Perhaps using a service account when creating notebooks?

Can the owner of the notebook be changed after it has been created?

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

MaxBronder — Fri, 14 Jun 2024 06:45:55 GMT

Hi Nikhilan,

I´m facing the same issue while trying to execute a fabric notebook with the visual studio code extension.

Regarding your suggestions, how can I check the MWC configuration for my notebook and change it to the correct settings?

Thanks and KR
Max