SAS^® Stored Processes do not complete successfully under the following conditions:

• The stored process uses the File Upload feature of the SAS^® Stored Process Web Application.
• The stored process is submitted in background mode from a web-based client.

When you encounter this problem, the execution server for the stored process (SAS Stored Process Server or SAS^® Workspace Server) stops responding. You must manually terminate unresponsive stored process servers and workspace servers.

Follow these steps to identify and terminate the unresponsive servers:

1. Stop the object spawner.

• Under Windows:
  Stop the object spawner service through the Windows Services Manager.
• Under UNIX:
  Locate the ObjectSpawner.sh file in your SAS Configuration directory. Here is an example:

SAS-configuration-directory/Lev1/ObjectSpawner/ObjectSpawner.sh

From a system prompt, change directories to where the ObjectSpawner.sh script is located and submit the following:

prompt> ObjectSpawner.sh stop

2. Search for remaining SAS processes that still persist after you terminate the object spawner:

• Under Windows:
  Use the Windows Task Manager. From the Users tab, sort the process list by the user name and look for sas.exe processes with an associated user name of sassrv (stored process server) or with an associated user name of end users experiencing the problem (standard workspace server).
• Under UNIX:
  Use the ps system command. Here is an example:

prompt> ps -ef | grep "StoredProcessServer"
prompt> ps -ef | grep "WorkspaceServer"

3. Stop the unresponsive processes.

• Under Windows:
  Use Task Manager or the kill command to terminate the unresponsive SAS servers.
• Under UNIX:
  Use the kill command. See the example below:

prompt> kill <process ID#>

4. Restart the object spawner.

• Under Windows:
  Start the object spawner service through the Windows Services Manager.
• Under UNIX:
  Locate your ObjectSpawner.sh file in your SAS configuration directory. Here is an example:

SAS-configuration-directory/Lev1/ObjectSpawner/ObjectSpawner.sh

From a system prompt, change directories to where the ObjectSpawner.sh script is located and submit the following:

prompt> ObjectSpawner.sh start

5. Clean up leftover Work library files. These files accumulate as a result of abnormal termination of the stored process server and workspace server sessions.

• Under Windows:
  Use the Cleanwork Utility, available beginning with the second maintenance release for SAS^® 9.4 (TS1M2).

For SAS releases earlier than SAS 9.4 TS1M2, use the SAS Disk Cleanwork Handler. For further information about this program see SAS Note 8786, "SAS^® Disk Cleanup Handler replaces a SAS^® 9.1 program called cleanworkpc.sas to clean work directories on Windows systems."

• Under UNIX:
  Use the cleanwork command.

To avoid this problem, do not configure a stored process that uses the File Upload feature to execute in background mode.

For more information about using the File Upload feature of the SAS Stored Process Web Application, refer to the Uploading Files section of SAS^® 9.4 Stored Processes: Developer's Guide, Third Edition.