kettle bat文件运行失败

kettle的pan.bat和kitchen.bat运行一直报错

D:\Program Files (x86)\F-KETTLE>d:

D:\Program Files (x86)\F-KETTLE>cd D:\Program Files (x86)\F-KETTLE\data-integration

D:\Program Files (x86)\F-KETTLE\data-integration>pan /file D:\Program Files (x86)\F-KETTLE\kettleFile\动态日期参数.ktr /level Basic /logfile D:\Program Files (x86)\F-KETTLE\ETL_LOG\timing.log
DEBUG: Using PENTAHO_JAVA_HOME
DEBUG: _PENTAHO_JAVA_HOME=D:\Program Files (x86)\F-KETTLE\data-integration/jdk_1.8
DEBUG: _PENTAHO_JAVA=D:\Program Files (x86)\F-KETTLE\data-integration/jdk_1.8\bin\java.exe

D:\Program Files (x86)\F-KETTLE\data-integration>"D:\Program Files (x86)\F-KETTLE\data-integration/jdk_1.8\bin\java.exe"  "-Xms1024m" "-Xmx2048m" "-XX:MaxPermSize=256m" "-Dhttps.protocols=TLSv1,TLSv1.1,TLSv1.2" "-Djava.library.path=libswt\win64" "-DKETTLE_HOME=" "-DKETTLE_REPOSITORY=" "-DKETTLE_USER=" "-DKETTLE_PASSWORD=" "-DKETTLE_PLUGIN_PACKAGES=" "-DKETTLE_LOG_SIZE_LIMIT=" "-DKETTLE_JNDI_ROOT=" -jar launcher\pentaho-application-launcher-7.0.0.0-25.jar -lib ..\libswt\win64  -main org.pentaho.di.pan.Pan -initialDir "D:\Program Files (x86)\F-KETTLE\data-integration"\ /file D:\Program Files (x86)\F-KETTLE\kettleFile\动态日期参数.ktr /level Basic /logfile D:\Program Files (x86)\F-KETTLE\ETL_LOG\timing.log
Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=256m; support was removed in 8.0
16:15:36,651 INFO  [KarafBoot] Checking to see if org.pentaho.clean.karaf.cache is enabled
16:15:42,826 INFO  [KarafInstance]
*******************************************************************************
*** Karaf Instance Number: 2 at D:\Program Files (x86)\F-KETTLE\data-integr ***
***   ation\.\system\karaf\caches\pan\data-1                                ***
*** Karaf Port:8803                                                         ***
*** OSGI Service Port:9052                                                  ***
*******************************************************************************
一月 20, 2021 4:15:43 下午 org.apache.karaf.main.Main$KarafLockCallback lockAquired
信息: Lock acquired. Setting startlevel to 100
2021-01-20 16:15:48.599:INFO:oejs.Server:jetty-8.1.15.v20140411
2021-01-20 16:15:48.684:INFO:oejs.AbstractConnector:Started NIOSocketConnectorWrapper@0.0.0.0:9052
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/core
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/configuration/beans
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/configuration/parameterized-types
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/configuration/security
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://schemas.xmlsoap.org/wsdl/
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://www.w3.org/2005/08/addressing
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://schemas.xmlsoap.org/ws/2004/08/addressing
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-management (149) [org.apache.cxf.management.InstrumentationManager]
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-ws-policy (198) [org.apache.cxf.ws.policy.PolicyEngine, org.apache.cxf.policy.PolicyDataEngine, org.apache.cxf.ws.policy.AssertionBuilderRegistry, org.apache.cxf.ws.policy.PolicyInterceptorProviderRegistry, org.apache.cxf.ws.policy.PolicyBuilder, org.apache.cxf.ws.policy.PolicyAnnotationListener, org.apache.cxf.ws.policy.attachment.ServiceModelPolicyProvider, org.apache.cxf.ws.policy.attachment.external.DomainExpressionBuilderRegistry, org.apache.cxf.ws.policy.attachment.external.EndpointReferenceDomainExpressionBuilder, org.apache.cxf.ws.policy.attachment.external.URIDomainExpressionBuilder, org.apache.cxf.ws.policy.attachment.wsdl11.Wsdl11AttachmentPolicyProvider, org.apache.cxf.ws.policy.mtom.MTOMAssertionBuilder, org.apache.cxf.ws.policy.mtom.MTOMPolicyInterceptorProvider]
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-wsdl (184) [org.apache.cxf.wsdl.WSDLManager]
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-transports-http (153) [org.apache.cxf.transport.http.HTTPTransportFactory, org.apache.cxf.transport.http.HTTPWSDLExtensionLoader, org.apache.cxf.transport.http.policy.HTTPClientAssertionBuilder, org.apache.cxf.transport.http.policy.HTTPServerAssertionBuilder, org.apache.cxf.transport.http.policy.NoOpPolicyInterceptorProvider]
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/transports/http/configuration
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-bindings-soap (187) [org.apache.cxf.binding.soap.SoapBindingFactory, org.apache.cxf.binding.soap.SoapTransportFactory]
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/jaxrs
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/jaxrs-client
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-bindings-xml (186) [org.apache.cxf.binding.xml.XMLBindingFactory, org.apache.cxf.binding.xml.wsdl11.XMLWSDLExtensionLoader]
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/bindings/soap
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/simple
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-frontend-jaxws (189) [org.apache.cxf.jaxws.context.WebServiceContextResourceResolver]
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/jaxws
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/binding/coloc
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-transports-local (194) [org.apache.cxf.transport.local.LocalTransportFactory]
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-bindings-object (195) [org.apache.cxf.binding.object.ObjectBindingFactory]
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/binding/object
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/policy
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://www.w3.org/ns/ws-policy
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://www.w3.org/2006/07/ws-policy
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://schemas.xmlsoap.org/ws/2004/09/policy
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://www.w3.org/2000/09/xmldsig#
一月 20, 2021 4:15:49 下午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://docs.oasis-open.org/ws-sx/ws-securitypolicy/200702
一月 20, 2021 4:15:50 下午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-ws-addr (215) [org.apache.cxf.ws.addressing.policy.AddressingAssertionBuilder, org.apache.cxf.ws.addressing.policy.UsingAddressingAssertionBuilder, org.apache.cxf.ws.addressing.policy.AddressingPolicyInterceptorProvider, org.apache.cxf.ws.addressing.impl.AddressingWSDLExtensionLoader, org.apache.cxf.ws.addressing.WSAddressingFeature$WSAddressingFeatureApplier, org.apache.cxf.ws.addressing.MAPAggregator$MAPAggregatorLoader]
一月 20, 2021 4:15:50 下午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/ws/addressing
一月 20, 2021 4:15:50 下午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-ws-security (217) [org.apache.cxf.ws.security.policy.WSSecurityPolicyLoader, org.apache.cxf.ws.security.cache.CacheCleanupListener]
一月 20, 2021 4:15:50 下午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-ws-rm (219) [org.apache.cxf.ws.rm.RMManager, org.apache.cxf.ws.rm.policy.RMPolicyInterceptorProvider, org.apache.cxf.ws.rm.policy.RM10AssertionBuilder, org.apache.cxf.ws.rm.policy.RM12AssertionBuilder, org.apache.cxf.ws.rm.policy.WSRMP12PolicyLoader, org.apache.cxf.ws.rm.policy.MC11PolicyLoader, org.apache.cxf.ws.rm.policy.RSPPolicyLoader]
一月 20, 2021 4:15:50 下午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://cxf.apache.org/ws/rm/manager
一月 20, 2021 4:15:50 下午 org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register
信息: Registered blueprint namespace handler for http://schemas.xmlsoap.org/ws/2005/02/rm/policy
一月 20, 2021 4:15:50 下午 org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions
信息: Adding the extensions from bundle org.apache.cxf.cxf-rt-javascript (220) [org.apache.cxf.javascript.JavascriptServerListener]
一月 20, 2021 4:15:50 下午 org.pentaho.caching.impl.PentahoCacheManagerFactory$RegistrationHandler$1 onSuccess
信息: New Caching Service registered
2021/01/20 16:15:51 - Pan - 日志级别 : 基本日志
2021/01/20 16:15:51 - Pan - 开始运行.
[Fatal Error] :1:1: Content is not allowed in prolog.
处理过程停止,由于错误:
Error reading information from input stream
Content is not allowed in prolog.

org.pentaho.di.core.exception.KettleXMLException:
Error reading information from input stream
Content is not allowed in prolog.

        at org.pentaho.di.core.xml.XMLHandler.loadXMLFile(XMLHandler.java:635)
        at org.pentaho.di.core.xml.XMLHandler.loadXMLFile(XMLHandler.java:559)
        at org.pentaho.di.core.xml.XMLHandler.loadXMLFile(XMLHandler.java:540)
        at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2724)
        at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2692)
        at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2669)
        at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2649)
        at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2614)
        at org.pentaho.di.trans.TransMeta.<init>(TransMeta.java:2577)
        at org.pentaho.di.pan.Pan.main(Pan.java:393)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92)
Caused by: org.xml.sax.SAXParseException; lineNumber: 1; columnNumber: 1; Content is not allowed in prolog.
        at org.apache.xerces.parsers.DOMParser.parse(Unknown Source)
        at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown Source)
        at javax.xml.parsers.DocumentBuilder.parse(DocumentBuilder.java:121)
        at org.pentaho.di.core.xml.XMLHandler.loadXMLFile(XMLHandler.java:612)
        ... 14 more

更新:忘记在哪看到的贴子了,可能是kettle的存储目录中包含括号的原因

将kettle文件换了个文件夹,直接放在了D盘,再重新修改bat文件内容,再运行就成功了

 

这是我的解决方法,希望对大家有用

### Kettle点击运行无反应的解决方案 当遇到Kettle点击运行无反应的问题时,可以从以下几个方面进行排查和解决: #### 1. JDK环境变量配置检查 确认系统的JDK环境变量是否正确配置。如果JDK未安装或者`JAVA_HOME`路径不正确,则可能导致Spoon.bat无法正常启动。可以通过命令行输入`java -version`来验证Java是否可用[^1]。 #### 2. JVM内存参数调整 默认情况下,Spoon.bat文件中定义了JVM的最大堆内存大小和其他相关参数。如果当前计算机的物理内存不足,可能会导致JVM初始化失败从而引发程序无响应。可以尝试降低这些值以适应较低规格的硬件条件。具体操作如下: 编辑位于Kettle根目录下的`sppon.bat`脚本文件,找到下面这一部分代码并做相应修改: ```batch if "%PENTAHO_DI_JAVA_OPTIONS%"=="" set PENTAHO_DI_JAVA_OPTIONS="-Xms512m" "-Xmx512m" "-XX:MaxPermSize=256m" ``` 这里我们将初始最小内存(`-Xms`)与最大允许使用的内存(`-Xmx`)均设为了更保守一些的数值即512MB而非原来的较高设定如1GB或更高[^3]。 #### 3. 日志查看定位错误原因 除了上述提到的方法之外还可以通过启用详细的日志记录功能进一步诊断潜在问题所在之处。这有助于发现任何隐藏于表面之下的异常状况比如类加载冲突或者是缺少某些必要的库文件等问题存在可能性较大时候采用这种方式尤为有效。要开启调试模式只需简单地向调用语句后面追加额外参数即可实现目的: ```batch call "%_PENTAJO_BIN_DIR%\set-pentaho-env.bat" %* "%_PENTAJO_JAVA%" -Dpentaho.installed.licenses.file="%USERPROFILE%\.pentaho\installedLicenses.xml" %PENTAHO_DI_JAVA_OPTIONS% -jar launcher.jar --log-level debug %* ``` 此更改会使得每次执行过程中产生的全部事件都被详细记录下来供后续分析使用[^2]。 综上所述,针对不同场景采取适当措施往往能够有效地解决问题.
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值