Symptoms

During installation of K2 4.7 CU (May/August) SQL script fails on K2 blackpearl update stage with the following error:

"'TRY_CONVERT' is not a recognized built-in function name."

This error is logged in the udpate manager installer trace file.

Diagnosis

The “'TRY_CONVERT' is not a recognized built-in function name” error is because this SQL function was only introduced with SQL Server 2012. This is part of the reason the minimum require version is SQL Server 2012.

Solution

SQL Server 2008 R2 and earlier versions are not supported by K2 4.7 as per product compatibility matrix: https://help.k2.com/blackpearl/support-matrix.

Most likely you run newer version of SQL Server (otherwise there would be other problems during 4.7 installation/upgrade), but your K2 database still has old compatibility level which was set at the time when you installed old version of K2 (when DB was first time created). Increase K2 datatabase compatibility level to the highest possilble level supported by your version of K2 and your SQL Server.

K2 4.7 supports only these compatibility SQL Server database compatibility levels:

SQL Server 2016 = 130
SQL Server 2014 = 120
SQL Server 2012 = 110

Details on how to set your K2 databse compatibility level can be found in Microsoft documentation - you can do this either using transact SQL statement or SSMS GUI.

Post August 4.7 CU installer versions will get logic to check for supported database compatibility level.