topic Re: document open call failed in QlikView

document open call failed

Anonymous — Thu, 23 Apr 2015 08:27:24 GMT

Hi All,

My schedulers from QMC are failing with following error in Log files:

4/23/2015 03:12:24.9250874	Error	Document open call failed. The document might require username and password.
4/23/2015 03:12:24.9250874	Information	Attempted to load the document without data.
4/23/2015 03:12:24.9250874	Error	The document failed to open.

Please help

Re: document open call failed

Thu, 23 Apr 2015 08:30:17 GMT

You have implemented section access in your QVW file?

Re: document open call failed

Anonymous — Thu, 23 Apr 2015 08:32:18 GMT

No , There is no section access.

Re: document open call failed

amit_saini — Thu, 23 Apr 2015 08:40:20 GMT

Hi,

Looks to me your qvw id protected from QMC (Section Access) . Please check.

Thanks,
AS

Re: document open call failed

Anonymous — Thu, 23 Apr 2015 11:00:14 GMT

No , Its not the case Amit.

Re: document open call failed

Thu, 23 Apr 2015 11:07:38 GMT

send me the error screen shot

Re: document open call failed

Anonymous — Thu, 23 Apr 2015 11:09:38 GMT

4/23/2015 03:11:36.5941635	Information	Starting task 'Stage2/Stage 2 NavItem.qvw'. Id:7159a055-f4b8-4563-830e-b93710648eb5. Triggered by 'TaskCompletedTrigger'. Id:31c7080f-6551-46fa-a00c-cb7f3991e34d
4/23/2015 03:11:36.5941635	Information	Entering Task Execution.
4/23/2015 03:11:36.5941635	Information	ClusterID=1
4/23/2015 03:11:36.5941635	Information	QDSID=21629243-55df-f9e5-8a71-87d7477710bc
4/23/2015 03:11:36.5941635	Information	TaskID=7159a055-f4b8-4563-830e-b93710648eb5
4/23/2015 03:11:36.5941635	Information	MaxRunTime=06:00:00
4/23/2015 03:11:36.5941635	Information	MachineName=MMTQVWEB
4/23/2015 03:11:36.5941635	Information	Max attempts:1
4/23/2015 03:11:36.5941635	Information	Current Attempt=0
4/23/2015 03:11:36.5941635	Information	Task Dependencies are OK
4/23/2015 03:11:36.7033649	Information	Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.
4/23/2015 03:11:36.7033649	Information	Opening "F:\QVDMAKERS\STAGE2\QVDMAKER\Stage 2 NavItem.qvw"
4/23/2015 03:11:43.9387580	Information	Allocating new QlikView Engine. Current usage count=7 of 25 (of type non-reader).
4/23/2015 03:11:43.9387580	Information	Max retries:5
4/23/2015 03:11:43.9387580	Information	Attempt:01
4/23/2015 03:12:17.7813950	Error	Failed to create QlikView Engine.. Exception=System.Runtime.InteropServices.COMException (0x80080005): Retrieving the COM class factory for component with CLSID {BE1F19B5-415E-11D1-934D-0040333C91CC} failed due to the following error: 80080005 Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE)). \|\| at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck) \|\| at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark) \|\| at System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark) \|\| at System.Activator.CreateInstance(Type type, Boolean nonPublic) \|\| at System.Activator.CreateInstance(Type type) \|\| at QVBWrapper.Document.<CreateQVBProcess>b__30(Boolean mutexCreated) \|\| at SolutionGlobal.GlobalMutex.Lock(Action`1 action, TimeSpan timeout) \|\| at QVBWrapper.Document.CreateQVBProcess(ILogBucket logBucket, Boolean createEmptyDoc)
4/23/2015 03:12:17.7813950	Information	Failed to create QlikView Engine - Cleanup and retry (3 second pause before trying again)
4/23/2015 03:12:20.7835341	Information	Attempt:11
4/23/2015 03:12:22.8608608	Information	Opened the QlikView Engine successfully. ProcessID=29620
4/23/2015 03:12:22.8764610	Information	Allocated QlikView Engine successfully. Current usage count=8 of 25 (of type non-reader). Ticket number=16544.
4/23/2015 03:12:22.8764610	Information	Loading document "F:\QVDMAKERS\STAGE2\QVDMAKER\Stage 2 NavItem.qvw" (0.22 Mb)
4/23/2015 03:12:23.8904740	Information	Loading. LoadTime=00:00:01.0140130
4/23/2015 03:12:24.9250874	Error	Document open call failed. The document might require username and password.
4/23/2015 03:12:24.9250874	Information	Attempted to load the document without data.
4/23/2015 03:12:24.9250874	Error	The document failed to open.
4/23/2015 03:12:25.5490954	Information	Closed the QlikView Engine successfully. ProcessID=29620
4/23/2015 03:12:25.5490954	Error	Document could not be opened
4/23/2015 03:12:25.5490954	Information	Closed the QlikView Engine successfully. ProcessID=29620
4/23/2015 03:12:25.5490954	Information	Failed to check in document: F:\QVDMAKERS\STAGE2\QVDMAKER\Stage 2 NavItem.qvw
4/23/2015 03:12:25.9703008	Error	The task "Stage2/Stage 2 NavItem.qvw" failed. Exception: \|\| QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.FailedDocumentCheckoutException: Failed to check out document with path: F:\QVDMAKERS\STAGE2\QVDMAKER\Stage 2 NavItem.qvw \|\| at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) \|\| --- End of inner exception stack trace --- \|\| at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) \|\| at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) \|\| --- End of inner exception stack trace --- \|\| at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult) \|\| at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)
4/23/2015 03:12:25.9703008	Information	Task Execute Duration=00:00:49.3761373
4/23/2015 03:12:25.9703008	Information	Sending Alert mail
4/23/2015 03:12:31.5389726	Information	TaskResult.status=Finished
4/23/2015 03:12:31.5545728	Information	Notifying all triggers of new state:FinishedWithErrors
4/23/2015 03:12:31.5701730	Information	Notifying all triggers of new state:FinishedWithErrors - completed
4/23/2015 03:12:31.5701730	Information	Saving Task Result

Re: document open call failed

awhitfield — Thu, 23 Apr 2015 11:19:20 GMT

HI Erika,

does the qvw load OK from QV Desktop?

Can you post the QVW?

Andy

Re: document open call failed

buzzy996 — Thu, 23 Apr 2015 11:22:58 GMT

are u tried to reload manually from QEMC?

Re: document open call failed

Anonymous — Thu, 23 Apr 2015 11:29:30 GMT

From QV Desktop its working fine....

Reload failure is not happening always when I Run through QMC, But sometimes...

Not getting the reason that why its is failing sometimes?

Re: document open call failed

buzzy996 — Thu, 23 Apr 2015 11:34:08 GMT

ya..understood..even I saw this issue recently on my qv environment!

i believe it's causing do to the some network/memory related issue.

tht's way i asked on my previous post whether ur able to run through QEMC manually or not, it's not application issue i believes..even if u scheduled this application it' will run next time on words with out failing reload.

Re: document open call failed

awhitfield — Thu, 23 Apr 2015 11:39:50 GMT

Hi Erika,

there are several post such as this, where the Document open call failed. The document might require username and password. error appears to be a Red Herring! After all the Error DOES say 'might'

I would check out the following article https://qlikcommunity.qliktech.com/thread/61646 , in particular the section added by Daniel Baksa

Regards

Andy

Re: document open call failed

bhavikumehta — Fri, 18 Aug 2017 10:50:08 GMT

Hello Venkat - I am facing same error message on Reloading the dashboard through QMC, however, manual reload runs fine. Dashboard has section access implemented.

Please suggest a solution. Thank you.

Re: document open call failed

Peter_Cammaert — Fri, 18 Aug 2017 11:26:48 GMT

Is the service account that is running the Qlikview services listed (as ADMIN) in your section access table? If not, then please add this aacount to SA and manually reload the document before publishing on your server..