BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
JohnJPS
Quartz | Level 8

I've already done a web serch on this one, and found a link that recommended newer drivers, but we're already on the latest. Has anyone seen this error: 

 

ERROR: A pipe communications routine failed: The pipe has been ended. (109)
ERROR: A pipe communications routine failed: The pipe is being closed. (232)
ERROR: A pipe communications routine failed: The pipe is being closed. (232)

 

PS: we're on Windows Server; and it is pulling from a network share location; users did not have this issue prior to us moving to from client-only to client-server, though; but may be useful info.

 

Any ideas on working around this sort of error?

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
JohnJPS
Quartz | Level 8

Another follow-up. Giving our service account that runs the process local admin status on the server running the job resolves the problem.

Esentially, it needs access to a registry key "Access Connectivtiy Engine." -- making the account Local Admin solved the problem..

View solution in original post

7 REPLIES 7
ballardw
Super User

Most likely cause is a network issue of some sort. Whether between your server and the data source or your SAS and the Server is a question.

Work arounds may depend on how you are communicating with the DB. You might share some details of that as specific DB may have different options for poor network traffic.

 

Or is this taking long enough that a higher priority user is "bumping" your access to the data?

JohnJPS
Quartz | Level 8

The database is just a MS Access "database" flat file. Agreed it's probably something with the network... hopefully it isn't chronic though.

Reeza
Super User

Well without the code+log we can't really say anything else. 

SASKiwi
PROC Star

You should talk to your IT network folks. I'm wondering if there are timeout rules in firewalls and/or network connections causing the problem.

Reeza
Super User

Were the paths in the pipe properly updated to use the server path/UNC path?

JohnJPS
Quartz | Level 8

Sorry for not responding sooner.  Discoveries since last time, using a more sterilized test involving both an Excel file and a smaller .accdb from an accessible UNC path.

 

Excel file:

  • Works from EG
  • Works running SASBatch from the server manually (logged on as ultra powerful SAS account)
  • Works running SASBatch from our scheduling system (using system-spcific service account)

AccessDB file

  • Works from EG
  • Works running SASBatch from the server manually (regardless of DBMS=ACCESS or DBMS=ACCESSCS)
  • Fails running SASBatch from our scheduling system (with a system-specific service account)
    • With DBMS=ACCESS, gives generic dump and says to conctact support (which is in play)
    • With DBMS=ACCESSCS, give the errors noted in original post

Anyway, so it's in flight with SAS Tech Support and I'll update the thread when I have something, but it sure seems permissions related... but the permissions only take effect with the .accdb file, not with the .xlsx file.

 

If anyone has any ideas around that angle (e.g. some subfolder somewhere to which we need to give our service account access; or some permission within SAS, etc...), I'm all ears.

 

Thanks!

 

JohnJPS
Quartz | Level 8

Another follow-up. Giving our service account that runs the process local admin status on the server running the job resolves the problem.

Esentially, it needs access to a registry key "Access Connectivtiy Engine." -- making the account Local Admin solved the problem..

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

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
  • 7 replies
  • 1632 views
  • 2 likes
  • 4 in conversation