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

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

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.

Cause

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

Resolution

• Contact your DBA and ask them to address the issue.
• Here is a Microsoft KB which explains a few strategies your DBA can choose: Troubleshooting Insufficient Disk Space in tempdb