Carga de dados no servidor

[ruzivao1980]

Bom dia...

Estou com um erro de carga de dados no servidor... alguem pode me ajudar....

(2018-02-23 11:16:09) Information: Starting task 'Teste/dashboard.qvw'. Id:8e37a710-72b0-4e14-a7d1-5813295b8da2. Triggered by 'ManualStartTrigger'. Id:00000001-0002-0003-0405-0607080a0b0c

(2018-02-23 11:16:09) Information: Entering Task Execution.

(2018-02-23 11:16:09) Information: ClusterID=1

(2018-02-23 11:16:09) Information: QDSID=c4b9a986-2b09-fad3-e98e-117dd7424c2d

(2018-02-23 11:16:09) Information: TaskID=8e37a710-72b0-4e14-a7d1-5813295b8da2

(2018-02-23 11:16:09) Information: MaxRunTime=06:00:00

(2018-02-23 11:16:09) Information: MachineName=13119619764LUIZ

(2018-02-23 11:16:09) Information: Max attempts:1

(2018-02-23 11:16:09) Information: Current Attempt=0

(2018-02-23 11:16:09) Information: Task Dependencies are OK

(2018-02-23 11:16:09) Information: Document is marked to be Reloaded with fresh data. Initializing Reload for Distribution.

(2018-02-23 11:16:09) Information: Opening "C:\Sistemas\Dashboard\Teste\dashboard.qvw"

(2018-02-23 11:16:09) Information: Allocating new QlikView Engine. Current usage count=0 of 2 (of type non-reader).

(2018-02-23 11:16:09) Information: Max retries:5

(2018-02-23 11:16:09) Information: Attempt:01

(2018-02-23 11:16:10) Information: Opened the QlikView Engine successfully. ProcessID=1976

(2018-02-23 11:16:10) Information: Allocated QlikView Engine successfully. Current usage count=1 of 2 (of type non-reader). Ticket number=1.

(2018-02-23 11:16:10) Information: Loading document "C:\Sistemas\Dashboard\Teste\dashboard.qvw" (10.31 Mb)

(2018-02-23 11:16:10) Information: Physical FileSize=10.31 Mb. Memory Allocation Delta for this file=11.34 Mb. Available Physical Memory Before Open=1110.98 Mb. Available Physical Memory After Open=1096.81 Mb. Total Physical Memory=2047.49 Mb.

(2018-02-23 11:16:10) Information: Attempted to load the document without data.

(2018-02-23 11:16:10) Information: The document was loaded successfully.

(2018-02-23 11:16:10) Information: Document was opened successfully

(2018-02-23 11:16:10) Information: Starting reload

(2018-02-23 11:16:10) Information: QlikView->Settings->Document Peferences->Generate Logfile in document is not set.

(2018-02-23 11:16:10) Information: The Source Document is being reloaded. DocumentPath=C:\Sistemas\Dashboard\Teste\dashboard.qvw

(2018-02-23 11:16:10) Information: The Source Document reload complete. DocumentPath=C:\Sistemas\Dashboard\Teste\dashboard.qvw

(2018-02-23 11:16:10) Information: Memory Allocation Delta for this file=1.04 Mb. Available Physical Memory Before Reload=1096.91 Mb. Available Physical Memory After Reload=1092.97 Mb. Total Physical Memory=1092.97 Mb.

(2018-02-23 11:16:11) Error: The Source Document was NOT reloaded successfully. DocumentPath=C:\Sistemas\Dashboard\Teste\dashboard.qvw.

(2018-02-23 11:16:11) Information: Closing the document.

(2018-02-23 11:16:11) Information: Closed the QlikView Engine successfully. ProcessID=1976

(2018-02-23 11:16:11) Error: The task "Teste/dashboard.qvw" failed. Exception:

(2018-02-23 11:16:11) Error: QDSMain.Exceptions.DistributionFailedException: Distribute failed with errors to follow. ---> QDSMain.Exceptions.ReloadFailedException: Reload failed ---> QDSMain.Exceptions.LogBucketErrorException: The Source Document was NOT reloaded successfully. DocumentPath=C:\Sistemas\Dashboard\Teste\dashboard.qvw.

(2018-02-23 11:16:11) Error: em QDSMain.ReloadTask.VerifyConditions(TaskResult taskResult)

(2018-02-23 11:16:11) Error: em QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2018-02-23 11:16:11) Error: --- Fim do rastreamento de pilha de exceções internas ---

(2018-02-23 11:16:11) Error: em QDSMain.ReloadTask.Reload(String fileName, TaskResult taskResult, String sectionAccessUserName, String sectionAccessPassword, eReloadOptions reloadOption, String variableName, String variableValue, Boolean moniterCpuUsage)

(2018-02-23 11:16:11) Error: em QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2018-02-23 11:16:11) Error: --- Fim do rastreamento de pilha de exceções internas ---

(2018-02-23 11:16:11) Error: em QDSMain.DistributeTask.Execute(TaskResult currentTaskResult)

(2018-02-23 11:16:11) Error: em QDSMain.Task.AbstractTask.TaskExecution(ILogBucket logBucket, TaskResult taskResult)

(2018-02-23 11:16:11) Information: Task Execute Duration=00:00:02.1982530

(2018-02-23 11:16:11) Information: TaskResult.status=Finished

(2018-02-23 11:16:11) Information: Notifying all triggers of new state:FinishedWithErrors

(2018-02-23 11:16:11) Information: Notifying all triggers of new state:FinishedWithErrors - completed

(2018-02-23 11:16:11) Information: Saving Task Result

[pablolabbe]

Ative o LOG do QVW , ali diz que não está ativo.

Parece que tem algum erro no script que está abortando a carga]

[cristianozilz]

Rooservelt Telles,

Você pode ativar o log em preferências do documentos (arquivo anexo) dê a carga e analise o log gerado. lá você obterá o que está ocorrendo.

[ruzivao1980]

se eu carrego pelo documento ele carrega normal... pelo server que da o erro... alguma ideia...

[ruzivao1980]

na carga pelo qv desktop carrega normal... pelo server da o erro

[ruzivao1980]

na carga pelo qv desktop carrega normal... pelo server da o erro

[mario_sergio_ti]

Roosevelt;

Ative o Log na aplicação QVW conforme orientado pelo cristianozilz‌ epablolabbe;

Após salvar a aplicação com o Log ativado, execute a carga pelo servidor;

Será gerado um arquivo de Log na pasta onde está a aplicação;

Favor, anexe este Log.

Abraço.

[ruzivao1980 · Accepted solution]

Amigos... ativei o log do qv.... e verifiquei que estava dando erro no usuario e senha de acesso ao banco, mas pelo qv desktop estava funcionando, ai verifiquei que o client odbc esta a nivel de usuário e nao de sistema, exclui o de usuario e fiz o de sistema e ficou correto, obrigado a ajuda de todos...

[pablolabbe]

Beleza !

[Thiago_Justen_]

Obrigado também por ter compartilhado conosco a solução

Abs e Sucesso!