Qlik Community

Brasil

cancel
Showing results for 
Search instead for 
Did you mean: 
welinton123
Contributor III
Contributor III

Erro Qlikview Server Executar BAT e Programa Externo

Bom dia,

Tenho uma aplicação que chama um BAT para mover arquivos txt e o bomremover para corrigir o problema do utf-8 do qlikview ao gerar arquivos BAT.

Quando executo o load na aplicação pelo qlikview, funciona normalmente mas quando agendo um reload no server ele apresenta o seguinte erro no log:

2016-04-10 10:01:11 0098   BatFile:

2016-04-10 10:01:11 0099   LOAD 'MOVE C:\QLIK\FONTES\MOV-VENDAS-09042016.txt ..\06-BKP\MOV-VENDAS\' AS [@echo off]

2016-04-10 10:01:11 0100   AUTOGENERATE(1)

2016-04-10 10:01:11         1 fields found: @echo off,

2016-04-10 10:01:11        3 lines fetched

2016-04-10 10:01:11 0101 NEXT

2016-04-10 10:01:11 0102

2016-04-10 10:01:11 0102 STORE BatFile INTO [..\05-BAT\MOVE-FILE-VENDAS.BAT](txt)

2016-04-10 10:01:11 0103 DROP TABLE BatFile

2016-04-10 10:01:11 0105 EXECUTE cmd.exe /c "echo. | ..\05-BAT\bomremover ..\05-BAT\ *.BAT"

2016-04-10 10:01:11      ERROR - EXECUTE Command Failed. AllowExecuteCommand setting violation detected.  Document: C:\QLIK\APP\COMERCIAL\02-QVW\PAINEL_COMERCIAL.qvw

2016-04-10 10:01:11      Error: Script line error:

2016-04-10 10:01:11      General Script Error

2016-04-10 10:01:11      Execution Failed

2016-04-10 10:01:11      Execution finished.

Alguém tem idéia?


Abs.


Welinton R Gonçalves

Labels (3)
1 Solution

Accepted Solutions
afurtado
MVP
MVP

Welinton,

você atualizou a versão do Qlik?  Esta usando a 12?

2016-04-11 15_51_17.jpg

furtado@farolbi.com.br

View solution in original post

3 Replies
afurtado
MVP
MVP

Welinton,

você atualizou a versão do Qlik?  Esta usando a 12?

2016-04-11 15_51_17.jpg

furtado@farolbi.com.br
welinton123
Contributor III
Contributor III
Author

Boa tarde Alessandro,

Na verdade estamos instalando o Qlikview agora e já começamos na versão 12, então não sabia sobre esse change log.

Funcionou com essa alteração.

Obrigado!

------

(2016-04-11 16:18:58) Information: Reloading..

(2016-04-11 16:19:04) Information: The Source Document reload complete. DocumentPath=C:\QLIK\APP\COMERCIAL\02-QVW\PAINEL_COMERCIAL.qvw

(2016-04-11 16:19:04) Information: Memory Allocation Delta for this file=465.39 Mb. Available Physical Memory Before Reload=59126.40 Mb. Available Physical Memory After Reload=58677.20 Mb. Total Physical Memory=58677.20 Mb.

(2016-04-11 16:19:04) Information: The Source Document was reloaded successfully.

(2016-04-11 16:19:04) Information: ScriptError suppressed. DocumentPath=C:\QLIK\APP\COMERCIAL\02-QVW\PAINEL_COMERCIAL.qvw. Errors: 1 ScriptError: , ScriptErrorList: File Not Found || , ScriptErrorDetails=

(2016-04-11 16:19:04) Information: Reload finished successfully

(2016-04-11 16:19:04) Information: Start saving document

(2016-04-11 16:19:24) Information: Check in document: C:\QLIK\APP\COMERCIAL\02-QVW\PAINEL_COMERCIAL.qvw

(2016-04-11 16:19:24) Information: Closing the document.

(2016-04-11 16:19:24) Information: Closed the QlikView Engine successfully. ProcessID=6404

(2016-04-11 16:19:24) Information: No distribution required.

(2016-04-11 16:19:24) Information: Task Execute Duration=00:01:20.9411768

(2016-04-11 16:19:24) Information: The task "QLIK/APP/COMERCIAL/02-QVW/PAINEL_COMERCIAL.qvw" finished successfully

(2016-04-11 16:19:24) Information: TaskResult.status=Finished

(2016-04-11 16:19:24) Information: Notifying all triggers of new state:Finished

(2016-04-11 16:19:24) Information: Notifying all triggers of new state:Finished - completed

(2016-04-11 16:19:24) Information: Saving Task Result

yurituan
Contributor II
Contributor II

afurtado‌, estou com o mesmo problema, segui as orientações mas não resolveu. Você pode me ajudar?

Nesta pergunta passo mais detalhes: Erro execução pelo QMC - EXECUTE Command Failed. AllowExecuteCommand setting violation detected