- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 09-12-2010 08:54 AM
(1754 views)
Hi,
I am trying to restart a SAS Object Spawner via a SAS Stored Process. If I test this code in Base SAS it works ok but when I use it in a Stored Process and run it in SAS Enterprise Guide or the SAS Webapp it does not error but does not restart the Object Spawner.
The .bat file contains this
net stop "SAS Object Spawer"
net start "SAS Object Spawner"
This is a different Spawner and not used by the stored process itself.
I have enabled the x command which works ok as I can unzip a file on
the O/S (Windows 2003) from a SAS STP.
%let live=Yes;
%if &live=Yes %THEN %DO;
* Restart the SAS Object Spawner;
options noxwait xmin;
data _null_;
do;
call system('"cd c:\temp"');
call system('"RestartOB.bat"');
end;
run;
%end;
Any ideas?
Thanks
Lee
I am trying to restart a SAS Object Spawner via a SAS Stored Process. If I test this code in Base SAS it works ok but when I use it in a Stored Process and run it in SAS Enterprise Guide or the SAS Webapp it does not error but does not restart the Object Spawner.
The .bat file contains this
net stop "SAS Object Spawer"
net start "SAS Object Spawner"
This is a different Spawner and not used by the stored process itself.
I have enabled the x command which works ok as I can unzip a file on
the O/S (Windows 2003) from a SAS STP.
%let live=Yes;
%if &live=Yes %THEN %DO;
* Restart the SAS Object Spawner;
options noxwait xmin;
data _null_;
do;
call system('"cd c:\temp"');
call system('"RestartOB.bat"');
end;
run;
%end;
Any ideas?
Thanks
Lee
5 REPLIES 5
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
When you run a stored process, your code is executing on the Stored Process server ot the Workspace server. Have you checked with your SAS admin to verify the correct path-- the SERVER path -- on those machines?? Are those servers Windows machines? Do you know that the c:\temp directory exists on the server that you are using?? You might want to check with Tech Support, because I believe that your script or .BAT file will also have to be on the server to be executed. Generally, speaking, the Stored Process server and the Workspace server do not have visibility of a directory on your local machine.
Cynthia
When you run a stored process, your code is executing on the Stored Process server ot the Workspace server. Have you checked with your SAS admin to verify the correct path-- the SERVER path -- on those machines?? Are those servers Windows machines? Do you know that the c:\temp directory exists on the server that you are using?? You might want to check with Tech Support, because I believe that your script or .BAT file will also have to be on the server to be executed. Generally, speaking, the Stored Process server and the Workspace server do not have visibility of a directory on your local machine.
Cynthia
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Other things to check.
what user Id is being used, does it have the correct permission to start/stop a service.
Check your event log, are there any msg there?
Cheers
Barry
what user Id is being used, does it have the correct permission to start/stop a service.
Check your event log, are there any msg there?
Cheers
Barry
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Barry,
The user I am using stops the service ok during my Base testing.
I will dive in the event log and check other permissions eg: sassrv,
Thanks
Lee
The user I am using stops the service ok during my Base testing.
I will dive in the event log and check other permissions eg: sassrv,
Thanks
Lee
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hi
I never got to the bottom of this and the need went away. So it is still a mystery. Will pick it back up another time.
Lee
I never got to the bottom of this and the need went away. So it is still a mystery. Will pick it back up another time.
Lee
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Cynthia,
- I am executing via the STP as Iam running a Stored Process.
- The path is correct because the process works in Base.
- All this sesting I am doing on the SAS Compute Server where the spawners are, no clients.
Thanks
Lee
- I am executing via the STP as Iam running a Stored Process.
- The path is correct because the process works in Base.
- All this sesting I am doing on the SAS Compute Server where the spawners are, no clients.
Thanks
Lee