Upgrading VMware vRealize Automation or VMware vRealize Automation IaaS SQL database fails with the error: Java version 1.7 or higher (64-bit) must be installed

Products

• VMware Aria Suite

Issue/Introduction

Symptoms:

• Cannot upgrade VMware vRealize Automation (formerly known as vCloud Automation Center) or the VMware vRealize Automation IaaS SQL database from version 6.0.1 to 6.1.
• Upgrading VMware vRealize Automation or the VMware vRealize Automation IaaS SQL database from version 6.0.1 to 6.1 fails with the error:
  
  Java version 1.7 or higher (64-bit) must be installed
  
  
• In the dbupgrade.log file, you see entries similar to:
  
  C:\Users\<user name>\Downloads\DBUpgrade>DBUpgrade -S MS_SQL_HOST\SQLEXPRESS -d vCAC
  -E
  Connected to vCAC database successfully.
  Current database version: 6.1.0.1200
  Java version 1.7 or higher (64-bit) must be installed, the environment variable
  JAVA_HOME must be set to the Java install folder, and %JAVA_HOME%\bin\java.exe m
  ust exist.
  Error executing script. Please see log file C:\Users\161144\Downloads\DBUpgrade\
  dbupgrade.log for more details.
  
  Note: The dbupgrade.log file path may vary depending on the location in which the DBUpgrade script is run.

Environment

VMware vCloud Automation Center for Desktop 6.1.x
VMware vCloud Automation Center for Server 6.1.x

Cause

This issue occurs due to missing Java or invalid JAVA_HOME environmental variables.

Resolution

To resolve this issue, ensure that:

1. The 64-bit Java version 1.7 is installed on the system from which you are running the scripts.
2. The environmental variable for Java is named as JAVA_HOME, and the value is correct and points to the 64-bit Java location.
   
   For example:
   
   C:\Program Files\Java\jre7
   
   Note: You do not have any quotes in the preceding value.
   
   
   
3. Test your java by running this command from a command prompt (with quotes):
   
   "%JAVA_HOME%\bin\java.exe" -version
   
   If you have the correct version, the output should look similar to:
   
   
   Java(TM) SE Runtime Environment (build 1.7.0_67-b01)

   Java HotSpot(TM) 64-Bit Server VM (build 24.65-b04, mixed mode)