Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Brrrr, that's weird.
Which release of QV12 did you use for the scheduled reloads?
Version 12.10.2500.0 SR7
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?