Unable to query Qlik Catalog managed entities after publishing to Qlik Sense

Gerald_U — Wed, 23 Aug 2023 07:59:50 GMT

After publishing a managed entity to Qlik Sense, running a SQL query on the entity fails with:

ERROR [38000] [Qlik][PostgreSQL] (30) Error occurred while trying to execute a query: [SQLState 38000] ERROR: program "find '/usr/local/qdc/data/receiving/dw_prefeito_1/dim_tipo_evento/20230605193726/good/'* -not -path '*/\\.*' -type f -exec sed 's:\\:\\\\:g' {} \;" failed DETAIL: child process exited with exit code 1

Running the directly in the Postgres database returns the same error.

This indicates the Postgres user account does not have the appropriate permissions to access the /usr/local/qdc/data path.

Resolution

Assign the appropriate permissions to the Postgres user account

Example command to use:

cd /usr/local/qdc/data/
sudo chmod a+rwx /usr/local/qdc/data

Cause

Postgres user account does not have the appropriate permissions to access the /usr/local/qdc/data path.

article Unable to query Qlik Catalog managed entities after publishing to Qlik Sense in Official Support Articles

Unable to query Qlik Catalog managed entities after publishing to Qlik Sense

Resolution

Cause

Environment