Pentaho Windows任务计划程序

Question

我正在尝试使用.bat文件安排作业。当我运行它时，它在开始执行作业时被卡住了。有人知道如何解决此问题，以便我可以运行我的作业吗？

这跟Java有关系吗？我没有变量PENTAHO_JAVA_HOME。我只有JAVA_HOME。不确定这是否与我的kitchen.bat文件有关。我只使用Spoon.bat。

我认为这是我的Kitchen.bat (.kjb)的问题，因为如果我用Pan.bat (.ktr)运行批处理文件，我的文件运行得很好。

C:\Users\bxt0\Desktop>c:

C:\Users\bxt\Desktop>cd /d "C:\data-integration"

C:\data-integration>call Kitchen.bat 
  /file:C:\Users\bxt\Desktop\CCMStatsJob.
kjb "-param:TABLE_NAME=region" -logfile=C:\Users\bxt058y\Documents\Pentaho 
  Jobs\
    ccmjob.txt
DEBUG: Using JAVA_HOME
DEBUG: _PENTAHO_JAVA_HOME=C:\Program Files\Java\jre1.8.0_74
DEBUG: _PENTAHO_JAVA=C:\Program Files\Java\jre1.8.0_74\bin\java.exe

C:\data-integration>"C:\Program Files\Java\jre1.8.0_74\bin\java.exe"  "- 
Xms1024m
" "-Xmx2048m" "-XX:MaxPermSize=256m" "- 
   Dhttps.protocols=TLSv1,TLSv1.1,TLSv1.2" "
-Djava.library.path=libswt\win64" "-DKETTLE_HOME=" "-DKETTLE_REPOSITORY=" "- 
  DKET
TLE_USER=" "-DKETTLE_PASSWORD=" "-DKETTLE_PLUGIN_PACKAGES=" "- 
DKETTLE_LOG_SIZE_L
IMIT=" "-DKETTLE_JNDI_ROOT=" -jar launcher\pentaho-application-launcher- 
7.1.0.0-
12.jar -lib ..\libswt\win64  -main org.pentaho.di.kitchen.Kitchen -initialDir 
 "C
:\data-integration"\ /file:C:\Users\bxt058y\Desktop\CCMStatsJob.kjb "- 
 param:TABL
E_NAME=region" -logfile C:\Users\bxt058y\Documents\Pentaho Jobs\ccmjob.txt
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=256m; 
 sup
port was removed in 8.0
log4j:ERROR Could not create an Appender. Reported error follows.
  java.lang.ClassCastException: org.apache.log4j.ConsoleAppender cannot be 
  cast to
   org.apache.log4j.Appender
    at org.apache.log4j.xml.DOMConfigurator.parseAppender(DOMConfigurator.ja
    va:248)
    at org.apache.log4j.xml.DOMConfigurator.findAppenderByName(DOMConfigurat
   or.java:176)
    at org.apache.log4j.xml.DOMConfigurator.findAppenderByReference(DOMConfi
  gurator.java:191)
    at org.apache.log4j.xml.DOMConfigurator.parseChildrenOfLoggerElement(DOM
   Configurator.java:523)
    at org.apache.log4j.xml.DOMConfigurator.parseCategory(DOMConfigurator.ja
    va:436)
    at org.apache.log4j.xml.DOMConfigurator.parse(DOMConfigurator.java:1004)

    at org.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java
    :872)
    at org.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java
    :755)
    at org.apache.log4j.xml.DOMConfigurator.configure(DOMConfigurator.java:8
   96)
    at org.pentaho.di.core.logging.log4j.Log4jLogging.applyLog4jConfiguratio
  n(Log4jLogging.java:81)
    at org.pentaho.di.core.logging.log4j.Log4jLogging.createLogger(Log4jLogg
    ing.java:89)
    at org.pentaho.di.core.logging.log4j.Log4jLogging.init(Log4jLogging.java
    :68)
    at org.pentaho.di.core.KettleClientEnvironment.initLogginPlugins(KettleC
    lientEnvironment.java:155)
    at org.pentaho.di.core.KettleClientEnvironment.init(KettleClientEnvironm
    ent.java:118)
    at org.pentaho.di.core.KettleClientEnvironment.init(KettleClientEnvironm
     ent.java:79)
    at org.pentaho.di.kitchen.Kitchen$1.call(Kitchen.java:91)
    at org.pentaho.di.kitchen.Kitchen$1.call(Kitchen.java:84)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
    log4j:ERROR Could not create an Appender. Reported error follows.
   java.lang.ClassCastException: org.apache.log4j.ConsoleAppender cannot be 
   cast to
   org.apache.log4j.Appender
    at org.apache.log4j.xml.DOMConfigurator.parseAppender(DOMConfigurator.ja
    va:248)
    at org.apache.log4j.xml.DOMConfigurator.findAppenderByName(DOMConfigurat
    or.java:176)
    at org.apache.log4j.xml.DOMConfigurator.findAppenderByReference(DOMConfi
   gurator.java:191)
    at org.apache.log4j.xml.DOMConfigurator.parseChildrenOfLoggerElement(DOM
    Configurator.java:523)
    at org.apache.log4j.xml.DOMConfigurator.parseRoot(DOMConfigurator.java:4
     92)
    at org.apache.log4j.xml.DOMConfigurator.parse(DOMConfigurator.java:1006)

    at org.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java
    :872)
    at org.apache.log4j.xml.DOMConfigurator.doConfigure(DOMConfigurator.java
    :755)
    at org.apache.log4j.xml.DOMConfigurator.configure(DOMConfigurator.java:8
    96)
    at org.pentaho.di.core.logging.log4j.Log4jLogging.applyLog4jConfiguratio
     n(Log4jLogging.java:81)
    at org.pentaho.di.core.logging.log4j.Log4jLogging.createLogger(Log4jLogg
     ing.java:89)
    at org.pentaho.di.core.logging.log4j.Log4jLogging.init(Log4jLogging.java
     :68)
    at org.pentaho.di.core.KettleClientEnvironment.initLogginPlugins(KettleC
     lientEnvironment.java:155)
    at org.pentaho.di.core.KettleClientEnvironment.init(KettleClientEnvironm
    ent.java:118)
    at org.pentaho.di.core.KettleClientEnvironment.init(KettleClientEnvironm
     ent.java:79)
    at org.pentaho.di.kitchen.Kitchen$1.call(Kitchen.java:91)
    at org.pentaho.di.kitchen.Kitchen$1.call(Kitchen.java:84)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
    2018/06/28 09:35:32 - Kitchen - Start of run.
    2018/06/28 09:35:34 - CCMStatsJob - Start of job execution
   2018/06/28 09:35:34 - CCMStatsJob - CCMStatsJob    

Answer 1

Windows不喜欢在文件名中使用空格(linux也不喜欢)。更正-logfile。

参数不能在引号之间。删除。

在Window中，参数是由"/“引入的，而不是由"-”引入的(如在linux中)。变化。

命令call在后台执行进程，因此您将什么也看不到，没有日志，甚至看不到进程已停止的信号。要检查它是否正确运行，您需要键入日志文件。

kitchen.bat /file:C:\Users\bxt058y\Desktop\CCMStatsJob.kjb /param:TABLE_NAME=region /logfile:"C:\Users\bxt058y\Documents\Pentaho Jobs\ccmjob.txt" 

Answer 2

我认为这是我的Kitchen.bat (.kjb)的问题，因为如果我用Pan.bat (.ktr)运行批处理文件，我的文件运行得很好。