topic SFTP Physical file does not exist in SAS Programming

SFTP Physical file does not exist

naspep21 — Mon, 10 Dec 2018 19:00:58 GMT

Hey,

using SAS 9.2

Having an issue using SFTP from my Unix SAS server to a Linux server. I have already setup my rsa key and have added it to knownhost file. I am able to ssh without a password so that shouldn't be the issue. However When ever i try to SFTP though SAS with the following code i get the following error:

FILENAME COOL SFTP "/home/myhome/cool.txt" USER='user' HOST="myhost" DEBUG;

DATA COOLSAS;
INFILE COOL DLM='|' DSD;
INPUT TEST $;
RUN;

PROC PRINT DATA=COOLSAS (OBS=100); RUN;

NOTE: Connected to <host>.
NOTE: sftp> cd /home/myhome/
NOTE: sftp> get cool.txt /data/SASWORK/SAS_workD88300960066_p00012/#LN00058Fetching
/home/myhome/cool.txt to /data/SASWORK/SAS_workD88300960066_p00012/cool.txt

ERROR: Physical file does not exist, /data/SASWORK/SAS_workD88300960066_p00012/#LN00058.
NOTE: The SAS System stopped processing this step because of errors.

The file on the remote server certainly exist, i have triple checked it. in fact it looks like in the work library the file is actually transferred over. However SAS never reads the file in and then for some reason is looking for this file and errors out when it cant find it

ERROR: Physical file does not exist, /data/SASWORK/SAS_workD88300960066_p00012/#LN00058.

Thanks

Re: SFTP Physical file does not exist

Kurt_Bremser — Mon, 10 Dec 2018 18:40:07 GMT

The message is clear, and it's not coming from SAS, but from sftp:

"/home/myhome/cool.txt" not found.

The file is not there.

Re: SFTP Physical file does not exist

naspep21 — Mon, 10 Dec 2018 18:52:32 GMT

File is certainly there. In fact the file is actually transferred over to SAS to the temp Work library. However then SAS throws in This error.

ERROR: Physical file does not exist, data/SASWORK/SAS_workD88300960066_p00012/#LN00058.

It never reads the file in after that point.

Re: SFTP Physical file does not exist

SASKiwi — Mon, 10 Dec 2018 18:57:31 GMT

Is that path to your WORK library in the SAS error correct - does it match the definition of your WORK library in your SAS session?

Re: SFTP Physical file does not exist

naspep21 — Mon, 10 Dec 2018 19:05:58 GMT

yup sure does. And the file does transfer over to the correct work location...so sas is getting that part right. But this #LN00058 file doesnt exist. Not even sure what its doing with that file.

Re: SFTP Physical file does not exist

SASKiwi — Mon, 10 Dec 2018 19:12:59 GMT

I suggest you track this problem to SAS Tech Support if you haven't already done so.

Re: SFTP Physical file does not exist

Kurt_Bremser — Mon, 10 Dec 2018 19:48:11 GMT

I pointed out the message from SFTP to you. Ignoring it will not make the cause go away. The file is not where the sftp expects it on the remote server, period.

Unless you failed to post the log correctly.

Re: SFTP Physical file does not exist

naspep21 — Mon, 10 Dec 2018 19:51:33 GMT

log was posted incorrectly and corrected above. The file exist, the corrected question above now reflects that....thanks

Re: SFTP Physical file does not exist

Kurt_Bremser — Mon, 10 Dec 2018 20:16:53 GMT

NOTE: sftp> get cool.txt /data/SASWORK/SAS_workD88300960066_p00012/#LN00058Fetching
/home/myhome/cool.txt to /data/SASWORK/SAS_workD88300960066_p00012/cool.txt

The crucial part is this:

Fetching
/home/myhome/cool.txt to /data/SASWORK/SAS_workD88300960066_p00012/cool.txt

(emphasis by me)

Somehow the sftp does not honor the target name and uses the source file name for the target.