3 Replies Latest reply: Sep 18, 2017 3:41 PM by Yuri Tuan Godoz RSS

    Erro Qlikview Server Executar BAT e Programa Externo

    Welinton Gonçalves

      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

        • Re: Erro Qlikview Server Executar BAT e Programa Externo
          Alessandro Furtado

          Welinton,

           

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

           

          2016-04-11 15_51_17.jpg

            • Re: Erro Qlikview Server Executar BAT e Programa Externo
              Welinton Gonçalves

              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

              • Re: Erro Qlikview Server Executar BAT e Programa Externo
                Yuri Tuan Godoz

                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