Error while importing a file

[UshaLatha]

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

[nhvdwalt]

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.

[Kurt_Bremser]

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

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

[qwerty11]

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 

[Kurt_Bremser]

Does the workspace server come up for any other submission?

[qwerty11]

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

[Kurt_Bremser]

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;

[qwerty11]

@Kurt_Bremser 

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

[Sajid01]

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.

[qwerty11]

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 

[Sajid01]

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

[qwerty11]

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 

[SASKiwi]

@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. 

[qwerty11]

@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! 🙂