How to get DB logs from QlikSense.

qwebnm — Fri, 15 Nov 2024 21:20:47 GMT

To the Qlik Team,

Hello. I am reaching out with a query regarding the Task Failed Log that I am currently reviewing. The details are as follows:

1. Issue:
Upon reviewing the logs for Task Failed, it indicates that the "drug_id" field is missing, but in reality, the column does exist.

2. Assessment:
1) In reality, the "drug_id" column does exist, but the situation appears to involve the absence of the "drug_dx" column, which seems to have resulted in the query execution failure.
2) Query execution failure leads to the absence of data in the first row, which in turn triggers an error stating the absence of the "drug_id" as the first field.
* In such cases, the logs are not entirely incorrect but seem inappropriate.
* Ideally, it appears that the logs should reflect the moment when the error occurs, which is at the time of query failure.

3. Request for Clarification: How to get the following logs from a task log or load script in QlikSense.
1) Is it possible to log database query execution failures?
If possible, could you please provide guidance on how to achieve this?

2) Can I check the error received from DB?
If possible, please provide a guide.

Please help if possible.
I look forward to hearing from Qlik.

Thank you.

Re: How to get DB logs from QlikSense.

Alan_Slaughter — Tue, 07 Nov 2023 20:19:04 GMT

Maybe this could be helpful:

https://community.qlik.com/t5/Official-Support-Articles/Turn-on-PostgreSQL-logs-in-Qlik-Sense/ta-p/1715486

topic Re: How to get DB logs from QlikSense. in Management & Governance

How to get DB logs from QlikSense.

Re: How to get DB logs from QlikSense.