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?