"Could not allocate a new page for database tempdb' because of insufficient disk space in filegroup" error while upgrading vRA

Products

• VMware Aria Suite

Issue/Introduction

Symptoms:

• Performing an upgrade of your vRA environment fails.
• In the upgrade logs located at C:\Program Files (x86)\Vmware\vCAC\InstallLogs, you see entries similar to:
  
  [8/18/2017 10:18:03 AM] System.Data.SqlClient.SqlException (0x80131904): Could not allocate a new page for database 'tempdb' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
  [8/18/2017 10:18:03 AM] at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
  [8/18/2017 10:18:03 AM] at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
  [8/18/2017 10:18:03 AM] at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

Note: The preceding log excerpts are only examples. Date, time, and environmental variables may vary depending on your environment.

Environment

VMware vRealize Automation 6.2.x
VMware vRealize Automation 7.0.x
VMware vRealize Automation 7.3.x
VMware vRealize Automation 7.2.x
VMware vRealize Automation 7.1.x

Cause

This is caused due to tempdb being used for the vRA database file growth, settings are very restrictive for vRA to complete the upgrade.

Resolution

To resolve this issue, adjust your auto-growth settings for the database:

 

1. Log in to SQL Server Management Studio with a user having sysadmin privileges.
2. Expand System Databases, right-click the tempdb and click on Properties.
3. Click Files in the left pane and then click on the ellipses button.
4. In the Change Autogrowth window ensure Enable Autogrowth is selected, and change File Growth section to In Percent and select 10. Ensure the Maximum File Size field is set to unrestricted File Growth.
5. After clicking OK, the new settings should be set.
6. Roll back your database and snapshots from the failed upgrade and attempt again.