Summary
You cannot upgrade the SecureCloud KMS from 3.0 to 3.6.
Details
The issue occurs because there is a huge amount of data. During the upgrade, SecureCloud converts the data type and once there is a huge data the SQL session times out which results to upgrade failure.
To resolve the issue, extend the timeout setting:
- In Microsoft SQL Management Studio, go to Tools > Options > Query Execution.
- Change the value of Execution time-out: to “0”.
- Go to Tools > Options > Designers > Table and Database Designers.
- Set the Transaction time-out after: to 1000 seconds.
You may enter a higher value depending on the SQL server performance if it needs more time.
- Go to Server Properties > Connections. Set the value of Remote query timeout to “0” for no timeout.
You have the option to roll back the values once SecureCloud upgrade is complete.