Wednesday, 5 November 2014

vCAC IaaS database Fail to upgrade


While upgrading vCloud Automation Center (vCAC) 6.0 to vCAC 6.1 one of the requirement is to upgrade  the database of vCAC IaaS  using the command line.

DBUpgrade.exe –S  <FQDN of Database> -d <Database Instance> -E

Example: DBUpgrade.exe –S IaaS.vClass.local –d vCAC –E

It connects to the database successfully, but finished with an error message like:
 
 
 
Error executing script. Please see log file c:\Scripts\dbupgrade.log for more details.
When we open the log, we can’t get any helpful information in it.
 
 
 
 But from the error message and VMware KB I got a clue that I must need to have java version 1.7 or higher, so I verified that  java version 1.7 or higher is installed on my machine from which I am executing the DBUpgrade command, which was not so I download the latest version of java and install.









After the java is been installed we will also require to declare an Environment variable named JAVA_HOME and value c:\Progra~1\java\jre1.8.0_25























 
 
 
 Remember do not use c:\Program Files\Java\jre1.8.0_25 because we have space “Program Files” which fails the command DBUpgrade.exe to fail. validate that the environment variable is working.
 
 



 
 


Once the changes are done logoff once and login, so that the environment variable can be loaded. Check that the environment variable is working properly, and then run the command to upgrade the IaaS database.

No comments:

Post a Comment