3 Replies Latest reply: Sep 19, 2017 12:10 PM by Yuri Tuan Godoz RSS

    Erro execução pelo QMC - EXECUTE Command Failed. AllowExecuteCommand setting violation detected

    Yuri Tuan Godoz

      Olá a todos.

       

      Estou com um problema ao executar o seguinte comando:

      EXECUTE cmd.exe /c "echo C:\Teste\BOMremover\bomremover.exe C:\Teste InsertCredenciadoRevistaAnoMes.sql";

       

      Quando executo via Desktop funciona, mas quando agendo a tarefa no QMC acusa erro.

      A primeira vez que executei via desktop deu erro, mas alterei a configuração OverrideScriptSecurity para 1 e passou a funcionar.

      2017-09-18 15_46_12-serv-qviewprod - Conexão de Área de Trabalho Remota.png

       

      alterei o AllowExecuteCommand=1 (estava=0) no arquivo Settings.ini, que fica no diretório C:\Windows\System32\config\systemprofile\AppData\Roaming\QlikTech\QlikViewBatch.

      Também incluí AllowExecuteCommand=1 no Settings.ini que fica no diretório: C:\ProgramData\QlikTech\QlikViewServer.


      Alguém já passou por isso e pode me ajudar?

       

      O log fica desta meneira:

      2017-09-18 15:27:33      Execution started.

      2017-09-18 15:27:33      QVB Version                   12.0.20400.0

      2017-09-18 15:27:33      CPU Target                    x64

      2017-09-18 15:27:33      Operating System              Windows Server 2012 Standard  (64 bit edition)

      2017-09-18 15:27:33      Wow64 mode                    Not using Wow64

      2017-09-18 15:27:33      Language                      0416 Portuguese (Brazil) Portuguese

      2017-09-18 15:27:33      Country                       55 Brazil Brazil

      2017-09-18 15:27:33      MDAC Version                  6.2.9200.16384

      2017-09-18 15:27:33      MDAC Full Install Version     6.2.9200.16384

      2017-09-18 15:27:33      PreferredCompression          2

      2017-09-18 15:27:33      EnableParallelReload          1

      2017-09-18 15:27:33      ParallelizeQvdLoads           1

      2017-09-18 15:27:33      AutoSaveAfterReload           0

      2017-09-18 15:27:33      BackupBeforeReload            0

      2017-09-18 15:27:33      EnableFlushLog                0

      2017-09-18 15:27:33      SaveInfoWhenSavingFile        0

      2017-09-18 15:27:33      UserLogfileCharset            65001

      2017-09-18 15:27:33      OdbcLoginTimeout              -1

      2017-09-18 15:27:33      OdbcConnectionTimeout         -1

      2017-09-18 15:27:33      ScriptWantsDbWrite            false

      2017-09-18 15:27:33      ScriptWantsExe                true

      2017-09-18 15:27:33      LogFile CodePage Used:        65001

      2017-09-18 15:27:33      UseMemoryFillPattern          1

      2017-09-18 15:27:33      ScriptMode                    Legacy (gives greater system access) (aka qv11 mode)

      2017-09-18 15:27:33      ReloadCodebase                Classic

      2017-09-18 15:27:33      Reload Executed By            POSTHAUS\qlikview.service

      2017-09-18 15:27:33      Process Executing             QVB

      2017-09-18 15:27:33      Process ID                    23360

      2017-09-18 15:27:33 0002 SET ThousandSep='.'

      2017-09-18 15:27:33 0003 SET DecimalSep=','

      2017-09-18 15:27:33 0004 SET MoneyThousandSep='.'

      2017-09-18 15:27:33 0005 SET MoneyDecimalSep=','

      2017-09-18 15:27:33 0006 SET MoneyFormat='R$ #.##0,00;-R$ #.##0,00'

      2017-09-18 15:27:33 0007 SET TimeFormat='hh:mm:ss'

      2017-09-18 15:27:33 0008 SET DateFormat='DD/MM/YYYY'

      2017-09-18 15:27:33 0009 SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]'

      2017-09-18 15:27:33 0010 SET MonthNames='jan;fev;mar;abr;mai;jun;jul;ago;set;out;nov;dez'

      2017-09-18 15:27:33 0011 SET DayNames='seg;ter;qua;qui;sex;sáb;dom'

      2017-09-18 15:27:33 0012 SET LongMonthNames='janeiro;fevereiro;março;abril;maio;junho;julho;agosto;setembro;outubro;novembro;dezembro'

      2017-09-18 15:27:33 0013 SET LongDayNames='segunda-feira;terça-feira;quarta-feira;quinta-feira;sexta-feira;sábado;domingo'

      2017-09-18 15:27:33 0014 SET FirstWeekDay=6

      2017-09-18 15:27:33 0015 SET BrokenWeeks=1

      2017-09-18 15:27:33 0016 SET ReferenceDay=0

      2017-09-18 15:27:33 0017 SET FirstMonthOfYear=1

      2017-09-18 15:27:33 0018 SET CollationLocale='pt-BR'

      2017-09-18 15:27:33 0023 EXECUTE cmd.exe /c "echo C:\Teste\BOMremover\bomremover.exe C:\Teste InsertCredenciadoRevistaAnoMes.sql"

      2017-09-18 15:27:33      ERROR - EXECUTE Command Failed. AllowExecuteCommand setting violation detected.  Document: D:\QLIKVIEW\1.DEPLOY\GI\teste4.qvw

      2017-09-18 15:27:33      Error: Script line error:

      2017-09-18 15:27:33      General Script Error

      2017-09-18 15:27:33      Execution Failed

      2017-09-18 15:27:33      Execution finished.

       

      Desde já, agradeço a todos!