An error might occur when running a stored process if the SAS® Stored Process Server is not functioning properly


When running a stored process, the following error message might occur if the SAS Stored Process Server is not functioning properly:

Stored Process Error
Unable to execute stored process.
The server is not running (paused/deferred stop mode?).

 

In some cases, this error message might be intermittent. For example, if the request being executed on the SAS Stored Process Server is running on port 8611 and is not functioning properly (but the other stored processes are running well on other ports), then the error message would occur only when a stored process request was sent to the process that is executed on the 8611 stored process server.

If you encounter this problem, perform the following steps to stop the process that is not functioning properly on the SAS Stored Process Server.

  1. Stop your Object Spawner.

  2. Determine if there are any processes that are running under the "sassrv" user account (that is, the "SAS General Servers" login account).

    If you are using a different user account for your "SAS General Servers" login account, then examine that account. If there is a process running under this account, then this is probably a process that is not responding on the SAS Stored Process Server.

    Determine if any stored processes are running under this user account:

    1. On the UNIX platform, use the following command:
      > ps -ef | grep "sassrv"

    2. On the Windows platform, use the Windows Task Manager

  3. If you have any SAS Stored Process Servers running under the "sassrv" (SAS General Servers) account, they must be stopped. You might need to stop these SAS processes in order to stop your processes that are executing on the Stored Process Server.

    Note: This assumes that the "sassrv" (SAS General Servers) user account is being used only for running the SAS Stored Process Server.

  4. Restart your Object Spawner.

For additional information, see SAS Note 17488: "Tips for identifying Process IDs associated with Stored Process Servers."