Learn more about the Alteryx Maveryx Universe recently announced at Inspire 2023!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Download csv from Amazon S3: No such key & process cannot access file error

8 - Asteroid

I'm trying to download csv files from https://www1.nyc.gov/site/tlc/about/tlc-trip-record-data.page.


If I try to download to a field, I receive the following error message: 


<?xml version="1.0" encoding="UTF-8"?>
<Error><Code>NoSuchKey</Code><Message>The specified key does not exist.</Message><Key>trip+data/yellow_tripdata_2019-02.csv</Key><RequestId>1E58CB163A50763A</RequestId><HostId>Up1JKmCAYMFPRDZwvGI+s/xv/1HEMlgoLqbl65PU+qLLs302PcoFw/HoIgXilQM+LM545etlRFo=</HostId></Error>


I'm not sure why the key doesn't exist as I can download the yellow taxi files manually.


If I try to store the data in a file, Alteryx says: process cannot access the file because it is being used by another process.


Can anyone think of a workaround please?

16 - Nebula
16 - Nebula

Hello @Luisa_Bez ,


This may be the possible solutions to your problem:


  1. You could be trying to reference the wrong file.  Double check the path that you tried to retrieve.

  2. Whenever the file was uploaded it must have failed.  Check the logs for your S3Sync process to see if you can find any relevant output

Edit: Other people seemd to see that the problem was the filename. It contained a hashtag # symbol, and I guess certain characters or symbols will also cause this error.


8 - Asteroid

According to https://stackoverflow.com/questions/7116450/what-are-valid-s3-key-names-that-can-be-accessed-via-the... it could be the + symbol. I've replaced it with a white space.