13 Replies Latest reply: Aug 25, 2016 12:38 PM by Jeremy Kofoot RSS

    publish task has intermittent failures

    Ken Geren

      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?

        • Re: publish task has intermittent failures
          Jeremy Kofoot

          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.

            • Re: publish task has intermittent failures
              Ken Geren

              How do I start document logging?


                • Re: publish task has intermittent failures
                  Denis Tronel

                  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

                  • Re: publish task has intermittent failures
                    Jeremy Kofoot

                    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.

                      • Re: publish task has intermittent failures
                        Ken Geren

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

                        log.png

                          • Re: publish task has intermittent failures
                            Jeremy Kofoot

                            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.

                              • Re: publish task has intermittent failures
                                Ken Geren

                                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.

                                  • Re: publish task has intermittent failures
                                    Ken Geren

                                    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.

                                     

                                     

                                     

                                     

                                     

                                    • Re: publish task has intermittent failures
                                      Jeremy Kofoot

                                      Can you include the Document log for the app?

                          • Re: publish task has intermittent failures
                            Denis Tronel

                            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

                            • Re: publish task has intermittent failures
                              Jeremy Kofoot

                              So you say this is an intermintent failure, so the next time the reload fails, check the document log and see what it tells you.  The document log won't have in there the published details, that would be in the task log.  What the document log will give you though is some more information on when the task fails.