vRA IaaS DBInstall

[Darophill]

Hi

I'm trying to create the Iaas database using the DBInstall method. I have install jre 1.8.0_201 and created the system variables but get an error message stating they don't exist.

below is the command line and error.

Has anyone experienced this problem before?

c:\DBInstall>BuildDB.bat /p:DBServer=sql01;DBName=vra;DBDir=C:\Data;LogDir=C:\Data;ServiceUser=lab\svc_vra_sql;ReportLogin=lab\svc_vra_sql

c:\DBInstall>C:\Windows\Microsoft.NET\Framework\v4.0.30319\msbuild.exe DBInstall.xml /p:DBServer=sql01;DBName=vra;DBDir=C:\Data;LogDir=C:\Data;ServiceUser=lab\svc_vra_sql;ReportLogin=lab\svc_vra_sql

Microsoft (R) Build Engine version 4.6.1590.0

[Microsoft .NET Framework, version 4.0.30319.42000]

Copyright (C) Microsoft Corporation. All rights reserved.

Build started 3/28/2019 6:12:33 PM.

Project "c:\DBInstall\DBInstall.xml" on node 1 (default targets).

DBInstall:

  Java version 1.8 update 91 or higher (64-bit) must be installed, the environment variable JAVA_HOME must be set to the Java install folder, and %JA

  VA_HOME%\bin\java.exe must exist.

Done Building Project "c:\DBInstall\DBInstall.xml" (default targets) -- FAILED.

Build FAILED.

    0 Warning(s)

    0 Error(s)

Time Elapsed 00:00:00.41

c:\DBInstall>java -version

java version "1.8.0_201"

Java(TM) SE Runtime Environment (build 1.8.0_201-b09)

Java HotSpot(TM) 64-Bit Server VM (build 25.201-b09, mixed mode)

c:\DBInstall>"%JAVA_HOME%"\bin\java -version

java version "1.8.0_201"

Java(TM) SE Runtime Environment (build 1.8.0_201-b09)

Java HotSpot(TM) 64-Bit Server VM (build 25.201-b09, mixed mode)

[daphnissov]

Out of curiosity, why are you doing this manually rather than letting the wizard take care of this for you?

[Darophill]

There is a company policy where by new databases need to be created manually by DBAs on the production SQL cluster.

[gradinka]

well, the error is clear:

Java version 1.8 update 91 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 must exist.

do you have this propely set?

can you share what is the current value for %JAVA_HOME% in your windows machine