.csv (Access is denied);1

Eight Stars

.csv (Access is denied);1

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?
Moderator

Re: .csv (Access is denied);1

Hi,
Did you use a relative path in tFileUnarchive component? More information about your current situation will be preferred.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Eight Stars

Re: .csv (Access is denied);1

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.

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now