Upgrade of UVMS setup in cluster mode fails with error version cannot be retrieved
Article ID: 265968
Updated On:
Products
Issue/Introduction
While upgrading our UVMS setup in cluster mode we get below error
Error Message: Version cannot be retrieved
Our environment details
- Database: MSSQL
- JDBC Driver version: 8
- Java version: 11.0.5
Also let us know when should we upgrade java to 11.0.18 version post upgrade or before running upgrade
Environment
Release : 7.00.01
Component: DOLLAR UNIVERSE
Cause
In uvserver.log we find below error, which shows that the UVMS node of cluster which is getting upgraded is unable to connect to database, hence resulting in the failure.
| 2023-05-11 01:38:16 |ERROR| main | com.orsyp.central.cli.nodecmd.ListNode | Unable to initialize DB
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host DB_SERVER_HOSTNAME, port 1433 has failed. Error: "connect timed out.
Resolution
1: Validate that UVMS node (in cluster setup) getting upgraded is able to communicate to the DB
2: Post DB communication is fine re-ran the upgrade
3: Launch UVC and connect to UVMS node(in cluster setup to the node got upgraded, via IP/hostname) and validate if the upgrade of this node is successful. The recommendation validation is as below
- Check if the nodes view is available
- Check if the Job runs are available
4: Stop the UVMS server
5: Install the Java 11.0.18 or upgrade the existing version of java on UVMS node server
6: Update the unienv.bat to point to the new JAVA
5: Started the UVMS node
6: Perform validation as mentioned in step 3
7: Upgrade the other secondary nodes (As the DB schema is already updated with primary node upgrade no changes will be made to schema during secondary node upgrade).
Additional Information
Feedback
