Desktop productivity for business analysts and programmers

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

Reply
Occasional Contributor
Posts: 7

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

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

Super User
Posts: 8,062

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

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Occasional Contributor
Posts: 7

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

Posted in reply to KurtBremser

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

Ask a Question
Discussion stats
  • 2 replies
  • 101 views
  • 0 likes
  • 2 in conversation