Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

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.

Not applicable

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






5 Replies
Not applicable

Publisher Errors

Hello,

I have exactly the same problem.


Enviroment:

2003 R2 SP2 x64

Release:

8.20.5402.2

Petr

Not applicable

Publisher Errors

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.

suniljain
Not applicable

Publisher Errors

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

Windows Server 2003 R2. so pls check after upgradation.

Regards;

Sunil Jain

Not applicable

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

Not applicable

Publisher Errors

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