Hello Eveyone, we have implemented SAS SPDE sever( dividing the datapath and index path into E and F drives, Meta data into Primary path E) for some of the scheduled jobs for performance improvement( Since Datsets are huge in sizes) We recently came across an issue for which spending lot of time but couldnt help !. The issue arising when new data added to the Base table using PROC APPEND. Following is the error message displays in the log file: NOTE: Appending WORK.OPENS to Master.OPENS NOTE: There were 97 observations read from the data set WORK.OPENS NOTE: 97 observations added. NOTE: The data set APSIS.OPENS_INVALID_LANDKOD has 7176598 observations and 14 variables. ERROR: The handle is invalid. ERROR: dareadp: Read failed: File=J:\SASdata\MASTER\Meta1\opens.mdf.0.0.0.spds9 Reason=Disk read failed on specified operation errno=-2134906859 ERROR: dauprev: DAFDREVISE on DPF component failed: Member=OPENS Reason=Disk read failed on specified operation ERROR: dafrfcb: Revision update failed on opens: Reason=Disk read failed on specified operation SO from the error message it is understood that there is a probolem with the metadata. Disk is failed to read metadata file while appending and throwing error like handle name is invalid. But I have no clue what is the exact reason behind it and what are the steps to follow to resolve it. We already restarted the metadata server through management console and still the problem persists. Help on this would be Greatly appreciated. I look forward to hear from you all. Thank you so much in Advance !!! Sridhar Sripada
... View more