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

Hello,

 

Most of our users today faced an issue.
"An error occurred executing the workspace job. Server disconnected."
It happened only when trying to use excel 

1)Defining a lib libname mos "\<path>\SSS\IT\Mos.xlsx";

2)proc export data=moc
outfile="C:\Users\john\Desktop\IT\test_file.xlsx"
dbms=excel replace;
run;

The above two worked till yesterday. Today we have issues.Jobs failed in both batch and EG.

When we replace dbms=excel with dbms=xlsx, it worked for some users. But not for all.

 

Is there anything wrong with excel went on our servers?  What could be the possible issue and resolution?

 

1 ACCEPTED SOLUTION

Accepted Solutions
pessi
Obsidian | Level 7
Windows team did some patches. unintalling those patches didn't work.
Reinstalling MS access DB driver worked.

View solution in original post

4 REPLIES 4
SASKiwi
PROC Star

If this is an intermittent problem then one possible cause is network outages.

 

Check with your SAS administrator to see if they are aware of any SAS server problems.

 

Do some test runs with different users. Do some users always fail or always succeed?

pessi
Obsidian | Level 7

No network issues. No server issues. tested with many users. everyone was successful till yesterday.
We are thinking it might be due to patches applied last week, But even after revoking them we see same issue.

DavidHD
SAS Employee
Did you take a look at the messages in the workspace server log, maybe that can provide additional insides.
pessi
Obsidian | Level 7
Windows team did some patches. unintalling those patches didn't work.
Reinstalling MS access DB driver worked.

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 5202 views
  • 2 likes
  • 3 in conversation