Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
qwebnm
Partner - Creator III
Partner - Creator III

Discrepancy in Error Messages in QlikSense DB Script

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

qwebnm_0-1698296340256.png 

qwebnm_1-1698296348562.png

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.

Labels (4)
0 Replies