topic Re: Auto Reload in QlikView

Auto Reload

Thu, 10 Sep 2015 17:41:35 GMT

Hi,

I have a qvw file. I am pulling data from SAP using the inbuilt connector. I want to reload the qvw continuously.

Can this be achieved? How?

I have a qlikview server. I want to know how to reload continuously!

Please help. Thanks in advance.

Arjun Jain

Re: Auto Reload

Clever_Anjos — Thu, 10 Sep 2015 17:46:45 GMT

How are you reloading your app?

Desktop?
QVS
QVS + Publisher?

Re: Auto Reload

Thu, 10 Sep 2015 17:54:10 GMT

I did not know that it is possible to do it by QVS+Publisher. I have never used publisher.

I want to do it by QVS.

Re: Auto Reload

Thu, 01 Oct 2015 11:23:47 GMT

Can you please help me on how to do it using QVS?

Re: Auto Reload

Peter_Cammaert — Thu, 01 Oct 2015 11:27:19 GMT

Publish your document on the QlikView server. In most cases this comes down to dropping your document in the Document Root Folder (see QMC).
In QMC->User Documents, select your document from the tree on the left and navigate to the Reload tab.
Enable the reload and define suitable trigger conditions.
Do not forget to press Apply.

That's it.

Peter

Re: Auto Reload

maxgro — Thu, 01 Oct 2015 11:29:39 GMT

there is a Continuosly you can choose when you schedule the task

from QMC help

Continuously, meaning that the reload is performed all the time, that is it is started and when executed, it is started again, and so on.

Re: Auto Reload

Thu, 01 Oct 2015 11:30:29 GMT

Thanks for the quick reply Peter. I am unable to see the reload tab in user Documents. Please refer to the screenshot below.

Any idea on how to resolve this?

Re: Auto Reload

Peter_Cammaert — Thu, 01 Oct 2015 11:34:31 GMT

If you have a Publisher, select your document in Source Documents and add a Task (green button on the right pane). You can skip all Task tabs except the last one: Triggers.
Add a single trigger and select the appropriate trigger conditions.
Again, press Apply to store the task details (and make them active)

If this is an end-user document; you may want to visit the Distribution tab as well. Otherwise your document won't end up in the Access Point.

Peter

Re: Auto Reload

prma7799 — Thu, 01 Oct 2015 11:56:20 GMT

You can do one thing

Go to Status

> Task

> select your QVW

> tick pencil in the right side

> Trigger

> Configure Trigger

Thanks

Re: Auto Reload

Thu, 01 Oct 2015 12:52:36 GMT

Thanks. I did this.

But this task is not being executed.

Re: Auto Reload

Thu, 01 Oct 2015 13:14:49 GMT

Thanks for your help. I tried doing this.

I was able to create a reload task successfully. But when I reload it through QMC, it fails. Please refer to the screenshot below.

Re: Auto Reload

Peter_Cammaert — Thu, 01 Oct 2015 13:18:24 GMT

Check the document log. It's located in the same folder as your QVW document. If you don't find a document log, enable option "Generate log file" in Settings->Document Properties->General in QV Desktop. Then reload again.

Peter

Re: Auto Reload

Clever_Anjos — Thu, 01 Oct 2015 13:34:08 GMT

On the right side you can see the log file for each execution, please attach it.

It would be easier to help if you attach the qvw.log file too

Re: Auto Reload

Wed, 07 Oct 2015 05:17:06 GMT

Sorry for the late reply.

Please see the snapshot of the log below:

10/7/2015 10:42:09 AM: Execution started.

10/7/2015 10:42:09 AM: QlikView Version:11.20.12577.0

10/7/2015 10:42:09 AM: CPU Target x64

10/7/2015 10:42:09 AM: Operating System Windows Server 2012 R2 Standard (64 bit edition)

10/7/2015 10:42:09 AM: Wow64 mode Not using Wow64

10/7/2015 10:42:09 AM: MDAC Version 6.3.9600.16384

10/7/2015 10:42:09 AM: MDAC Full Install Version 6.3.9600.16384

10/7/2015 10:42:09 AM: PreferredCompression 2

10/7/2015 10:42:09 AM: EnableParallelReload 1

10/7/2015 10:42:09 AM: ParallelizeQvdLoads 1

10/7/2015 10:42:09 AM: AutoSaveAfterReload 0

10/7/2015 10:42:09 AM: BackupBeforeReload 0

10/7/2015 10:42:09 AM: EnableFlushLog 0

10/7/2015 10:42:09 AM: SaveInfoWhenSavingFile 0

10/7/2015 10:42:09 AM: UserLogfileCharset 1200

10/7/2015 10:42:09 AM: OdbcLoginTimeout -1

10/7/2015 10:42:09 AM: OdbcConnectionTimeout -1

10/7/2015 10:42:09 AM: ScriptWantsDbWrite false

10/7/2015 10:42:09 AM: ScriptWantsExe false

10/7/2015 10:42:09 AM: LogFile CodePage Used: 1200

10/7/2015 10:42:09 AM: Reload Executed By QLIKVIEW\Administrator

10/7/2015 10:42:09 AM: Process Executing: QVB

10/7/2015 10:42:09 AM: Process ID: 5384

10/7/2015 10:42:09 AM: 0002 SET ThousandSep=','

10/7/2015 10:42:09 AM: 0003 SET DecimalSep='.'

10/7/2015 10:42:09 AM: 0004 SET MoneyThousandSep=','

10/7/2015 10:42:09 AM: 0005 SET MoneyDecimalSep='.'

10/7/2015 10:42:09 AM: 0006 SET MoneyFormat='$#,##0.00;($#,##0.00)'

10/7/2015 10:42:09 AM: 0007 SET TimeFormat='h:mm:ss TT'

10/7/2015 10:42:09 AM: 0008 SET DateFormat='M/D/YYYY'

10/7/2015 10:42:09 AM: 0009 SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'

10/7/2015 10:42:09 AM: 0010 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

10/7/2015 10:42:09 AM: 0011 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

10/7/2015 10:42:09 AM: 0014 CUSTOM CONNECT*Provider*QvSAPBAPIConnector.dll*XUserId*XPassword*

10/7/2015 10:42:11 AM: 0015 [ZBAPI_DAS_TEST_ET_FINAL_UNLD]:

10/7/2015 10:42:11 AM: 0016 LOAD *

10/7/2015 10:42:11 AM: 0017 SQL {

10/7/2015 10:42:11 AM: 0018 "function":"ZBAPI_DAS_TEST",

10/7/2015 10:42:11 AM: 0019 "output":"ET_FINAL_UNLD",

10/7/2015 10:42:11 AM: 0020 "parameters":

10/7/2015 10:42:11 AM: 0021 [

10/7/2015 10:42:11 AM: 0022 { "direction":"out", "length":4, "name":"LV_MPRE_EMPTY", "optional":false, "type":"INT", "value":" " },

10/7/2015 10:42:11 AM: 0023 { "direction":"out", "length":4, "name":"LV_MPRE_TOT", "optional":false, "type":"INT", "value":" " },

10/7/2015 10:42:11 AM: 0024 { "direction":"out", "length":4, "name":"LV_RWIP_EMPTY", "optional":false, "type":"INT", "value":" " },

10/7/2015 10:42:11 AM: 0025 { "direction":"out", "length":4, "name":"LV_RWIP_TOT", "optional":false, "type":"INT", "value":" " },

10/7/2015 10:42:11 AM: 0026 { "direction":"out", "name":"RETURN", "optional":false },

10/7/2015 10:42:11 AM: 0027 { "direction":"in", "length":4, "name":"LV_LGNUM", "optional":false, "type":"CHAR", "value":"TS01" },

10/7/2015 10:42:11 AM: 0028 { "direction":"tables", "name":"ET_FINAL_PARK", "optional":false },

10/7/2015 10:42:11 AM: 0029 { "direction":"tables", "name":"ET_FINAL_UNLD", "optional":false }

10/7/2015 10:42:11 AM: 0030 ]

10/7/2015 10:42:11 AM: 0031 }

10/7/2015 10:42:30 AM: 18 fields found: TU_NUM, DOOR, TU_NUM_EXT, ARR_CHK, DOC_DOOR, UNLD_COMP, GR_COMP, QI_COMP, GR_COMP_NO, GR_TOT_NO, UNLD_COMP_NO, UNLD_TOT_NO, QI_COMP_NO, QI_TOT_NO, START_PLAN_TSTFR_D, START_PLAN_TSTFR_T, END_PLAN_TSTFR_D, END_PLAN_TSTFR_T, 6 lines fetched

10/7/2015 10:42:31 AM: 0035 [ZBAPI_DAS_TEST_LV_MPRE_EMPTY]:

10/7/2015 10:42:31 AM: 0036 LOAD *

10/7/2015 10:42:31 AM: 0037 SQL {

10/7/2015 10:42:31 AM: 0038 "function":"ZBAPI_DAS_TEST",

10/7/2015 10:42:31 AM: 0039 "output":"LV_MPRE_EMPTY",

10/7/2015 10:42:31 AM: 0040 "parameters":

10/7/2015 10:42:31 AM: 0041 [

10/7/2015 10:42:31 AM: 0042 { "direction":"out", "length":4, "name":"LV_MPRE_EMPTY", "optional":false, "type":"INT", "value":" " },

10/7/2015 10:42:31 AM: 0043 { "direction":"out", "length":4, "name":"LV_MPRE_TOT", "optional":false, "type":"INT", "value":" " },

10/7/2015 10:42:31 AM: 0044 { "direction":"out", "length":4, "name":"LV_RWIP_EMPTY", "optional":false, "type":"INT", "value":" " },

10/7/2015 10:42:31 AM: 0045 { "direction":"out", "length":4, "name":"LV_RWIP_TOT", "optional":false, "type":"INT", "value":" " },

10/7/2015 10:42:31 AM: 0046 { "direction":"out", "name":"RETURN", "optional":false },

10/7/2015 10:42:31 AM: 0047 { "direction":"in", "length":4, "name":"LV_LGNUM", "optional":false, "type":"CHAR", "value":"TS01" },

10/7/2015 10:42:31 AM: 0048 { "direction":"tables", "name":"ET_FINAL_PARK", "optional":false },

10/7/2015 10:42:31 AM: 0049 { "direction":"tables", "name":"ET_FINAL_UNLD", "optional":false }

10/7/2015 10:42:31 AM: 0050 ]

10/7/2015 10:42:31 AM: 0051 }

10/7/2015 10:42:37 AM: 1 fields found: LV_MPRE_EMPTY, 1 lines fetched

10/7/2015 10:42:37 AM: 0055 [ZBAPI_DAS_TEST_LV_MPRE_TOT]:

10/7/2015 10:42:37 AM: 0056 LOAD *

10/7/2015 10:42:37 AM: 0057 SQL {

10/7/2015 10:42:37 AM: 0058 "function":"ZBAPI_DAS_TEST",

10/7/2015 10:42:37 AM: 0059 "output":"LV_MPRE_TOT",

10/7/2015 10:42:37 AM: 0060 "parameters":

10/7/2015 10:42:37 AM: 0061 [

10/7/2015 10:42:37 AM: 0062 { "direction":"out", "length":4, "name":"LV_MPRE_EMPTY", "optional":false, "type":"INT", "value":" " },

10/7/2015 10:42:37 AM: 0063 { "direction":"out", "length":4, "name":"LV_MPRE_TOT", "optional":false, "type":"INT", "value":" " },

10/7/2015 10:42:37 AM: 0064 { "direction":"out", "length":4, "name":"LV_RWIP_EMPTY", "optional":false, "type":"INT", "value":" " },

10/7/2015 10:42:37 AM: 0065 { "direction":"out", "length":4, "name":"LV_RWIP_TOT", "optional":false, "type":"INT", "value":" " },

10/7/2015 10:42:37 AM: 0066 { "direction":"out", "name":"RETURN", "optional":false },

10/7/2015 10:42:37 AM: 0067 { "direction":"in", "length":4, "name":"LV_LGNUM", "optional":false, "type":"CHAR", "value":"TS01" },

10/7/2015 10:42:37 AM: 0068 { "direction":"tables", "name":"ET_FINAL_PARK", "optional":false },

10/7/2015 10:42:37 AM: 0069 { "direction":"tables", "name":"ET_FINAL_UNLD", "optional":false }

10/7/2015 10:42:37 AM: 0070 ]

10/7/2015 10:42:37 AM: 0071 }

10/7/2015 10:42:43 AM: 1 fields found: LV_MPRE_TOT, 1 lines fetched

10/7/2015 10:42:43 AM: 0075 [ZBAPI_DAS_TEST_LV_RWIP_EMPTY]:

10/7/2015 10:42:43 AM: 0076 LOAD *

10/7/2015 10:42:43 AM: 0077 SQL {

10/7/2015 10:42:43 AM: 0078 "function":"ZBAPI_DAS_TEST",

10/7/2015 10:42:43 AM: 0079 "output":"LV_RWIP_EMPTY",

10/7/2015 10:42:43 AM: 0080 "parameters":

10/7/2015 10:42:43 AM: 0081 [

10/7/2015 10:42:43 AM: 0082 { "direction":"out", "length":4, "name":"LV_MPRE_EMPTY", "optional":false, "type":"INT", "value":" " },

10/7/2015 10:42:43 AM: 0083 { "direction":"out", "length":4, "name":"LV_MPRE_TOT", "optional":false, "type":"INT", "value":" " },

10/7/2015 10:42:43 AM: 0084 { "direction":"out", "length":4, "name":"LV_RWIP_EMPTY", "optional":false, "type":"INT", "value":" " },

10/7/2015 10:42:43 AM: 0085 { "direction":"out", "length":4, "name":"LV_RWIP_TOT", "optional":false, "type":"INT", "value":" " },

10/7/2015 10:42:43 AM: 0086 { "direction":"out", "name":"RETURN", "optional":false },

10/7/2015 10:42:43 AM: 0087 { "direction":"in", "length":4, "name":"LV_LGNUM", "optional":false, "type":"CHAR", "value":"TS01" },

10/7/2015 10:42:43 AM: 0088 { "direction":"tables", "name":"ET_FINAL_PARK", "optional":false },

10/7/2015 10:42:43 AM: 0089 { "direction":"tables", "name":"ET_FINAL_UNLD", "optional":false }

10/7/2015 10:42:43 AM: 0090 ]

10/7/2015 10:42:43 AM: 0091 }

10/7/2015 10:42:50 AM: 1 fields found: LV_RWIP_EMPTY, 1 lines fetched

10/7/2015 10:42:50 AM: 0095 [ZBAPI_DAS_TEST_LV_RWIP_TOT]:

10/7/2015 10:42:50 AM: 0096 LOAD *

10/7/2015 10:42:50 AM: 0097 SQL {

10/7/2015 10:42:50 AM: 0098 "function":"ZBAPI_DAS_TEST",

10/7/2015 10:42:50 AM: 0099 "output":"LV_RWIP_TOT",

10/7/2015 10:42:50 AM: 0100 "parameters":

10/7/2015 10:42:50 AM: 0101 [

10/7/2015 10:42:50 AM: 0102 { "direction":"out", "length":4, "name":"LV_MPRE_EMPTY", "optional":false, "type":"INT", "value":" " },

10/7/2015 10:42:50 AM: 0103 { "direction":"out", "length":4, "name":"LV_MPRE_TOT", "optional":false, "type":"INT", "value":" " },

10/7/2015 10:42:50 AM: 0104 { "direction":"out", "length":4, "name":"LV_RWIP_EMPTY", "optional":false, "type":"INT", "value":" " },

10/7/2015 10:42:50 AM: 0105 { "direction":"out", "length":4, "name":"LV_RWIP_TOT", "optional":false, "type":"INT", "value":" " },

10/7/2015 10:42:50 AM: 0106 { "direction":"out", "name":"RETURN", "optional":false },

10/7/2015 10:42:50 AM: 0107 { "direction":"in", "length":4, "name":"LV_LGNUM", "optional":false, "type":"CHAR", "value":"TS01" },

10/7/2015 10:42:50 AM: 0108 { "direction":"tables", "name":"ET_FINAL_PARK", "optional":false },

10/7/2015 10:42:50 AM: 0109 { "direction":"tables", "name":"ET_FINAL_UNLD", "optional":false }

10/7/2015 10:42:50 AM: 0110 ]

10/7/2015 10:42:50 AM: 0111 }

10/7/2015 10:42:56 AM: 1 fields found: LV_RWIP_TOT, 1 lines fetched

10/7/2015 10:42:57 AM: 0113 [ZBAPI_DAS_PACKTAB_IT_STOCK_OVERVIEW]:

10/7/2015 10:42:57 AM: 0114 LOAD *

10/7/2015 10:42:57 AM: 0115 SQL {

10/7/2015 10:42:57 AM: 0116 "function":"ZBAPI_DAS_PACKTAB",

10/7/2015 10:42:57 AM: 0117 "output":"IT_STOCK_OVERVIEW",

10/7/2015 10:42:57 AM: 0118 "parameters":

10/7/2015 10:42:57 AM: 0119 [

10/7/2015 10:42:57 AM: 0120 { "direction":"out", "name":"RETURN", "optional":false },

10/7/2015 10:42:57 AM: 0121 { "direction":"in", "length":4, "name":"LV_LGNUM", "optional":false, "type":"CHAR", "value":"TS01" },

10/7/2015 10:42:57 AM: 0122 { "direction":"in", "length":4, "name":"LV_LGTYP", "optional":false, "type":"CHAR", "value":"MPAC" },

10/7/2015 10:42:57 AM: 0123 { "direction":"tables", "name":"IT_STOCK_OVERVIEW", "optional":false }

10/7/2015 10:42:57 AM: 0124 ]

10/7/2015 10:42:57 AM: 0125 }

10/7/2015 10:42:57 AM: 54 fields found: LGNUM, LGPLA, LGTYP, LGBER, LPTYP, BIN_AT, PLAUF, PLPOS, SKZUA, SKZUE, SKZSI, FLGSBIN, ANZLE, MAXLE, MAX_WEIGHT, UNIT_W, WEIGHT, VOLUM, MAX_VOLUME, UNIT_V, MAX_CAPA, FCAPA, KZLER, KZVOL, PTWY_DATE, MOVED_TIME, MOVED_DATE, BTANR, CLEARED_TIME, CLEARED_DATE, KZINV, IDATUM, IVNUM, IVPOS, BRAND, UNAME, CHANGED_TIME, CHANGED_DATE, VERIF, LGPLA_MAIN, AISLE, STACK, LVL_V, BINSC, DEPTH, X_CORD, Y_CORD, Z_CORD, FIXBINTYP, USER_STATUS, PSAS, ANGLE, LGBER_LGST, REC_GRP, 0 lines fetched

10/7/2015 10:42:58 AM: Execution finished.

This says that the execution finished. But in qmc it says that the task FAILED. So now has it been executed or no? Has the reload been successful?

Re: Auto Reload

Wed, 07 Oct 2015 05:28:53 GMT

Okay so I just figured that the task that I have created reloads the .qvw and then distributes it.

I checked the log. Everything is fine till the reload part, its when the file is being distributed the task fails.

Can somebody please tell me what do you mean by distributing the file.

I just want to see the changes in the reloaded file, via internet explorer without needing to refresh the page.

Re: Auto Reload

Peter_Cammaert — Wed, 07 Oct 2015 09:05:48 GMT

The document log shows no errors, although the last load returning 0 lines bothers me a bit.

A QDS Reload job also has a TaskLog that documents everyhthing that happens before or after script execution. mostly QDS management -related stuff. The TaskLog can be found - as Clever Anjos indicated - in the QMC task overview by selecting your failed task and clicking the "Show Task Details" link at the top right. The last tab shows the task log details. Please cut and paste this information in this thread. Thanks

Best,

Peter

Re: Auto Reload

Wed, 07 Oct 2015 09:54:40 GMT

Hi Peter

Thanks for the reply please find the log file below:

10/7/2015 11:46:18.4618631	Information	Starting task 'Auto-Reload-DM'. Id:8c26079d-9876-40e0-bdc8-02fb4f595bda. Triggered by 'ScheduleTrigger'. Id:1997d1dc-f98a-4820-80a1-b441af843f31
10/7/2015 11:46:18.5086902	Information	Entering Task Execution.
10/7/2015 11:46:18.5086902	Information	ClusterID=1
10/7/2015 11:46:18.5086902	Information	QDSID=c27b7be8-004f-d83a-0510-d5f727418e87
10/7/2015 11:46:18.5086902	Information	TaskID=8c26079d-9876-40e0-bdc8-02fb4f595bda
10/7/2015 11:46:18.5086902	Information	MaxRunTime=1.00:00:00
10/7/2015 11:46:18.5086902	Information	MachineName=QLIKVIEW
10/7/2015 11:46:18.5086902	Information	Max attempts:1
10/7/2015 11:46:18.5086902	Information	Current Attempt=0
10/7/2015 11:46:18.5086902	Information	Task Dependencies are OK
10/7/2015 11:46:18.5086902	Information	Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.
10/7/2015 11:46:18.5086902	Information	Opening "C:\EWM\Application\Dock Monitor.qvw"
10/7/2015 11:46:18.5086902	Information	Allocating new QlikView Engine. Current usage count=0 of 4 (of type non-reader).
10/7/2015 11:46:18.5086902	Information	Max retries:5
10/7/2015 11:46:18.5086902	Information	Attempt:01
10/7/2015 11:46:19.5555700	Information	Opened the QlikView Engine successfully. ProcessID=5824
10/7/2015 11:46:19.5555700	Information	Allocated QlikView Engine successfully. Current usage count=1 of 4 (of type non-reader). Ticket number=854.
10/7/2015 11:46:19.5555700	Information	Loading document "C:\EWM\Application\Dock Monitor.qvw" (0.36 Mb)
10/7/2015 11:46:19.6805721	Information	Physical FileSize=0.36 Mb. Memory Allocation Delta for this file=4.68 Mb. Available Physical Memory Before Open=5596.00 Mb. Available Physical Memory After Open=5588.55 Mb. Total Physical Memory=7863.55 Mb.
10/7/2015 11:46:19.6961890	Information	Attempted to load the document without data.
10/7/2015 11:46:19.6961890	Information	The document was loaded successfully.
10/7/2015 11:46:19.6961890	Information	Document was opened successfully
10/7/2015 11:46:19.6961890	Information	Starting reload
10/7/2015 11:46:19.7118186	Information	QlikView->Settings->Document Peferences->Generate Logfile in document is set. Enabling Log Copier.
10/7/2015 11:46:19.7118186	Information	Waiting for the document log "C:\EWM\Application\Dock Monitor.qvw" to become available.. Check until 10/7/2015 11:46:49 AM
10/7/2015 11:46:19.7118186	Information	The Source Document is being reloaded. DocumentPath=C:\EWM\Application\Dock Monitor.qvw
10/7/2015 11:46:19.7899776	Information	Found a document log. FileName=C:\EWM\Application\Dock Monitor.qvw.log
10/7/2015 11:46:19.7899776	Information	Writing documentLog to C:\ProgramData\QlikTech\DistributionService\1\Log\20151007\114618 - Auto-Reload-DM\DocumentLog.txt
10/7/2015 11:46:20.6962044	Information	Reloading.
10/7/2015 11:46:21.6962224	Information	Reloading..
10/7/2015 11:46:22.6962502	Information	Reloading...
10/7/2015 11:46:23.6962503	Information	Reloading....
10/7/2015 11:46:24.7118432	Information	Reloading.....
10/7/2015 11:46:25.7275033	Information	Reloading......
10/7/2015 11:46:26.7275056	Information	Reloading.......
10/7/2015 11:46:27.7275131	Information	Reloading........
10/7/2015 11:46:28.7431324	Information	Reloading.........
10/7/2015 11:46:29.7587192	Information	Reloading..........
10/7/2015 11:46:30.7587752	Information	Slow down logging. Log every <2> seconds.
10/7/2015 11:46:30.7587752	Information	Reloading
10/7/2015 11:46:32.7743989	Information	Reloading.
10/7/2015 11:46:34.8056166	Information	Reloading..
10/7/2015 11:46:36.8369019	Information	Reloading...
10/7/2015 11:46:38.8525343	Information	Reloading....
10/7/2015 11:46:40.8681614	Information	Reloading.....
10/7/2015 11:46:42.8838148	Information	Reloading......
10/7/2015 11:46:44.9150447	Information	Reloading.......
10/7/2015 11:46:46.9306368	Information	Reloading........
10/7/2015 11:46:48.9306734	Information	Reloading.........
10/7/2015 11:46:50.9618986	Information	Reloading..........
10/7/2015 11:46:52.9619797	Information	Slow down logging. Log every <10> seconds.
10/7/2015 11:46:52.9619797	Information	Reloading
10/7/2015 11:46:56.4931582	Information	The Source Document reload complete. DocumentPath=C:\EWM\Application\Dock Monitor.qvw
10/7/2015 11:46:56.4931582	Information	Memory Allocation Delta for this file=5.09 Mb. Available Physical Memory Before Reload=5588.54 Mb. Available Physical Memory After Reload=5579.42 Mb. Total Physical Memory=5579.42 Mb.
10/7/2015 11:46:56.7118864	Information	The Source Document was reloaded successfully.
10/7/2015 11:46:56.7744195	Information	Reload finished successfully
10/7/2015 11:46:56.7744195	Information	Start saving document
10/7/2015 11:46:59.4619114	Information	Check in document: C:\EWM\Application\Dock Monitor.qvw
10/7/2015 11:46:59.4931541	Information	Closing the document.
10/7/2015 11:47:00.1337909	Information	Closed the QlikView Engine successfully. ProcessID=5824
10/7/2015 11:47:00.1337909	Information	Start document distribution.
10/7/2015 11:47:00.1337909	Information	Opening source document
10/7/2015 11:47:00.1337909	Information	Opening document: "Dock Monitor.qvw"
10/7/2015 11:47:00.1337909	Information	Allocating new QlikView Engine. Current usage count=0 of 4 (of type non-reader).
10/7/2015 11:47:00.1337909	Information	Max retries:5
10/7/2015 11:47:00.1337909	Information	Attempt:01
10/7/2015 11:47:01.2275273	Information	Opened the QlikView Engine successfully. ProcessID=2872
10/7/2015 11:47:01.2275273	Information	Allocated QlikView Engine successfully. Current usage count=1 of 4 (of type non-reader). Ticket number=855.
10/7/2015 11:47:01.2275273	Information	Loading document "C:\EWM\Application\Dock Monitor.qvw" (0.36 Mb)
10/7/2015 11:47:02.2275297	Information	Loading. LoadTime=00:00:01.0000024
10/7/2015 11:47:02.3994035	Information	Physical FileSize=0.36 Mb. Memory Allocation Delta for this file=7.05 Mb. Available Physical Memory Before Open=5555.66 Mb. Available Physical Memory After Open=5562.93 Mb. Total Physical Memory=7863.55 Mb.
10/7/2015 11:47:02.3994035	Information	Attempted to load the document with data.
10/7/2015 11:47:02.3994035	Information	The document was loaded successfully.
10/7/2015 11:47:02.4306537	Information	Reduce skipped, nothing is selected.
10/7/2015 11:47:02.4306537	Information	Document was opened successfully
10/7/2015 11:47:02.4306537	Information	Determined 8 static recipients spread over 2 Distribution Resources.
10/7/2015 11:47:02.4306537	Information	Number of rule combinations was calculated successfully. Rounds=1
10/7/2015 11:47:02.4306537	Information	Empty rules
10/7/2015 11:47:02.4306537	Information	Rules resulted in distribution.
10/7/2015 11:47:02.4306537	Information	ROUND: 0 of 1. WarningCount=0
10/7/2015 11:47:02.4306537	Information	Building filename
10/7/2015 11:47:02.4306537	Information	Destination name: Dock Monitor.qvw
10/7/2015 11:47:02.4306537	Information	Set script
10/7/2015 11:47:02.4618969	Information	Resetting of the Document Script for the Distributed Document was successful. ScriptType=Clear
10/7/2015 11:47:02.4618969	Information	Offer resources
10/7/2015 11:47:02.4931524	Information	Commencing ReduceData for C:\ProgramData\QlikTech\DistributionService\1\temp\2a93b038-8aaf-404e-ac29-a4a88a06ddff\document.qvw. (Reduce=False, Save=True)
10/7/2015 11:47:02.6025261	Information	Completed ReduceData for C:\ProgramData\QlikTech\DistributionService\1\temp\2a93b038-8aaf-404e-ac29-a4a88a06ddff\document.qvw. (Reduce=False, Save=True)
10/7/2015 11:47:02.6025261	Information	Memory Allocation Delta for this file=1.21 Mb. Available Physical Memory Before Reduce=5562.82 Mb. Available Physical Memory After Reduce=5562.48 Mb. Total Physical Memory=5562.48 Mb.
10/7/2015 11:47:02.6025261	Information	Distributing
10/7/2015 11:47:02.6025261	Information	Distributing using resource "Auto-Reload-DM_QVS_1".
10/7/2015 11:47:02.6337774	Information	Deleting temporary files.
10/7/2015 11:47:02.6650301	Information	Closing the document.
10/7/2015 11:47:03.2799340	Information	Closed the QlikView Engine successfully. ProcessID=2872
10/7/2015 11:47:03.2799340	Information	Document distribution done.
10/7/2015 11:47:03.2955553	Error	The task "Auto-Reload-DM" failed. Exception:

QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.DistributeToResourcesFailedException: Distribute to resource failed. ---> QDSMain.Exceptions.DscOffLineException: Failed to AddNamedUsers

at QDSMain.Support.DSCHelper.AddNamedUsers(ILogBucket logBucket, XmlDocument xml, List`1 namedUsers, FileSystemPluginHelper fileSystemPluginHelper)

at QDSMain.Support.DSCHelper.GetFileSystemSecurity(ILogBucket logBucket, FileSystemPluginHelper fileSystemPluginHelper, List`1 recipients)

at QDSMain.QlikViewServerDistributionResource.CreateSettingsBlock(ILogBucket i_LogBucket, FileSystemPluginHelper i_FileSystemPluginHelper, String i_SourceDocumentName, DateTime i_LastUpdate, DateTime i_NextUpdate, Boolean i_EventDriven, String i_Category, eDistributionFileType i_TotalDistributionFileTypeMask, FilePackageContainer i_FilePackageContainer)

at QDSMain.QlikViewServerDistributionResource.Distribute(ILogBucket i_LogBucket, DistributionRequest i_DistributionRequest)

at QDSMain.DistributeTask.DistributeStreamToResources(Int32 round, Distribution distribution, IEnumerable`1 distributionResources)

--- End of inner exception stack trace ---

at QDSMain.DistributeTask.DistributeStreamToResources(Int32 round, Distribution distribution, IEnumerable`1 distributionResources)

at QDSMain.DistributeTask.DistributionExecution(String fileName, Document qvbDocument, DistributionRequest distributionRequest, TaskResult taskResult, String repeatVariableName, String currentRepeatVariableValue)

at QDSMain.DistributeTask.Distribution(String fileName, DistributionRequest distributionRequest, TaskResult taskResult, String repeatVariableName, String currentRepeatVariableValue)

at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

--- End of inner exception stack trace ---

at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

10/7/2015 11:47:03.2955553	Information	Task Execute Duration=00:00:44.7868651
10/7/2015 11:47:03.2955553	Information	Sending Alert mail
10/7/2015 11:47:07.6705113	Warning	No mailaddress found. Recipient= charanpreet.singh@stelliuminc.com

Jethendra.Ravi@stelliuminc.com

10/7/2015 11:47:07.6705113	Information	TaskResult.status=Finished
10/7/2015 11:47:07.7017626	Information	Notifying all triggers of new state:FinishedWithErrors
10/7/2015 11:47:07.7017626	Information	Notifying all triggers of new state:FinishedWithErrors - completed
10/7/2015 11:47:07.7017626	Information	Saving Task Result

Thanks!!

Arjun

Re: Auto Reload

Peter_Cammaert — Wed, 07 Oct 2015 10:24:40 GMT

Well it was indeed the distribution that failed, and for a seemingly simple reason. Have a look at this part:

QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.DistributeToResourcesFailedException: Distribute to resource failed. ---> QDSMain.Exceptions.DscOffLineException: Failed to AddNamedUsers

at QDSMain.Support.DSCHelper.AddNamedUsers(ILogBucket logBucket, XmlDocument xml, List`1 namedUsers, FileSystemPluginHelper fileSystemPluginHelper)

at QDSMain.Support.DSCHelper.GetFileSystemSecurity(ILogBucket logBucket, FileSystemPluginHelper fileSystemPluginHelper, List`1 recipients)

at QDSMain.QlikViewServerDistributionResource.CreateSettingsBlock(ILogBucket i_LogBucket,

To distribute a document to Named Users, the QlikView Distribution Service has to figure out who these users really are. For that he uses the Directory Service Connector.

Apparently your Server has no DSC configured, or the DSC isn't working properly. Check the DSC configuration in QMC.

Peter

Re: Auto Reload

pradosh_thakur — Wed, 04 Oct 2017 16:04:09 GMT

you have a source document and user document structure and when you distribute it the app will be refreshed in user document which you can see through access point.

in distribute tab try using all users as user type and mount it to a folder.

create a task from source document and go through all the tabs in the trigger task creation carefully.

hopefully you have AD groups configured.

regards

Pradosh