Pentaho Data Integration

0 comments
Problem: 
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.

Solutions:

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

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

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


 3. Save and Close the kitchen.sh file.


Post a Comment