topic Re: .csv (Access is denied);1 in Talend Studio

.csv (Access is denied);1

Anonymous — Thu, 23 Feb 2017 08:47:52 GMT

I have an ETL job that connects to an FTP server, gets a .ZIP file, extracts its contents and then reads the file to process the data present inside it.
When I run the job from Open Studio there are no errors. However when the job is run from a server a java.io.FileNotFoundException is thrown with the message (Access is denied). This exception is thrown by the tFileUnarchive component.
The server is a Windows server where the job is deployed as a build file (build .zip file extracted and .bat file present in the job directory is executed to run the job). The job .bat file is executed through Windows PowerShell window.
Anyone has a clue why this exception is thrown? And how it can be resolved?

Re: .csv (Access is denied);1

Anonymous — Fri, 24 Feb 2017 07:50:24 GMT

Hi,
Did you use a relative path in tFileUnarchive component? More information about your current situation will be preferred.
Best regards
Sabrina

Re: .csv (Access is denied);1

Anonymous — Fri, 03 Mar 2017 10:24:38 GMT

Hi,
Did you use a relative path in tFileUnarchive component? More information about your current situation will be preferred.
Best regards
Sabrina

Hi Sabrina,
We get the path where the file to unarchive is located from the tFileList component that iterates through a given directory.
So in the Archive file property of the tFileUnarchive component the value is given is ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH")).
Also when I run the job as administrator I do not get this error and the job processes the file correctly.