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.
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