Discussion Board for collaboration related to QlikView Deployment.
I am a newer Qlik customer and am reaching out to seek guidance. We are running server version 11.20.12852.0
I have a set of QVWs that build QVD files. Conceptually, we have three layers of QVWs and QVDs that construct our complete data model before user interface elements are introduced. We are using the QV Publisher to automate these data loads. Last night, all of my layer 2 tasks failed. For the previous 14 days, these tasks have completed successfully.
When I attempt to open one of the QVW files that failed, as the service account, I get the error message: "Failed to open document." I am using the client to open the QVW. When I manually run the task from the QMC, the task fails. When I look at the NTFS permissions for the QVW, I see that all permissions have been removed!
Since we load this QVW across a SMB share, I looked at the share permissions. The service account has full control to share. The service account has full file permissions to the folder and, through inheritance, the file.
All of the Layer 1 tasks opened a QVW, saved a QVD, and completed successfully across the same share.
When I look at the log file for one of the Layer 2 tasks, I find that the QVW is opened, data are loaded, and when the QVW is written back to the folder, there is an error. Somewhere in the process, NTFS file permissions are destroyed and no user has access to the QVW file. When I look at the QVD files, I have found that they were updated by the task (update timestamps are from this morning). It is only when the QVW is written back to disk does the error occur.
Here is the log file for the QVW.
8/7/2015 05:00:34.4424434 Information Starting task 'Layer 2\Attendance.qvw'. Id:14115670-db7b-41ea-91ae-3d0fe1eab5d9. Triggered by 'AndTrigger'. Id:3c69ea39-fdc0-460b-ac21-cc27766a2496
8/7/2015 05:00:34.4424434 Information Entering Task Execution.
8/7/2015 05:00:34.4424434 Information ClusterID=1
8/7/2015 05:00:34.4424434 Information QDSID=f0893642-d647-b123-dcbf-6e722fedb1b3
8/7/2015 05:00:34.4424434 Information TaskID=14115670-db7b-41ea-91ae-3d0fe1eab5d9
8/7/2015 05:00:34.4424434 Information MaxRunTime=1.00:00:00
8/7/2015 05:00:34.4424434 Information MachineName=QLIK-PUB
8/7/2015 05:00:34.4424434 Information Max attempts:1
8/7/2015 05:00:34.4424434 Information Current Attempt=0
8/7/2015 05:00:34.4424434 Information Task Dependencies are OK
8/7/2015 05:00:34.4580581 Information Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.
8/7/2015 05:00:34.4580581 Information Opening "\\QLIK-ENT01\qlikview\Qlik Documents\Enterprise Data QVD Builders\DataWarehouse\Layer 2\Attendance.qvw"
8/7/2015 05:00:38.4581178 Information Failed to allocate new QlikView Engine. Retrying! Max usage reached. Current usage count=4 of 4 (of type non-reader).
8/7/2015 05:00:39.4737573 Information Allocating new QlikView Engine. Current usage count=2 of 4 (of type non-reader).
8/7/2015 05:00:39.4737573 Information Max retries:5
8/7/2015 05:00:39.4737573 Information Attempt:01
8/7/2015 05:00:40.5050247 Information Opened the QlikView Engine successfully. ProcessID=5060
8/7/2015 05:00:40.5050247 Information Allocated QlikView Engine successfully. Current usage count=3 of 4 (of type non-reader). Ticket number=122.
8/7/2015 05:00:40.5050247 Information Loading document "\\QLIK-ENT01\qlikview\Qlik Documents\Enterprise Data QVD Builders\DataWarehouse\Layer 2\Attendance.qvw" (0.15 Mb)
8/7/2015 05:00:40.5675246 Information Physical FileSize=0.15 Mb. Memory Allocation Delta for this file=2.66 Mb. Available Physical Memory Before Open=62866.25 Mb. Available Physical Memory After Open=62861.31 Mb. Total Physical Memory=65535.55 Mb.
8/7/2015 05:00:40.5675246 Information Attempted to load the document without data.
8/7/2015 05:00:40.5675246 Information The document was loaded successfully.
8/7/2015 05:00:40.5675246 Information Document was opened successfully
8/7/2015 05:00:41.9269419 Information Starting reload
8/7/2015 05:00:41.9582351 Information QlikView->Settings->Document Peferences->Generate Logfile in document is not set.
8/7/2015 05:00:41.9582351 Information The Source Document is being reloaded. DocumentPath=\\QLIK-ENT01\qlikview\Qlik Documents\Enterprise Data QVD Builders\DataWarehouse\Layer 2\Attendance.qvw
8/7/2015 05:00:42.9425626 Information Reloading.
8/7/2015 05:00:43.4894464 Information The Source Document reload complete. DocumentPath=\\QLIK-ENT01\qlikview\Qlik Documents\Enterprise Data QVD Builders\DataWarehouse\Layer 2\Attendance.qvw
8/7/2015 05:00:43.4894464 Information Memory Allocation Delta for this file=19.74 Mb. Available Physical Memory Before Reload=62922.64 Mb. Available Physical Memory After Reload=62901.61 Mb. Total Physical Memory=62901.61 Mb.
8/7/2015 05:00:43.5519543 Information The Source Document was reloaded successfully.
8/7/2015 05:00:43.5519543 Information Reload finished successfully
8/7/2015 05:00:43.5519543 Information Start saving document
8/7/2015 05:00:44.5988323 Error The sourcedocument failed to save.. Exception=System.UnauthorizedAccessException: Access to the path '\\QLIK-ENT01\qlikview\Qlik Documents\Enterprise Data QVD Builders\DataWarehouse\Layer 2\Attendance.qvw' is denied. || at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) || at System.IO.File.InternalCopy(String sourceFileName, String destFileName, Boolean overwrite, Boolean checkHost) || at QVBWrapper.Document.ReplaceSourceFile(ILogBucket logBucket, String replaceFromFileName, String replaceToFilename) || at QVBWrapper.Document.Save(ILogBucket i_LogBucket, String i_SaveAsFileName)
8/7/2015 05:00:44.6300830 Information Closing the document.
8/7/2015 05:00:45.2707247 Information Closed the QlikView Engine successfully. ProcessID=5060
8/7/2015 05:00:45.3175962 Error The task "Layer 2\Attendance.qvw" failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The sourcedocument failed to save.. Exception=System.UnauthorizedAccessException: Access to the path '\\QLIK-ENT01\qlikview\Qlik Documents\Enterprise Data QVD Builders\DataWarehouse\Layer 2\Attendance.qvw' is denied. || at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) || at System.IO.File.InternalCopy(String sourceFileName, String destFileName, Boolean overwrite, Boolean checkHost) || at QVBWrapper.Document.ReplaceSourceFile(ILogBucket logBucket, String replaceFromFileName, String replaceToFilename) || at QVBWrapper.Document.Save(ILogBucket i_LogBucket, String i_SaveAsFileName) || 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)
8/7/2015 05:00:45.3175962 Information Task Execute Duration=00:00:10.8751528
8/7/2015 05:00:45.3175962 Information TaskResult.status=Finished
8/7/2015 05:00:45.3175962 Information Notifying all triggers of new state:FinishedWithErrors
8/7/2015 05:00:45.3332226 Information Notifying all triggers of new state:FinishedWithErrors - completed
8/7/2015 05:00:45.3332226 Information Saving Task Result
Is this a bug that I should contact Qlik Support about or is there a solution out there somewhere that I haven't yet been able to find?
Many thanks for you help.
If you have antivirus software installed in the server then make sure QV folders are exceptions for scanning.
Does QV Service account has domain admin privilege?
Where is this share located? Make sure that the share is hosted on a Windows server machine or a Windows-compatible SAN. QlikView Server/Distribution Service doesn't support any other kind of remote file storage.
I'll look into the Antivirus software.
No, the QV service is not a domain admin (Why should the QV service have admin access to AD, DHCP, and all other services in the domain?). It is an admin on the servers in question, and in the environments it should affect. It has full permissions to the shares and files.
It was implied in the original post that the process was working for some time, but failed on the one date. I apologize if that should have been explicitly stated.
Since this original post, we manually re-setup permissions on the files, and the process has worked since. I've not marked this question as answered as we still do not have a cause for this behavior.
I had the same problem:
11/18/2015 6:00:03 AM Error The document failed to open.
11/18/2015 6:00:04 AM Error Document could not be opened
I also checked NTFS permissions etc. but to no avail. In the end a reboot of my Windows Server 2012 R2 did the trick.