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.
