Connection errors when running a query in SAS® Information Map Studio or SAS® Web Report Studio


If SAS Trusted User (sastrust@saspw) is an unrestricted user and you are using a pooled workspace server, queries in SAS Information Map Studio and SAS Web Report Studio will fail.

For example, when attempting to run a query, you might see an error message that includes the following content, indicating that a connection to the pooled workspace server on port 8701 has been refused.

 Connection refused: connect 
java.net.ConnectException: Connection refused: connect 
............
[ com.sas.services.connection.FatalConnectionFactoryException: The application could not 
log on to the server "machine.name.com:8701". No server is available at that port on that machine.  

Following is another typeof connection error that you might see in the application or the log.

ERROR [] com.sas.servlet.tbeans.valuepicker.ValuePicker - 
An existing connection was forcibly closed by the remote host

In addition, the object spawner log will contain messages similar to the following, indicating that a password cannot be retrieved for the launch credentials for the pooled workspace server (typically, sassrv).

2010-09-01T10:30:06,119 INFO  [00000021] SYSTEM@machine - Error authenticating user machine\sassrv in function LogonUser.  
   Error 1326 (Logon failure: unknown user name or bad password. ).
2010-09-01T10:30:06,119 WARN  [00000021] SYSTEM@machine - The credentials specified for the SASApp - Pooled Workspace Server (A53BEC7R.AV000006) 
  server definition failed to authenticate. Therefore this server definition will not be included.
2010-09-01T10:30:06,120 WARN  [00000021] SYSTEM@machine - The password obtained from the metadata indicates 
  that it was obtained by an user that has unrestricted access.  Please check your configuration.

To resolve this problem, perform these steps:

  1. Log in to SAS Management Console as an administrative user (such as sasadm@saspw).
  2. Under the User Manager plug-in, open the properties for the SAS Trusted User.
  3. Click the Groups and Roles tab.
  4. Edit the SAS Trust User's memberships so that he is not a member of any of the following groups or roles.
    • SAS Administrators
    • Metadata Server:Unrestricted
    • Metadata Server:User Administration

Note: You must also ensure that the SAS Trusted User is not an indirect member of any group or role with unrestricted privileges.

5. Restart your object spawner.