Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

scheduling failed in qlikview

my task is reloading manually but when i scheduling it is failing

my task is having section access

hear is the log

(2015-01-30 15:03:00) Information: Executing ClusterID=1, QDSID=07cbd14b-5ab2-f13c-5811-cfc0d67015d8 QDSMain.DistributeTask

(2015-01-30 15:03:00) Information: Starting task "NMEA/NMEA_iManage_Dashboard_1.3.qvw" (Attempt 1 of 1)

(2015-01-30 15:03:00) Information: Max run time: 06:00:00

(2015-01-30 15:03:00) Information: Document is marked for refresh; Initializing Reload.

(2015-01-30 15:03:00) Information: Opening "C:\QlikView_Document\NMEA\NMEA_iManage_Dashboard_1.3.qvw"

(2015-01-30 15:03:00) Information: Allocating QlikView Engine

(2015-01-30 15:03:00) Information: Allocating new QlikView Engine. Current usagecount=1 of 2

(2015-01-30 15:03:00) Information: An instance of the QlikView Engine is being created

(2015-01-30 15:03:00) Information: Starting QlikView Engine

(2015-01-30 15:03:01) Information: Allocated QlikView Engine successfully. Current usagecount=1 of 2, Ticket=90

(2015-01-30 15:03:01) Information: Loading document "C:\QlikView_Document\NMEA\NMEA_iManage_Dashboard_1.3.qvw" (40.01 Mb)

(2015-01-30 15:03:01) Error: Document open call failed. The document might require username and password.

(2015-01-30 15:03:01) Error: The document failed to open.

(2015-01-30 15:03:01) Information: Closed the QlikView Engine successfully. ProcessID=2840

(2015-01-30 15:03:01) Information: Initializing Checkout (0), Loading document (1047), Initializing load (1047), Checking read (1047), Creating QlikView Engine (1047), Checking Size (1062), Load (1078), Load Completed (1375)

(2015-01-30 15:03:01) Error: Document could not be opened

(2015-01-30 15:03:01) Information: Document could not be opened (0)

(2015-01-30 15:03:01) Information: Initializing (0), Finished (0)

(2015-01-30 15:03:01) Error: Reload failed because the document could not be opened successfully. DocumentState=CouldNotOpenDocument

(2015-01-30 15:03:01) Information: Initializing (0), Finished (0)

(2015-01-30 15:03:01) Error: Reload failed. Distribution skipped.

their is no QlikView Distribution Service

Thanks

sivaram

23 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

Or change the code in Section Access into this:

Section Access;

SA:

LOAD * INLINE [

ACCESS, NTNAME, SID

ADMIN, QVAdmin,

];

CONCATENATE(SA)

LOAD [ACCESS],

     NTNAME,

     SID

FROM

(ooxml, embedded labels, table is SECTIONMASTER);

Section Application;

:


Now the Service Account will always be included, whether there is any data in your Excel or not. No more reload failures.

Best,

PEter

Not applicable
Author

Hi peter,

I had tried another qvd without section access it is scheduling

The one with section access is not scheduling

manually it is reloading   only issue is i want to reload for every 4 hours every time manually is difficult pleace help me with it to solve it

Thanks

Peter_Cammaert
Partner - Champion III
Partner - Champion III

If your section access works, and this new question is about task scheduling, close this discussion and start a new one.

Is yoiur service account allowed to reload the document in QMC now?

Not applicable
Author

Thanks a lot Peter Cammaert

sivaram