topic Re: SAS Enterprise guide fails in SAS Enterprise Guide

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

Yarlanil59 — Fri, 17 Feb 2017 15:43:32 GMT

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

Re: SAS Enterprise guide fails

ChrisHemedinger — Tue, 14 Feb 2017 20:45:09 GMT

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.

Re: SAS Enterprise guide fails

Yarlanil59 — Tue, 14 Feb 2017 20:53:47 GMT

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

Re: SAS Enterprise guide fails

ballardw — Tue, 14 Feb 2017 21:06:59 GMT

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.

Re: SAS Enterprise guide fails

Yarlanil59 — Tue, 14 Feb 2017 21:34:39 GMT

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.

Re: SAS Enterprise guide fails

ChrisHemedinger — Tue, 14 Feb 2017 22:31:24 GMT

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

Re: SAS Enterprise guide fails

ballardw — Tue, 14 Feb 2017 23:08:45 GMT

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

Re: SAS Enterprise guide fails

Yarlanil59 — Fri, 17 Feb 2017 15:44:38 GMT

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.