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 [K2SQLUM].[dbo].[K2Users] ALTER COLUMN UserPassword NVARCHAR(200)
Replace [K2SQLUM] with corresponding K2SQLUM database name.