Field not found

[Vondox]

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

[anat]

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');

[Vondox]

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 🙂

[Vondox]

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.