设为首页收藏本站 开启辅助访问
 找回密码
 立即注册

QQ登录

只需一步,快速开始

用新浪微博登录

只需一步,快速搞定

楼主: 小白

Kettle商业智能管理平台-更新

  [复制链接]

0

主题

17

帖子

92

积分

注册会员

Rank: 2

积分
92
发表于 2016-4-25 10:05:54 | 显示全部楼层
太给力啦,谢谢楼主,我无耻的带走了

0

主题

5

帖子

16

积分

新手上路

Rank: 1

积分
16
发表于 2016-4-26 09:56:40 | 显示全部楼层
太牛了  感谢小白

0

主题

8

帖子

22

积分

新手上路

Rank: 1

积分
22
发表于 2016-4-26 10:09:23 | 显示全部楼层
学习 学习  感觉要学好久

0

主题

4

帖子

22

积分

新手上路

Rank: 1

积分
22
发表于 2016-4-29 10:46:18 | 显示全部楼层
有没有支持 6.1.0版的呀!

2

主题

7

帖子

28

积分

新手上路

Rank: 1

积分
28
发表于 2016-5-13 11:08:28 | 显示全部楼层
大白菜 发表于 2015-4-2 08:50
这个太给力了,再也不用傻傻看log了,夜神威武,小白威武 ...

哈哈,看log,我现在初期阶段,想问问,在Server8上如何添加定时任务,我按着网上的试了下,虽然报错如,但是数据还是抽取成功,log我附图如下:
E:\Data\Lyy\software\pdi-ce-6.1.0.1-196\data-integration>"C:\Program Files\Java\jdk1.7.0_65\bin\java.exe"  "-Xms1024m" "-Xmx2048m" "-XX:MaxPermSize=256m" "-Dhttps.protocols=TLSv1,TLSv1.1,TLSv1.2" "-Djava.library.path=libswt\win64" "-DKETTLE_HOME=C:\Program Files\pdi-ce-6.1.0.1-196\data-integration" "-DKETTLE_REPOSITORY=" "-DKETTLE_USER=" "-DKETTLE_PASSWORD=" "-DKETTLE_PLUGIN_PACKAGES=" "-DKETTLE_LOG_SIZE_LIMIT=" "-DKETTLE_JNDI_ROOT=" -jar launcher\pentaho-application-launcher-6.1.0.1-196.jar -lib ..\libswt\win64  -main org.pentaho.di.kitchen.Kitchen -file E:\Data\kettle\month\test.kjb
10:58:47,909 INFO  [KarafInstance]
*******************************************************************************
*** Karaf Instance Number: 2 at E:\Data\Lyy\software\pdi-ce-6.1.0.1-196\dat ***
***   a-integration\.\system\karaf\caches\default\data-1                    ***
*** Karaf Port:8803                                                         ***
*** OSGI Service Port:9052                                                  ***
*******************************************************************************
10:58:47,910 INFO  [KarafBoot] Checking to see if org.pentaho.clean.karaf.cache is enabled
2016/05/13 10:58:49 - Kitchen - Start of run.
Updating configuration from org.apache.karaf.shell.cfg
Updating configuration from org.ops4j.pax.web.cfg
2016/05/13 10:58:50 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp
ERROR: Bundle org.apache.karaf.config.command [88] Error starting mvnrg.apache.karaf.config/org.apache.karaf.config.command/3.0.3 (org.osgi.framework.BundleException: Unresolved constraint in bundle org.apache.karaf.config.command [88]: Unable to resolve 88.0: missing requirement [88.0] osgi.wiring.package; (&(osgi.wiring.package=org.apache.felix.service.command)(version>=0.12.0)(!(version>=1.0.0))))
ERROR: Bundle pentaho-osgi-utils-impl [40] Error starting mvn:pentaho/pentaho-osgi-utils-impl/6.1.0.1-196 (org.osgi.framework.BundleException: Unresolved constraint in bundle pentaho-osgi-utils-impl [40]: Unable to resolve 40.0: missing requirement [40.0] osgi.wiring.package; (&(osgi.wiring.package=org.apache.karaf.bundle.core)(version>=3.0.0)(!(version>=4.0.0))))
10:58:52,377 ERROR [BootFeaturesInstaller] Error installing boot features
java.lang.Exception: Could not start bundle mvnrg.apache.karaf.config/org.apache.karaf.config.command/3.0.3 in feature(s) config-3.0.3: Unresolved constraint in bundle org.apache.karaf.config.command [88]: Unable to resolve 88.0: missing requirement [88.0] osgi.wiring.package; (&(osgi.wiring.package=org.apache.felix.service.command)(version>=0.12.0)(!(version>=1.0.0)))
        at org.apache.karaf.features.internal.FeaturesServiceImpl.startBundle(FeaturesServiceImpl.java:504)
        at org.apache.karaf.features.internal.FeaturesServiceImpl.installFeatures(FeaturesServiceImpl.java:459)
        at org.apache.karaf.features.internal.BootFeaturesInstaller.installBootFeatures(BootFeaturesInstaller.java:92)
        at org.apache.karaf.features.internal.BootFeaturesInstaller$1.run(BootFeaturesInstaller.java:71)
Caused by: org.osgi.framework.BundleException: Unresolved constraint in bundle org.apache.karaf.config.command [88]: Unable to resolve 88.0: missing requirement [88.0] osgi.wiring.package; (&(osgi.wiring.package=org.apache.felix.service.command)(version>=0.12.0)(!(version>=1.0.0)))
        at org.apache.felix.framework.Felix.resolveBundleRevision(Felix.java:4002)
        at org.apache.felix.framework.Felix.startBundle(Felix.java:2045)
        at org.apache.felix.framework.BundleImpl.start(BundleImpl.java:976)
        at org.apache.felix.framework.BundleImpl.start(BundleImpl.java:963)
        at org.apache.karaf.features.internal.FeaturesServiceImpl.startBundle(FeaturesServiceImpl.java:501)
        ... 3 more
ERROR: Bundle pdi-osgi-bridge-activator [46] Error starting mvn:pentaho/pdi-osgi-bridge-activator/6.1.0.1-196 (org.osgi.framework.BundleException: Activator start error in bundle pdi-osgi-bridge-activator [46].)
ERROR: Bundle pentaho-osgi-utils-impl [40] Error starting mvn:pentaho/pentaho-osgi-utils-impl/6.1.0.1-196 (org.osgi.framework.BundleException: Unresolved constraint in bundle pentaho-osgi-utils-impl [40]: Unable to resolve 40.0: missing requirement [40.0] osgi.wiring.package; (&(osgi.wiring.package=org.apache.karaf.bundle.core)(version>=3.0.0)(!(version>=4.0.0))))
11:00:30,233 ERROR [KarafLifecycleListener] The Kettle Karaf Lifecycle Listener failed to execute properly after waiting for 100 seconds. Releasing lifecycle hold, but some services may be unavailable.
2016/05/13 11:00:31 - test - 开始执行任务
2016/05/13 11:00:31 - test - 开始项[转换]
2016/05/13 11:00:31 - 转换 - Loading transformation from XML file [file:///E:/Data/kettle/month/test.ktr]
2016/05/13 11:00:31 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp
2016/05/13 11:00:31 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp
2016/05/13 11:00:31 - cfgbuilder - Warning: The configuration parameter [org] is not supported by the default configuration builder for scheme: sftp
2016/05/13 11:00:31 - test - 为了转换解除补丁开始  [test]
2016/05/13 11:00:31 - 表输出.0 - Connected to database [mysql] (commit=1000)
2016/05/13 11:00:31 - 执行SQL脚本.0 - Finished reading query, closing connection.
2016/05/13 11:00:31 - 执行SQL脚本.0 - 完成处理 (I=0, O=0, R=0, W=1, U=0, E=0)
2016/05/13 11:00:32 - 表输入.0 - Finished reading query, closing connection.
2016/05/13 11:00:32 - 表输入.0 - 完成处理 (I=1566, O=0, R=0, W=1566, U=0, E=0)
2016/05/13 11:00:32 - 表输出.0 - 完成处理 (I=0, O=1566, R=1566, W=1566, U=0, E=0)
2016/05/13 11:00:32 - test - 完成作业项[转换] (结果=[true])
2016/05/13 11:00:32 - test - 任务执行完毕
2016/05/13 11:00:32 - Kitchen - Finished!
2016/05/13 11:00:32 - Kitchen - Start=2016/05/13 10:58:49.066, Stop=2016/05/13 11:00:32.990
2016/05/13 11:00:32 - Kitchen - Processing ended after 1 minutes and 43 seconds (103 seconds total).


.bat书写如下:
@echo off





@echo off

set  KETTLE_PATH=E:\Data\Lyy\software\pdi-ce-6.1.0.1-196\data-integration

set  JOB_PATH=E:\Data\kettle\month




CALL %KETTLE_PATH%\Kitchen.bat  -file=%JOB_PATH%\test.kjb   >> E:\Data\kettle\month\kitchen_%date.log
pause

0

主题

2

帖子

24

积分

新手上路

Rank: 1

积分
24
发表于 2016-5-25 23:05:57 | 显示全部楼层
受教了,非常感谢分享!!

0

主题

22

帖子

46

积分

新手上路

Rank: 1

积分
46
发表于 2016-6-1 15:23:54 | 显示全部楼层
非常不错了

0

主题

24

帖子

74

积分

注册会员

Rank: 2

积分
74
发表于 2016-7-4 14:21:09 | 显示全部楼层
好东西,下来参考一下

0

主题

11

帖子

54

积分

注册会员

Rank: 2

积分
54
发表于 2016-7-11 23:26:07 | 显示全部楼层
纵观整个论坛,感觉就你最火了,,请教下,你里面的定时任务是实现思路是怎样的,恳请解惑

47

主题

620

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
11777
 楼主| 发表于 2016-7-13 16:00:13 | 显示全部楼层
风一样的男子 发表于 2016-7-11 23:26
纵观整个论坛,感觉就你最火了,,请教下,你里面的定时任务是实现思路是怎样的,恳请解惑 ...

可以加入用户群,大家一起讨论
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

手机版|小黑屋| μKettle ( 沪ICP备14044064号 )     

GMT+8, 2017-8-23 08:19 , Processed in 0.252790 second(s), 16 queries , File On.

Powered by Discuz!  uKettle

Copyright © 2014 Comsenz Inc.

快速回复 返回顶部 返回列表