topic Re: An error occurred executing the workspace job. Server disconnected. Excel issue in Administration and Deployment

An error occurred executing the workspace job. Server disconnected. Excel issue

pessi — Mon, 07 Dec 2020 06:21:32 GMT

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?

Re: An error occurred executing the workspace job. Server disconnected. Excel issue

SASKiwi — Mon, 07 Dec 2020 07:04:41 GMT

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?

Re: An error occurred executing the workspace job. Server disconnected. Excel issue

pessi — Mon, 07 Dec 2020 11:53:09 GMT

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.

Re: An error occurred executing the workspace job. Server disconnected. Excel issue

DavidHD — Mon, 07 Dec 2020 12:29:15 GMT

Did you take a look at the messages in the workspace server log, maybe that can provide additional insides.

Re: An error occurred executing the workspace job. Server disconnected. Excel issue

pessi — Thu, 10 Dec 2020 09:18:52 GMT

Windows team did some patches. unintalling those patches didn't work.
Reinstalling MS access DB driver worked.