Failure to upgrade from 4.6.11 to 4.7. Conversion failed when converting from a character string to unique identifier
kbt137620
PRODUCTIssue
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.