Migrate.sql failed during database upgrade because the Primary filegroup in tempdb is full
6.0.x & 7.x (Windows OS Only).
Upgrade of the database is failing.
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.
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.
Check where the tempdb (or other table mentioned on the error message)is located and its current free disk space
Open SQL Server Management Studio and connect to the Bit9 database
Expand Databases > expand System Databases > right-click on tempdb (or other table mentioned on the error message) > select Properties
On the Properties window, select General and make note of the current size of this database
Select Files > scroll to the right to see the Path column > make note of the file location
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
On the tempdb (or other table mentioned on the error message)Properties window, select Files > scroll to the right to see the Autogrowth column
Click the button with 3 dots to open the Change Autogrowth dialog box
On the Maximum File Size, select Unrestricted File Growth and click OK (if unrestricted is not possible, increase the growth restriction accordingly)
Click OK to close the Properties window
Close SQL Server Management Studio before restarting the Bit9 upgrade process.