failed in task in QMC

[#1]

Dear All,

I have one task in QMC to reload data .it's start after successful of one task. While running that task it's failed ,but while opening that document in QV desktop and reloading it, it's completed successfully without any error .

I checked the bath of that document and the security and all are right .

the log show this information : 

(2017-01-15 09:25:15) Information: Starting task 'Reload of BI Product\QV_Apps\Projects\HR\Apps\HR.qvw'. Id:bd9b9592-c2ad-4515-80ed-278cf844b3d2. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c

(2017-01-15 09:25:15) Information: Entering Task Execution.

(2017-01-15 09:25:15) Information: ClusterID=1

(2017-01-15 09:25:15) Information: QDSID=a284cc68-1c45-94f3-f2fa-52b61b6b64c2

(2017-01-15 09:25:15) Information: TaskID=bd9b9592-c2ad-4515-80ed-278cf844b3d2

(2017-01-15 09:25:15) Information: MaxRunTime=1.00:00:00

(2017-01-15 09:25:15) Information: MachineName=PASI-PIDT

(2017-01-15 09:25:15) Information: Max attempts:1

(2017-01-15 09:25:15) Information: Current Attempt=0

(2017-01-15 09:25:15) Information: Task Dependencies are OK

(2017-01-15 09:25:15) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(2017-01-15 09:25:15) Information: Opening "D:\PASI BI Project\BI Product\QV_Apps\Projects\HR\Apps\HR.qvw"

(2017-01-15 09:25:15) Information: Allocating new QlikView Engine. Current usage count=1 of 4 (of type non-reader).

(2017-01-15 09:25:15) Information: Max retries:5

(2017-01-15 09:25:15) Information: Attempt:01

(2017-01-15 09:25:16) Information: Opened the QlikView Engine successfully. ProcessID=8252

(2017-01-15 09:25:16) Information: Allocated QlikView Engine successfully. Current usage count=2 of 4 (of type non-reader). Ticket number=41.

(2017-01-15 09:25:16) Information: Loading document "D:\PASI BI Project\BI Product\QV_Apps\Projects\HR\Apps\HR.qvw" (9.59 Mb)

(2017-01-15 09:25:17) Information: Loading. LoadTime=00:00:01.0000443

(2017-01-15 09:25:18) Error: Document open call failed. The document might require username and password.

(2017-01-15 09:25:18) Information: Attempted to load the document without data.

(2017-01-15 09:25:18) Error: The document failed to open.

(2017-01-15 09:25:19) Information: Closed the QlikView Engine successfully. ProcessID=8252

(2017-01-15 09:25:19) Error: Document could not be opened

(2017-01-15 09:25:19) Information: Closed the QlikView Engine successfully. ProcessID=8252

(2017-01-15 09:25:19) Information: Failed to check in document: D:\PASI BI Project\BI Product\QV_Apps\Projects\HR\Apps\HR.qvw

(2017-01-15 09:25:19) Error: The task "Reload of BI Product\QV_Apps\Projects\HR\Apps\HR.qvw" 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: D:\PASI BI Project\BI Product\QV_Apps\Projects\HR\Apps\HR.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)

(2017-01-15 09:25:19) Information: Task Execute Duration=00:00:03.8641711

(2017-01-15 09:25:19) Information: TaskResult.status=Finished

(2017-01-15 09:25:19) Information: Notifying all triggers of new state:FinishedWithErrors

(2017-01-15 09:25:19) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2017-01-15 09:25:19) Information: Saving Task Result

[hector_munoz]

Hi Maeda Ahmed,

It seems that your QV document has section access and you can open it with the QlikView Desktop, as your user is listed there, but you have not introduced a valid user in the reload task. So QMC cannot open the document. The key in the log is this phrase:

"(2017-01-15 09:25:18) Error: Document open call failed. The document might require username and password."

I hope it can serve to you.

Regards,

Héctor

[satheshreddy]

Hi Ahmed,

Hi My Knowledge, This Document have Section Access, can you check the scheduled User Have Access are Not For that QVW File.

Regards

Sathish

[ziadm]

it seems that you have section access and the QMC reload manger does not have access to reload the qvw file

try to remove the section access and try to reload from QMC and if it works then this is for sure that problem

in this is the case you need to add MachineName=PASI-PIDT

You can use the Windows OS user manager.

The user should also be listed in the Windows services details for the QlikView services.

[#5]

Dear ,

I have Section Access in this document, and it reads the data from

xlsx file which has two columns as shown in the picture ,I defined in first column the admin and users ,

and in second column I defined the BI_ADMIN( Windows OS user manager) and user_code (all users who have access to the document)

and in next script, I reloading data from xlsx file.I define all user_code with the sheet name without admin users(bi_admin) as shown below:

[#6]

while reloading without section access from QMC, it's completed successfully, so the problem from section access.

I already add the admin in the file and that user listed in QlikView management services.

[ziadm]

if this solved the problem please close the thread and tag as as answered

[jonathandienst]

Does the NTNAME column contain the name of the service account for QV Server/Publisher?

Or group name to which the service account belongs?

[#9]

stile same problem

[#10]

yes ,it contain the service account