topic Re: dbutils.notebook.exit() executing from except in try/except block even if there is no error. in Data Engineering

dbutils.notebook.exit() executing from except in try/except block even if there is no error.

Roy — Mon, 18 Nov 2019 20:59:25 GMT

I am using Python notebooks as part of a concurrently running workflow with Databricks Runtime 6.1.

Within the notebooks I am using try/except blocks to return an error message to the main concurrent notebook if a section of code fails. However I have noticed that in the last block of execution the "except" exit text will be returned regardless of an error in the "try" block.

Running this code highlights the problem:

try:

a = 5

dbutils.notebook.exit("a equals 5")

except:

dbutils.notebook.exit("Still printing exception")

Re: dbutils.notebook.exit() executing from except in try/except block even if there is no error.

shyam_9 — Tue, 19 Nov 2019 07:25:19 GMT

Hey @Roy,

It's working for me,

Check the indentation correctly.

Re: dbutils.notebook.exit() executing from except in try/except block even if there is no error.

Roy — Tue, 19 Nov 2019 13:21:51 GMT

That's odd, it's working for me now also. I tried this in different notebooks attached to the same cluster, I wonder if it was some odd cluster behavior. Thanks for checking.

Re: dbutils.notebook.exit() executing from except in try/except block even if there is no error.

akshaylad — Thu, 25 Jun 2020 06:09:26 GMT

dbutils.notebook.exit() will raise an exception

In the answer provided by @Shyamprasad Miryala above the print inside of except does not get printed because notebook.exit() text takes priority over any other print().

Look at this example:

%python a = 0 try: a = 1 dbutils.notebook.exit("Inside try") except Exception as ex: a = 2 dbutils.notebook.exit("Inside exception")

Output: Notebook exited: Inside exception

%python print(a)

Output: 2

Re: dbutils.notebook.exit() executing from except in try/except block even if there is no error.

sivasankar — Wed, 07 Oct 2020 11:20:38 GMT

SO if i want to exit with try block dbutils.notebook.exit("Inside try").What is the process?

Re: dbutils.notebook.exit() executing from except in try/except block even if there is no error.

vivekvardhanSha — Wed, 04 Aug 2021 09:07:59 GMT

You can add a fake except for the notebook.exit inside try block

try:

notebook.run(somenotebook)

try:

notebook.exit()

except Exception as e

print("Notebook exited")

except:

print("Main exception")

Re: dbutils.notebook.exit() executing from except in try/except block even if there is no error.

tonyliken — Thu, 16 Jan 2025 16:26:32 GMT

because the dbutils.notebook.exit() is an 'Exception' it will always trigger the except Exception as e: part of the code.

When can use this to our advantage to solve the problem by adding an 'if else' to the except block.

query = "SELECT 'a' as Column" try: spark.sql(query) ##if this part fails it will trigger and exception with the actual error message from the failure when running the query. dbutils.notebook.exit(f'Success: SQL query completed') ##notebook.exit() is classed as an exception and therefore triggers the exception part below, we add custom text so we can check for it in the exception part of the code except Exception as e: if str(e) == 'Success: SQL query completed': ##we check here for the custom text we added above, meaning the notebook code actually completed successfully. (we have to conver the exception (e) to string to do that dbutils.notebook.exit(f"Success: SQL query completed") ## exit the notebook with a custom success message. as there is no more 'except Exception....' checks in the code this will exit the notebook else: dbutils.notebook.exit(f"Error: {str(e)}") ## exit the notebook with a Error: followed by the actual error messaage from the notebook code (agian we converted it to a string.

correct query:

error in query: