topic Re: file not found in SAS Enterprise Guide

file not found

alepage — Thu, 29 Oct 2020 13:23:17 GMT

Hello,

Our SAS version was upgrated on one of our Unix server at the end of september, and for a reason I don't understand it seems that some files are missing. It is like some files have been deleted randomly. Hard to believe.

Here's the errors:

MPRINT(IMPORT_TRANSACTION): SYSTASK COMMAND "rm /dwh_operation/sasdata/smp_production/smp_ref/trans/AUPOLI.XPORT" WAIT;
NOTE: Task "task1" produced no LOG/Output.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
MPRINT(IMPORT_TRANSACTION): proc datasets LIBRARY=sortie NOLIST;
ERROR: Unable to obtain file system status for path
/dwh_operation/sasdata/smp_production/smp_ref/trans/auto_polices_20170602.dpf.00021c6e.0.1.spds9: Reason=File was not found.
ERROR: Unable to obtain file system status for path
/dwh_operation/sasdata/smp_production/smp_ref/trans/auto_polices_20170602.dpf.00021c6e.3.1.spds9: Reason=File was not found.
ERROR: Unable to obtain file system status for path
/dwh_operation/sasdata/smp_production/smp_ref/trans/auto_polices_20170602.dpf.00021c6e.5.1.spds9: Reason=File was not found.
ERROR: Unable to obtain file system status for path
/dwh_operation/sasdata/smp_production/smp_ref/trans/auto_polices_20170605.dpf.00021c6e.2.1.spds9: Reason=File was not found.
ERROR: Unable to obtain file system status for path
/dwh_operation/sasdata/smp_production/smp_ref/trans/auto_polices_20170605.dpf.00021c6e.4.1.spds9: Reason=File was not found.
ERROR: Unable to obtain file system status for path
/dwh_operation/sasdata/smp_production/smp_ref/trans/auto_polices_20170607.dpf.00021c6e.0.1.spds9: Reason=File was not found.
ERROR: Unable to obtain file system status for path
/dwh_operation/sasdata/smp_production/smp_ref/trans/auto_polices_20170607.dpf.00021c6e.3.1.spds9: Reason=File was not found.
ERROR: Unable to obtain file system status for path
/dwh_operation/sasdata/smp_production/smp_ref/trans/auto_polices_20170614.dpf.00021c6e.0.1.spds9: Reason=File was not found.
ERROR: Unable to obtain file system status for path
/dwh_operation/sasdata/smp_production/smp_ref/trans/auto_polices_20170614.dpf.00021c6e.2.1.spds9: Reason=File was not found.
ERROR: Unable to obtain file system status for path
/dwh_operation/sasdata/smp_production/smp_ref/trans/auto_polices_20170614.dpf.00021c6e.4.1.spds9: Reason=File was not found.

Does someone has some suggestion what could be done to solve this issue.

Regards,

Re: file not found

Amir — Thu, 29 Oct 2020 13:37:13 GMT

Hi @alepage ,

Can you see if the same user id that is being used to run the SAS code can access the files without using SAS?

This might be an access permission issue.

Kind regards,

Amir.

Re: file not found

alepage — Thu, 29 Oct 2020 14:03:21 GMT

Hello,

We can see the many spde files into the folder but not the one being reported as missing. The missing files are not into the folder.

Re: file not found

Amir — Thu, 29 Oct 2020 14:33:13 GMT

Hi @alepage ,

The error message is mentioned in the following article if that's of any help:

https://communities.sas.com/t5/SAS-Communities-Library/Accessing-SPDE-files-with-CAS/ta-p/507673

Kind regards,

Amir.

Re: file not found

SASKiwi — Thu, 29 Oct 2020 19:14:21 GMT

If the required files are definitely not showing in a simple directory search, talk to those who were involved in the SAS upgrade to see if they can explain why the files were removed. As a general rule any SAS upgrade will not tamper with user folders.

Arrange a restore from backup of the missing files.

Re: file not found

alepage — Fri, 30 Oct 2020 17:56:03 GMT

Hello,

After making some verifications, it was found that those files were deleted a long time ago. Theses errors message are due to the fact that a piece of code was added to one of our sas programs in order to check if files are deleted into that directory.

So there is no issue in terms of SAS software upgrade but just a piece of code added in the same time.

Thanks for your help and for sharing your thoughs.