Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ken_geren
Contributor III
Contributor III

publish task has intermittent failures

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?

13 Replies
jeremy_kofoot
Contributor III
Contributor III

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.

dtronel
Contributor III
Contributor III

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

ken_geren
Contributor III
Contributor III
Author

How do I start document logging?


dtronel
Contributor III
Contributor III

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.screen_20160824_172715.png

jeremy_kofoot
Contributor III
Contributor III

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.

ken_geren
Contributor III
Contributor III
Author

It looks like that logging is for reloading the app, but shows nothing for when the app is published.

log.png

jeremy_kofoot
Contributor III
Contributor III

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.

ken_geren
Contributor III
Contributor III
Author

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.

ken_geren
Contributor III
Contributor III
Author

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.