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=mocoutfile="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?
View solution in original post
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.
Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.
Find more tutorials on the SAS Users YouTube channel.