VMware Cloud Community
filencho
Contributor
Contributor

vRA 7.2 Install Fail on External SQL

All,

I'm having trouble deploying vRA 7.2 and was wondering if you could help. I ran the installation and i'm getting the below error.

vRA Install Output

Downloading installer...

Execution time:00:24.986

Download succeeded.

Installing vCAC Server Custom Setup files on the disk

Executing:"C:\Users\felix.vargas\AppData\Local\Temp\VMware\vCAC\\vCAC-Server-Setup.exe" /s /w /V"/qn ADDLOCAL=Database INSTALLDIR=\"C:\Program Files (x86)\VMware\vCAC\\Server\" /Lvoicewarmup! \"C:\Program Files (x86)\VMware\vCAC\InstallLogs-20170124025340\Server-Setup.log""

vCAC Server Custom Setup Installation Succeeded, ExitCode:0

Execution time:01:37.895

Configuring vCAC IaaS core components:

- Database

Executing:"C:\Program Files (x86)\VMware\vCAC\Server\ConfigTool\\vCAC-Config.exe" /S "/P:C:\Users\felix.vargas\AppData\Local\Temp\VMware\vCAC\\ConfigToolProperties.vCAC-Server-Database-ConfigTool.xml" "/L:C:\Program Files (x86)\VMware\vCAC\InstallLogs-20170124025340\vCAC-Config.log"

Running vCloud Automation Software Configuration Wizard in silent mode.

The following vRealize Automation features have been installed and selected for configuration:

Database

Database configuration failed.

vCAC-Server-Custom-Database-ConfigTool Installation Failed, ExitCode:5500

Error configuring vRealize Automation Server. For more information, refer to vCAC-Config.log after collecting the IaaS logs.

Execution time:10:16.222


vCAC Config Log


[UTC:2017-01-24 19:55:07 Local:2017-01-24 14:55:07] :================= Logging started at [UTC:2017-01-24 19:55:07 Local:2017-01-24 14:55:07] ==================

[UTC:2017-01-24 19:55:07 Local:2017-01-24 14:55:07] :Product version: 7.2.0.9518.

Info : [UTC:2017-01-24 19:55:08 Local:2017-01-24 14:55:08] :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:2017-01-24 19:55:08 Local:2017-01-24 14:55:08] :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="True" /p:DBServer="SQL\FELIXSQLSERvER";DBName="vra" /p:DBUser=""  /p:DBPassword=******

Info : [UTC:2017-01-24 19:55:12 Local:2017-01-24 14:55:12] :Microsoft (R) Build Engine version 4.0.30319.33440

Info : [UTC:2017-01-24 19:55:12 Local:2017-01-24 14:55:12] :[Microsoft .NET Framework, version 4.0.30319.33440]

Info : [UTC:2017-01-24 19:55:12 Local:2017-01-24 14:55:12] :Copyright (C) Microsoft Corporation. All rights reserved.

Info : [UTC:2017-01-24 19:55:13 Local:2017-01-24 14:55:13] :Build started 1/24/2017 2:55:13 PM.

Info : [UTC:2017-01-24 19:55:14 Local:2017-01-24 14:55:14] :Project "C:\Program Files (x86)\VMware\vCAC\Server\Database\DeployVMPS.xml" on node 1 (BuildDB target(s)).

Info : [UTC:2017-01-24 19:55:14 Local:2017-01-24 14:55:14] :BuildDB:

Info : [UTC:2017-01-24 19:55:14 Local:2017-01-24 14:55:14] :  ##BuildDB Creating and populating database

Info : [UTC:2017-01-24 19:55:14 Local:2017-01-24 14:55:14] :  sqlcmd -S SQL\FELIXSQLSERvER  -i SetDatabaseSettings.sql -v DBName="vra" -b

Info : [UTC:2017-01-24 19:55:16 Local:2017-01-24 14:55:16] :  Checking database compatibility level

Info : [UTC:2017-01-24 19:55:16 Local:2017-01-24 14:55:16] :  Disabling full text search.

Info : [UTC:2017-01-24 19:55:16 Local:2017-01-24 14:55:16] :  Setting database settings.

Info : [UTC:2017-01-24 20:04:41 Local:2017-01-24 15:04:41] :  Error occurred while executing SQL file: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding..

Info : [UTC:2017-01-24 20:04:43 Local:2017-01-24 15:04:43] :C:\Program Files (x86)\VMware\vCAC\Server\Database\DeployVMPS.xml(53,5): error MSB3073: The command "sqlcmd -S SQL\FELIXSQLSERvER  -i SetDatabaseSettings.sql -v DBName="vra" -b" exited with code 1.

Info : [UTC:2017-01-24 20:04:43 Local:2017-01-24 15:04:43] :Done Building Project "C:\Program Files (x86)\VMware\vCAC\Server\Database\DeployVMPS.xml" (BuildDB target(s)) -- FAILED.

Info : [UTC:2017-01-24 20:04:43 Local:2017-01-24 15:04:43] :Build FAILED.

Info : [UTC:2017-01-24 20:04:43 Local:2017-01-24 15:04:43] :"C:\Program Files (x86)\VMware\vCAC\Server\Database\DeployVMPS.xml" (BuildDB target) (1) ->

Info : [UTC:2017-01-24 20:04:43 Local:2017-01-24 15:04:43] :(BuildDB target) ->

Info : [UTC:2017-01-24 20:04:43 Local:2017-01-24 15:04:43] :  C:\Program Files (x86)\VMware\vCAC\Server\Database\DeployVMPS.xml(53,5): error MSB3073: The command "sqlcmd -S SQL\FELIXSQLSERvER  -i SetDatabaseSettings.sql -v DBName="vra" -b" exited with code 1.

Info : [UTC:2017-01-24 20:04:43 Local:2017-01-24 15:04:43] :    0 Warning(s)

Info : [UTC:2017-01-24 20:04:43 Local:2017-01-24 15:04:43] :    1 Error(s)

Info : [UTC:2017-01-24 20:04:43 Local:2017-01-24 15:04:43] :Time Elapsed 00:09:29.59


4 Replies
z001yv0r
Enthusiast
Enthusiast

Reply
0 Kudos
filencho
Contributor
Contributor

Thanks for the reply but the link speaks to Java errors which are not showing up in my logs.

Reply
0 Kudos
filencho
Contributor
Contributor

I found the bit of code where the installation fails. See below.

<!-- Set Database Settings -->

    <Exec WorkingDirectory="$(MSBuildProjectDirectory)"

          Command="sqlcmd -S $(DBServer) $(DBConnectParam) -i SetDatabaseSettings.sql -v DBName=&quot;$(DBName)&quot; -b" />

Reply
0 Kudos
filencho
Contributor
Contributor

I was able to resolve this problem. The steps I look to resolve this are below.

  • Reverted IaaS Machine, vRA appliance, and external SQL server to snapshot taken before starting the installation.
  • Deleted the vRA 7.2 database I had created
  • Directed the vRA wizard to create a net new database instead of using the one I created