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

book

Article ID: 133111

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

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.

Cause

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

Environment

Release : All

Component : Data Warehouse

Database: MSSQL

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