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."
Resolution:
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.
prashant1603765
V_Roboto_V
ashokkarale
arivu96
sharazkm32
Anil_G
pikorpa
postwick
jaswanthvarma.gottumukkal
adi.mehare