Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

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

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?

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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.

Regards

Highlighted
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.

Labels