Issue

In certain scenarios, the K2 Blackpearl upgrade to 4.7 from 4.6.11 will not complete with the following script failure appearing.

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: Conversion failed when converting from a character string to uniqueidentifier.

Component.ExecuteTarget: 08:32:16:>> Logged Error: Target did not complete successfully: SourceCode.Data.Form.4.16060.7.5.PostUpgrade.sql"

Symptoms

This is a known issue when upgrading to 4.7 from 4.6.11.

Resolution

Please log a support ticket to obtain the fix.