topic Re: Getting Error while opening Excel File in Talend Studio

Getting Error while opening Excel File

javvaji — Fri, 19 Jul 2019 13:16:34 GMT

Hi Team,

I was trying to run Talend job which is loading data from excel file to Database,but when i was trying to run it from TAC getting the following error. And i was able to run the job from Talend studio.

Exception in component tFileInputExcel_7
java.util.concurrent.ExecutionException: org.apache.poi.openxml4j.exceptions.InvalidOperationException: Can't open the specified file: '/xxxx/xxxx/abc.xlsx'
at java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.util.concurrent.FutureTask.get(FutureTask.java:192)
at com.talend.excel.xssf.event.ExcelReader.handleException(ExcelReader.java:98)
at _fdl_aws_dev_q.copy_of_j_File_load_0_1.Copy_of_J_File_Load.tFileInputExcel_7Process(Copy_of_J_File_Load.java:2151)
at _fdl_aws_dev_q.copy_of_j_File_load_0_1.Copy_of_J_File_Load.tJava_1Process(Copy_of_J_File_Load.java:936)
at _fdl_aws_dev_q.copy_of_j_File_load_0_1.Copy_of_J_File_Load.tPostgresqlConnection_1Process(Copy_of_J_File_Load.java:601)
at _fdl_aws_dev_q.copy_of_j_File_load_0_1.Copy_of_J_File_Load.runJobInTOS(Copy_of_J_File_Load.java:2793)
at _fdl_aws_dev_q.copy_of_j_File_load_0_1.Copy_of_J_File_Load.main(Copy_of_J_File_Load.java:2598)
Caused by: org.apache.poi.openxml4j.exceptions.InvalidOperationException: Can't open the specified file: '/xxxx/xxxx/abc.xlsx'
at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:112)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:224)
at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:186)
at com.talend.excel.xssf.event.ExcelReader.call(ExcelReader.java:105)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.util.zip.ZipException: error in opening zip file
at java.util.zip.ZipFile.open(Native Method)
at java.util.zip.ZipFile.<init>(ZipFile.java:219)
at java.util.zip.ZipFile.<init>(ZipFile.java:149)
at java.util.zip.ZipFile.<init>(ZipFile.java:163)
at org.apache.poi.openxml4j.opc.internal.ZipHelper.openZipFile(ZipHelper.java:174)
at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:110)
... 5 more

Thanks in advance.

Regards,

Bharath.

Re: Getting Error while opening Excel File

Anonymous — Fri, 19 Jul 2019 18:05:36 GMT

Hi Bharath,

Could you please double check whether the file '/xxxx/xxxx/abc.xlsx' is present in the Job server under the specific location? When you are running the job from Studio, you will be pointing to your local folder structure. But when you are running through TAC, the file should be present either in the Job server or in a file location which is shared with Job server.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Getting Error while opening Excel File

javvaji — Tue, 23 Jul 2019 08:10:29 GMT

Hi Nikhil,

Thanks for the reply.

I have place the file '/xxxx/xxxx/abc.xlsx' readily in the job server and ran the job. I also changed the file path as per the job server when i used remote execution. But i think if we don't have the file in location it will say file not found exception right. But here it was saying cannot open the file.

Regards,

Bharath.

Re: Getting Error while opening Excel File

Anonymous — Tue, 23 Jul 2019 21:21:30 GMT

Hi,

Could you please advise whether the job flow started working once you place the file in Job server?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Getting Error while opening Excel File

javvaji — Wed, 24 Jul 2019 14:07:40 GMT

Hi Nikhil,

The job flow is started and getting error at file component.

Regards,

Bharath.

Re: Getting Error while opening Excel File

Anonymous — Wed, 24 Jul 2019 14:59:43 GMT

Hi Bharath,

I hope you are using a Linux system. Did you check the file reading permissions for the user used by Talend? If you are able o connect to FTP but not able to read the file means there could be permission issues.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Getting Error while opening Excel File

javvaji — Wed, 24 Jul 2019 15:11:05 GMT

Hi Nikhil,

I was able to connect to server from Talend and also able to read the file. File is having the permissions needed.

Regards,

Bharath.