Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Task scheduler fails in Qlik12 but ok in Qlik10

Hi everyone,

I have an app in qlik10 that runs each day with no issues.  I copied it over to qlik12 and scheduled it to run each day just like in qlik10.

The task fails in qlik12.  If I run the app manually, it works fine.  So I compared the load text file. (schedule vs manual)

It fails after it loads the first inline table.  As you can see, when it is scheduled, it is missing these two lines. (or failing to process these two lines)

Missing lines

2017-08-23 09:46:52       2 fields found: METRIC, METRIC_FIELD,

2017-08-23 09:46:52      3 lines fetched

note: I comment out the inline tables and the scheduled script ran farther but failed once it found another  inline table.

schedule

2017-08-23 09:05:55 0064 LOAD * INLINE [

2017-08-23 09:05:55 0065  METRIC, METRIC_FIELD

2017-08-23 09:05:55 0066     Cases, z_cases_shpd

2017-08-23 09:05:55 0067     Grs Rev, z_grossrev_shpd

2017-08-23 09:05:55 0068     Pounds, z_netwt_shpd

2017-08-23 09:05:55 0069 ]

2017-08-23 09:05:55      Error: Unknown Error

2017-08-23 09:05:55      Unknown Error

2017-08-23 09:05:55      Execution Failed

2017-08-23 09:05:55      Execution finished

manual

2017-08-23 09:46:52 0064 LOAD * INLINE [

2017-08-23 09:46:52 0065  METRIC, METRIC_FIELD

2017-08-23 09:46:52 0066     Cases, z_cases_shpd

2017-08-23 09:46:52 0067     Grs Rev, z_grossrev_shpd

2017-08-23 09:46:52 0068     Pounds, z_netwt_shpd

2017-08-23 09:46:52 0069 ]

2017-08-23 09:46:52       2 fields found: METRIC, METRIC_FIELD,

2017-08-23 09:46:52      3 lines fetched

2017-08-23 09:46:52 0072 LOAD * INLINE [

Any ideas what is causing the failure?

Thanks for looking

Tom

3 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

Brrrr, that's weird.

Which release of QV12 did you use for the scheduled reloads?

Not applicable
Author

Version 12.10.2500.0 SR7

Not applicable
Author

For a test, I made a new app with just the following table in the script

LOAD * INLINE [

    F1, F2

    one, 1

    two, 2

    three, 3

    four, 4

];

It runs fine manually but fails when it is scheduled as a task.

Is this a bug?  QV12 task scheduler can't auto refresh?

Does anyone out there have an app with an inline table that refreshes as a task?