BookmarkSubscribeRSS Feed
Sridher_Sripada
Calcite | Level 5

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

2 REPLIES 2
LinusH
Tourmaline | Level 20

THe metadata file has "nothing" to do with the metadata in the metadata server, the terminology might be a bit confusing...

So this sounds more like a physical problem.

What OS do you use?

What is your partsize setting? (which leads to the question how many dpf-files you have for that table).

Make sure that you don't have any out of memory issue (RAM and disk, including saswork) during the operation.

Data never sleeps
Kurt_Bremser
Super User

Have your admin run an extended check on the disk(s) in question, ASAP. You may be experiencing a creeping death of one of your disks. If that returns no problems, run a repair on the file system.

In UNIX, I'd unmount the file system and do a fsck, after making sure I don't have some kind of disk full condition.

Also check for the existence and size of J:\SASdata\MASTER\Meta1\opens.mdf.0.0.0.spds9

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 790 views
  • 0 likes
  • 3 in conversation