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
- 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.
