Problem Note 43097: The error "No available engine session manager slots" occurs when you access Teradata tables with the META LIBNAME engine
 |  |  |  |  |
The following error can occur when you access Teradata tables using the META libname engine:
ERROR: No available engine session manager slots. All 215 in use.
The error might happen because connections to Teradata have been leaked.
To circumvent the problem, specify values of SHARED, SHAREDREAD, GLOBAL, or GLOBALREAD for the CONNECTION= option when you define the Teradata library in the SAS® Metadata Repository.
The total number of slots (215) cannot be increased.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS Metadata Server | Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS2M3 | 9.4 TS1M0 |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Microsoft Windows XP 64-bit Edition | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Microsoft® Windows® for x64 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2003 for x64 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2008 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Microsoft Windows XP Professional | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Windows Vista | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Windows Vista for x64 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| 64-bit Enabled AIX | 9.2 TS2M3 | 9.4 TS1M0 | ||
| 64-bit Enabled HP-UX | 9.2 TS2M3 | 9.4 TS1M0 | ||
| 64-bit Enabled Solaris | 9.2 TS2M3 | 9.4 TS1M0 | ||
| HP-UX IPF | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Linux | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Linux for x64 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Solaris for x64 | 9.2 TS2M3 | 9.4 TS1M0 | ||
A fix for this issue for Base SAS 9.21_M3 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/B25.html#43097A fix for this issue for Base SAS 9.3_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/I22.html#43097A fix for this issue for Base SAS 9.3_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/F98.html#43097
Connections might be leaked when you access Teradata tables with the META LIBNAME engine. The leak leads to the error.
| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2011-05-05 10:02:55 |
| Date Created: | 2011-04-28 10:08:24 |