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

[Gerald_U]

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.

Environment

Qlik Catalog