qlikview document could not be opened

[ali_hijazi]

Hello we've got a qlikview document with script to read from QVD files

the document doesn't have SECTION ACCESS at all but we are getting the below error as per the log file:

(2019-11-14 11:27:08) Information: Starting task '1-Prod CES - Case Management Mart - PEGA @ 10774 (Case_Management_Mart_Pega)'. Id:1376d7c9-6f66-4a57-82f8-a75848078936. Triggered by 'TaskCompletedTrigger'. Id:25c0f3e6-0efc-4458-a7ea-642f7751aa1d

(2019-11-14 11:27:08) Information: Entering Task Execution.

(2019-11-14 11:27:08) Information: ClusterID=1

(2019-11-14 11:27:08) Information: QDSID=e415609b-fd99-e261-9f5b-850ac17792b2

(2019-11-14 11:27:08) Information: TaskID=1376d7c9-6f66-4a57-82f8-a75848078936

(2019-11-14 11:27:08) Information: MaxRunTime=1.00:00:00

(2019-11-14 11:27:08) Information: MachineName=QLIKMMPRD

(2019-11-14 11:27:08) Information: Max attempts:1

(2019-11-14 11:27:08) Information: Current Attempt=0

(2019-11-14 11:27:08) Information: Task Dependencies are OK

(2019-11-14 11:27:08) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(2019-11-14 11:27:08) Information: Opening "\\qlikprd\Source Documents\1-PROD\Customer Case Analysis Dashboard\QVWT\Case_Management_Mart_PEGA.qvw"

(2019-11-14 11:27:08) Information: Allocating new QlikView Engine. Current usage count=0 of 4 (of type non-reader).

(2019-11-14 11:27:08) Information: Max retries:5

(2019-11-14 11:27:08) Information: Attempt:01

(2019-11-14 11:27:09) Information: Opened the QlikView Engine successfully. ProcessID=7912

(2019-11-14 11:27:09) Information: Allocated QlikView Engine successfully. Current usage count=1 of 4 (of type non-reader). Ticket number=1276.

(2019-11-14 11:27:09) Information: Loading document "\\qlikprd\Source Documents\1-PROD\Customer Case Analysis Dashboard\QVWT\Case_Management_Mart_PEGA.qvw" (487.50 Mb)

(2019-11-14 11:27:10) Information: Loading. LoadTime=00:00:01.0073117

(2019-11-14 11:27:11) Error: Document open call failed. The document might require username and password.

(2019-11-14 11:27:11) Information: Attempted to load the document without data.

(2019-11-14 11:27:11) Error: The document failed to open.

(2019-11-14 11:27:12) Information: Closed the QlikView Engine successfully. ProcessID=7912

(2019-11-14 11:27:12) Error: Document could not be opened

(2019-11-14 11:27:12) Information: Closed the QlikView Engine successfully. ProcessID=7912

(2019-11-14 11:27:12) Information: Failed to check in document: \\qlikprd\Source Documents\1-PROD\Customer Case Analysis Dashboard\QVWT\Case_Management_Mart_PEGA.qvw

(2019-11-14 11:27:12) Error: The task "1-Prod CES - Case Management Mart - PEGA @ 10774 (Case_Management_Mart_Pega)" 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: \\qlikprd\Source Documents\1-PROD\Customer Case Analysis Dashboard\QVWT\Case_Management_Mart_PEGA.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)

(2019-11-14 11:27:12) Information: Task Execute Duration=00:00:03.6997027

(2019-11-14 11:27:12) Information: TaskResult.status=Finished

(2019-11-14 11:27:12) Information: Notifying all triggers of new state:FinishedWithErrors

(2019-11-14 11:27:12) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2019-11-14 11:27:12) Information: Saving Task Result

we've got another server machine that has QlikView server installed and the task runs successfully but on the current machine that we are working on it is giving the above error

Kindly advise on what to do to fix this issue

[Josh_Berg_Support]

That error is a bit of a tricky one as it can be caused by a few issues.  I took a look through our Knowledgebase and found the following article regarding this error:

https://support.qlik.com/articles/000003243

If you re-run the task at another time, will it complete without error or does it fail with the same error in the task log?  You said you have another Qlikview Server that's able to run this task successfully, is the QVS that's failing to run the task a new install or has this ever worked properly on this server?  Has anything recently changed in your Qlikview environment that could be related to this error?

Thanks,
Josh
Qlik Support

[ali_hijazi]

Hello we increased the memory on the new server but still getting the same error 

is there something we should check?
kindly advise

[Brett_Bleess]

Ali, do you guys have the Desktop Client installed on the server as well?  If so, can you login as the service account and open/license the Desktop (you can do a license lease if you can assign the service account a Named CAL from the QVS), and see if things open properly that way?  The only other thing of which I can think is Anti-Virus or some other active scanning utility you have running on the server is screwing up our ability to open the file with the exclusive lock such that we can save the file post reload...  Shout back when you can with info but hopefully this may help you move things forward a bit more. 

Regards,
Brett

[ali_hijazi]

Hello, yes I can open the document with QlikView desktop and I can reload the document successfully
only the task fails to open the document
knowing that the distribution service is run by a domain administrator
I will ask admins to disable anti-virus and will get back to you
thank you for your prompt reply

[Brett_Bleess]

Ali, yeah, see if the AV team and do exceptions on our folders, that should ensure you do not have any issues related to active scanning.  If they want some proof, hopefully their logs will show them grabbing things while we are trying to open etc.  If not, only thing I can suggest would be running Sys Internals Process Monitor utility on the folder to see what other process may be getting hold of the file we are trying to open.  Hopefully that may catch things for you.  Keep us posted, but that is the best hunch I have at the moment and by the way, you do not need a domain admin running things, a domain user set up a s local admin on the server should be fine! 🙂  I cannot imagine you have a security issue in this case!

Cheers,
Brett

[ali_hijazi]

Hello 
one thing to add; the tasks run successfully if the qvw file doesn't have data and the reload simply saves data as qvd and deletes tables
so the tasks only fail when the qvw file has data i.e. a complete dashboard

[Brett_Bleess]

Ok, I suspect your data model may be the issue in that case, any chance you can do a limited load of a few records so we can have a look at what the data model ends up looking like?  I would suspect you have a Cartesian of some sort in the data model etc. that is likely causing things to balloon in size when the app is opened with data.  The only easy workaround is to drop your tables at the end of the script in the meantime.  Thanks for the extra info that was very helpful, hopefully this makes sense as well.

Regards,
Brett 

[Arthur_Fong]

Is this qvw binaried from another qvw?

To check this, go to the first line in the script and look for any binary load in it.

If there is, check the qvw of the binary source and see if there is section access in it.

[ali_hijazi]

yes it binary loads from another document and that other document doesn't have section access