kettle执行job成功,Java执行kettle报错,求大神指导

[INFO,DoKettleService,http-bio-8080-exec-5] 执行kettle开始
[INFO,StandardFileSystemManager,http-bio-8080-exec-5] Using "C:\Users\ADMINI~1\AppData\Local\Temp\vfs_cache" as temporary files store.
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - 开始执行任务
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - 开始项[数据追溯]
2017/03/27 09:28:11 - cetl_001 - ERROR (version 1.0.0, build 1 from 2015-07-31 09.59.35 by chenrh) : 一个数据库错误发生在从资源库文件读取转换时
2017/03/27 09:28:11 - cetl_001 - org.pentaho.di.core.exception.KettlePluginLoaderException:
2017/03/27 09:28:11 - cetl_001 - Unable to load class for step/plugin with id [trace
2017/03/27 09:28:11 - cetl_001 - ]. Check if the plugin is available in the plugins subdirectory of the Kettle distribution.
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - ERROR (version 1.0.0, build 1 from 2015-07-31 09.59.35 by chenrh) : org.pentaho.di.core.exception.KettleException:
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - Unexpected error during transformation metadata load
2017/03/27 09:28:11 - JOB_GLOBAL_RUN -
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - 一个数据库错误发生在从资源库文件读取转换时
2017/03/27 09:28:11 - JOB_GLOBAL_RUN -
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - Unable to load class for step/plugin with id [trace
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - ]. Check if the plugin is available in the plugins subdirectory of the Kettle distribution.
2017/03/27 09:28:11 - JOB_GLOBAL_RUN -
2017/03/27 09:28:11 - JOB_GLOBAL_RUN -
2017/03/27 09:28:11 - JOB_GLOBAL_RUN -
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.pentaho.di.job.entries.trans.JobEntryTrans.getTransMeta(JobEntryTrans.java:1208)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.pentaho.di.job.entries.trans.JobEntryTrans.execute(JobEntryTrans.java:648)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.pentaho.di.job.Job.execute(Job.java:716)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.pentaho.di.job.Job.execute(Job.java:859)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.pentaho.di.job.Job.execute(Job.java:532)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.pentaho.di.job.Job.run(Job.java:424)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at com.wa.framework.quartz.service.DoKettleService.runJob(DoKettleService.java:52)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at com.wa.framework.quartz.service.DoKettleService$$FastClassBySpringCGLIB$$8a4f9c12.invoke()
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:708)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:262)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:644)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at com.wa.framework.quartz.service.DoKettleService$$EnhancerBySpringCGLIB$$3cedfde9.runJob()
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at com.udatech.common.taskManage.controller.CollectionTaskController.testDs(CollectionTaskController.java:310)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at java.lang.reflect.Method.invoke(Method.java:483)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:749)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:689)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:938)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:870)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:852)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at com.wa.framework.log.AccessLogFilter.doFilter(AccessLogFilter.java:121)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:230)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at com.wa.framework.security.XssAndSqlFilter.doFilter(XssAndSqlFilter.java:43)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at com.wa.framework.filter.SecurityFilter.doFilter(SecurityFilter.java:106)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
2017/03/27 09:28:11 - JOB_GLOBAL_RUN - at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)

1个回答

一直用informatica,对kettle不了解,无能为力,准备也学习下kettle,毕竟开源

qq_33653097
qq_33653097 你这斯说话,却似
10 天之前 回复
Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
其他相关推荐
kettle job执行调用问题

刚刚开始学习Kettle,对于一些问题不是很明白。kettle是一种ETL工具,它肯定是为ETL服务的,比如我现在就要根据业务需求对数据进行ETL,忽略其他步骤,只说用kettle对数据进行清洗,那么我肯定会写很多的job,写完了测试也完成了,项目上线了这些job怎么调用或者说执行啊?我现在只会写完一个start一个?主要是这里不明白,求大神解惑!!!http://ask.csdn.net/?ref=toolbar#

kettle直接执行hbase作业能成功,但通过java程序来执行时却报错

ERROR 13-12 17:04:32,359 - 174_kettle - 一个数据库错误发生在从资源库文件读取转换时 org.pentaho.di.core.exception.KettleStepLoaderException: Unable to load class for step/plugin with id [HBaseOutput ]. Check if the plugin is available in the plugins subdirectory of the Kettle distribution.

在程序中调用shell脚本执行kettle抽取报错

前提:服务器中间件用的是weblogic,操作系统用的是linux,kettle在服务器端执行抽取完全没有问题; 但是在程序中远程调用shell脚本执行却报错,以下是程序中调用代码: ... String[] command = { "/bin/sh", "-c", "XX.sh" }; Process ps = Runtime.getRuntime().exec(command); ... 报错信息为Error occured while trying to connect to the database! 已知:shell脚本路径没有问题、数据库一切正常、kettle数据库配置文件也没问题,kettle在服务器端执行抽取完全没有问题; 请各位大神帮忙分析下原因!谢谢! ![图片说明](https://img-ask.csdn.net/upload/201705/12/1494578158_306718.jpg)

在kettle的调试软件中执行没有问题,但是在java代码中调用就会报错,含有接口的调用。

![图片说明](https://img-ask.csdn.net/upload/201910/15/1571124184_733842.jpg) 这是我再调试器中的内容,然后用java代码调用这个任务的时候,就会报一下错误: ``` 2019/10/15 14:50:12 - JSON Input.0 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : 错误初始化步骤[JSON Input] 2019/10/15 14:50:12 - JSON Input.0 - ERROR (version 7.1.0.0-12, build 1 from 2017-05-16 17.18.02 by buildguy) : java.lang.NullPointerException 2019/10/15 14:50:12 - JSON Input.0 - at org.pentaho.di.trans.steps.fileinput.BaseFileInputStep.init(BaseFileInputStep.java:102) 2019/10/15 14:50:12 - JSON Input.0 - at org.pentaho.di.trans.step.StepInitThread.run(StepInitThread.java:69) 2019/10/15 14:50:12 - JSON Input.0 - at java.lang.Thread.run(Thread.java:745) ``` 我网上查找好像是因为转换里是并行执行的。所以会直接报空指针的错误。但是在调试器中为什么没有报错呢,是我java代码调用方式有问题吗?求大佬解惑 以下是我java调用代码:

Kettle7.0如何使用java执行一个转换的ktr文件

kettle-engine这个jar包中确实存在TransMeta.class,但是却缺少这个类,其他Trans,KettleEnvironment这些类也都存在。 是我jar包出错了,还是7.0不用TransMeta这个类了。最重要的是,Kettle7.0如何使用java执行一个转换的ktr文件。

kettle的JOB互相嵌套的作业,在windows上正常运行,迁移到Linux服务器就报错了

windows系统运行正常: ![图片说明](https://img-ask.csdn.net/upload/201907/29/1564389024_347344.png) Linux系统下运行报错: ``` /usr/local/kettle/data-integration/spoon.sh: line 140: ldconfig: command not found ####################################################################### WARNING: no libwebkitgtk-1.0 detected, some features will be unavailable Consider installing the package with apt-get or yum. e.g. 'sudo apt-get install libwebkitgtk-1.0-0' ####################################################################### Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=256m; support was removed in 8.0 log4j:WARN Continuable parsing error 45 and column 76 log4j:WARN Element type "rollingPolicy" must be declared. log4j:WARN Continuable parsing error 52 and column 14 log4j:WARN The content of element type "appender" must match "(errorHandler?,param*,layout?,filter*,appender-ref*)". log4j:WARN Please set a rolling policy for the RollingFileAppender named 'pdi-execution-appender' 16:11:29,469 INFO [KarafBoot] Checking to see if org.pentaho.clean.karaf.cache is enabled 16:11:29,646 INFO [KarafInstance] ******************************************************************************* *** Karaf Instance Number: 1 at /usr/local/kettle/data-integration/./system *** *** /karaf/caches/kitchen/data-1 *** *** FastBin Provider Port:52901 *** *** Karaf Port:8802 *** *** OSGI Service Port:9051 *** ******************************************************************************* Jul 29, 2019 4:11:32 PM org.apache.karaf.main.Main$KarafLockCallback lockAquired INFO: Lock acquired. Setting startlevel to 100 2019/07/29 16:11:36 - Kitchen - Start of run. 2019/07/29 16:11:36 - RepositoriesMeta - Reading repositories XML file: /usr/local/kettle/.kettle/repositories.xml 2019-07-29 16:11:53.034:INFO:oejs.Server:jetty-8.1.15.v20140411 2019-07-29 16:11:53.106:INFO:oejs.AbstractConnector:Started NIOSocketConnectorWrapper@0.0.0.0:9051 Jul 29, 2019 4:11:58 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register INFO: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/core Jul 29, 2019 4:11:58 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register INFO: Registered blueprint namespace handler for http://cxf.apache.org/configuration/beans Jul 29, 2019 4:11:58 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register INFO: Registered blueprint namespace handler for http://cxf.apache.org/configuration/parameterized-types Jul 29, 2019 4:11:58 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register INFO: Registered blueprint namespace handler for http://cxf.apache.org/configuration/security Jul 29, 2019 4:11:58 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register INFO: Registered blueprint namespace handler for http://schemas.xmlsoap.org/wsdl/ Jul 29, 2019 4:11:58 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register INFO: Registered blueprint namespace handler for http://www.w3.org/2005/08/addressing Jul 29, 2019 4:11:58 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register INFO: Registered blueprint namespace handler for http://schemas.xmlsoap.org/ws/2004/08/addressing Jul 29, 2019 4:11:58 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions INFO: Adding the extensions from bundle org.apache.cxf.cxf-rt-management (195) [org.apache.cxf.management.InstrumentationManager] Jul 29, 2019 4:11:59 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions INFO: Adding the extensions from bundle org.apache.cxf.cxf-rt-wsdl (198) [org.apache.cxf.wsdl.WSDLManager] Jul 29, 2019 4:11:59 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions INFO: Adding the extensions from bundle org.apache.cxf.cxf-rt-bindings-xml (200) [org.apache.cxf.binding.xml.XMLBindingFactory, org.apache.cxf.binding.xml.wsdl11.XMLWSDLExtensionLoader] Jul 29, 2019 4:11:59 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions INFO: Adding the extensions from bundle org.apache.cxf.cxf-rt-bindings-soap (201) [org.apache.cxf.binding.soap.SoapBindingFactory, org.apache.cxf.binding.soap.SoapTransportFactory] Jul 29, 2019 4:11:59 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register INFO: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/bindings/soap Jul 29, 2019 4:11:59 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions INFO: Adding the extensions from bundle org.apache.cxf.cxf-rt-transports-http (202) [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] Jul 29, 2019 4:11:59 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions INFO: Adding the extensions from bundle org.apache.cxf.cxf-rt-ws-policy (220) [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] Jul 29, 2019 4:11:59 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register INFO: Registered blueprint namespace handler for http://cxf.apache.org/transports/http/configuration Jul 29, 2019 4:11:59 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register INFO: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/simple Jul 29, 2019 4:11:59 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions INFO: Adding the extensions from bundle org.apache.cxf.cxf-rt-frontend-jaxws (204) [org.apache.cxf.jaxws.context.WebServiceContextResourceResolver] Jul 29, 2019 4:11:59 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register INFO: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/jaxws Jul 29, 2019 4:12:00 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register INFO: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/jaxrs Jul 29, 2019 4:12:00 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register INFO: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/jaxrs-client Jul 29, 2019 4:12:00 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register INFO: Registered blueprint namespace handler for http://cxf.apache.org/binding/coloc Jul 29, 2019 4:12:00 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions INFO: Adding the extensions from bundle org.apache.cxf.cxf-rt-transports-local (216) [org.apache.cxf.transport.local.LocalTransportFactory] Jul 29, 2019 4:12:00 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions INFO: Adding the extensions from bundle org.apache.cxf.cxf-rt-bindings-object (217) [org.apache.cxf.binding.object.ObjectBindingFactory] Jul 29, 2019 4:12:00 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register INFO: Registered blueprint namespace handler for http://cxf.apache.org/blueprint/binding/object Jul 29, 2019 4:12:00 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register INFO: Registered blueprint namespace handler for http://cxf.apache.org/policy Jul 29, 2019 4:12:00 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register INFO: Registered blueprint namespace handler for http://www.w3.org/ns/ws-policy Jul 29, 2019 4:12:00 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register INFO: Registered blueprint namespace handler for http://www.w3.org/2006/07/ws-policy Jul 29, 2019 4:12:00 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register INFO: Registered blueprint namespace handler for http://schemas.xmlsoap.org/ws/2004/09/policy Jul 29, 2019 4:12:00 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register INFO: Registered blueprint namespace handler for http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd Jul 29, 2019 4:12:00 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register INFO: Registered blueprint namespace handler for http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd Jul 29, 2019 4:12:00 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register INFO: Registered blueprint namespace handler for http://www.w3.org/2000/09/xmldsig# Jul 29, 2019 4:12:00 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register INFO: Registered blueprint namespace handler for http://docs.oasis-open.org/ws-sx/ws-securitypolicy/200702 Jul 29, 2019 4:12:00 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions INFO: Adding the extensions from bundle org.apache.cxf.cxf-rt-ws-addr (237) [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] Jul 29, 2019 4:12:00 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register INFO: Registered blueprint namespace handler for http://cxf.apache.org/ws/addressing Jul 29, 2019 4:12:01 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions INFO: Adding the extensions from bundle org.apache.cxf.cxf-rt-ws-security (239) [org.apache.cxf.ws.security.policy.WSSecurityPolicyLoader, org.apache.cxf.ws.security.cache.CacheCleanupListener] Jul 29, 2019 4:12:01 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions INFO: Adding the extensions from bundle org.apache.cxf.cxf-rt-ws-rm (241) [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] Jul 29, 2019 4:12:01 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register INFO: Registered blueprint namespace handler for http://cxf.apache.org/ws/rm/manager Jul 29, 2019 4:12:01 PM org.apache.cxf.bus.blueprint.NamespaceHandlerRegisterer register INFO: Registered blueprint namespace handler for http://schemas.xmlsoap.org/ws/2005/02/rm/policy Jul 29, 2019 4:12:01 PM org.apache.cxf.bus.osgi.CXFExtensionBundleListener addExtensions INFO: Adding the extensions from bundle org.apache.cxf.cxf-rt-javascript (242) [org.apache.cxf.javascript.JavascriptServerListener] Jul 29, 2019 4:12:01 PM org.pentaho.caching.impl.PentahoCacheManagerFactory$RegistrationHandler$1 onSuccess INFO: New Caching Service registered SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/usr/local/kettle/data-integration/launcher/../lib/slf4j-log4j12-1.7.7.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/usr/local/kettle/data-integration/plugins/pentaho-big-data-plugin/lib/slf4j-log4j12-1.7.7.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. SLF4J: Actual binding is of type [org.slf4j.impl.Log4jLoggerFactory] 2019/07/29 16:12:08 - test - Start of job execution log4j:ERROR No output stream or file set for the appender named [pdi-execution-appender]. 2019/07/29 16:12:08 - test - Starting entry [job1] 2019/07/29 16:12:08 - test - Launched job entry [job1] in parallel. 2019/07/29 16:12:08 - test - Starting entry [job2] 2019/07/29 16:12:08 - test - Launched job entry [job2] in parallel. 2019/07/29 16:12:08 - job2 - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : Error running job entry 'job' : 2019/07/29 16:12:08 - job1 - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : Error running job entry 'job' : 2019/07/29 16:12:08 - job2 - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : org.pentaho.di.core.exception.KettleException: 2019/07/29 16:12:08 - job2 - Unexpected error during job metadata load 2019/07/29 16:12:08 - job2 - at java.lang.Thread.run (Thread.java:748) 2019/07/29 16:12:08 - job2 - at org.pentaho.di.job.Job$1.run (Job.java:798) 2019/07/29 16:12:08 - job2 - at org.pentaho.di.job.Job.access$000 (Job.java:121) 2019/07/29 16:12:08 - job2 - at org.pentaho.di.job.Job.execute (Job.java:680) 2019/07/29 16:12:08 - job2 - at org.pentaho.di.job.entries.job.JobEntryJob.execute (JobEntryJob.java:667) 2019/07/29 16:12:08 - job2 - at org.pentaho.di.job.entries.job.JobEntryJob.getJobMeta (JobEntryJob.java:1343) 2019/07/29 16:12:08 - job2 - at org.pentaho.di.job.entries.job.JobEntryJob.getJobMeta (JobEntryJob.java:1381) 2019/07/29 16:12:08 - job2 - at org.pentaho.di.job.entries.job.JobEntryJob.getJobMetaFromRepository (JobEntryJob.java:1353) 2019/07/29 16:12:08 - job2 - 2019/07/29 16:12:08 - job2 - at org.pentaho.di.job.entries.job.JobEntryJob.getJobMeta(JobEntryJob.java:1421) 2019/07/29 16:12:08 - job2 - at org.pentaho.di.job.entries.job.JobEntryJob.getJobMeta(JobEntryJob.java:1343) 2019/07/29 16:12:08 - job2 - at org.pentaho.di.job.entries.job.JobEntryJob.execute(JobEntryJob.java:667) 2019/07/29 16:12:08 - job2 - at org.pentaho.di.job.Job.execute(Job.java:680) 2019/07/29 16:12:08 - job2 - at org.pentaho.di.job.Job.access$000(Job.java:121) 2019/07/29 16:12:08 - job2 - at org.pentaho.di.job.Job$1.run(Job.java:798) 2019/07/29 16:12:08 - job2 - at java.lang.Thread.run(Thread.java:748) 2019/07/29 16:12:08 - job2 - Caused by: java.lang.NullPointerException 2019/07/29 16:12:08 - job2 - at org.pentaho.di.job.entries.job.JobEntryJob.getJobMetaFromRepository(JobEntryJob.java:1353) 2019/07/29 16:12:08 - job2 - at org.pentaho.di.job.entries.job.JobEntryJob.getJobMeta(JobEntryJob.java:1381) 2019/07/29 16:12:08 - job2 - ... 6 more 2019/07/29 16:12:08 - job1 - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : org.pentaho.di.core.exception.KettleException: 2019/07/29 16:12:08 - job1 - Unexpected error during job metadata load 2019/07/29 16:12:08 - job1 - at java.lang.Thread.run (Thread.java:748) 2019/07/29 16:12:08 - job1 - at org.pentaho.di.job.Job$1.run (Job.java:798) 2019/07/29 16:12:08 - job1 - at org.pentaho.di.job.Job.access$000 (Job.java:121) 2019/07/29 16:12:08 - job1 - at org.pentaho.di.job.Job.execute (Job.java:680) 2019/07/29 16:12:08 - job1 - at org.pentaho.di.job.entries.job.JobEntryJob.execute (JobEntryJob.java:667) 2019/07/29 16:12:08 - job1 - at org.pentaho.di.job.entries.job.JobEntryJob.getJobMeta (JobEntryJob.java:1343) 2019/07/29 16:12:08 - job1 - at org.pentaho.di.job.entries.job.JobEntryJob.getJobMeta (JobEntryJob.java:1381) 2019/07/29 16:12:08 - job1 - at org.pentaho.di.job.entries.job.JobEntryJob.getJobMetaFromRepository (JobEntryJob.java:1353) 2019/07/29 16:12:08 - job1 - 2019/07/29 16:12:08 - job1 - at org.pentaho.di.job.entries.job.JobEntryJob.getJobMeta(JobEntryJob.java:1421) 2019/07/29 16:12:08 - job1 - at org.pentaho.di.job.entries.job.JobEntryJob.getJobMeta(JobEntryJob.java:1343) 2019/07/29 16:12:08 - job1 - at org.pentaho.di.job.entries.job.JobEntryJob.execute(JobEntryJob.java:667) 2019/07/29 16:12:08 - job1 - at org.pentaho.di.job.Job.execute(Job.java:680) 2019/07/29 16:12:08 - job1 - at org.pentaho.di.job.Job.access$000(Job.java:121) 2019/07/29 16:12:08 - job1 - at org.pentaho.di.job.Job$1.run(Job.java:798) 2019/07/29 16:12:08 - job1 - at java.lang.Thread.run(Thread.java:748) 2019/07/29 16:12:08 - job1 - Caused by: java.lang.NullPointerException 2019/07/29 16:12:08 - job1 - at org.pentaho.di.job.entries.job.JobEntryJob.getJobMetaFromRepository(JobEntryJob.java:1353) 2019/07/29 16:12:08 - job1 - at org.pentaho.di.job.entries.job.JobEntryJob.getJobMeta(JobEntryJob.java:1381) 2019/07/29 16:12:08 - job1 - ... 6 more 2019/07/29 16:12:08 - test - Job execution finished 2019/07/29 16:12:08 - Kitchen - Finished! 2019/07/29 16:12:08 - Kitchen - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : Finished with errors 2019/07/29 16:12:08 - Kitchen - Start=2019/07/29 16:11:36.193, Stop=2019/07/29 16:12:08.071 2019/07/29 16:12:08 - Kitchen - Processing ended after 31 seconds. ``` Linux环境运行作业调用转换的就没问题,作业调用作业的就报错,望大神指点,哪儿有问题。 kettle版本为8.2,jdk版本为 java version "1.8.0_171" 如果需要什么其他的参数,我再上传

kettle Job调用转换问题

![图片说明](https://img-ask.csdn.net/upload/201903/31/1554034983_886203.png) 图中的转换中已经测试过没有问题,可以同步数据,但是将这个转换放到job中 执行job,不到1秒就执行完成,但是查看库中数据,起始并没有执行这个转换,似乎知识界面上显示成功而已,请问这个怎么回事

使用java调用kettle执行sql的删除语句来删除数据改怎么解决

现在有一个需求,需要使用java代码来调用kettle来执行根据sql来执行数据库的删除功能,请问具体代码该怎么实现??

linux 下 kettle Job 日志文件问题

启动脚本是 ``` /opt/kettle/data-integration/kitchen.sh -file=/opt/kettle/Job/syncToGreenCloud.kjb -level=basic >> /opt/kettle/rLog/syn_$(date +%Y%m%d).log & ``` JOB是每10分钟执行一次,日志的时间没有变过,永远在一个日志文件中,文件越来越大,占用资源。 如何能够将每次定时开启之前的日志清空。

linux 下kettle执行mysql抽数到oracle的job问题报错

![图片说明](https://img-ask.csdn.net/upload/201811/21/1542797604_216018.jpg) mysql驱动包已放在\data-integration\lib以及jdbc/driver 执行job报错。 驱动版本 5.1.47 kettle版本 7.1

执行java -jar命令后报错

![![图片说明](https://img-ask.csdn.net/upload/201501/11/1420969585_5509.jpg)图片说明](https://img-ask.csdn.net/upload/201501/11/1420969573_2580.png)

kettle循环执行job内存溢出

循环分页查询一天的数据,每页1000条,1000个ID拼成串并设置为变量,供后边查询使用,kettle版本7.1,尝试过调大内存,还是不行。也会触发gc,但是经历新生代后进入老年代,直到撑爆堆内存,jdk版本1.8

kettle 利用命令执行向haf's写数据的转换没有报错,但写入不了数据是什么原因。

网上好多关于kettle 连接hadoop上传文件的教程,但都是在windows下运行spoon.bat 通过界面实现的。我这也可以通过界面上传文件到hadoop的hafs上。但通过命令行执行 转换脚本,或者JAVA程序调用转换脚本时,就无法实现文件上传,但运行没有保错,有 kettle大神帮忙解答一下不?

kettle job中是否可以输出错误日志到文件中?

想将job中错误日志输出到.txt文件,应该怎么做? ![图片说明](https://img-ask.csdn.net/upload/201811/22/1542872916_44350.png)

在linux下通过kitchen.sh运行job报错,求各路大神指点

2017/05/03 03:57:31 - Kitchen - Logging is at level : Basic logging 2017/05/03 03:57:31 - Kitchen - Start of run. 2017/05/03 03:57:31 - RepositoriesMeta - Reading repositories XML file: /root/.kettle/repositories.xml Processing stopped because of an error: An error occured loading the directory tree from the repository Error loading a repository directory ERROR executing query Error determining value metadata from SQL resultset metadata at org.pentaho.commons.launcher.Launcher.main (Launcher.java:92) at java.lang.reflect.Method.invoke (Method.java:606) at sun.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:43) at sun.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:57) at sun.reflect.NativeMethodAccessorImpl.invoke0 (NativeMethodAccessorImpl.java:-2) at org.pentaho.di.kitchen.Kitchen.main (Kitchen.java:313) at org.pentaho.di.repository.kdr.KettleDatabaseRepository.loadRepositoryDirectoryTree (KettleDatabaseRepository.java:536) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryDirectoryDelegate.loadRepositoryDirectoryTree (KettleDatabaseRepositoryDirectoryDelegate.java:101) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryDirectoryDelegate.loadRepositoryDirectory (KettleDatabaseRepositoryDirectoryDelegate.java:119) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryDirectoryDelegate.getDirectory (KettleDatabaseRepositoryDirectoryDelegate.java:48) at org.pentaho.di.repository.kdr.delegates.KettleDatabaseRepositoryConnectionDelegate.getOneRow (KettleDatabaseRepositoryConnectionDelegate.java:1811) at org.pentaho.di.core.database.Database.openQuery (Database.java:1743) at org.pentaho.di.core.database.Database.getRowInfo (Database.java:2197) at org.pentaho.di.core.database.Database.getValueFromSQLType (Database.java:2251) at org.pentaho.di.core.row.value.ValueMetaBase.getValueFromSQLType (ValueMetaBase.java:4548) at org.pentaho.di.core.row.value.ValueMetaFactory.createValueMeta (ValueMetaFactory.java:57) at org.pentaho.di.core.row.value.ValueMetaFactory.createValueMeta (ValueMetaFactory.java:46) at org.pentaho.di.core.plugins.PluginRegistry.getPlugin (PluginRegistry.java:275) at org.pentaho.di.core.plugins.PluginRegistry.getPlugins (PluginRegistry.java:244) at java.util.HashMap$KeyIterator.next (HashMap.java:928) at java.util.HashMap$HashIterator.nextEntry (HashMap.java:894) ERROR: Kitchen can't continue because the job couldn't be loaded.

Kettle DB连接报错,InvocationTargetException

kettle 新手,刚刚下载好kettle后想要连接数据库,却出现如下bao'cuo org.pentaho.ui.xul.XulException: org.pentaho.ui.xul.XulException: java.lang.reflect.InvocationTargetException at org.pentaho.ui.xul.impl.AbstractXulLoader.loadXul(AbstractXulLoader.java:144) at org.pentaho.ui.xul.swt.SwtXulLoader.loadXul(SwtXulLoader.java:127) at org.pentaho.ui.xul.swt.SwtXulLoader.loadXul(SwtXulLoader.java:121) at org.pentaho.ui.xul.impl.AbstractXulLoader.loadXul(AbstractXulLoader.java:252) at org.pentaho.ui.database.DatabaseConnectionDialog.getSwtInstance(DatabaseConnectionDialog.java:56) at org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.createDialog(XulDatabaseDialog.java:144) at org.pentaho.di.ui.core.database.dialog.XulDatabaseDialog.open(XulDatabaseDialog.java:105) at org.pentaho.di.ui.core.database.dialog.DatabaseDialog.open(DatabaseDialog.java:59) at org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.newConnection(SpoonDBDelegate.java:464) at org.pentaho.di.ui.spoon.delegates.SpoonDBDelegate.newConnection(SpoonDBDelegate.java:451) at org.pentaho.di.ui.spoon.Spoon.newConnection(Spoon.java:8728) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:567) at org.pentaho.ui.xul.impl.AbstractXulDomContainer.invoke(AbstractXulDomContainer.java:313) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:157) at org.pentaho.ui.xul.impl.AbstractXulComponent.invoke(AbstractXulComponent.java:141) at org.pentaho.ui.xul.jface.tags.JfaceMenuitem.access$100(JfaceMenuitem.java:43) at org.pentaho.ui.xul.jface.tags.JfaceMenuitem$1.run(JfaceMenuitem.java:106) at org.eclipse.jface.action.Action.runWithEvent(Action.java:498) at org.eclipse.jface.action.ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:545) at org.eclipse.jface.action.ActionContributionItem.access$2(ActionContributionItem.java:490) at org.eclipse.jface.action.ActionContributionItem$5.handleEvent(ActionContributionItem.java:402) at org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source) at org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source) at org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source) at org.pentaho.di.ui.spoon.Spoon.readAndDispatch(Spoon.java:1319) at org.pentaho.di.ui.spoon.Spoon.waitForDispose(Spoon.java:7939) at org.pentaho.di.ui.spoon.Spoon.start(Spoon.java:9190) at org.pentaho.di.ui.spoon.Spoon.main(Spoon.java:654) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:567) at org.pentaho.commons.launcher.Launcher.main(Launcher.java:92) Caused by: org.pentaho.ui.xul.XulException: java.lang.reflect.InvocationTargetException at org.pentaho.ui.xul.impl.XulParser.getElement(XulParser.java:239) at org.pentaho.ui.xul.impl.XulParser.parse(XulParser.java:164) at org.pentaho.ui.xul.impl.XulParser.parseDocument(XulParser.java:85) at org.pentaho.ui.xul.impl.AbstractXulLoader.loadXul(AbstractXulLoader.java:136) ... 36 more Caused by: java.lang.reflect.InvocationTargetException at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:567) at org.apache.commons.beanutils.PropertyUtilsBean.invokeMethod(PropertyUtilsBean.java:2155) at org.apache.commons.beanutils.PropertyUtilsBean.setSimpleProperty(PropertyUtilsBean.java:2141) at org.apache.commons.beanutils.PropertyUtilsBean.setNestedProperty(PropertyUtilsBean.java:1948) at org.apache.commons.beanutils.PropertyUtilsBean.setProperty(PropertyUtilsBean.java:2054) at org.apache.commons.beanutils.BeanUtilsBean.setProperty(BeanUtilsBean.java:1015) at org.apache.commons.beanutils.BeanUtilsBean.populate(BeanUtilsBean.java:830) at org.apache.commons.beanutils.BeanUtils.populate(BeanUtils.java:433) at org.pentaho.ui.xul.impl.XulParser.getElement(XulParser.java:235) ... 39 more Caused by: java.lang.ClassCastException: class [Ljava.lang.Object; cannot be cast to class [Ljava.lang.String; ([Ljava.lang.Object; and [Ljava.lang.String; are in module java.base of loader 'bootstrap') at org.pentaho.ui.xul.swt.tags.SwtDialog.setButtons(SwtDialog.java:268) ... 51 more

kettle预览报错,但是数据却能执行成功,这是怎么回事呢

2018/10/01 19:26:07 - 放贷明细表 - 转换已经从资源库预先载入. 2018/10/01 19:26:07 - Spoon - 转换已经打开. 2018/10/01 19:26:07 - Spoon - 正在打开转换 [放贷明细表]... 2018/10/01 19:26:07 - Spoon - 开始执行转换. 2018/10/01 19:26:07 - 放贷明细表 - 为了转换解除补丁开始 [放贷明细表] 2018/10/01 19:26:07 - 放贷明细表 - 已经找到的参数数量:0 2018/10/01 19:26:07 - 放贷明细表 - 这没有一个重放的转换 2018/10/01 19:26:07 - 放贷明细表 - 我找到 2 个不同的要执行的步骤. 2018/10/01 19:26:07 - 放贷明细表 - 分派记录集... 2018/10/01 19:26:07 - 放贷明细表 - 正在分配行组为步骤 0 --> 放贷明细表-新逻辑 2018/10/01 19:26:07 - 放贷明细表 - 前一个副本 = 1, 下一个副本=1 2018/10/01 19:26:07 - 放贷明细表 - 转换分配了新的行组 [放贷明细表-新逻辑.0 - Microsoft Excel 输出 2 2.0] 2018/10/01 19:26:07 - 放贷明细表 - 已分配 1 行组为步骤 0 --> 放贷明细表-新逻辑 2018/10/01 19:26:07 - 放贷明细表 - 正在分配行组为步骤 1 --> Microsoft Excel 输出 2 2 2018/10/01 19:26:07 - 放贷明细表 - 已分配 1 行组为步骤 1 --> Microsoft Excel 输出 2 2 2018/10/01 19:26:07 - 放贷明细表 - 正在分配步骤和步骤数据... 2018/10/01 19:26:07 - 放贷明细表 - 转换大约分配了 步骤 [放贷明细表-新逻辑] 类型的 [TableInput] 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - 分散被激活 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - Starting allocation of buffers & new threads... 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - 步骤信息: 输入数量=0 输出数量=1 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - output rel. is 1:1 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - 发现输出 rowset [放贷明细表-新逻辑.0 - Microsoft Excel 输出 2 2.0] 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - 完成分发 2018/10/01 19:26:07 - 放贷明细表 - 转换已经分配了一个新的步骤: [放贷明细表-新逻辑].0 2018/10/01 19:26:07 - 放贷明细表 - 转换大约分配了 步骤 [Microsoft Excel 输出 2 2] 类型的 [TypeExitExcelWriterStep] 2018/10/01 19:26:07 - Microsoft Excel 输出 2 2.0 - 分散被激活 2018/10/01 19:26:07 - Microsoft Excel 输出 2 2.0 - Starting allocation of buffers & new threads... 2018/10/01 19:26:07 - Microsoft Excel 输出 2 2.0 - 步骤信息: 输入数量=1 输出数量=0 2018/10/01 19:26:07 - Microsoft Excel 输出 2 2.0 - 获取来自前一步骤 [Microsoft Excel 输出 2 2] #0 --> 放贷明细表-新逻辑 2018/10/01 19:26:07 - Microsoft Excel 输出 2 2.0 - input rel is 1:1 2018/10/01 19:26:07 - Microsoft Excel 输出 2 2.0 - 发现输入记录集合 [放贷明细表-新逻辑.0 - Microsoft Excel 输出 2 2.0] 2018/10/01 19:26:07 - Microsoft Excel 输出 2 2.0 - 完成分发 2018/10/01 19:26:07 - 放贷明细表 - 转换已经分配了一个新的步骤: [Microsoft Excel 输出 2 2].0 2018/10/01 19:26:07 - 放贷明细表 - 这项转换可以被回放 回放日期是: 2018/10/01 19:26:07 2018/10/01 19:26:07 - 放贷明细表 - 正在初始化 2 步骤... 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - Released server socket on port 0 2018/10/01 19:26:07 - Microsoft Excel 输出 2 2.0 - Released server socket on port 0 2018/10/01 19:26:07 - sqlserver - New database connection defined 2018/10/01 19:26:07 - sqlserver - Auto commit off 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - Connected to database... 2018/10/01 19:26:07 - 放贷明细表 - 步骤 [放贷明细表-新逻辑.0] 初始化不完全,有缺陷. 2018/10/01 19:26:07 - 放贷明细表 - 步骤 [Microsoft Excel 输出 2 2.0] 初始化不完全,有缺陷. 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - 开始运行... 2018/10/01 19:26:07 - Microsoft Excel 输出 2 2.0 - 开始运行... 2018/10/01 19:26:07 - 放贷明细表 - 转换已经分配了 2 线程 和 1 列组. 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - SQL query : 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - DECLARE @BEGINDATE DATE=DATEADD(mm, DATEDIFF(mm,0,getdate())-1 , 0) --改 上月月初 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - ,@ENDDATE DATE=DATEADD(mm, DATEDIFF(mm,0,getdate()), 0); --改 本月月初 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - SELECT A.BusinessID AS [业务号] 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - ,A.ContractNo AS [合同号] 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - ,B.name AS [户名] 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - ,CASE WHEN A.ProductType=62 AND E.MultiCapitalFlag=1 THEN E.LoanCapitalB ELSE A.LoanCapital END AS [合同金额] 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - ,CONVERT(VARCHAR(10),A.LoanTime,120) AS [放款日期] 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - ,ISNULL(A.EvaluationCost,0) AS [评估费] 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - ,A.ProceduresAmout AS [手续费] 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - ,CASE WHEN D.Name IN ('百度借现金','借趣花') THEN ([VcreditDW].dbo.YearInerterate(A.LoanCapital,A.LoanPeriod,A.DayRate)/12)*100 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - WHEN A.LoanKind in ('LOANKIND/TYSUIYIJIE') 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - then (VcreditDW.dbo.PMTS(A.InterestRate,A.LoanPeriod,A.LoanCapital)/12)*100 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - ELSE 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - CASE WHEN A.InterestRate=0 THEN A.DayRate*30*100 ELSE A.InterestRate * 100 END 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - END AS [利率] 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - ,A.ProceduresRate * 100 AS [手续费率] 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - ,A.LoanPeriod AS [贷款期限] 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - ,ISNULL(D.Name,'') AS [产品名称] 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - FROM PostLoan.dbo.Business A 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - LEFT JOIN loan.[check].applyinfoCustomer B 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - ON A.businessid=B.bid 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - LEFT JOIN [Sys].common.EnumerationAll D 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - ON A.LoanKind=D.FullKey 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - JOIN PostLoan.dbo.BusinessExtend AS E WITH(NOLOCK) 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - ON A.BusinessID=E.BusinessID 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - WHERE A.LendingSideKey IN('COMPANY/WX_CDWS_LENDING','COMPANY/BHB_LENDING') 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - AND A.LoanTime>= @BEGINDATE AND A.LoanTime<@ENDDATE 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - AND A.Operable =1 2018/10/01 19:26:07 - 放贷明细表-新逻辑.0 - and D.Name<>'甜橙白条' 2018/10/01 19:26:13 - 放贷明细表-新逻辑.0 - Finished reading query, closing connection. 2018/10/01 19:26:13 - sqlserver - Connection to database closed! 2018/10/01 19:26:13 - 放贷明细表-新逻辑.0 - 完成处理 (I=20241, O=0, R=0, W=20241, U=0, E=0) 2018/10/01 19:26:14 - Microsoft Excel 输出 2 2.0 - 完成处理 (I=0, O=20242, R=20241, W=20241, U=0, E=0) 2018/10/01 19:26:14 - Spoon - 转换完成!! ``` ```

Kettle连接mysql数据库报错Failed to execute runnable (java.lang.NullPointerException)

Kettle连接mysql数据库点击确认时报错Failed to execute runnable (java.lang.NullPointerException)该怎么办呀 ![图片说明](https://img-ask.csdn.net/upload/202004/24/1587710084_31337.jpg)

kettle作业中的运行结果怎样输出

请教下,各位大神,kettle作业流程中的节点运行怎么输出!

学Python后到底能干什么?网友:我太难了

感觉全世界营销文都在推Python,但是找不到工作的话,又有哪个机构会站出来给我推荐工作? 笔者冷静分析多方数据,想跟大家说:关于超越老牌霸主Java,过去几年间Python一直都被寄予厚望。但是事实是虽然上升趋势,但是国内环境下,一时间是无法马上就超越Java的,也可以换句话说:超越Java只是时间问题罢。 太嚣张了会Python的人!找工作拿高薪这么简单? https://edu....

在中国程序员是青春饭吗?

今年,我也32了 ,为了不给大家误导,咨询了猎头、圈内好友,以及年过35岁的几位老程序员……舍了老脸去揭人家伤疤……希望能给大家以帮助,记得帮我点赞哦。 目录: 你以为的人生 一次又一次的伤害 猎头界的真相 如何应对互联网行业的「中年危机」 一、你以为的人生 刚入行时,拿着傲人的工资,想着好好干,以为我们的人生是这样的: 等真到了那一天,你会发现,你的人生很可能是这样的: ...

为什么程序猿都不愿意去外包?

分享外包的组织架构,盈利模式,亲身经历,以及根据一些外包朋友的反馈,写了这篇文章 ,希望对正在找工作的老铁有所帮助

Java校招入职华为,半年后我跑路了

何来 我,一个双非本科弟弟,有幸在 19 届的秋招中得到前东家华为(以下简称 hw)的赏识,当时秋招签订就业协议,说是入了某 java bg,之后一系列组织架构调整原因等等让人无法理解的神操作,最终毕业前夕,被通知调往其他 bg 做嵌入式开发(纯 C 语言)。 由于已至于校招末尾,之前拿到的其他 offer 又无法再收回,一时感到无力回天,只得默默接受。 毕业后,直接入职开始了嵌入式苦旅,由于从未...

Java基础知识面试题(2020最新版)

文章目录Java概述何为编程什么是Javajdk1.5之后的三大版本JVM、JRE和JDK的关系什么是跨平台性?原理是什么Java语言有哪些特点什么是字节码?采用字节码的最大好处是什么什么是Java程序的主类?应用程序和小程序的主类有何不同?Java应用程序与小程序之间有那些差别?Java和C++的区别Oracle JDK 和 OpenJDK 的对比基础语法数据类型Java有哪些数据类型switc...

@程序员:GitHub这个项目快薅羊毛

今天下午在朋友圈看到很多人都在发github的羊毛,一时没明白是怎么回事。 后来上百度搜索了一下,原来真有这回事,毕竟资源主义的羊毛不少啊,1000刀刷爆了朋友圈!不知道你们的朋友圈有没有看到类似的消息。 这到底是啥情况? 微软开发者平台GitHub 的一个区块链项目 Handshake ,搞了一个招募新会员的活动,面向GitHub 上前 25万名开发者派送 4,246.99 HNS币,大约价...

用python打开电脑摄像头,并把图像传回qq邮箱【Pyinstaller打包】

前言: 如何悄悄的打开朋友的摄像头,看看她最近过的怎么样,嘿嘿!这次让我带你们来实现这个功能。 注: 这个程序仅限在朋友之间开玩笑,别去搞什么违法的事情哦。 代码 发送邮件 使用python内置的email模块即可完成。导入相应的代码封装为一个send函数,顺便导入需要导入的包 注: 下面的代码有三处要修改的地方,两处写的qq邮箱地址,还有一处写的qq邮箱授权码,不知道qq邮箱授权码的可以去百度一...

做了5年运维,靠着这份监控知识体系,我从3K变成了40K

从来没讲过运维,因为我觉得运维这种东西不需要太多的知识面,然后我一个做了运维朋友告诉我大错特错,他就是从3K的运维一步步到40K的,甚至笑着说:我现在感觉自己什么都能做。 既然讲,就讲最重要的吧。 监控是整个运维乃至整个产品生命周期中最重要的一环,事前及时预警发现故障,事后提供详实的数据用于追查定位问题。目前业界有很多不错的开源产品可供选择。选择一款开源的监控系统,是一个省时省力、效率最高的方...

C++(继承):19---虚基类与虚继承(virtual)

一、菱形继承 在介绍虚继承之前介绍一下菱形继承 概念:A作为基类,B和C都继承与A。最后一个类D又继承于B和C,这样形式的继承称为菱形继承 菱形继承的缺点: 数据冗余:在D中会保存两份A的内容 访问不明确(二义性):因为D不知道是以B为中介去访问A还是以C为中介去访问A,因此在访问某些成员的时候会发生二义性 缺点的解决: 数据冗余:通过下面“虚继承”技术来解决(见下) 访问...

再不跳槽,应届毕业生拿的都比我多了!

跳槽几乎是每个人职业生涯的一部分,很多HR说“三年两跳”已经是一个跳槽频繁与否的阈值了,可为什么市面上有很多程序员不到一年就跳槽呢?他们不担心影响履历吗? PayScale之前发布的**《员工最短任期公司排行榜》中,两家码农大厂Amazon和Google**,以1年和1.1年的员工任期中位数分列第二、第四名。 PayScale:员工最短任期公司排行榜 意外的是,任期中位数极小的这两家公司,薪资...

我以为我学懂了数据结构,直到看了这个导图才发现,我错了

数据结构与算法思维导图

技术大佬:我去,你写的 switch 语句也太老土了吧

昨天早上通过远程的方式 review 了两名新来同事的代码,大部分代码都写得很漂亮,严谨的同时注释也很到位,这令我非常满意。但当我看到他们当中有一个人写的 switch 语句时,还是忍不住破口大骂:“我擦,小王,你丫写的 switch 语句也太老土了吧!” 来看看小王写的代码吧,看完不要骂我装逼啊。 private static String createPlayer(PlayerTypes p...

华为初面+综合面试(Java技术面)附上面试题

华为面试整体流程大致分为笔试,性格测试,面试,综合面试,回学校等结果。笔试来说,华为的难度较中等,选择题难度和网易腾讯差不多。最后的代码题,相比下来就简单很多,一共3道题目,前2题很容易就AC,题目已经记不太清楚,不过难度确实不大。最后一题最后提交的代码过了75%的样例,一直没有发现剩下的25%可能存在什么坑。 笔试部分太久远,我就不怎么回忆了。直接将面试。 面试 如果说腾讯的面试是挥金如土...

和黑客斗争的 6 天!

互联网公司工作,很难避免不和黑客们打交道,我呆过的两家互联网公司,几乎每月每天每分钟都有黑客在公司网站上扫描。有的是寻找 Sql 注入的缺口,有的是寻找线上服务器可能存在的漏洞,大部分都...

讲一个程序员如何副业月赚三万的真实故事

loonggg读完需要3分钟速读仅需 1 分钟大家好,我是你们的校长。我之前讲过,这年头,只要肯动脑,肯行动,程序员凭借自己的技术,赚钱的方式还是有很多种的。仅仅靠在公司出卖自己的劳动时...

win10暴力查看wifi密码

刚才邻居打了个电话说:喂小灰,你家wifi的密码是多少,我怎么连不上了。 我。。。 我也忘了哎,就找到了一个好办法,分享给大家: 第一种情况:已经连接上的wifi,怎么知道密码? 打开:控制面板\网络和 Internet\网络连接 然后右击wifi连接的无线网卡,选择状态 然后像下图一样: 第二种情况:前提是我不知道啊,但是我以前知道密码。 此时可以利用dos命令了 1、利用netsh wlan...

上班一个月,后悔当初着急入职的选择了

最近有个老铁,告诉我说,上班一个月,后悔当初着急入职现在公司了。他之前在美图做手机研发,今年美图那边今年也有一波组织优化调整,他是其中一个,在协商离职后,当时捉急找工作上班,因为有房贷供着,不能没有收入来源。所以匆忙选了一家公司,实际上是一个大型外包公司,主要派遣给其他手机厂商做外包项目。**当时承诺待遇还不错,所以就立马入职去上班了。但是后面入职后,发现薪酬待遇这块并不是HR所说那样,那个HR自...

女程序员,为什么比男程序员少???

昨天看到一档综艺节目,讨论了两个话题:(1)中国学生的数学成绩,平均下来看,会比国外好?为什么?(2)男生的数学成绩,平均下来看,会比女生好?为什么?同时,我又联想到了一个技术圈经常讨...

总结了 150 余个神奇网站,你不来瞅瞅吗?

原博客再更新,可能就没了,之后将持续更新本篇博客。

副业收入是我做程序媛的3倍,工作外的B面人生是怎样的?

提到“程序员”,多数人脑海里首先想到的大约是:为人木讷、薪水超高、工作枯燥…… 然而,当离开工作岗位,撕去层层标签,脱下“程序员”这身外套,有的人生动又有趣,马上展现出了完全不同的A/B面人生! 不论是简单的爱好,还是正经的副业,他们都干得同样出色。偶尔,还能和程序员的特质结合,产生奇妙的“化学反应”。 @Charlotte:平日素颜示人,周末美妆博主 大家都以为程序媛也个个不修边幅,但我们也许...

MySQL数据库面试题(2020最新版)

文章目录数据库基础知识为什么要使用数据库什么是SQL?什么是MySQL?数据库三大范式是什么mysql有关权限的表都有哪几个MySQL的binlog有有几种录入格式?分别有什么区别?数据类型mysql有哪些数据类型引擎MySQL存储引擎MyISAM与InnoDB区别MyISAM索引与InnoDB索引的区别?InnoDB引擎的4大特性存储引擎选择索引什么是索引?索引有哪些优缺点?索引使用场景(重点)...

女朋友过生日,我花了20分钟给她写了一个代理服务器

女朋友说:“看你最近挺辛苦的,我送你一个礼物吧。你看看想要什么,我来准备。” 我想了半天,从书到鞋子到电子产品最后到生活用品,感觉自己什么都不缺,然后和她说:“你省省钱吧,我什么都不需要。” 她坚持要送:“不行,你一定要说一个礼物,我想送你东西了。” 于是,我认真了起来,拿起手机,上淘宝逛了几分钟,但还是没能想出来缺点什么,最后实在没办法了:“这样吧,如果你实在想送东西,那你就写一个代理服务器吧”...

记一次腾讯面试,我挂在了最熟悉不过的队列上……

腾讯后台面试,面试官问:如何自己实现队列?

如果你是老板,你会不会踢了这样的员工?

有个好朋友ZS,是技术总监,昨天问我:“有一个老下属,跟了我很多年,做事勤勤恳恳,主动性也很好。但随着公司的发展,他的进步速度,跟不上团队的步伐了,有点...

我入职阿里后,才知道原来简历这么写

私下里,有不少读者问我:“二哥,如何才能写出一份专业的技术简历呢?我总感觉自己写的简历太烂了,所以投了无数份,都石沉大海了。”说实话,我自己好多年没有写过简历了,但我认识的一个同行,他在阿里,给我说了一些他当年写简历的方法论,我感觉太牛逼了,实在是忍不住,就分享了出来,希望能够帮助到你。 01、简历的本质 作为简历的撰写者,你必须要搞清楚一点,简历的本质是什么,它就是为了来销售你的价值主张的。往深...

程序员写出这样的代码,能不挨骂吗?

当你换槽填坑时,面对一个新的环境。能够快速熟练,上手实现业务需求是关键。但是,哪些因素会影响你快速上手呢?是原有代码写的不够好?还是注释写的不够好?昨夜...

带了6个月的徒弟当了面试官,而身为高级工程师的我天天修Bug......

即将毕业的应届毕业生一枚,现在只拿到了两家offer,但最近听到一些消息,其中一个offer,我这个组据说客户很少,很有可能整组被裁掉。 想问大家: 如果我刚入职这个组就被裁了怎么办呢? 大家都是什么时候知道自己要被裁了的? 面试软技能指导: BQ/Project/Resume 试听内容: 除了刷题,还有哪些技能是拿到offer不可或缺的要素 如何提升面试软实力:简历, 行为面试,沟通能...

!大部分程序员只会写3年代码

如果世界上都是这种不思进取的软件公司,那别说大部分程序员只会写 3 年代码,恐怕就没有程序员这种职业。

离职半年了,老东家又发 offer,回不回?

有小伙伴问松哥这个问题,他在上海某公司,在离职了几个月后,前公司的领导联系到他,希望他能够返聘回去,他很纠结要不要回去? 俗话说好马不吃回头草,但是这个小伙伴既然感到纠结了,我觉得至少说明了两个问题:1.曾经的公司还不错;2.现在的日子也不是很如意。否则应该就不会纠结了。 老实说,松哥之前也有过类似的经历,今天就来和小伙伴们聊聊回头草到底吃不吃。 首先一个基本观点,就是离职了也没必要和老东家弄的苦...

2020阿里全球数学大赛:3万名高手、4道题、2天2夜未交卷

阿里巴巴全球数学竞赛( Alibaba Global Mathematics Competition)由马云发起,由中国科学技术协会、阿里巴巴基金会、阿里巴巴达摩院共同举办。大赛不设报名门槛,全世界爱好数学的人都可参与,不论是否出身数学专业、是否投身数学研究。 2020年阿里巴巴达摩院邀请北京大学、剑桥大学、浙江大学等高校的顶尖数学教师组建了出题组。中科院院士、美国艺术与科学院院士、北京国际数学...

立即提问
相关内容推荐