ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 133111

calendar_today

Updated On:

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