topic Re: SAS File Output error - File In Use in SAS Enterprise Guide

SAS File Output error - File In Use

cbrotz — Tue, 13 Nov 2018 14:26:28 GMT

Can anyone shed some light on what this error means? I did actually open the file referenced and it opens manually, but when I run the job in Windows Task Scheduler, it says it is in use. Thank you!

ERROR: You cannot open REPORTS.DAILYREPORT3RESALECON.DATA for output access with member-level control because
REPORTS.DAILYREPORT3RESALECON.DATA is in use by you in resource environment IOM ROOT COMP ENV.

Re: SAS File Output error - File In Use

ChrisHemedinger — Tue, 13 Nov 2018 14:28:19 GMT

Usually this means that you have the data set open in another app, such as SAS Enterprise Guide. Make sure that all of your EG sessions are closed when you try to run something in a scheduled task -- if possible. Especially if you're working with the same data.

Re: SAS File Output error - File In Use

cbrotz — Tue, 13 Nov 2018 14:30:58 GMT

I just shut the machine down, restarted and re-ran and it worked. There are many many files in that code. I don't know why just that file was hung up, but it looks like it is resolved. Thanks.

Re: SAS File Output error - File In Use

ballardw — Tue, 13 Nov 2018 15:31:13 GMT

One cause of that type of message is that you are examining the properties of a data set using one of the tools such as SAS Explorer or have the table open in table view and did not shut the window prior to running the code.

Re: SAS File Output error - File In Use

cbrotz — Tue, 13 Nov 2018 15:48:04 GMT

The weird thing is - it says "opened by you" which would mean someone opened that file on that machine using some SAS tool but none are open. I am having ongoing issues with this particular EG project. It is very large and I don't have time to rewrite at the moment but I think it just has too many output files.

Re: SAS File Output error - File In Use

ChrisHemedinger — Tue, 13 Nov 2018 18:03:42 GMT

The "IOM ROOT COMP ENV" is a give-away -- the file is held by a process that's in a SAS Workspace server, probably with SAS Enterprise Guide or the SAS Add-In for Microsoft Office as the client. If you think all of your EG sessions are closed, you might want to check Task Manager for SEGuide.exe instances.

Re: SAS File Output error - File In Use

cbrotz — Tue, 13 Nov 2018 21:24:49 GMT

So something in the SAS server is holding the file? I am not expecting you to know for sure but you think it is a server thing?

Re: SAS File Output error - File In Use

cbrotz — Mon, 19 Nov 2018 13:04:51 GMT

I ended up opening an empty EG project and copying the current code module and all output modules into the new EG. I also deleted all the SAS output Excel files out of the output folder. It has run successfully for the past three days. I still do not know why this error occurs to begin with but this solved it for now.