Qlik Community

Qlik Brasil

Group community for Brazil users. discussion only in Portuguese.

Highlighted
ruzivao1980
Contributor

Carga de dados no servidor

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

Tags (1)
1 Solution

Accepted Solutions
ruzivao1980
Contributor

Re: Carga de dados no servidor

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...

9 Replies
pablolabbe
Valued Contributor II

Re: Carga de dados no servidor

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
New Contributor III

Re: Carga de dados no servidor

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
Contributor

Re: Carga de dados no servidor

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

ruzivao1980
Contributor

Re: Carga de dados no servidor

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

ruzivao1980
Contributor

Re: Carga de dados no servidor

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

mario_sergio_ti
Valued Contributor

Re: Carga de dados no servidor

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
Contributor

Re: Carga de dados no servidor

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
Valued Contributor II

Re: Carga de dados no servidor

Beleza !

thiago_justen
Valued Contributor III

Re: Carga de dados no servidor

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

Abs e Sucesso!

Thiago Justen Teixeira Gonçalves
WhatsApp: 24 98152-1675
Skype: justen.thiago