vRealize Install SQL error

[vmware12]

Hey guys,

Ran into a new error when I actually got to the install portion of the automatic wizard. I'll highlight where it seems to break down specifically

--------------------------

[UTC:2016-06-03 16:47:37 Local:2016-06-03 09:47:37] :================= Logging started at [UTC:2016-06-03 16:47:37 Local:2016-06-03 09:47:37] ==================

[UTC:2016-06-03 16:47:37 Local:2016-06-03 09:47:37] :Product version: 7.0.1.6851.

Info : [UTC:2016-06-03 16:47:37 Local:2016-06-03 09:47:37] :Initialized configuration property for feature Database. Node read DATABASE_INSTANCE.

Initialized configuration property for feature Database. Node read DATABASE_NAME.

Initialized configuration property for feature Database. Node read DATA_PROTECTED.

Initialized configuration property for feature Database. Node read DATABASE_DATA_PATH.

Initialized configuration property for feature Database. Node read DATABASE_LOG_PATH.

Initialized configuration property for feature Database. Node read WINDOWS_AUTHEN_DATABASE_INSTALL_FLAG.

Initialized configuration property for feature Database. Node read DATABASE_INSTALL_SQL_USER.

Initialized configuration property for feature Database. Node read DATABASE_INSTALL_SQL_USER_PASSWORD.

Initialized configuration property for feature Database. Node read PRECREATED_DATABASE_FLAG.

Initialized configuration property for feature Database. Node read CREATE_MSSQL_AZMAN_STORE_FLAG.

Initialized configuration property for feature Database. Node read DATABASE_USE_ENCRYPTION.

Info : [UTC:2016-06-03 16:47:37 Local:2016-06-03 09:47:37] :Executing C:\Windows\Microsoft.NET\Framework\v4.0.30319\MsBuild.exe "C:\Program Files (x86)\VMware\vCAC\Server\Database\DeployVMPS.xml" /t:BuildDB /p:UsePreCreatedDatabase="False" /p:DBServer="IaaS-VRA-Test";DBName="vra" /p:DBUser="installer"  /p:DBPassword=******

Info : [UTC:2016-06-03 16:47:43 Local:2016-06-03 09:47:43] :Microsoft (R) Build Engine version 4.6.1055.0

Info : [UTC:2016-06-03 16:47:43 Local:2016-06-03 09:47:43] :[Microsoft .NET Framework, version 4.0.30319.42000]

Info : [UTC:2016-06-03 16:47:43 Local:2016-06-03 09:47:43] :Copyright (C) Microsoft Corporation. All rights reserved.

Info : [UTC:2016-06-03 16:47:44 Local:2016-06-03 09:47:44] :Build started 6/3/2016 9:47:44 AM.

Info : [UTC:2016-06-03 16:47:46 Local:2016-06-03 09:47:46] :Project "C:\Program Files (x86)\VMware\vCAC\Server\Database\DeployVMPS.xml" on node 1 (BuildDB target(s)).

Info : [UTC:2016-06-03 16:47:46 Local:2016-06-03 09:47:46] :BuildDB:

Info : [UTC:2016-06-03 16:47:46 Local:2016-06-03 09:47:46] :  ##BuildDB Creating and populating database

Info : [UTC:2016-06-03 16:47:46 Local:2016-06-03 09:47:46] :  sqlcmd -S IaaS-VRA-Test -U installer -P ******   -i CreateDatabase.sql -v DBName="vra" DBDir="\." LogDir="\." -b

Info : [UTC:2016-06-03 16:47:54 Local:2016-06-03 09:47:54] :  Creating Database 'vra'.

Info : [UTC:2016-06-03 16:47:54 Local:2016-06-03 09:47:54] :  Using default SQL database data and log directory

Info : [UTC:2016-06-03 16:47:54 Local:2016-06-03 09:47:54] :  Setting database compatibility level to SQL 2008.

Info : [UTC:2016-06-03 16:47:55 Local:2016-06-03 09:47:55] :  Disabling full text search.

Info : [UTC:2016-06-03 16:47:55 Local:2016-06-03 09:47:55] :  Setting database settings.

Info : [UTC:2016-06-03 16:47:55 Local:2016-06-03 09:47:55] :  Executed CreateDatabase.sql.

Info : [UTC:2016-06-03 16:47:55 Local:2016-06-03 09:47:55] :  sqlcmd -S IaaS-VRA-Test -U installer -P ******   -d "vra" -i VMPSOpsUser.sql -v ServiceUser="installer" UseWindowsAuthentication="False"

Info : [UTC:2016-06-03 16:47:56 Local:2016-06-03 09:47:56] :  Executed VMPSOpsUser.sql.

Info : [UTC:2016-06-03 16:47:57 Local:2016-06-03 09:47:57] :Project "C:\Program Files (x86)\VMware\vCAC\Server\Database\DeployVMPS.xml" (1) is building "C:\Program Files (x86)\VMware\vCAC\Server\Database\Liquibase.xml" (2) on node 1 (RunLiquibase target(s)).

Info : [UTC:2016-06-03 16:47:57 Local:2016-06-03 09:47:57] :RunLiquibase:

Info : [UTC:2016-06-03 16:47:57 Local:2016-06-03 09:47:57] :  "C:\Program Files\Java\jre7\\bin\java.exe"  -Djsse.enableCBCProtection=false -Djava.library.path="C:\Program Files (x86)\VMware\vCAC\Server\Database" -cp "liquibase.jar;jtds-1.3.1.jar" liquibase.integration.commandline.Main --driver=net.sourceforge.jtds.jdbc.Driver --url=jdbc:jtds:sqlserver://IaaS-VRA-Test/"vra";user=installer;password=******;ssl=request releaseLocks

Info : [UTC:2016-06-03 16:48:02 Local:2016-06-03 09:48:02] :  Liquibase releaseLocks Failed: liquibase.exception.DatabaseException: java.sql.SQLException: Network error IOException: Connection refused: connect

Info : [UTC:2016-06-03 16:48:02 Local:2016-06-03 09:48:02] : 

Info : [UTC:2016-06-03 16:48:02 Local:2016-06-03 09:48:02] :C:\Program Files (x86)\VMware\vCAC\Server\Database\Liquibase.xml(28,5): error MSB3073: The command ""C:\Program Files\Java\jre7\\bin\java.exe"  -Djsse.enableCBCProtection=false -Djava.library.path="C:\Program Files (x86)\VMware\vCAC\Server\Database" -cp "liquibase.jar;jtds-1.3.1.jar" liquibase.integration.commandline.Main --driver=net.sourceforge.jtds.jdbc.Driver --url=jdbc:jtds:sqlserver://IaaS-VRA-Test/"vra";user=installer;password=******;ssl=request releaseLocks" exited with code -1.

Info : [UTC:2016-06-03 16:48:02 Local:2016-06-03 09:48:02] :Done Building Project "C:\Program Files (x86)\VMware\vCAC\Server\Database\Liquibase.xml" (RunLiquibase target(s)) -- FAILED.

Info : [UTC:2016-06-03 16:48:02 Local:2016-06-03 09:48:02] :Done Building Project "C:\Program Files (x86)\VMware\vCAC\Server\Database\DeployVMPS.xml" (BuildDB target(s)) -- FAILED.

Info : [UTC:2016-06-03 16:48:02 Local:2016-06-03 09:48:02] :Build FAILED.

Info : [UTC:2016-06-03 16:48:02 Local:2016-06-03 09:48:02] :"C:\Program Files (x86)\VMware\vCAC\Server\Database\DeployVMPS.xml" (BuildDB target) (1) ->

Info : [UTC:2016-06-03 16:48:02 Local:2016-06-03 09:48:02] :"C:\Program Files (x86)\VMware\vCAC\Server\Database\Liquibase.xml" (RunLiquibase target) (2) ->

Info : [UTC:2016-06-03 16:48:02 Local:2016-06-03 09:48:02] :(RunLiquibase target) ->

Info : [UTC:2016-06-03 16:48:02 Local:2016-06-03 09:48:02] :  C:\Program Files (x86)\VMware\vCAC\Server\Database\Liquibase.xml(28,5): error MSB3073: The command ""C:\Program Files\Java\jre7\\bin\java.exe"  -Djsse.enableCBCProtection=false -Djava.library.path="C:\Program Files (x86)\VMware\vCAC\Server\Database" -cp "liquibase.jar;jtds-1.3.1.jar" liquibase.integration.commandline.Main --driver=net.sourceforge.jtds.jdbc.Driver --url=jdbc:jtds:sqlserver://IaaS-VRA-Test/"vra";user=installer;password=******;ssl=request releaseLocks" exited with code -1.

Info : [UTC:2016-06-03 16:48:02 Local:2016-06-03 09:48:02] :    0 Warning(s)

Info : [UTC:2016-06-03 16:48:02 Local:2016-06-03 09:48:02] :    1 Error(s)

Info : [UTC:2016-06-03 16:48:02 Local:2016-06-03 09:48:02] :Time Elapsed 00:00:17.90

--------------------

If anyone can understand where this all went wrong, please let me know.

[thecloudxpert]

Hi - i'll assume you've met all the pre-requisites for the installation detailed in vRealize Automation 7.0 Document Center?

[vmware12]

Just read through them again to double check, but yes.

[thecloudxpert]

what is your JAVA_HOME variable mapped to?

It seems to be mapped to C:\Program Files\Java\jre7\ rather than C:\Program Files\Java\jre7 as there is a \\ in the following:

Info : [UTC:2016-06-03 16:48:02 Local:2016-06-03 09:48:02] :C:\Program Files (x86)\VMware\vCAC\Server\Database\Liquibase.xml(28,5): error MSB3073: The command ""C:\Program Files\Java\jre7\\bin\java.exe"  -Djsse.enableCBCProtection=false -Djava.library.path="C:\Program Files (x86)\VMware\vCAC\Server\Database" -cp "liquibase.jar;jtds-1.3.1.jar" liquibase.integration.commandline.Main --driver=net.sourceforge.jtds.jdbc.Driver --url=jdbc:jtds:sqlserver://IaaS-VRA-Test/"vra";user=installer;password=******;ssl=request releaseLocks" exited with code -1.

[vmware12]

Actually, I figured it out a few minutes ago. Turns out that my TCP was NOT enabled on SQL Server Configuration Manager. Enable that, restart the services, installed no problem.

Thanks for helping though!

[thecloudxpert]

great news! that is always one to check because i don't believe its enabled by default anymore!