Solved

K2 4.7 May 2017 Cumulative Update fails to install

Forum|Forum|8 years ago
June 5, 2017
5 replies
14 views

S

+16

Sharpharp1
Scout

Hi all,

Anyone else have any problems installing the May update?

When trying to update, it fails on this error:

1:0: ExecuteSqlScript.Execute: >> Logged Error: Script execute failed: System.Exception: Script execution exception: Microsoft.SqlServer.Management.Common.ExecutionFailureException: An exception occurred while executing a Transact-SQL statement or batch. ---> System.Data.SqlClient.SqlException: 'TRY_CONVERT' is not a recognized built-in function name.

1:0: Component.ExecuteTarget: >> Logged Error: Target did not complete successfully: DataPatches693317 + 693502.sql

Any ideas?

Best answer by Albarghouthy

Hi,

We have created a KB for this issue, thanks for your input.

http://community.k2.com/t5/K2-blackpearl/SQL-Script-error-after-running-May-CU/ta-p/97395

P

+12

Perc
Forum|Forum|8 years ago
June 5, 2017

Hi @Sharpharp1,

Thank you for logging this post to the community. Please log a support ticket for this issue, as further investigations will have to be carried out here.

Kind regards,

Percy

Like

P

+12

Perc
Forum|Forum|8 years ago
June 5, 2017

Hi @Sharpharp1,

Further looking into this on our side, it appears that this can occur if you are still using SQL 2008 R2 after upgrading to 4.7 as this is not supported by us as per compatibiliity matrix below:

http://help.k2.com/blackpearl/support-matrix

If you are however using SQL 2012 and later please do log a support call to allow us to further investigate here.

Kind regards,

Percy

Like

S

+16

Sharpharp1
Author
Scout
Forum|Forum|8 years ago
June 5, 2017

Hi Percy,

I was on SQL Server Expre2008 (SP3)

Updated to SQL Server 2016 (SP1), tried again and still same error

Like

S

+16

Sharpharp1
Author
Scout
Forum|Forum|8 years ago
June 5, 2017

Upon further investigation this afternoon i noticed the following: it appears that the compatibility level is still 100 on my DB (SQL Express) even after upgrading it to SQL Express 2016 (SP1)

If the level is 100, the K2 May Update will fail (during the Server update part) because it runs a couple of SQL script injections using the TRY_CONVERT function.

I had to manually change the level to 120, then ran the May K2 Update and it went through without failure.

Hope this helps others, i wasted a day on what should have been a simple procedure.