5 Replies Latest reply: Nov 23, 2010 6:04 AM by petrkoula RSS

    Publisher Errors

       

      Hello All,

       

      during the execution of jobs in Publisher we sometimes got the following errors. With manual reload on the server were no problems. Does anybody know, what goes wrong?

       

       

      Error 1

      8673832 2010-05-03 07:03:40 Normal Error Reload failed Exception=%Exception Exception: System.Runtime.InteropServices.COMException (0x800706BE): Der Remoteprozeduraufruf ist fehlgeschlagen. (Ausnahme von HRESULT: 0x800706BE) bei QlikView.Doc.DoReload(Int32 _Mode, Boolean _Partial, Boolean _Debug) bei QVBWrapper.Document.Reload(Int32 i_ParentLogID, Object i_Partial).

      8673833 2010-05-03 07:03:40 Normal Error System.Exception: Reload failed ---> System.Runtime.InteropServices.COMException (0x800706BE): Der Remoteprozeduraufruf ist fehlgeschlagen. (Ausnahme von HRESULT: 0x800706BE) bei QlikView.Doc.DoReload(Int32 _Mode, Boolean _Partial, Boolean _Debug) bei QVBWrapper.Document.Reload(Int32 i_ParentLogID, Object i_Partial) --- Ende der internen Ausnahmestapelüberwachung --- bei QVBWrapper.Document.Reload(Int32 i_ParentLogID, Object i_Partial) bei QVBWrapper.Document.StartThread2(Int32 i_ParentLogID, Object i_Object)

       

      Error 2

      8734438 2010-05-11 07:52:03 Normal Error The Source Document was NOT reloaded successfully. DocumentPath=E:\QlikView Dokumente\Produktionsauswertung_NEU.qvw. Errors: 5 ScriptError: , ScriptErrorList: General ODBC Error Table Not Found Table Not Found Table Not Found Table Not Found , ScriptErrorDetails=

       



      Environment

      Windows Server 2003 R2

      Standard Edition

      Service Pack 2
      4 GB RAM

       

       

       



       

      Release
      QVPublisherExecutionService.exe: 8.20.517.0

       

       

       






        • Publisher Errors
          petrkoula

          Hello,

          I have exactly the same problem.


          Enviroment:

          2003 R2 SP2 x64

          Release:

          8.20.5402.2

           

          Petr

          • Publisher Errors
            petrkoula

            The solution which worked for me:

            Use ODBC source created from QlikView directly. (System/User ODBC sources work when reloading manualy but not when reloading by job)

             

            P.

            • Publisher Errors
              s j

              pls upgrade window patches. before few days Micorosoft upgrades the patches of

              Windows Server 2003 R2. so pls check after upgradation.

              Regards;

              Sunil Jain

                • Publisher Errors

                  System.Runtime.InteropServices.COMException happens when same QVW file is opened in developer while reloading in Publisher. There can be only one writer to a file

                  -Alex

                • Publisher Errors
                  petrkoula

                  Hi,

                  thanks for ideas.

                  Please see the log entry from publisher web interface attached below.. This is the situation when QV file is connected to the system ODBC source (created by ODBC Data Source Administrator; odbcad32) and reload by job fails contrary to manual reload, which is fine.


                  LogIDTimeLogLevelLogTypeText
                  19568262010-11-22 13:12:13NormalInformation
                  Starting Job "Other reports reload" (Attempt 1 of 1)

                  19568272010-11-22 13:12:13NormalInformation
                  Job started (Attempt 1 of 1)
                  19568292010-11-22 13:12:13NormalInformation
                  Starting task "Other reports reload"

                  19568312010-11-22 13:12:13NormalInformation
                  Starting task "Other reports reload" (9cedb313-2377-4e9d-ae7a-b9fc18d1f677)

                  19568322010-11-22 13:12:13NormalInformation
                  Preparing "D:\KPI\ActiveClients.qvw" for reload.

                  19568332010-11-22 13:12:13NormalInformation
                  Checking write permissions on "D:\KPI\ActiveClients.qvw"
                  19568342010-11-22 13:12:13NormalInformation
                  Opening "D:\KPI\ActiveClients.qvw"

                  19568542010-11-22 13:12:15NormalInformation
                  Starting Operation: Reload

                  19568552010-11-22 13:12:15DebugInformation
                  Starting Read Document Log Thread.

                  19568572010-11-22 13:12:15DebugInformation
                  Starting QVB Monitor Thread.

                  19568582010-11-22 13:12:15DebugInformation
                  Waiting for pulse from QVB Monitor Thread.

                  19568602010-11-22 13:12:15DebugInformation
                  Starting Reload Thread.

                  19568612010-11-22 13:12:15NormalInformation
                  Waiting for the document log "D:\KPI\ActiveClients.qvw.log" to become available..

                  19568622010-11-22 13:12:15DebugInformation
                  StartThread exit.

                  19568642010-11-22 13:12:15NormalInformation
                  The Source Document is being reloaded. DocumentPath=D:\KPI\ActiveClients.qvw

                  19568652010-11-22 13:12:15NormalInformation
                  The Source Document reload complete. DocumentPath=D:\KPI\ActiveClients.qvw

                  19568662010-11-22 13:12:15NormalInformation
                  Memory Allocation Delta for this file=-24.63 Mb. Available Physical Memory Before Reload=2547.89 Mb. Available Physical Memory After Reload=2570.83 Mb. Total Physical Memory=2570.83 Mb.

                  19568672010-11-22 13:12:15NormalError
                  The Source Document was NOT reloaded successfully. DocumentPath=D:\KPI\ActiveClients.qvw. Errors: 4 ScriptError: , ScriptErrorList: General ODBC Error Table Not Found General ODBC Error General ODBC Error

                  19568732010-11-22 13:12:35NormalInformation
                  Document log "D:\KPI\ActiveClients.qvw.log" was not found / not updated. Skipped.

                  19568752010-11-22 13:12:36NormalInformation
                  ReloadASync completed

                  19568772010-11-22 13:12:36NormalInformation
                  Checkin

                  19568782010-11-22 13:12:36NormalInformation
                  Closing QlikView Engine

                  19568802010-11-22 13:12:36NormalInformation
                  Closing the Source Document. DocumentPath=D:\KPI\ActiveClients.qvw

                  19568812010-11-22 13:12:36NormalInformation
                  The Source Document was closed successfully DocumentPath=D:\KPI\ActiveClients.qvw

                  19568822010-11-22 13:12:36NormalInformation
                  Closing the QlikView Engine. ProcessID=3188

                  19568832010-11-22 13:12:36NormalInformation
                  Closed the QlikView Engine successfully. ProcessID=3188

                  19568842010-11-22 13:12:36NormalError
                  The task Other reports reload failed with an error (Exception)

                  19568372010-11-22 13:12:13NormalInformation
                  Waiting for "Other reports reload" to complete.

                  19568862010-11-22 13:12:37NormalInformation
                  1 task(s) failed - Sending alertmail...

                  19568872010-11-22 13:12:37NormalInformation
                  Sending AlertMail to:

                  19568882010-11-22 13:12:38NormalError
                  Job finished with errors.

                  19568892010-11-22 13:12:38NormalInformation
                  Job "Other reports reload" has exited. NextExec=11/23/2010 6:00:00 AM

                   

                  Petr