Cannot access the file (\\fileshare\file.xlsx) while executiong the job in TMC

McJingles — Fri, 15 Nov 2024 22:57:18 GMT

Hi,

I built the job to read the file from a shared drive. It was running successfully while it is in the local studio. But I was getting the following errors when it was running in TMC

tFileInputExcel_1 org.apache.poi.openxml4j.exceptions.InvalidOperationException: Can't open the specified file input stream from file: '\\fileshare1\aaaaa\bbb\ccc.xlsx'

java.util.concurrent.ExecutionException: org.apache.poi.openxml4j.exceptions.InvalidOperationException: Can't open the specified file input stream from file: '\\fileshare1\aaaaa\bbb\ccc.xlsx'

at java.util.concurrent.FutureTask.report(Unknown Source)

at java.util.concurrent.FutureTask.get(Unknown Source)

at com.talend.excel.xssf.event.ExcelReader.handleException(ExcelReader.java:125)

at natera_el.el_dynamic_dataprocess_alt_0_1.EL_Dynamic_DataProcess_ALT.tFileInputExcel_1Process(EL_Dynamic_DataProcess_ALT.java:8032)

at natera_el.el_dynamic_dataprocess_alt_0_1.EL_Dynamic_DataProcess_ALT.tSystem_1Process(EL_Dynamic_DataProcess_ALT.java:25651)

at natera_el.el_dynamic_dataprocess_alt_0_1.EL_Dynamic_DataProcess_ALT.tDBInput_2Process(EL_Dynamic_DataProcess_ALT.java:25269)

at natera_el.el_dynamic_dataprocess_alt_0_1.EL_Dynamic_DataProcess_ALT.tJava_5Process(EL_Dynamic_DataProcess_ALT.java:24044)

at natera_el.el_dynamic_dataprocess_alt_0_1.EL_Dynamic_DataProcess_ALT.runJobInTOS(EL_Dynamic_DataProcess_ALT.java:29882)

at natera_el.el_dynamic_dataprocess_alt_0_1.EL_Dynamic_DataProcess_ALT.runJob(EL_Dynamic_DataProcess_ALT.java:28620)

at natera_el.el_metadatachanges_alt_0_1.EL_MetadataChanges_ALT.tRunJob_4Process(EL_MetadataChanges_ALT.java:14317)

at natera_el.el_metadatachanges_alt_0_1.EL_MetadataChanges_ALT.tJava_3Process(EL_MetadataChanges_ALT.java:13392)

at natera_el.el_metadatachanges_alt_0_1.EL_MetadataChanges_ALT.tHashInput_3Process(EL_MetadataChanges_ALT.java:13131)

at natera_el.el_metadatachanges_alt_0_1.EL_MetadataChanges_ALT.tFixedFlowInput_3Process(EL_MetadataChanges_ALT.java:11504)

at natera_el.el_metadatachanges_alt_0_1.EL_MetadataChanges_ALT.tDBInput_1Process(EL_MetadataChanges_ALT.java:7089)

at natera_el.el_metadatachanges_alt_0_1.EL_MetadataChanges_ALT.tJava_5Process(EL_MetadataChanges_ALT.java:6265)

at natera_el.el_metadatachanges_alt_0_1.EL_MetadataChanges_ALT$8.run(EL_MetadataChanges_ALT.java:23313)

Caused by: org.apache.poi.openxml4j.exceptions.InvalidOperationException: Can't open the specified file input stream from file: '\\fileshare1\aaaaa\bbb\ccc.xlsx'

at org.apache.poi.openxml4j.opc.ZipPackage.openZipEntrySourceStream(ZipPackage.java:166)

at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:153)

at org.apache.poi.openxml4j.opc.ZipPackage.<init>(ZipPackage.java:123)

at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:233)

at org.apache.poi.openxml4j.opc.OPCPackage.open(OPCPackage.java:166)

at com.talend.excel.xssf.event.ExcelReader.call(ExcelReader.java:145)

at java.util.concurrent.FutureTask.run(Unknown Source)

at java.lang.Thread.run(Unknown Source)

Caused by: java.io.FileNotFoundException: \\fileshare1\aaaaa\bbb\ccc.xlsx (Access is denied)

at java.io.FileInputStream.open0(Native Method)

at java.io.FileInputStream.open(Unknown Source)

at java.io.FileInputStream.<init>(Unknown Source)

at org.apache.poi.openxml4j.opc.ZipPackage.openZipEntrySourceStream(ZipPackage.java:163)

may I get any solutions ASAP

Thanks

Re: Cannot access the file (\\fileshare\file.xlsx) while executiong the job in TMC

Anonymous — Wed, 04 May 2022 15:31:51 GMT

This path needs to be available on the TMC (or via the Remote Engine the job is being run from). I suspect that it is not. If this is an internal location on your system (machine or company network), then the TMC won't necessarily be able to access this and neither will the Remote Engine unless you have provided them with access.

Re: Cannot access the file (\\fileshare\file.xlsx) while executiong the job in TMC

McJingles — Wed, 04 May 2022 16:31:59 GMT

Thanks for your reply @Richard Hall

TMC and Remote engine pointed out our Remote desktop only. But in that, we can connect/read/write the document from the network/shared drive. If the remote engine doesn't have access then how we can provide that. May I get any information briefly means it'll be very helpful for me.

Re: Cannot access the file (\\fileshare\file.xlsx) while executiong the job in TMC

Anonymous — Wed, 04 May 2022 23:03:31 GMT

You will need to provide a lot more information about where \\fileshare1\aaaaa\bbb is. If it is on a local network in your environment, is it available over the internet? Is this job running on a TMC engine or a remote engine? If it is running on a remote engine, where is the remote engine in relation to the network location?

topic Re: Cannot access the file (\\fileshare\file.xlsx) while executiong the job in TMC in Talend Studio

Cannot access the file (\\fileshare\file.xlsx) while executiong the job in TMC

Re: Cannot access the file (\\fileshare\file.xlsx) while executiong the job in TMC

Re: Cannot access the file (\\fileshare\file.xlsx) while executiong the job in TMC

Re: Cannot access the file (\\fileshare\file.xlsx) while executiong the job in TMC