Hi,
I am running Kettle Version 8.2 on Windows Server 2016 Standard running Java version 1.8.0_271. I am having problems with a Transformation when writing an Excel spreadsheet to a Citrix ShareFile directory.
I can run this transformation from the console and it executes and writes the Excel spreadsheet without any problems, but when I attempt to run the batch file from Pan it will not write to ShareFile and gives me the following errors. I have run the batch file as myself and as Administrator with the same outcome.
2021/03/03 13:27:03 - Daily_Audit_Report - Dispatching started for transformation [Daily_Audit_Report]
2021/03/03 13:27:03 - Table input.0 - Finished reading query, closing connection.
2021/03/03 13:27:03 - Table input.0 - Finished processing (I=43, O=0, R=0, W=43, U=0, E=0)
2021/03/03 13:27:04 - Select values.0 - Finished processing (I=0, O=0, R=43, W=43, U=0, E=0)
2021/03/03 13:27:04 - Database lookup.0 - Finished processing (I=43, O=0, R=43, W=43, U=0, E=0)
2021/03/03 13:27:04 - Microsoft Excel writer.0 - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : Error opening new file
2021/03/03 13:27:04 - Microsoft Excel writer.0 - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : java.io.IOException: Error creating output file! Parent directory [file:///S:/Shared Folders/Automated_Reports] does not exist.
2021/03/03 13:27:04 - Microsoft Excel writer.0 - at org.pentaho.di.core.vfs.KettleVFS.getOutputStream(KettleVFS.java:284)
2021/03/03 13:27:04 - Microsoft Excel writer.0 - at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.prepareNextOutputFile(ExcelWriterStep.java:646)
2021/03/03 13:27:04 - Microsoft Excel writer.0 - at org.pentaho.di.trans.steps.excelwriter.ExcelWriterStep.processRow(ExcelWriterStep.java:111)
2021/03/03 13:27:04 - Microsoft Excel writer.0 - at org.pentaho.di.trans.step.RunThread.run(RunThread.java:62)
2021/03/03 13:27:04 - Microsoft Excel writer.0 - at java.lang.Thread.run(Unknown Source)
2021/03/03 13:27:04 - Microsoft Excel writer.0 - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : Could not prepare output file S:\Shared Folders\Automated_Reports\Daily_Claims_over_$500
2021/03/03 13:27:04 - Microsoft Excel writer.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)
2021/03/03 13:27:04 - Daily_Audit_Report - Transformation detected one or more steps with errors.
2021/03/03 13:27:04 - Pan - Finished!
2021/03/03 13:27:04 - Pan - Start=2021/03/03 13:26:55.536, Stop=2021/03/03 13:27:04.753
2021/03/03 13:27:04 - Daily_Audit_Report - Transformation is killing the other steps!
2021/03/03 13:27:04 - Pan - Processing ended after 9 seconds.
Has anyone seen anything like this before?
Best Regards
Steve Johnson
#PentahoDataIntegrationPDI#Kettle#Pentaho