Cannot access the file (\\fileshare\file.xlsx) while executiong the job in TMC
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)
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.
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.
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?
