file not found

[alepage]

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,

[Amir]

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.

[alepage]

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.

[Amir]

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.

[SASKiwi]

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.

[alepage · Accepted solution]

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.