We are using Program Command Shape to run Stored Procedure on SQL server 2008. Try/Catch shape before this program command shape is not catching dead lock error from SQL and continuing as if the process ran successfully.
With some troubleshooting, we found that Boomi Try/Catch shape only catches SQL error with severity level of 16 or higher. SQL server has error raised with severity level of 11 and higher that indicates various type of failure. For deadlock error, SQL reports with Severity level of 13.
How can we make Try/Catch Shape catch SQL error with severity level of 11 or higher from Program Command Shape?