Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a scheduled task in QlikView Management Console to reload data and publish. The publish task has intermittent failures,
"QDSMain.Exceptions.DistributeToResourcesFailedException: Distribute to resource failed. ---> QDSMain.Exceptions.DscOffLineException: Failed to AddNamedUsers ||"
sometimes it completes successfully, other times it gets this distribution error. It was running fine for several months and now it's randomly failing. I just manually rerun the task in the QlikView Management Console and it then runs fine. How do I trace down this distribution failure?
Do you have document logging turned on. If you do check in that log to see if there is an error message. What I have typically found is that the Task log error messages aren't very descriptive and you need to look at the document log to get the real answer.
Hi
Do you have some 'intrusive' antivirus on your server ?
I sometimes needed to temporarily unactive it, especially when reading big QVD tables because it was locking the files and so the task execution.....
Rgds
How do I start document logging?
Hello
You must activate the checkbox red-circled in attached printscreen , for each document you want to trace.
If you need different log files after each run, you must also activate the check-box below blue-circled.
Open the app in QlikView Desktop. While open select Settings -> Document Properties and chech the box for Generate Logfile. Save and then rerun your task. The log file is created in the same folder that the app is in.
It looks like that logging is for reloading the app, but shows nothing for when the app is published.
Ken, you are in the QMC. To check document logging you need to open the application in QlikView Desktop and follow the steps I laid out or follow the screenshot that Denis had in his reply.
Yes, I that's what I did, but the log only shows the application being refreshed, It has no information on the app being published.
Log has nothing about publishing
8/25/2016 8:59:31 AM: Execution started.
8/25/2016 8:59:31 AM: QlikView Version:11.20.12742.0
8/25/2016 8:59:31 AM: CPU Target x64
8/25/2016 8:59:31 AM: Operating System Windows Server 2012 R2 Standard (64 bit edition)
8/25/2016 8:59:31 AM: Wow64 mode Not using Wow64
8/25/2016 8:59:31 AM: MDAC Version 6.3.9600.16384
8/25/2016 8:59:31 AM: MDAC Full Install Version 6.3.9600.16384
8/25/2016 8:59:31 AM: PreferredCompression 2
8/25/2016 8:59:31 AM: EnableParallelReload 1
8/25/2016 8:59:31 AM: ParallelizeQvdLoads 1
8/25/2016 8:59:31 AM: AutoSaveAfterReload 0
8/25/2016 8:59:31 AM: BackupBeforeReload 0
8/25/2016 8:59:31 AM: EnableFlushLog 0
8/25/2016 8:59:31 AM: SaveInfoWhenSavingFile 0
8/25/2016 8:59:31 AM: UserLogfileCharset 1200
8/25/2016 8:59:31 AM: OdbcLoginTimeout -1
8/25/2016 8:59:31 AM: OdbcConnectionTimeout -1
8/25/2016 8:59:31 AM: ScriptWantsDbWrite false
8/25/2016 8:59:31 AM: ScriptWantsExe false
8/25/2016 8:59:31 AM: LogFile CodePage Used: 1200
8/25/2016 8:59:31 AM: Reload Executed By ANOKA\QVAdmin
8/25/2016 8:59:31 AM: Process Executing: QVB
8/25/2016 8:59:31 AM: Process ID: 185152
8/25/2016 8:59:31 AM: 0002 Binary [..\..\..\data models\omar_TEST_data_model.qvw]
8/25/2016 8:59:34 AM: 0005 SET ThousandSep=','
8/25/2016 8:59:34 AM: 0006 SET DecimalSep='.'
8/25/2016 8:59:34 AM: 0007 SET MoneyThousandSep=','
8/25/2016 8:59:34 AM: 0008 SET MoneyDecimalSep='.'
8/25/2016 8:59:34 AM: 0009 SET MoneyFormat='$#,##0.00;($#,##0.00)'
8/25/2016 8:59:34 AM: 0010 SET TimeFormat='h:mm:ss TT'
8/25/2016 8:59:34 AM: 0011 SET DateFormat='M/D/YYYY'
8/25/2016 8:59:34 AM: 0012 SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'
8/25/2016 8:59:34 AM: 0013 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'
8/25/2016 8:59:34 AM: 0014 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'
8/25/2016 8:59:34 AM: 0016 set HidePrefix= '%'
8/25/2016 8:59:34 AM: 0018 Detail:
8/25/2016 8:59:34 AM: 0019 Load * inline [
8/25/2016 8:59:34 AM: 0020 %ViewLevel, %ViewID
8/25/2016 8:59:34 AM: 0021 Standard, 1
8/25/2016 8:59:34 AM: 0022 Detail, 2
8/25/2016 8:59:34 AM: 0023 ]
8/25/2016 8:59:34 AM: 2 fields found: %ViewLevel, %ViewID, 2 lines fetched
8/25/2016 8:59:34 AM: 0025 Exit Script
8/25/2016 8:59:35 AM: Execution finished.