Desktop productivity for business analysts and programmers

Error while importing a file

Reply
Contributor
Posts: 28

Error while importing a file

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

 

Super Contributor
Posts: 292

Re: Error while importing a file

Posted in reply to UshaLatha

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.

Super User
Posts: 9,607

Re: Error while importing a file

Posted in reply to UshaLatha

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

 

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

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 2 replies
  • 94 views
  • 0 likes
  • 3 in conversation