Desktop productivity for business analysts and programmers

SAS Enterprise guide fails: [Error] Library WORK does not exist

Accepted Solution Solved
Reply
Contributor
Posts: 35
Accepted Solution

SAS Enterprise guide fails: [Error] Library WORK does not exist

[ Edited ]

When using query builder it is showing. But I can use for other tables to create in sas work. Only some time it is showing this error.

Application Error
SAS Enterprise Guide needs to close
SAS Enterprise Guide has encountered a problem and needs to close. We are sorry for the inconvenience.

-------------------------------------------------------------------------------------------------------
Exception information
-------------------------------------------------------------------------------------------------------

[Error] Library WORK does not exist.


-------------------------- Technical Information Follows --------------------------

Exception Details:
----------------------------------------
Exception type: System.Data.OleDb.OleDbException
SAS Message: [Error] Library WORK does not exist.

Raw Message: <?xml version="1.0" ?><Exceptions><Exception><SASMessage severity="Error">Library WORK does not exist.</SASMessage></Exception></Exceptions>
Target Site: ExecuteCommandTextErrorHandling

 


Accepted Solutions
Solution
‎02-17-2017 10:44 AM
Contributor
Posts: 35

Re: SAS Enterprise guide fails

[ Edited ]

I very sorry for the confusion. The error which I mention is not causing by any code. We schedule a script to clean SAS WORK folders and somehow It was deleting my WORK folder while in use. I resolved it.

View solution in original post


All Replies
Community Manager
Posts: 2,889

Re: SAS Enterprise guide fails

Hi @Yarlanil59 - we'll need some more information.  What vesion of EG, and what version of SAS?  Are you running this on a SAS Grid Environment?

 

You might need to enable additional logging (Tools->Options->Application Logging in EG 7.1 and later) and work with SAS Technical Support to diagnose.

Contributor
Posts: 35

Re: SAS Enterprise guide fails

Thanks for the replySAS EG 7.13 and SAS 9.4. Not a grid environment. Standalone environment.
Insufficient space in file WORK.'SASTMP-000000033'n.UTILITY. 
ERROR: File WORK.'SASTMP-000000033'n.UTILITY is damaged. I/O processing did not complete.
But work space is 1.0TB free
Super User
Posts: 11,134

Re: SAS Enterprise guide fails

This bit:

[Error] Library WORK does not exist.

 

indicates a very major error. I've been using SAS off and on for nearly 30 years and have never seen that one.

 

I would close down SAS and restart and check the log before doing anything to see if there are start up issues. And veryify that teh WORK library is available.

 

 

Contributor
Posts: 35

Re: SAS Enterprise guide fails

Thanks for the reply.

Work library is available. I tried different code it worked fine. only when distinct is selected it is happening like that.
Community Manager
Posts: 2,889

Re: SAS Enterprise guide fails

Assuming you're working with a large table or perhap a complex join, and that's creating a large utility table in WORK and filling up the space.  You might try chunking your query into steps, or reconsider any expensive operations (such as ORDER BY/sorted output).

Super User
Posts: 11,134

Re: SAS Enterprise guide fails

Post the code of what you submit that causes the problem and describe the data set(s) involved.

Solution
‎02-17-2017 10:44 AM
Contributor
Posts: 35

Re: SAS Enterprise guide fails

[ Edited ]

I very sorry for the confusion. The error which I mention is not causing by any code. We schedule a script to clean SAS WORK folders and somehow It was deleting my WORK folder while in use. I resolved it.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 7 replies
  • 373 views
  • 0 likes
  • 3 in conversation