Search the VMware Knowledge Base (KB)
View by Article ID

Installing vCenter Server 6.5 fails on a size restricted SQL database (2147918)

  • 3 Ratings
Language Editions

Symptoms

  • The Microsoft SQL database is size restricted.
  • The installation fails with the error:

    "VMware VirtualCenter failed firstboot.
    An error occurred while starting service 'vpxd'
    Please refer to vSphere documentation to troubleshoot or Please contact VMware Support."


  • In the %ALLUSERSPROFILE%\VMWare\vCenterServer\logs\vmware-vpx\vpxd.log file, there are entries similar to:

    2016-11-17T14:41:09.200-05:00 error vpxd[06440] [Originator@6876 sub=Default] [VdbStatement::ResultValue:GetValue] Error to get value at pos: 6, ctype: -27 for SQL "SELECT File_Type, Drive, VCDB_Space_Mb, Physical_Name, Sql_Server_Edition, Sql_Server_Version, CASE WHEN  CHARINDEX('Express Edition',CAST (Sql_Server_Edition as varchar)) >0 THEN (SELECT MIN(n) FROM (VALUES (10240 - VCDB_Space_Mb), (FreeSpaceInMB (DB_limit - VCDB_Space_Mb)) AS i(n)  ) ELSE (SELECT MIN(n) FROM (VALUES (FreeSpaceInMB), (DB_limit - VCDB_Space_Mb)) AS i(n)  ) END AS FreeSpaceInMB, CASE WHEN  CHARINDEX('Express Edition',CAST (Sql_Server_Edition as varchar)) >0 THEN (SELECT MIN(n) FROM (VALUES (10240), (TotalSpaceInMB), (DB_limit)) AS i(n) ) ELSE (SELECT MIN(n) FROM (VALUES (TotalSpaceInMB), (DB_limit)) AS i(n)  ) END AS TotalSpaceInMB FROM (SELECT DB_NAME(os.database_id) DBName, CASE mf.FILE_ID WHEN 1 THEN 'DATA' WHEN 2 THEN 'LOG' END File_Type, os.volume_mount_point AS Drive, CONVERT(INT, (mf.SIZE * 8) / 1024.0 ) AS VCDB_Space_Mb, mf.PHYSICAL_NAME Physical_Name, SERVERPROPERTY('edition') Sql_Server_Edition, SERVERPROPERTY('productversion') Sql_Server_Version, CONVERT(INT,((os.available_bytes)/1024.0)/1024.0) AS FreeSpaceInMB, CONVERT(INT,((os.total_bytes)/1024.0)/1024.0) AS TotalSpaceInMB, CASE WHEN mf.growth = 0 THEN CONVERT(INT, (mf.SIZE * 8) / 1024.0 ) ELSE CASE WHEN mf.max_SIZE not in (0,-1, 268435456) THEN CONVERT(INT, ((mf.max_SIZE * 8) / 1024.0)/1024.0 ) ELSE CONVERT(INT,((os.total_bytes)/1024.0)/1024.0) END END AS DB_limit FROM sys.master_files mf CROSS APPLY sys.dm_os_volume_stats(mf.database_id, mf.FILE_ID) os where os.DATABASE_ID = DB_ID() ) as realdata"
    2016-11-17T14:41:09.201-05:00 warning vpxd[06440] [Originator@6876 sub=OsLayer_win32] [VpxUnhandledException] Win32 Exception (3765269347) detected at 00007ffae4268a5c

Purpose

This article provides information on disabling size restrictions on a Microsoft SQL database.

Cause

During the installation of the vCenter Server a check is performed for the available space on the database. An error in logic of calculating free space results negative values. This further triggers a failure in vpxd on reading the negative value. 

Resolution

To resolve this issue remove the limit on the database files by setting the Maximum File Size to Unrestricted File Growth.
  1. Connect to database server using SQL Management Studio.
  2. Right-click the vCenter Server database and click Properties.
  3. In the Database Properties window, click Files.
  4. Click the expand button in the Autogrowth column.
  5. Set Maximum File Size to Unrestricted File Growth.
  6. Repeat this step for the remaining database files.
Note: For log files the Unlimited option will return to Restricted and the size limit will be 2,097,152 (2TB). This is expected as log files are limited to 2TB on SQL Servers.

See Also

Language Editions

ja,2147918;zh_cn,2150443

Request a Product Feature

To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.

Feedback

  • 3 Ratings

Did this article help you?
This article resolved my issue.
This article did not resolve my issue.
This article helped but additional information was required to resolve my issue.

What can we do to improve this information? (4000 or fewer characters)




Please enter the Captcha code before clicking Submit.
  • 3 Ratings
Actions
KB: