Pentaho Data Integration

Pentaho Data Integration [aka kettle] community edition 4.4 gives “Unable to close open File” error when writing data in excel file using the template option on Linux platform.

PDI – Template option :

When user run the ETL job on Linux OS, ETL job may gives the  below error.


Required to add “-Dfile.encoding=Cp1252” keyword in the file as per the below steps.

1. Open using any editor (For example, vi /home/data-integration/

2. Add “-Dfile.encoding=Cp1252” word in the OPT variable. So the file will looks like as shown in the below image.

 3. Save and Close the file.

Post a Comment