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.

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


Article ID: 133111


Updated On:


Clarity PPM On Premise


Error message in logs during Load Data Warehouse (DWH) job run:

[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 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 or Jaspersoft database, but just MSSQL tempdb for internal objects, temp tables etc).


Release : All

Component : Data Warehouse

Database: MSSQL


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