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.
Release | Yes/No |
---|---|
8.3.x | |
8.2.x | |
8.1.x | |
8.0.x | |
7.3.x |
RDBMS | Yes/No |
---|---|
Oracle Server | |
Microsoft SQL Server | |
CSS3 | |
CSS2 |
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 deviceThis 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.Even after creating free space if the issue is not resolved then
if the RDBMS is CSS, please make sure to run the CssOptimize on the KB and then run the analysis
- 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
- After optimizing if the issue is still there then contact CAST Technical Support with Relevant input
Relevant input
- Sherlock export with the option Export Logs , Export Computer Environment checked