• RHEL 6.4 64bit kettle5.01导入xlsx格式的excel时报错


    环境:RHEL 6.4 64bit ; kettle5.01;xlsx格式的excel

    创建的job,在spoon里面运行都没有问题(Linux和windows)

    在windows的命令行运行也没有问题,
    但是在Linux的命令行运行就有问题了
    报[oracle@localhost data-integration]$ ./kitchen.sh -rep:"rui_test_repository" -job:"job_one" -dir:/ -user:admin -pass:admin -level:Basic
    2014/06/09 22:21:52 - Kitchen - Logging is at level : »ù±¾ÈÕÖ¾
    2014/06/09 22:21:52 - Kitchen - Start of run.
    2014/06/09 22:21:52 - RepositoriesMeta - Reading repositories XML file: /home/oracle/.kettle/repositories.xml
    2014/06/09 22:21:54 - job_one - ¿ªÊ¼Ö´ÐÐÈÎÎñ
    2014/06/09 22:21:55 - job_one - ¿ªÊ¼Ïî[delete_table]
    2014/06/09 22:21:55 - job_one - ¿ªÊ¼Ïî[excel_etl_AMB1]
    2014/06/09 22:21:55 - excel_etl_AMB1 - ΪÁËת»»½â³ý²¹¶¡¿ªÊ¼ [excel_etl_AMB1]
    2014/06/09 22:21:55 - insert_ODS_PRODUCT_SALES_M.0 - Connected to database [RUIJIEBI_TEST] (commit=1000)
    java.lang.NoSuchMethodError: org.apache.poi.openxml4j.opc.OPCPackage.open(Ljava/io/File;)Lorg/apache/poi/openxml4j/opc/OPCPackage;
    at org.pentaho.di.trans.steps.excelinput.poi.PoiWorkbook.<init>(PoiWorkbook.java:66)
    at org.pentaho.di.trans.steps.excelinput.WorkbookFactory.getWorkbook(WorkbookFactory.java:38)
    at org.pentaho.di.trans.steps.excelinput.ExcelInput.getRowFromWorkbooks(ExcelInput.java:603)
    at org.pentaho.di.trans.steps.excelinput.ExcelInput.processRow(ExcelInput.java:471)
    at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)
    at java.lang.Thread.run(Thread.java:662)
    2014/06/09 22:21:55 - select_AMB1.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : Unexpected error
    2014/06/09 22:21:55 - select_AMB1.0 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : java.lang.NoSuchMethodError: org.apache.poi.openxml4j.opc.OPCPackage.open(Ljava/io/File;)Lorg/apache/poi/openxml4j/opc/OPCPackage;
    2014/06/09 22:21:55 - select_AMB1.0 - at org.pentaho.di.trans.steps.excelinput.poi.PoiWorkbook.<init>(PoiWorkbook.java:66)
    2014/06/09 22:21:55 - select_AMB1.0 - at org.pentaho.di.trans.steps.excelinput.WorkbookFactory.getWorkbook(WorkbookFactory.java:38)
    2014/06/09 22:21:55 - select_AMB1.0 - at org.pentaho.di.trans.steps.excelinput.ExcelInput.getRowFromWorkbooks(ExcelInput.java:603)
    2014/06/09 22:21:55 - select_AMB1.0 - at org.pentaho.di.trans.steps.excelinput.ExcelInput.processRow(ExcelInput.java:471)
    2014/06/09 22:21:55 - select_AMB1.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)
    2014/06/09 22:21:55 - select_AMB1.0 - at java.lang.Thread.run(Thread.java:662)
    child index = 2, logging object : org.pentaho.di.core.logging.LoggingObject@1edfbb43 parent=1edc8786-3499-48f9-bf49-8fb610e41283
    2014/06/09 22:21:55 - excel_etl_AMB1 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : ´íÎó±»¼ì²âµ½!
    2014/06/09 22:21:55 - excel_etl_AMB1 - ERROR (version 5.0.1-stable, build 1 from 2013-11-15_16-08-58 by buildguy) : ´íÎó±»¼ì²âµ½!
    2014/06/09 22:21:55 - select_AMB1.0 - Íê³É´¦Àí (I=0, O=0, R=0, W=0, U=0, E=1
    2014/06/09 22:21:55 - job_one - Íê³É×÷ÒµÏî[excel_etl_AMB1] (½á¹û=[false])
    2014/06/09 22:21:55 - job_one - ¿ªÊ¼Ïî[excel_etl_AMB2]
    2014/06/09 22:21:55 - excel_etl_AMB1 - excel_etl_AMB1
    2014/06/09 22:21:55 - excel_etl_AMB1 - excel_etl_AMB1
    2014/06/09 22:21:56 - excel_etl_AMB2 - ΪÁËת»»½â³ý²¹¶¡¿ªÊ¼ [excel_etl_AMB2]
    2014/06/09 22:21:56 - ODS_DHF_M.0 - Connected to database [RUIJIEBI_TEST] (commit=1000)
    java.lang.NoSuchMethodError: org.apache.poi.openxml4j.opc.OPCPackage.open(Ljava/io/File;)Lorg/apache/poi/openxml4j/opc/OPCPackage;
    at org.pentaho.di.trans.steps.excelinput.poi.PoiWorkbook.<init>(PoiWorkbook.java:66)
    at org.pentaho.di.trans.steps.excelinput.WorkbookFactory.getWorkbook(WorkbookFactory.java:38)
    at org.pentaho.di.trans.steps.excelinput.ExcelInput.getRowFromWorkbooks(ExcelInput.java:603)
    at org.pentaho.di.trans.steps.excelinput.ExcelInput.processRow(ExcelInput.java:471)
    at org.pentaho.di.trans.step.RunThread.run(RunThread.java:60)
    at java.lang.Thread.run(Thread.java:662)

    百思不得其解,最后google 到http://forums.pentaho.com/showthread.php?156318-Recent-changes-to-error-handling-in-PDI5-trunk&goto=nextoldest

    之后退回到kettle4.4的版本,经过测试完全没有问题。

  • 相关阅读:
    稳扎稳打Silverlight(47) 4.0UI之操作剪切板, 隐式样式, CompositeTransform, 拖放外部文件到程序中
    返璞归真 asp.net mvc (9) asp.net mvc 3.0 新特性之 View(Razor)
    返璞归真 asp.net mvc (6) asp.net mvc 2.0 新特性
    稳扎稳打Silverlight(48) 4.0其它之打印, 动态绑定, 增强的导航系统, 杂七杂八
    精进不休 .NET 4.0 (9) ADO.NET Entity Framework 4.1 之 Code First
    稳扎稳打Silverlight(42) 4.0控件之Viewbox, RichTextBox
    稳扎稳打Silverlight(53) 4.0通信之对WCF NetTcpBinding的支持, 在Socket通信中通过HTTP检索策略文件, HTTP请求中的ClientHttp和BrowserHttp
    稳扎稳打 Silverlight 4.0 系列文章索引
    稳扎稳打Silverlight(54) 4.0通信之对UDP协议的支持: 通过 UdpAnySourceMulticastClient 实现 ASM(Any Source Multicast),即“任意源多播”
    返璞归真 asp.net mvc (8) asp.net mvc 3.0 新特性之 Model
  • 原文地址:https://www.cnblogs.com/Alex-Zeng/p/3779501.html
Copyright © 2020-2023  润新知