topic Re: Path of Work library changes halfway through code running (Local Server) in SAS Enterprise Guide

Path of Work library changes halfway through code running (Local Server)

WestChan — Tue, 12 Sep 2017 06:43:46 GMT

I’m having a very bizarre issue at the moment where the path of the work library is changing halfway through me running the code, leaving me with the error message: TABLENAME could not be found.

For example, if I would import data, and I can see it in the work library, The path of the work library would be like: C:\Users\$User\SASTempfile\_TD11568

And then I would run my next step in the code, which could be some simple proc sql referring to the imported data. Halfway through processing, i would get TABLENAME could not be found error. The work library has been changed to: C:\Users\$User\SASTempfile\_TD14024

This all happens in less than 10 Minutes.

Have i accidently selected an option unintentionally? Can anyone identify what’s happening?

Thanks

Re: Path of Work library changes halfway through code running (Local Server)

Kurt_Bremser — Tue, 12 Sep 2017 07:05:32 GMT

Maybe you set "allow parallel execution on the same server" for your project. It's found in the last option of the project properties.

Are all nodes in the project running without problems (no WARNINGs, no ERRORs)? If one causes an abort (which terminates the SAS instance), EG would automatically start a new workspace server for the next submit.

Re: Path of Work library changes halfway through code running (Local Server)

WestChan — Tue, 12 Sep 2017 07:11:59 GMT

Hi Kurt,

Allow parallel execution on the same server was not selected.

That is correct, All prior nodes does not have any errors, but that sounds like a similar result to what I am seeing.

Thanks