Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

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

Inactive User
Not applicable

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?

2 REPLIES 2
afv2688
16 - Nebula
16 - Nebula

Hello @Inactive User ,

 

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

Inactive User
Not applicable

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