Problem with querying managed objects

pandabrowski — Tue, 07 Dec 2021 22:33:09 GMT

Hi,

I'm running version 4.6.2 on single node installation. I've just set up an env with MSSQL source (demo db), onboarded 2 objects, but when i want to query them either in explore mode or when viewing source - i get an error.

"ERROR: program "find /usr/local/qdc/data/receiving/Sales/CustomerCategories/20200917085153/good/* -not -path '*/\\.*' -type f -exec cat {} \;" failed Detail: child process exited with exit code 1; nested exception is org.postgresql.util.PSQLException: ERROR: program "find /usr/local/qdc/data/receiving/Sales/CustomerCategories/20200917085153/good/* -not -path '*/\\.*' -type f -exec cat {} \;" failed Detail: child process exited with exit code 1 "

when i want to query dataset calculated with dataflow i get:

"Query execution failed: coop.error.code.DYNAMIC_ERROR - PreparedStatementCallback; uncategorized SQLException for SQL [SELECT * FROM Sales.Podsumowanie_sprzedazy]; SQL state [38000]; error code [0]; ERROR: program "find /usr/local/qdc/data/receiving/Sales/Podsumowanie_sprzedazy/20201007080735/good/* -not -path '*/\\.*' -type f -exec cat {} \;" failed Detail: child process exited with exit code 1; nested exception is org.postgresql.util.PSQLException: ERROR: program "find /usr/local/qdc/data/receiving/Sales/Podsumowanie_sprzedazy/20201007080735/good/* -not -path '*/\\.*' -type f -exec cat {} \;" failed Detail: child process exited with exit code 1"

I'm almost sure it worked before.

the files are present in the folder, and the dataflows based on them work correctly.

could you give me a hint what can be wrong there?

thanks, rd

topic Problem with querying managed objects in Catalog and Lineage

Problem with querying managed objects