6 Replies Latest reply: Nov 18, 2015 2:59 AM by Stefan Heinz RSS

    Failed to open document - NTFS Permissions Removed Question

    Austin James

      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