Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW

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

100% helpful (1/1)
cancel
Showing results for 
Search instead for 
Did you mean: 
Gerald_U
Support
Support

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

Last Update:

Aug 23, 2023 3:59:50 AM

Updated By:

Sonja_Bauernfeind

Created date:

Aug 23, 2023 3:59:50 AM

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

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 

Labels (1)
Version history
Last update:
‎2023-08-23 03:59 AM
Updated by: