Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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?
Thanks a lot Peter Cammaert
sivaram