Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

austin_james
New Contributor

Failed to open document - NTFS Permissions Removed Question

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!

AttPermissions.JPG

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.

Folder Permissions:

FolderPermissions.JPG

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.


Austin

6 Replies
prabhu0505
Valued Contributor

Re: Failed to open document - NTFS Permissions Removed Question

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?

Re: Failed to open document - NTFS Permissions Removed Question

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.

austin_james
New Contributor

Re: Failed to open document - NTFS Permissions Removed Question

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.

austin_james
New Contributor

Re: Failed to open document - NTFS Permissions Removed Question

The shares are setup correctly on Windows Servers.

austin_james
New Contributor

Re: Failed to open document - NTFS Permissions Removed Question

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.

steeefan
New Contributor II

Re: Failed to open document - NTFS Permissions Removed Question

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.

Community Browser