Discrepancy in Error Messages in QlikSense DB Script

qwebnm — Fri, 15 Nov 2024 21:18:01 GMT

To the Qlik team,

Hello,
I connected to PostgreSQL in my QlikSense script and loaded data by creating a DB Select query. However, when running the same query, I encountered different error messages in the database and QlikSense logs.

Error logs:
QlikSense Error Log: Field 'drug_id' not found
DB Error Log: column "drug_dx" does not exist

I'm attaching it as a related image file, so please check it.

I have a few questions regarding this issue:
1) Why is the DB error log not accurately reflecting the error?
2) Is there a way to make QlikSense error logs during data loading match the actual DB query execution error logs?
3) Alternatively, is there a method to retrieve error logs from the database when loading data in QlikSense?

While QlikSense does provide information about the error, it doesn't provide precise error logs. Are there any solutions or alternatives for this?

If possible, I would appreciate your response.

Thank you.

topic Discrepancy in Error Messages in QlikSense DB Script in Management & Governance

Discrepancy in Error Messages in QlikSense DB Script