Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Senhores tenho um qvw que faz a extracao de um banco de dados para gerar um qvd onde configurei um reload para tal tarefa, porem ele esta me retornando erro com o log abaixo, conseguem me auxiliar, quando realizo a carga manualmente ele executa sem nenhum problema.
(2017-02-22 11:54:06) Information: Starting task 'Roge/T/Monitor_Pedidos.qvw'. Id:31f387f6-c1ac-4939-a904-fd44667aace0. Triggered by 'ScheduleTrigger'. Id:984fead9-9b39-429c-9e87-0454452f7b71
(2017-02-22 11:54:06) Information: Entering Task Execution.
(2017-02-22 11:54:06) Information: ClusterID=1
(2017-02-22 11:54:06) Information: QDSID=8e6f1647-e180-54f8-13d5-5094f06e3fa7
(2017-02-22 11:54:06) Information: TaskID=31f387f6-c1ac-4939-a904-fd44667aace0
(2017-02-22 11:54:06) Information: MaxRunTime=06:00:00
(2017-02-22 11:54:06) Information: MachineName=ROGE02
(2017-02-22 11:54:06) Information: Max attempts:1
(2017-02-22 11:54:06) Information: Current Attempt=0
(2017-02-22 11:54:06) Information: Task Dependencies are OK
(2017-02-22 11:54:06) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.
(2017-02-22 11:54:06) Information: Opening "D:\ROGE\T\Monitor_Pedidos.qvw"
(2017-02-22 11:54:06) Information: Allocating new QlikView Engine. Current usage count=0 of 2 (of type non-reader).
(2017-02-22 11:54:06) Information: Max retries:5
(2017-02-22 11:54:06) Information: Attempt:01
(2017-02-22 11:54:07) Information: Opened the QlikView Engine successfully. ProcessID=4136
(2017-02-22 11:54:07) Information: Allocated QlikView Engine successfully. Current usage count=1 of 2 (of type non-reader). Ticket number=34.
(2017-02-22 11:54:07) Information: Loading document "D:\ROGE\T\Monitor_Pedidos.qvw" (0.61 Mb)
(2017-02-22 11:54:07) Information: Physical FileSize=0.61 Mb. Memory Allocation Delta for this file=6.42 Mb. Available Physical Memory Before Open=16485.73 Mb. Available Physical Memory After Open=16473.04 Mb. Total Physical Memory=31249.61 Mb.
(2017-02-22 11:54:07) Information: Attempted to load the document without data.
(2017-02-22 11:54:07) Information: The document was loaded successfully.
(2017-02-22 11:54:07) Information: Document was opened successfully
(2017-02-22 11:54:07) Information: Starting reload
(2017-02-22 11:54:07) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is not set.
(2017-02-22 11:54:07) Information: The Source Document is being reloaded. DocumentPath=D:\ROGE\T\Monitor_Pedidos.qvw
(2017-02-22 11:54:07) Information: The Source Document reload complete. DocumentPath=D:\ROGE\T\Monitor_Pedidos.qvw
(2017-02-22 11:54:07) Information: Memory Allocation Delta for this file=2.11 Mb. Available Physical Memory Before Reload=16473.05 Mb. Available Physical Memory After Reload=16463.30 Mb. Total Physical Memory=16463.30 Mb.
(2017-02-22 11:54:07) Error: The Source Document was NOT reloaded successfully. DocumentPath=D:\ROGE\T\Monitor_Pedidos.qvw.
(2017-02-22 11:54:07) Information: Closing the document.
(2017-02-22 11:54:08) Information: Closed the QlikView Engine successfully. ProcessID=4136
(2017-02-22 11:54:08) Error: The task "Roge/T/Monitor_Pedidos.qvw" failed. Exception: || QDSMain.Exceptions.TaskFailedException: Task execution failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=D:\ROGE\T\Monitor_Pedidos.qvw. || at QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult) || 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-02-22 11:54:08) Information: Task Execute Duration=00:00:02.1248947
(2017-02-22 11:54:08) Information: Sending Alert mail
(2017-02-22 11:54:09) Information: TaskResult.status=Finished
(2017-02-22 11:54:09) Information: Notifying all triggers of new state:FinishedWithErrors
(2017-02-22 11:54:09) Information: Notifying all triggers of new state:FinishedWithErrors - completed
(2017-02-22 11:54:09) Information: Saving Task Result
Senhores, problema corrigido, a conexao tinha que ser System DSN, obrigado a todos.
Paulo, marca uma das resposta como a correta para que a pergunta não fique aberta.
Abraço.
Conseguiu resolver seu problema? Se possível, marque as respostas apropriadas como Útil/Correta para mantermos a comuniade organizada.
Referência (Tópicos 2.3 e 2.4): Manual do usuário | Como criar e gerir minhas perguntas?
Abraço.