QMC task failure

[EladKushmaro]

Hi, 

We experience QV QMC tasks failure during night when no users or developers are in the system.

Our QV version is 12.6 IR.

These are the Server Event log messages:

"Session stop reason: Socket closed by client

StdServer: OnRemoteClosed entered for socket ::1:4747 <-> ::1:57039, user: , app: ."

Appreciate any advice,

Elad

[Chip_Matejowsky]

Hi @EladKushmaro,

When investigating task failures we need to review the QlikView Distribution Service log of the failed task.  By default, the task logs are stored in %ProgramData%\QlikTech\DistributionService\1\Log\DateOfTask\NameOfTask.  If you have configured the QDS Application Data Folder in a different folder, you can check the location by looking in the QMC > System > Setup > Distribution Services > QDS@ > General tab for the QDS App Data Folder.

If there is an error in the task log states that states "The Source Document was NOT reloaded successfully," then you would need to review the document log of the QVW associated with the failed task.  If document logging is enabled, it will be stored in the same directory in which the QVW file is housed.  If document logging is not enabled, you will need to open the QVW file in QlikView Developer, click Settings > Document Properties > General tab and ensure the Generate Logfile checkbox is ticked. Then run the reload task so that the document log is generated.

So once you have located the QDS task log, please attach the log or or post a snippet of the log containing the error to this thread.

Best Regards

[EladKushmaro]

Hi again,

This is the document log (I put "XYZ" instead of the information related to our server).

The application user is the one that runs the QMC task, it has file open privilege (I re-checked it by accessing the server and document with the application user).

(8/1/2022 6:09:43 AM) Information: QDSID=4b983b1b-5873-0848-34fe-14c3bf809b76

(8/1/2022 6:09:43 AM) Information: TaskID=28953283-e5fd-4128-a8a8-fe461054e7d8

(8/1/2022 6:09:43 AM) Information: ExecID=aadafcef-9f70-4639-a367-1ca80484d504

(8/1/2022 6:09:43 AM) Information: MaxRunTime=06:00:00

(8/1/2022 6:09:43 AM) Information: MachineName=XYZ

(8/1/2022 6:09:43 AM) Information: Task execution max attempts=1

(8/1/2022 6:09:43 AM) Information: Task execution current attempt=1

(8/1/2022 6:09:43 AM) Information: Task Dependencies are OK

(8/1/2022 6:09:43 AM) Information: The task "XYZ" is starting

(8/1/2022 6:09:43 AM) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(8/1/2022 6:09:43 AM) Information: Opening "XYZ"

(8/1/2022 6:09:44 AM) Information: Allocating new QlikView Engine. Current usage count=7 of 11 (of type non-reader).

(8/1/2022 6:09:44 AM) Information: Max retries:5

(8/1/2022 6:09:44 AM) Information: Attempt:01

(8/1/2022 6:09:45 AM) Information: Opened the QlikView Engine successfully. ProcessID=154152

(8/1/2022 6:09:45 AM) Information: Allocated QlikView Engine successfully. Current usage count=8 of 11 (of type non-reader). Ticket number=407.

(8/1/2022 6:09:45 AM) Information: Loading document "XYZ" (295.18 Mb)

(8/1/2022 6:09:46 AM) Information: Loading. LoadTime=00:00:01.0001359

(8/1/2022 6:09:47 AM) Error: Document open call failed. The document might require username and password.

(8/1/2022 6:09:47 AM) Information: Attempted to load the document without data.

(8/1/2022 6:09:47 AM) Error: The document failed to open.

(8/1/2022 6:09:48 AM) Information: Closed the QlikView Engine successfully. ProcessID=154152

(8/1/2022 6:09:48 AM) Error: Document could not be opened

(8/1/2022 6:09:48 AM) Information: Closed the QlikView Engine successfully. ProcessID=154152

(8/1/2022 6:09:48 AM) Information: Failed to check in document: XYZ

(8/1/2022 6:09:48 AM) Error: The task "XYZ" failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.FailedDocumentCheckoutException: Failed to check out document with path: XYZ || at QDSMain.AbstractReloadTask.Reload(String fileName, IExecutingTaskResult executingTaskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) || --- End of inner exception stack trace --- || at QDSMain.AbstractReloadTask.Reload(String fileName, IExecutingTaskResult executingTaskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) || at QDSMain.DistributeTask.PerformExecute(IExecutingTaskResult executingTaskResult) || --- End of inner exception stack trace --- || at QDSMain.DistributeTask.PerformExecute(IExecutingTaskResult executingTaskResult) || at QDSMain.Task.AbstractTask.TaskExecution(CurrentExecutionArgs args)

(8/1/2022 6:09:48 AM) Information: Task Execute Duration=00:00:04.8576563

(8/1/2022 6:09:48 AM) Information: Sending Alert mail

(8/1/2022 6:09:48 AM) Information: TaskResult.status=Finished

(8/1/2022 6:09:48 AM) Information: Notifying all triggers of new state: "FinishedWithErrors"...

(8/1/2022 6:09:48 AM) Information: Notifying all triggers of new state: "FinishedWithErrors" - Completed

[EladKushmaro]

Hi again,

This is the relevant part in the document log (I put "XYZ" instead of the information related to our server).

The application user runs the QMC task, it has file open privilege (I re-checked it by accessing the server and document with the application user).

(8/1/2022 6:09:45 AM) Information: Opened the QlikView Engine successfully. ProcessID=154152

(8/1/2022 6:09:45 AM) Information: Allocated QlikView Engine successfully. Current usage count=8 of 11 (of type non-reader). Ticket number=407.

(8/1/2022 6:09:45 AM) Information: Loading document "XYZ" (295.18 Mb)

(8/1/2022 6:09:46 AM) Information: Loading. LoadTime=00:00:01.0001359

(8/1/2022 6:09:47 AM) Error: Document open call failed. The document might require username and password.

(8/1/2022 6:09:47 AM) Information: Attempted to load the document without data.

(8/1/2022 6:09:47 AM) Error: The document failed to open.

(8/1/2022 6:09:48 AM) Information: Closed the QlikView Engine successfully. ProcessID=154152

(8/1/2022 6:09:48 AM) Error: Document could not be opened

(8/1/2022 6:09:48 AM) Information: Closed the QlikView Engine successfully. ProcessID=154152

(8/1/2022 6:09:48 AM) Information: Failed to check in document: XYZ

(8/1/2022 6:09:48 AM) Error: The task "XYZ" failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.FailedDocumentCheckoutException: Failed to check out document with path: XYZ || at QDSMain.AbstractReloadTask.Reload(String fileName, IExecutingTaskResult executingTaskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) || --- End of inner exception stack trace --- || at QDSMain.AbstractReloadTask.Reload(String fileName, IExecutingTaskResult executingTaskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage) || at QDSMain.DistributeTask.PerformExecute(IExecutingTaskResult executingTaskResult) || --- End of inner exception stack trace --- || at QDSMain.DistributeTask.PerformExecute(IExecutingTaskResult executingTaskResult) || at QDSMain.Task.AbstractTask.TaskExecution(CurrentExecutionArgs args)

[marcus_sommer]

Beside the file access rights the access might fail if any section access is applied and the executing user isn't properly listed.

I'm not sure if you really tried it with the right user because you name the user as "application user" and the qmc task runs with the user from the QlikView distribution service. Are both users really the same?

- Marcus

[EladKushmaro]

Hi,

The document has section access and the application user is properly listed in it.

All 6 QV services are defined with the same application user as "log on as".

When the task fails - we just start the task manually from the QMC (the same task definitions) and it completes successfully.

[marcus_sommer]

The same qmc-task worked if you run it manually and failed by timely/depending scheduled task? By running the task manually is the services user (or any other) logged in on the server? If yes, try it again without a logged user - the qmc could be also externally controlled.

Beside this the task-log error-message might not be exact and and the opening might be successful but anything within the load-script failed. Therefore how does the document-log look like if the task failed?

- Marcus

[Chip_Matejowsky · Accepted solution]

Hi @EladKushmaro,

Have a look at the Qlik Support article QlikView Publisher Task Failing With Error:Error Document open call failed. The document might requi....

Best Regards