Using the connection pooling option in SAS Federation Server might cause a leaked database connection and increased memory use. Leaked database connection handles remain in a connected state, possibly reducing the availability of additional connections to database servers configured for use with SAS Federation Server data services.

Note: For information about connection pooling, see "Managing Client Connections" in SAS^® Federation Server 4.2: Administrator's Guide, Second Edition.

When you encounter this issue, you can use one of the following workarounds:

• Run with connection pooling turned off. In a SAS Federation Server administrator role, issue the following data definition language (DDL) via a DSN=ADMIN connection:
  alter server {options xset CONNECTION_POOLING OFF}
• Run with a time-out value exceeding the scheduled uptime of the SAS Federation Server. You can configure an indefinite time-out value as follows:
  alter server {options xset CONNECTION_POOLING ON, xset CONNECTION_POOL_TIMEOUT -1}

To obtain a fix for this issue, contact SAS Technical Support.

Operating System and Release Information