Re: Document comtains mdx query reload failed - Qlik Community

Report Inappropriate Content · ‎2013-10-20

Hi All,

i have a document which have script i generate it using mdx query generator

it runs successfully on the server and on my machine,

but when i assign a task for it in Management console the reload failed!!

i don't know why??

dvasseur · ‎2013-10-20

you mean an Analysis Service MDX query ? Could you copy the log here ?

Analysis Service is using Windows authentication so make sure the account running Distribution Service has access to your AS cubes.

Report Inappropriate Content · ‎2013-10-20

here's the log file on management console

(2013-10-20 11:38:16) Information: Starting task 'Secondary Sales.V2.qvw'. Id:c34acd29-781e-4fc3-be2f-98da120c25c9. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c

(2013-10-20 11:38:16) Information: Entering Task Execution.

(2013-10-20 11:38:16) Information: ClusterID=1

(2013-10-20 11:38:16) Information: QDSID=00aa2e3a-fa76-2190-0033-56596f93d1b2

(2013-10-20 11:38:16) Information: TaskID=c34acd29-781e-4fc3-be2f-98da120c25c9

(2013-10-20 11:38:16) Information: MaxRunTime=06:00:00

(2013-10-20 11:38:16) Information: MachineName=EGCAQV01

(2013-10-20 11:38:16) Information: Max attempts:1

(2013-10-20 11:38:16) Information: Current Attempt=0

(2013-10-20 11:38:16) Information: Task Dependencies are OK

(2013-10-20 11:38:16) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(2013-10-20 11:38:16) Information: Opening "C:\ProgramData\QlikTech\Documents\Secondary Sales.V2.qvw"

(2013-10-20 11:38:16) Information: Allocating new QlikView Engine. Current usage count=0 of 2 (of type non-reader).

(2013-10-20 11:38:16) Information: Max retries:5

(2013-10-20 11:38:16) Information: Attempt:01

(2013-10-20 11:38:17) Information: Allocated QlikView Engine successfully. Current usage count=1 of 2 (of type non-reader). Ticket number=2112.

(2013-10-20 11:38:17) Information: Loading document "C:\ProgramData\QlikTech\Documents\Secondary Sales.V2.qvw" (9.98 Mb)

(2013-10-20 11:38:17) Information: Physical FileSize=9.98 Mb. Memory Allocation Delta for this file=5.14 Mb. Available Physical Memory Before Open=6994.59 Mb. Available Physical Memory After Open=6983.51 Mb. Total Physical Memory=8074.68 Mb.

(2013-10-20 11:38:17) Information: Attempted to load the document without data.

(2013-10-20 11:38:17) Information: The document was loaded successfully.

(2013-10-20 11:38:17) Information: Document was opened successfully

(2013-10-20 11:38:17) Information: Starting reload

(2013-10-20 11:38:17) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is not set.

(2013-10-20 11:38:17) Information: The Source Document is being reloaded. DocumentPath=C:\ProgramData\QlikTech\Documents\Secondary Sales.V2.qvw

(2013-10-20 11:38:17) Information: The Source Document reload complete. DocumentPath=C:\ProgramData\QlikTech\Documents\Secondary Sales.V2.qvw

(2013-10-20 11:38:17) Information: Memory Allocation Delta for this file=1.18 Mb. Available Physical Memory Before Reload=6983.49 Mb. Available Physical Memory After Reload=6975.72 Mb. Total Physical Memory=6975.72 Mb.

(2013-10-20 11:38:17) Error: The Source Document was NOT reloaded successfully. DocumentPath=C:\ProgramData\QlikTech\Documents\Secondary Sales.V2.qvw.

(2013-10-20 11:38:17) Information: Closing the document.

(2013-10-20 11:38:18) Information: Closed the QlikView Engine successfully. ProcessID=2008

(2013-10-20 11:38:18) Error: The task "Secondary Sales.V2.qvw" failed. Exception:

(2013-10-20 11:38:18) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=C:\ProgramData\QlikTech\Documents\Secondary Sales.V2.qvw.

(2013-10-20 11:38:18) Error: at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

(2013-10-20 11:38:18) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2013-10-20 11:38:18) Error: --- End of inner exception stack trace ---

(2013-10-20 11:38:18) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2013-10-20 11:38:18) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2013-10-20 11:38:18) Error: --- End of inner exception stack trace ---

(2013-10-20 11:38:18) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2013-10-20 11:38:18) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2013-10-20 11:38:18) Information: Task Execute Duration=00:00:01.4820000

(2013-10-20 11:38:18) Information: TaskResult.status=Finished

(2013-10-20 11:38:18) Information: Notifying all triggers of new state:FinishedWithErrors

(2013-10-20 11:38:18) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2013-10-20 11:38:18) Information: Saving Task Result

Report Inappropriate Content · ‎2013-10-20

here's the log file of the document

10/20/2013 11:44:03 AM: Execution started.

10/20/2013 11:44:03 AM: QlikView Version:11.20.11643.0

10/20/2013 11:44:03 AM: CPU Target x86

10/20/2013 11:44:03 AM: Operating System Windows 7 Professional (32 bit edition)

10/20/2013 11:44:03 AM: Wow64 mode Not using Wow64

10/20/2013 11:44:03 AM: MDAC Version 6.1.7600.16385

10/20/2013 11:44:03 AM: MDAC Full Install Version 6.1.7600.16385

10/20/2013 11:44:03 AM: PreferredCompression 2

10/20/2013 11:44:03 AM: EnableParallelReload 1

10/20/2013 11:44:03 AM: ParallelizeQvdLoads 1

10/20/2013 11:44:03 AM: AutoSaveAfterReload 0

10/20/2013 11:44:03 AM: BackupBeforeReload 0

10/20/2013 11:44:03 AM: EnableFlushLog 0

10/20/2013 11:44:03 AM: SaveInfoWhenSavingFile 0

10/20/2013 11:44:03 AM: UserLogfileCharset 0

10/20/2013 11:44:03 AM: OdbcLoginTimeout -1

10/20/2013 11:44:03 AM: OdbcConnectionTimeout -1

10/20/2013 11:44:03 AM: ScriptWantsDbWrite false

10/20/2013 11:44:03 AM: ScriptWantsExe false

10/20/2013 11:44:03 AM: LogFile CodePage Used: 1252

10/20/2013 11:44:03 AM: 0002 SET ThousandSep=','

10/20/2013 11:44:03 AM: 0003 SET DecimalSep='.'

10/20/2013 11:44:03 AM: 0004 SET MoneyThousandSep=','

10/20/2013 11:44:03 AM: 0005 SET MoneyDecimalSep='.'

10/20/2013 11:44:03 AM: 0006 SET MoneyFormat='$#,##0.00;($#,##0.00)'

10/20/2013 11:44:03 AM: 0007 SET TimeFormat='h:mm:ss TT'

10/20/2013 11:44:03 AM: 0008 SET DateFormat='M/D/YYYY'

10/20/2013 11:44:03 AM: 0009 SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'

10/20/2013 11:44:03 AM: 0010 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'

10/20/2013 11:44:03 AM: 0011 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'

10/20/2013 11:44:03 AM: 0014 OLEDB CONNECT*Provider*

10/20/2013 11:44:03 AM: 0019 LET varMinDate = Num(MakeDate(2010,1, 1))

10/20/2013 11:44:03 AM: 0020 LET varMaxDate = Num(MakeDate(2013,12,31))

10/20/2013 11:44:03 AM: 0022 Secondary_Sales:

10/20/2013 11:44:03 AM: 0023 LOAD [Qty by TON],

10/20/2013 11:44:03 AM: 0024 [Qty by Carton],

10/20/2013 11:44:03 AM: 0025 [Area],

10/20/2013 11:44:03 AM: 0026 [Branch],

10/20/2013 11:44:03 AM: 0027 [District],

10/20/2013 11:44:03 AM: 0028 [Region],

10/20/2013 11:44:03 AM: 0029 [Sub Area],

10/20/2013 11:44:03 AM: 0030 SubField([Month],' ',2) as NewMonth,

10/20/2013 11:44:03 AM: 0031 [Quarter],

10/20/2013 11:44:03 AM: 0032 Right([Year],4) as NewYear,

10/20/2013 11:44:03 AM: 0033 SubField([Day],' ',2) as NewDay,

10/20/2013 11:44:03 AM: 0034

10/20/2013 11:44:03 AM: 0035 [Date],

10/20/2013 11:44:03 AM: 0036 [Month/Year],

10/20/2013 11:44:03 AM: 0037

10/20/2013 11:44:03 AM: 0038 SKU,

10/20/2013 11:44:03 AM: 0039 PRODUCT,

10/20/2013 11:44:03 AM: 0040 Customer

10/20/2013 11:44:03 AM: 0042 LOAD

10/20/2013 11:44:03 AM: 0043 "[Measures].[Qty by TON]" as [Qty by TON],

10/20/2013 11:44:03 AM: 0044 "[Measures].[Qty by Carton]" as [Qty by Carton],

10/20/2013 11:44:03 AM: 0045 "[Branch].[Area].[Area].[MEMBER_CAPTION]" as [Area],

10/20/2013 11:44:03 AM: 0046 "[Branch].[Branch].[Branch].[MEMBER_CAPTION]" as [Branch],

10/20/2013 11:44:03 AM: 0047 "[Branch].[District].[District].[MEMBER_CAPTION]" as [District],

10/20/2013 11:44:03 AM: 0048 "[Branch].[Region].[Region].[MEMBER_CAPTION]" as [Region],

10/20/2013 11:44:03 AM: 0049 "[Branch].[Sub Area].[Sub Area].[MEMBER_CAPTION]" as [Sub Area],

10/20/2013 11:44:03 AM: 0050 "[Date].[Month].[Month].[MEMBER_CAPTION]" as [Month/Year],

10/20/2013 11:44:03 AM: 0051 "[Date].[Quarter].[Quarter].[MEMBER_CAPTION]" as [Quarter],

10/20/2013 11:44:03 AM: 0052 "[Date].[Year].[Year].[MEMBER_CAPTION]" as [Year],

10/20/2013 11:44:03 AM: 0053 "[Date].[Date].[Date].[MEMBER_CAPTION]" as [Date],

10/20/2013 11:44:03 AM: 0054 "[Date].[Day Of Month].[Day Of Month].[MEMBER_CAPTION]" as [Day],

10/20/2013 11:44:03 AM: 0055 "[Date].[Month Of Year].[Month Of Year].[MEMBER_CAPTION]" as [Month],

10/20/2013 11:44:03 AM: 0056 "[Product SKU].[SKU].[SKU].[MEMBER_CAPTION]" as SKU,

10/20/2013 11:44:03 AM: 0057 "[Product SKU].[Product].[Product].[MEMBER_CAPTION]" as PRODUCT,

10/20/2013 11:44:03 AM: 0058 "[Customers].[Customer].[Customer].[MEMBER_CAPTION]" as Customer

10/20/2013 11:44:03 AM: 0059

10/20/2013 11:44:03 AM: 0060 SELECT

10/20/2013 11:44:03 AM: 0061 {

10/20/2013 11:44:03 AM: 0062 [Measures].[Qty by TON],

10/20/2013 11:44:03 AM: 0063 [Measures].[Qty by Carton]

10/20/2013 11:44:03 AM: 0064 }

10/20/2013 11:44:03 AM: 0065 DIMENSION PROPERTIES PARENT_UNIQUE_NAME,HIERARCHY_UNIQUE_NAME ON COLUMNS , NON EMPTY

10/20/2013 11:44:03 AM: 0066 CrossJoin(

10/20/2013 11:44:03 AM: 0067 {[Branch].[Area].Children},

10/20/2013 11:44:03 AM: 0068 {[Branch].[Branch].Children},

10/20/2013 11:44:03 AM: 0069 {[Branch].[District].Children},

10/20/2013 11:44:03 AM: 0070 {[Branch].[Region].Children},

10/20/2013 11:44:03 AM: 0071 {[Branch].[Sub Area].Children},

10/20/2013 11:44:03 AM: 0072 {[Product SKU].[SKU].Children},

10/20/2013 11:44:03 AM: 0073 {[Product SKU].[Product].Children},

10/20/2013 11:44:03 AM: 0074 {[Customers].[Customer].Children},

10/20/2013 11:44:03 AM: 0075 {[Date].[Month].Children},

10/20/2013 11:44:03 AM: 0076 {[Date].[Quarter].Children},

10/20/2013 11:44:03 AM: 0077 {[Date].[Year].Children},

10/20/2013 11:44:03 AM: 0078 {[Date].[Date].Children},

10/20/2013 11:44:03 AM: 0079 {[Date].[Day Of Month].Children},

10/20/2013 11:44:03 AM: 0080 {[Date].[Month Of Year].Children})

10/20/2013 11:44:03 AM: 0081 ON ROWS

10/20/2013 11:44:03 AM: 0082 FROM [TotalSales]

10/20/2013 11:44:51 AM: 16 fields found: Qty by TON, Qty by Carton, Area, Branch, District, Region, Sub Area, NewMonth, Quarter, NewYear, NewDay, Date, Month/Year, SKU, PRODUCT, Customer, 1,449,599 lines fetched

10/20/2013 11:45:05 AM: 0086 LOAD [Date],

10/20/2013 11:45:05 AM: 0087 NewMonth&'/'&NewDay&'/'&NewYear as NewDate

10/20/2013 11:45:05 AM: 0088 resident Secondary_Sales

10/20/2013 11:45:05 AM: 2 fields found: Date, NewDate, 1,449,599 lines fetched

10/20/2013 11:45:06 AM: 0108 LOAD * Inline [

10/20/2013 11:45:06 AM: 0109 Month/Year,SortNumber

10/20/2013 11:45:06 AM: 0110 January 2010,1

10/20/2013 11:45:06 AM: 0111 February 2010,2

10/20/2013 11:45:06 AM: 0112 March 2010,3

10/20/2013 11:45:06 AM: 0113 April 2010,4

10/20/2013 11:45:06 AM: 0114 May 2010,5

10/20/2013 11:45:06 AM: 0115 June 2010,6

10/20/2013 11:45:06 AM: 0116 July 2010,7

10/20/2013 11:45:06 AM: 0117 August 2010,8

10/20/2013 11:45:06 AM: 0118 September 2010,9

10/20/2013 11:45:06 AM: 0119 October 2010,10

10/20/2013 11:45:06 AM: 0120 November 2010,11

10/20/2013 11:45:06 AM: 0121 December 2010,12

10/20/2013 11:45:06 AM: 0122 January 2011,13

10/20/2013 11:45:06 AM: 0123 February 2011,14

10/20/2013 11:45:06 AM: 0124 March 2011,15

10/20/2013 11:45:06 AM: 0125 April 2011,16

10/20/2013 11:45:06 AM: 0126 May 2011,17

10/20/2013 11:45:06 AM: 0127 June 2011,18

10/20/2013 11:45:06 AM: 0128 July 2011,19

10/20/2013 11:45:06 AM: 0129 August 2011,20

10/20/2013 11:45:06 AM: 0130 September 2011,21

10/20/2013 11:45:06 AM: 0131 October 2011,22

10/20/2013 11:45:06 AM: 0132 November 2011,23

10/20/2013 11:45:06 AM: 0133 December 2011,24

10/20/2013 11:45:06 AM: 0134 January 2012,25

10/20/2013 11:45:06 AM: 0135 February 2012,26

10/20/2013 11:45:06 AM: 0136 March 2012,27

10/20/2013 11:45:06 AM: 0137 April 2012,28

10/20/2013 11:45:06 AM: 0138 May 2012,29

10/20/2013 11:45:06 AM: 0139 June 2012,30

10/20/2013 11:45:06 AM: 0140 July 2012,31

10/20/2013 11:45:06 AM: 0141 August 2012,32

10/20/2013 11:45:06 AM: 0142 September 2012,33

10/20/2013 11:45:06 AM: 0143 October 2012,34

10/20/2013 11:45:06 AM: 0144 November 2012,35

10/20/2013 11:45:06 AM: 0145 December 2012,36

10/20/2013 11:45:06 AM: 0146 January 2013,37

10/20/2013 11:45:06 AM: 0147 February 2013,38

10/20/2013 11:45:06 AM: 0148 March 2013,39

10/20/2013 11:45:06 AM: 0149 April 2013,40

10/20/2013 11:45:06 AM: 0150 May 2013,41

10/20/2013 11:45:06 AM: 0151 June 2013,42

10/20/2013 11:45:06 AM: 0152 July 2013,43

10/20/2013 11:45:06 AM: 0153 August 2013,44

10/20/2013 11:45:06 AM: 0154 September 2013,45

10/20/2013 11:45:06 AM: 0155 October 2013,46

10/20/2013 11:45:06 AM: 0156 November 2013,47

10/20/2013 11:45:06 AM: 0157 December 2013,48

10/20/2013 11:45:06 AM: 0158 ]

10/20/2013 11:45:06 AM: 2 fields found: Month/Year, SortNumber, 48 lines fetched

10/20/2013 11:45:07 AM: Execution finished.

dvasseur · ‎2013-10-20

OK, indeed reload is OK but it seems there is something wrong with distribution/conditions:

Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=C:\ProgramData\QlikTech\Documents\Secondary Sales.V2.qvw.

(2013-10-20 11:38:18) Error: at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

=> Do you have publisher ? Is this just a reload task or are you doing anything else ?

Report Inappropriate Content · ‎2013-10-20

No, i don't have publisher

it just a reload task (reload schedule hourly)