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
![failed detail child process exited with exit code 1.png failed detail child process exited with exit code 1.png](https://community.qlik.com/t5/image/serverpage/image-id/114981i9D5F76D64EEE953D/image-size/large?v=v2&px=999)
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