Symptoms

Issues encountered during 4.6.5 upgrade
 

Diagnoses

While trying to upgrade our production environment from 4.5 to 4.6.5, we encountered an issue while running the 4.6.5 utility. I have attached the log files from the setup folder. While reviewing ScriptErrors-40540.txt it appears the eror is with the following sql in the 'K2SQLUM' database:

-- here is the error from the K2 install log:

Line 11415: "11412","2015-04-03 11:39:16","Error","15","15002","ERROR","SourceCode.Database.Configuration.ConfigureDBs","15002 SqlException.Number != -2, so not handling it as a timeout. SqlException.Number = 15466. Exception: An error occurred during decryption.
Cannot insert the value NULL into column 'UserPassword', table 'E2E_K2SQLUM.dbo.K2Users' column does not allow nulls. UPDATE fails.
The key 'SCSSOKey' is not open. Please open the key before using it.
Encrypting existing passwords
 

Resolution

The 'UserPassword' column in the 'K2Users' table had nvarchar(30).

Increasing the datatype for the "UserPassword" column in the SQLUM database to nvarchar(200) resolved the issue and customer was able to upgrade successfully.

ALTER TABLE LK2SQLUM].Mdbo].oK2Users] ALTER COLUMN UserPassword NVARCHAR(200)

Replace cK2SQLUM] with corresponding K2SQLUM database name.