4 Replies Latest reply: Jul 25, 2012 8:21 AM by Freddy Johnsen RSS

    Server reload problem with section access

      Hi,

       

      Hope someone can help me with this problem.

       

      I recently implmeneted section access for a document and now I get the following error message when trying to run scheduled reload:

       

       

       

      The task "MO Sales Application.qvw" failed. Part
      of the log file follows:

       

       

       

      25.07.2012 13:16:48 Error Document open call failed. The document might require
      username and password.

       

      25.07.2012 13:16:48 Error The document failed to open.

       

      25.07.2012 13:16:48 Error Document could not be opened

       

      25.07.2012 13:16:48 Error The task "MO Sales Application.qvw" failed.
      Exception: QDSMain.Exceptions.DistributionFailedException: Distribute failed
      with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload
      failed ---> QDSMain.Exceptions.FailedDocumentCheckoutException: Failed to
      check out document with path: D:\QlikView\Active\MO Sales Application.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)

       

      I have seen from other post that I might have to include service name in the section access logic in the document but I am not sure how this should be done.

       

      Here is the section access statement:

       

      Section Access;


      LOAD * INLINE [

       

          ACCESS, NTNAME, SALESOFFICE

       

          ADMIN, XXXX\MKFJ,NMS01

       

          ADMIN, XXXX\MKFJ,UMS01,

       

      ];

       

      Section Application;

       

      There are 4 services running:

      DSC@Server

      QMS@Server

      QVS@Server

      QVWS@Server

       

      What service should be included in section access statement and what would that look like?

       

      Thanks.