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?
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?
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.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
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.