Field Not Found

[baarathi]

When below code is executed in Qlik Script daily, Sometimes the script runs successfully and sometimes it throws below mentioned error and fails.

Qlik Script:

Load  DateColumn as Count_Row_Date,

Count_Row_Num

select top 1

cast(LDateUTC as date format 'YYYYMMDD') as DateColumn,

sum(1) as Count_Row_Num

from FactTable

  group by 1

  order by 1 desc;

ERROR MESSAGE

Error: Field 'DateColumn' not found

[Or]

I'd guess that something is causing the SQL to not return anything, possibly some sort of error that the connector doesn't catch. As a result, the load can't find the field from the Select. You could cross-check your database logs to see whether the query is executing successfully at the specified time.