首页 > 代码库 > RHEL 6.4 64bit kettle5.01导入xlsx格式的excel时报错

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 - ?aê??′DDè???
2014/06/09 22:21:55 - job_one - ?aê???[delete_table]
2014/06/09 22:21:55 - job_one - ?aê???[excel_etl_AMB1]
2014/06/09 22:21:55 - excel_etl_AMB1 - ?aá?×a???a3y21???aê? [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) : ′í?ó±??ì2aμ?!
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) : ′í?ó±??ì2aμ?!
2014/06/09 22:21:55 - select_AMB1.0 - íê3é′|àí (I=0, O=0, R=0, W=0, U=0, E=1
2014/06/09 22:21:55 - job_one - íê3é×÷òμ??[excel_etl_AMB1] (?á1?=[false])
2014/06/09 22:21:55 - job_one - ?aê???[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 - ?aá?×a???a3y21???aê? [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的版本,经过测试完全没有问题。