Error: Could not allocate space for object 'dbo.SORT' temporary run storage - when refreshing a segment

When refreshing a segment or exporting a mailing, this error is shown due to lack of space in the tempdb.

Unable to save keys to static selection table. Could not allocate space for object 'dbo.SORT temporary run storage: 141036665831424' 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.
This is an issue with available storage on the TempDB table on the SQL server, and should be addressed by a qualified SQL DBA.  If you are hosted by Blackbaud, create a case with our support team.  

Steps to Duplicate

  1. Select Marketing and Communications
  2. Select Segments
  3. Select a segment and the Recent Status tab
  4. See error

Environment

 Blackbaud CRM
 4.0
 4.0.141.9

Was this article helpful?