Qlik Community

QlikView Publisher

Discussion Board for collaboration on QlikView Publisher.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

ken_geren
Not applicable

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
Not applicable

Re: publish task has intermittent failures

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
Not applicable

Re: publish task has intermittent failures

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
Not applicable

Re: publish task has intermittent failures

How do I start document logging?


dtronel
Not applicable

Re: publish task has intermittent failures

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
Not applicable

Re: publish task has intermittent failures

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
Not applicable

Re: publish task has intermittent failures

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

log.png

jeremy_kofoot
Not applicable

Re: publish task has intermittent failures

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
Not applicable

Re: publish task has intermittent failures

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
Not applicable

Re: publish task has intermittent failures

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.