Page tree
Skip to end of metadata
Go to start of metadata
Purpose (problem description)

This page gives the information for the troubleshooting of the SQL Error in analysis log file:

ERROR:  could not write block XXXXXXXX of temporary file: No space left on device.

Observed in CAST AIP


Observed on RDBMS


Oracle Server(tick)
Microsoft SQL Server(tick)
Action Plan
  1. This error usually occurs when there is actually no disk space left on the database Server (CSS / ORACLE / MS SQL SERVER). For instance if you are using CSS then the machine on which the CSS is installed is falling out of disk space.

    For example  if the error is as shown below : 
    SQL Error: ERROR:  could not write block 31283089 of temporary file: No space left on device

    This message says that the SQL query needs (31283089 * 8) / (1024 * 1024) = 238GB  of available space.
    So cross check if there is 238 GB free space on the database server. If there is no free space, this explain the error message and the solution is to create free space.

  2. Even after creating free space if the issue is not resolved then

    1. if the RDBMS is CSS, please make sure to run the CssOptimize on the KB and then run the analysis

    2. if the RDBMS is Oracle then please update the stats by referring to the page - CMS Snapshot Analysis - Run Analyzer - Fatal Error - SQL Error - ERROR could not write block XXXXXXXX of temporary file and then run the analysis
  3. After optimizing if the issue is still there then contact  CAST Technical Support with Relevant input

Relevant input

  1. Sherlock export with the option Export Logs , Export Computer Environment checked


Related Pages




  • No labels