Failed to open document

[simran_mann]

Hi, 

Error: Document open call failed. The document might require username and password.

(6/10/2019 11:28:49 AM) Information: Attempted to load the document without data.

(6/10/2019 11:28:49 AM) Error: The document failed to open.

(6/10/2019 11:28:49 AM) Information: Closed the QlikView Engine successfully. ProcessID=9360

(6/10/2019 11:28:49 AM) Error: Document could not be opened

(6/10/2019 11:28:49 AM) Information: Closed the QlikView Engine successfully. ProcessID=9360

(6/10/2019 11:28:49 AM) Information: Failed to check in document: E:\QLIKVIEW\Final\Application\Application.qvw

(6/10/2019 11:28:49 AM) Error: The task "Qlikview/Final/Application/Application.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: E:\QLIKVIEW\Final\Application\Application.qvw || at QDSMain.AbstractReloadTask.Reload(String fileName, IExecutingTaskResult executingTaskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) || --- End of inner exception stack trace --- || at QDSMain.AbstractReloadTask.Reload(String fileName, IExecutingTaskResult executingTaskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) || at QDSMain.DistributeTask.PerformExecute(IExecutingTaskResult executingTaskResult) || --- End of inner exception stack trace --- || at QDSMain.DistributeTask.PerformExecute(IExecutingTaskResult executingTaskResult) || at QDSMain.Task.AbstractTask.TaskExecution(CurrentExecutionArgs args)

Facing this error in a task set on QMC. 

Please advice. 

Thank you

[Gysbert_Wassenaar]

---

Error: Document open call failed. The document might require username and password.

---

And? Does it? Did you add section access to the document?

[Brett_Bleess]

If this is occurring on the 'distribution' piece of the task only, you can change the following setting in the QDS exe.config:

• OpenDocumentAttempts - This setting determines the number of attempts by the QlikView Batch (QVB) process to open the QlikView file before it is logged as an error during the distribution cycle of a task.  In environments where there may be some file system latency, and the Disribution Service Root_date logs show entries regarding 'could not open file', increasing the default value to a few retries may alleviate the task failures.  Default value is "1".

Actual setting in QDS file:

<!-- The number of attempts the document is tried to be opened before it's logged as error during distribution -->
<add key="OpenDocumentAttempts" value="1"></add>

Try bumping that up to see if that alleviates the ultimate failure, it may just be that the file system is not ready for it to be accessed again so quickly after the reload completes etc...

If the issue is occurring in the reload section though, this will NOT help, need to find out if the file is in use by another process, Process Monitor from Sys Internals tools is the best way to do that...  If you have not had Anti-Virus excluded from your QDS Source Documents etc., that could be another thing potentially causing the issue as well.

Regards,
Brett