topic Re: Field not found in Connectivity & Data Prep

Field not found

Vondox — Wed, 10 Jul 2024 15:15:03 GMT

Hi,
I want to ask for an advice. I have a QlikSense app to be reloaded automatically. For this purpose I have created two tasks in the QMC:
1. task set to the specific day and time - this works correctly, data is reloaded
2. task triggered by successful finish of reload of another task - this one fails with the error message 'Field not found'.

First of all, I am not sure it should mean that the field is not found in the table at all (but in fact the field is there) OR the field is found, but there is some null value which causes the problem. Maybe there is some another problem with my script (below).

Does anyone have any idea what could be the reason for the error message 'Error: Field 'field_id' not found'?

Facts:

the field is in the source table
the query timeout for the connection is set to maximum
Teradata connection is used
manual reload run from QMC works correctly

My script in the Load script:

[Fields]: load field_id , field_l0_nm as Field , field_l1_nm as Field_group , field_l2_nm as Field_type ; SQL SELECT base.field_id , hier.field_l0_nm , hier.field_l1_nm , hier.field_l2_nm FROM DTB_NAME.LIST_OF_FIELDS AS base INNER JOIN DTB_NAME.FIELDS_HIERARCHY AS hier ON base.field_id = hier.field_id WHERE base.field_id IN ( SELECT field_id FROM DTB_NAME.REPORT WHERE field_id IS NOT NULL AND business_dt >='2024-01-01') ;

Thanks in advance

Re: Field not found

anat — Wed, 10 Jul 2024 15:21:45 GMT

try with below code:

[Fields]:
load
field_id
, field_l0_nm as Field
, field_l1_nm as Field_group
, field_l2_nm as Field_type
;

SQL

SELECT base.field_id as field_id
, hier.field_l0_nm as field_l0_nm
, hier.field_l1_nm as field_l1_nm
, hier.field_l2_nm as field_l2_nm
FROM DTB_NAME.LIST_OF_FIELDS AS base
INNER JOIN DTB_NAME.FIELDS_HIERARCHY AS hier
ON base.field_id = hier.field_id
WHERE base.field_id IN (
SELECT field_id
FROM DTB_NAME.REPORT
WHERE field_id IS NOT NULL
AND business_dt >='2024-01-01');

Re: Field not found

Vondox — Tue, 16 Jul 2024 09:36:24 GMT

Hi Anat,

thank you for the reply. I tried to adjust my script accordingly - I had to add alias also to the Load part, but for now it works correctly. We have more issues like this, I will chcek whether this solution will help in general and let you know.

Thank you one again 🙂

Re: Field not found

Vondox — Tue, 23 Jul 2024 12:18:29 GMT

Hi Anat,

I used the solutions for another skript as well but here it does not work. I adjusted it as following:

[Fields]: Load field_id as field_id , field_l0_nm as Field , field_l1_nm as Field_group , field_l2_nm as Field_type ; SQL SELECT base.field_id as field_id , hier.field_l0_nm as field_l0_nm , hier.field_l1_nm as field_l1_nm , hier.field_l2_nm as field_l2_nm FROM DTB_NAME.LIST_OF_FIELDS AS base INNER JOIN DTB_NAME.FIELDS_HIERARCHY AS hier ON base.field_id = hier.field_id WHERE base.field_id IN ( SELECT field_id FROM DTB_NAME.REPORT WHERE field_id IS NOT NULL AND business_dt >='2024-01-01') ;

The reload failed, the log says:

Error: Field 'field_id' not found

Execution Failed

Execution finished.

Would you have any other idea how to proceed? Thank you very much.