search cancel

MSSQL not allocating space in "tempdb", the PRIMARY file group is full


Article ID: 133111


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


Error message in logs:

[CA Clarity][SQLServer JDBC Driver][SQLServer]Could not allocate space for object 'dbo.SORT temporary run storage: 1111XXXXXXX' 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 error may be thrown for DWH, other jobs, or when using Clarity UI.


This is a Database issue. It appears you ran out of space on tempdb (this is not Clarity, DWH or Jaspersoft database, but just MSSQL tempdb for internal objects, temp tables etc).