topic Re: Error while importing a file in SAS Enterprise Guide

Error while importing a file

UshaLatha — Tue, 24 Apr 2018 11:46:39 GMT

Hi ,

While trying to import a csv file, encountered following error:

An error occurred executing the workspace job "The Import Data Wizard (Intermediate submit)".

The server is disconnected.

Please help how to resolve this error.

Thanks

Re: Error while importing a file

nhvdwalt — Tue, 24 Apr 2018 11:55:09 GMT

In short, it means your workspace server session has crashed. The trick is to find out why...

I guess there are different ways to troubleshoot, but my approach would be to run the code in batch on the server, thus removing things like SAS Enterprise Guide, Workspace Servers, etc. out of the equation. When the SAS session then crashes again, you should receive a lot more diagnostic information than what you do in Enterprise Guide. Based on this info you can then investigate further.

Re: Error while importing a file

Kurt_Bremser — Tue, 24 Apr 2018 11:55:20 GMT

Please post the code that was submitted by the import task.

How large is the csv file, and what does the layout look like?

Re: Error while importing a file

qwerty11 — Mon, 15 Mar 2021 16:59:29 GMT

Hello Geeks,

I have a similar error "An error occurred executing the workspace job "the import data wizard (intermediate submit)". Timeout during initialization".

Here, we are trying to use Import functionality in SAS EG. When my colleague is trying to do it, there is no error.

Note: the excel file is in a shared drive.

@Kurt_Bremser @nhvdwalt, @UshaLatha

Re: Error while importing a file

Kurt_Bremser — Tue, 16 Mar 2021 07:51:20 GMT

Does the workspace server come up for any other submission?

Re: Error while importing a file

qwerty11 — Tue, 16 Mar 2021 12:35:52 GMT

No, just during the Import Wizard from EG.
Magically it was fixed by noon without any intervention. But the problem is back now. It is intermittent at this point.
Any suggestions for troubleshooting?

Thanks

Re: Error while importing a file

Kurt_Bremser — Tue, 16 Mar 2021 12:54:16 GMT

What I meant: can any other task be executed on this workspace server? E.g. a code node with

proc print data=sashelp.class;
run;

Re: Error while importing a file

Sajid01 — Wed, 17 Mar 2021 13:54:17 GMT

Hello @qwerty11
Note: the excel file is in a shared drive.
Please investigate network issues with the appropriate admins and storage team.
Take help from your SAS Administration.

Re: Error while importing a file

qwerty11 — Wed, 17 Mar 2021 21:30:22 GMT

@Kurt_Bremser

sorry, i meant "Yes" . Was able to run all .sas & .egp with no issues.

Re: Error while importing a file

qwerty11 — Wed, 17 Mar 2021 21:33:30 GMT

I'm an SAS Admin 🙂

and yes, as i mentioned before these are One Drive - shared drives. No problem here, checked that.

We created a libname statement and read data - no issues.

Only issue is when we use the import wizard in EG, which is again intermittent. @Sajid01

Re: Error while importing a file

Sajid01 — Wed, 17 Mar 2021 22:57:28 GMT

Why not enable workspace server logs for some time and see if they through some light?

Re: Error while importing a file

qwerty11 — Thu, 18 Mar 2021 14:53:02 GMT

yes that would be last option before i submit a SAS Track 🙂

since the issue is intermittent, will enable workspace sever logs when we have the issue again. there were no issues from yesterday.

thanks @Sajid01

Re: Error while importing a file

SASKiwi — Fri, 19 Mar 2021 21:58:23 GMT

@qwerty11 - Since it works fine for your colleague then this would appear to be a PC-specific issue. Do both PCs have the same OS and MS product versions? One Drive and MS 365 have rolled out a lot of enhancements recently. Might also be work checking the Windows event log for any errors.

Re: Error while importing a file

qwerty11 — Mon, 22 Mar 2021 13:21:59 GMT

@SASKiwi : that's a god point, as there were MS 365 updates which were rolled out a couple of weeks back (OS and others are same)! will check if the user has the latest updates, thank you! 🙂