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