topic Re: SAS EG Copy Task ERROR: Download exception occured in SAS Enterprise Guide

SAS EG Copy Task ERROR: Download exception occured

elwayfan446 — Wed, 27 Jan 2021 15:58:46 GMT

Good morning. I have created a copy task that uses a variables to define the paths of the files I need to download.

The macros resolve fine and the files download but I get the following error in the log:

ERROR: Download exception occurred. Error while trying to get remote file.

When I open the .xlsx files that download I get the following message:

If I transfer the files via sftp directly to my network drive the files open normally without an error so something appears to be happening during the download in the copy task. Has anyone ever seen this and is there a fix?

Re: SAS EG Copy Task ERROR: Download exception occured

ChrisHemedinger — Wed, 27 Jan 2021 16:03:44 GMT

Can you change the download spec to "*.xlsx" (note the dot before "xlsx")? Does that help?

Re: SAS EG Copy Task ERROR: Download exception occured

elwayfan446 — Wed, 27 Jan 2021 16:12:42 GMT

Thanks, I didn't catch that before. However, I changed it and I am still having the same issues.

Re: SAS EG Copy Task ERROR: Download exception occured

ChrisHemedinger — Wed, 27 Jan 2021 16:17:50 GMT

Should not matter, but your SASApp looks like Linux so use a forward slash in the Download from field.

This task emits lots of messages in the Application Log, so turning that on in Tools->Options might reveal something. It's a lot to decipher, so SAS Tech Support might be able to help at that point.

Re: SAS EG Copy Task ERROR: Download exception occured

elwayfan446 — Wed, 27 Jan 2021 16:25:01 GMT

The forward slash fixed the issue! I've never seen anything that indicates a forward slash is needed on a wildcard macro like this in EG so I didn't even think to try that. I appreciate the suggestion and ultimately helping me figure out how to fix this!