topic Re: how fix this error ? in Qlik Automate

how fix this error ?

sacc — Wed, 28 Aug 2024 18:10:46 GMT

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

Re: how fix this error ?

jameskhol — Fri, 30 Aug 2024 06:52:37 GMT

@sacc dry 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.

Re: how fix this error ?

harybrook — Fri, 04 Oct 2024 07:02:07 GMT

@sacc ehall 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.