Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
A few days ago, my QlikView cube was working fine, and I could reload it without any issues. But now, when I tried to reload it, I got this error. I haven't modified anything in the code or anything else. How can I fix it?
ODBC error
Connector reply error: SQL##f - SqlState: 53100, ErrorCode: 1, ErrorMsg: ERROR: could not write to file "base/pgsql_tmp/pgsql_tmp989087.1": No space left on device;
Error while executing the query
@saccdry needling wrote:
A few days ago, my QlikView cube was working fine, and I could reload it without any issues. But now, when I tried to reload it, I got this error. I haven't modified anything in the code or anything else. How can I fix it?
ODBC error
Connector reply error: SQL##f - SqlState: 53100, ErrorCode: 1, ErrorMsg: ERROR: could not write to file "base/pgsql_tmp/pgsql_tmp989087.1": No space left on device;
Error while executing the query
The error indicates that there is no space left on the device where PostgreSQL stores temporary files. To fix this:
- Free up disk space on the server where PostgreSQL is installed.
- Check PostgreSQL’s temporary file settings and adjust them if needed.
- Verify that the database server has sufficient space for operations.
After addressing the space issue, try reloading the QlikView cube again.
@saccehall wrote:
A few days ago, my QlikView cube was working fine, and I could reload it without any issues. But now, when I tried to reload it, I got this error. I haven't modified anything in the code or anything else. How can I fix it?
ODBC error
Connector reply error: SQL##f - SqlState: 53100, ErrorCode: 1, ErrorMsg: ERROR: could not write to file "base/pgsql_tmp/pgsql_tmp989087.1": No space left on device;
Error while executing the query
To resolve the "No space left on device" error, start by freeing up disk space on the PostgreSQL server. You can delete unnecessary files or move data to another storage solution. Additionally, check the PostgreSQL settings for temporary files to ensure they are optimized.
