kettle导出Excel报错：No such file or directory

明明已经指定文件对了目录和文件名，但是导出时仍然提升文件不存在。而且偶尔也能成功。

2020/04/09 19:35:31 - Excel 输出:新疆.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : java.lang.RuntimeException: java.io.IOException: No such file or directory
2020/04/09 19:35:31 - Excel 输出:新疆.0 -       at org.apache.poi.xssf.streaming.SXSSFWorkbook.createAndRegisterSXSSFSheet(SXSSFWorkbook.java:637)
2020/04/09 19:35:31 - Excel 输出:新疆.0 -       at org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:230)
2020/04/09 19:35:31 - Excel 输出:新疆.0 -       at org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:185)
2020/04/09 19:35:31 - Excel 输出:新疆.0 -       at org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:160)
2020/04/09 19:35:31 - Excel 输出:新疆.0 -       at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.prepareNextOutputFile(ExcelWriterStep.java:739)
2020/04/09 19:35:31 - Excel 输出:新疆.0 -       at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.processRow(ExcelWriterStep.java:106)
2020/04/09 19:35:31 - Excel 输出:新疆.0 -       at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2020/04/09 19:35:31 - Excel 输出:新疆.0 -       at java.lang.Thread.run(Thread.java:748)
2020/04/09 19:35:31 - Excel 输出:新疆.0 - Caused by: java.io.IOException: No such file or directory
2020/04/09 19:35:31 - Excel 输出:新疆.0 -       at java.io.UnixFileSystem.createFileExclusively(Native Method)
2020/04/09 19:35:31 - Excel 输出:新疆.0 -       at java.io.File.createTempFile(File.java:2024)
2020/04/09 19:35:31 - Excel 输出:新疆.0 -       at org.apache.poi.util.TempFile$DefaultTempFileCreationStrategy.createTempFile(TempFile.java:105)
2020/04/09 19:35:31 - Excel 输出:新疆.0 -       at org.apache.poi.util.TempFile.createTempFile(TempFile.java:60)
2020/04/09 19:35:31 - Excel 输出:新疆.0 -       at org.apache.poi.xssf.streaming.SheetDataWriter.createTempFile(SheetDataWriter.java:80)
2020/04/09 19:35:31 - Excel 输出:新疆.0 -       at org.apache.poi.xssf.streaming.SheetDataWriter.<init>(SheetDataWriter.java:63)
2020/04/09 19:35:31 - Excel 输出:新疆.0 -       at org.apache.poi.xssf.streaming.SheetDataWriter.<init>(SheetDataWriter.java:68)
2020/04/09 19:35:31 - Excel 输出:新疆.0 -       at org.apache.poi.xssf.streaming.SXSSFWorkbook.createSheetDataWriter(SXSSFWorkbook.java:292)
2020/04/09 19:35:31 - Excel 输出:新疆.0 -       at org.apache.poi.xssf.streaming.SXSSFSheet.<init>(SXSSFSheet.java:69)
2020/04/09 19:35:31 - Excel 输出:新疆.0 -       at org.apache.poi.xssf.streaming.SXSSFWorkbook.createAndRegisterSXSSFSheet(SXSSFWorkbook.java:633)
2020/04/09 19:35:31 - Excel 输出:新疆.0 -       ... 7 more
2020/04/09 19:35:31 - Excel 输出:贵州.0 - ERROR (version 6.1.0.1-196, build 1 from 2016-04-07 12.08.49 by buildguy) : java.lang.RuntimeException: java.io.IOException: No such file or directory
2020/04/09 19:35:31 - Excel 输出:贵州.0 -       at org.apache.poi.xssf.streaming.SXSSFWorkbook.createAndRegisterSXSSFSheet(SXSSFWorkbook.java:637)
2020/04/09 19:35:31 - Excel 输出:贵州.0 -       at org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:230)
2020/04/09 19:35:31 - Excel 输出:贵州.0 -       at org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:185)
2020/04/09 19:35:31 - Excel 输出:贵州.0 -       at org.apache.poi.xssf.streaming.SXSSFWorkbook.<init>(SXSSFWorkbook.java:160)
2020/04/09 19:35:31 - Excel 输出:贵州.0 -       at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.prepareNextOutputFile(ExcelWriterStep.java:739)
2020/04/09 19:35:31 - Excel 输出:贵州.0 -       at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.processRow(ExcelWriterStep.java:106)
2020/04/09 19:35:31 - Excel 输出:贵州.0 -       at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2020/04/09 19:35:31 - Excel 输出:贵州.0 -       at java.lang.Thread.run(Thread.java:748)
2020/04/09 19:35:31 - Excel 输出:贵州.0 - Caused by: java.io.IOException: No such file or directory
2020/04/09 19:35:31 - Excel 输出:贵州.0 -       at java.io.UnixFileSystem.createFileExclusively(Native Method)
2020/04/09 19:35:31 - Excel 输出:贵州.0 -       at java.io.File.createTempFile(File.java:2024)
2020/04/09 19:35:31 - Excel 输出:贵州.0 -       at org.apache.poi.util.TempFile$DefaultTempFileCreationStrategy.createTempFile(TempFile.java:105)
2020/04/09 19:35:31 - Excel 输出:贵州.0 -       at org.apache.poi.util.TempFile.createTempFile(TempFile.java:60)
2020/04/09 19:35:31 - Excel 输出:贵州.0 -       at org.apache.poi.xssf.streaming.SheetDataWriter.createTempFile(SheetDataWriter.java:80)
2020/04/09 19:35:31 - Excel 输出:贵州.0 -       at org.apache.poi.xssf.streaming.SheetDataWriter.<init>(SheetDataWriter.java:63)
2020/04/09 19:35:31 - Excel 输出:贵州.0 -       at org.apache.poi.xssf.streaming.SheetDataWriter.<init>(SheetDataWriter.java:68)
2020/04/09 19:35:31 - Excel 输出:贵州.0 -       at org.apache.poi.xssf.streaming.SXSSFWorkbook.createSheetDataWriter(SXSSFWorkbook.java:292)
2020/04/09 19:35:31 - Excel 输出:贵州.0 -       at org.apache.poi.xssf.streaming.SXSSFSheet.<init>(SXSSFSheet.java:69)
2020/04/09 19:35:31 - Excel 输出:贵州.0 -       at org.apache.poi.xssf.streaming.SXSSFWorkbook.createAndRegisterSXSSFSheet(SXSSFWorkbook.java:633)
2020/04/09 19:35:31 - Excel 输出:贵州.0 -       ... 7 more

 

原因：kettle导出Excel，使用了poi-ooxml工具包，这个工具包使用了一个临时目录，作为导出的缓存，默认是在/tmp/poifiles目录下。猜测可能是这个目录没有创建成功导致。

解决方法：由于kettle中无法修改这个临时目录，所以只能在job中使用一个【创建一个目录】组件，主动创建这个目录。问题得以解决。