15 Replies Latest reply: Jun 11, 2014 8:17 AM by Ashfaq Mohammed Branched to a new discussion. RSS

    Error: Document open call failed. The document might require username and password.

      I am getting the below error, when I run my Reload task.

      I have one sheet which contains "Section Access" script as below

      Section Access;

      Security:

      LOAD Distinct

             Upper(AccessLevel) as ACCESS,

             'DOMAINNAME\' & upper(USERID) as NTNAME 

      ;

      SQL SELECT *

      FROM dbo.User_Access;

       

      Error :

      (2014-06-11 04:13:52) Information: Starting task 'Reload MSO Dashboard'. Id:29365970-6c74-48c4-946f-345229f9f29e. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c

      (2014-06-11 04:13:52) Information: Entering Task Execution.

      (2014-06-11 04:13:52) Information: ClusterID=1

      (2014-06-11 04:13:52) Information: QDSID=9e50631d-d758-48e8-3c56-6b384d23961d

      (2014-06-11 04:13:52) Information: TaskID=29365970-6c74-48c4-946f-345229f9f29e

      (2014-06-11 04:13:52) Information: MaxRunTime=1.00:00:00

      (2014-06-11 04:13:52) Information: MachineName=D116237-002

      (2014-06-11 04:13:52) Information: Max attempts:1

      (2014-06-11 04:13:52) Information: Current Attempt=0

      (2014-06-11 04:13:52) Information: Task Dependencies are OK

      (2014-06-11 04:13:52) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

      (2014-06-11 04:13:52) Information: Opening "\\firmwide.corp.gs.com\root\Projects\Firmwide\NY\APGQlikview\IMD\QA\Infra\MSO_DashBoard.qvw"

      (2014-06-11 04:13:52) Information: Allocating new QlikView Engine. Current usage count=1 of 4 (of type non-reader).

      (2014-06-11 04:13:52) Information: Max retries:5

      (2014-06-11 04:13:52) Information: Attempt:01

      (2014-06-11 04:13:53) Information: Opened the QlikView Engine successfully. ProcessID=5880

      (2014-06-11 04:13:53) Information: Allocated QlikView Engine successfully. Current usage count=2 of 4 (of type non-reader). Ticket number=346.

      (2014-06-11 04:13:53) Information: Loading document "\\firmwide.corp.gs.com\root\Projects\Firmwide\NY\APGQlikview\IMD\QA\Infra\MSO_DashBoard.qvw" (2.30 Mb)

      (2014-06-11 04:13:54) Information: Loading. LoadTime=00:00:01.0000519

      (2014-06-11 04:13:55) Error: Document open call failed. The document might require username and password.

      (2014-06-11 04:13:55) Information: Attempted to load the document without data.

      (2014-06-11 04:13:55) Error: The document failed to open.

      (2014-06-11 04:13:56) Information: Closed the QlikView Engine successfully. ProcessID=5880

      (2014-06-11 04:13:56) Error: Document could not be opened

      (2014-06-11 04:13:56) Information: Closed the QlikView Engine successfully. ProcessID=5880

      (2014-06-11 04:13:56) Information: Failed to check in document: \\firmwide.corp.gs.com\root\Projects\Firmwide\NY\APGQlikview\IMD\QA\Infra\MSO_DashBoard.qvw

      (2014-06-11 04:13:56) Error: The task "Reload MSO Dashboard" failed. Exception:

      (2014-06-11 04:13:56) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.FailedDocumentCheckoutException: Failed to check out document with path: \\firmwide.corp.gs.com\root\Projects\Firmwide\NY\APGQlikview\IMD\QA\Infra\MSO_DashBoard.qvw

      (2014-06-11 04:13:56) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

      (2014-06-11 04:13:56) Error: --- End of inner exception stack trace ---

      (2014-06-11 04:13:56) Error: at QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

      (2014-06-11 04:13:56) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

      (2014-06-11 04:13:56) Error: --- End of inner exception stack trace ---

      (2014-06-11 04:13:56) Error: at QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

      (2014-06-11 04:13:56) Error: at QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

      (2014-06-11 04:13:56) Information: Task Execute Duration=00:00:04.0042392

      (2014-06-11 04:13:56) Information: TaskResult.status=Finished

      (2014-06-11 04:13:56) Information: Notifying all triggers of new state:FinishedWithErrors

      (2014-06-11 04:13:56) Information: Notifying all triggers of new state:FinishedWithErrors - completed

      (2014-06-11 04:13:56) Information: Saving Task Result


      Can somebody please help ?

      It is very urgent.


      Thanks in Advance