Migration Failed: Init Database 'TRY_CONVERT' Is Not A Recognized Built-In Function Name

When upgrade of Orchestrator to 21.4 it is attempted, it throws error related to SQL DB. "Error: System.Exception: Migration failed: Init Database: 'TRY_CONVERT' is not a recognized built-in function name."


Update the compatibility level to support version 2014 or compatibility level 120 and then try to do the Orchestrator setup. Refer article on SQL Server Fix Error 195: TRY_CONVERT Is Not A Recognized Built In Function Name .

Additional information is available at TRY CONVERT Is Not Recognized Built In to know the compatibility level with SQL version.