Just Published! Threat Report: Exposing Malware in Linux-Based Multi-Cloud Environments | Download Now

Migrate.sql failed during database upgrade because the Primary filegroup in tempdb is full

Migrate.sql failed during database upgrade because the Primary filegroup in tempdb is full

Version

6.0.x & 7.x (Windows OS Only).

 

Issue

Upgrade of the database is failing.

 

Symptom

It gives an error that migrate.sql failed. Debugview log and Windows Event log show this message during the migrate.sql failure – “Could not allocate space for object '<temporary system object: 422214422626304>' in database 'tempdb' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup”. Other table might also require additional space. Please check which table is mentioned on the error message.

 

Cause

The  location of the tempdb (or other table mentioned on the error message) does not have enough disk space and/or the tempdb has growth restriction.

 

Solution

Check where the tempdb (or other table mentioned on the error message) is located and its current free disk space

  1. Open SQL Server Management Studio and connect to the Bit9 database
  2. Expand Databases > expand System Databases > right-click on tempdb (or other table mentioned on the error message) > select Properties
  3. On the Properties window, select General and make note of the current size of this database
  4. Select Files > scroll to the right to see the Path column > make note of the file location
  5. Check the partition drive where the files are located and make sure that it has at least 3x the tempdb’s size for free disk space

 

To remove growth restriction on tempdb

  1. On the tempdb (or other table mentioned on the error message) Properties window, select Files > scroll to the right to see the Autogrowth column
  2. Click the button with 3 dots to open the Change Autogrowth dialog box
  3. On the Maximum File Size, select Unrestricted File Growth and click OK (if unrestricted is not possible, increase the growth restriction accordingly)
  4. Click OK to close the Properties window

 

Close SQL Server Management Studio before restarting the Bit9 upgrade process.

Labels (1)
Was this article helpful? Yes No
No ratings
Article Information
Author:
Creation Date:
‎12-02-2014
Views:
2440
Contributors