Problem Note 65746: A metadata connection leak occurs when you save a SAS® Enterprise Guide® project on SAS® Content Server
 |  |  |  |  |
You might encounter several metadata connections being left open from the middle tier and the metadata server. The issue began in SAS® 9.4M3 (TS1M3). This issue is caused by SAS® Web Infrastructure Platform services not closing the metadata connection. The connections originate from SASServer1_1 where the SAS Content Server and WIP Services are deployed to the metadata server. In this scenario, there are far more connections than users who are connected. These metadata connections are never cleaned up or closed.
Currently, the only workaround is to restart the SAS® Web Application Server.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Web Infrastructure Platform | Microsoft® Windows® for x64 | 9.4_M3 | 9.4_M7 | 9.4 TS1M3 | 9.4 TS1M7 |
| 64-bit Enabled AIX | 9.4_M3 | 9.4_M7 | 9.4 TS1M3 | 9.4 TS1M7 | ||
| 64-bit Enabled Solaris | 9.4_M3 | 9.4_M7 | 9.4 TS1M3 | 9.4 TS1M7 | ||
| HP-UX IPF | 9.4_M3 | 9.4_M7 | 9.4 TS1M3 | 9.4 TS1M7 | ||
| Linux for x64 | 9.4_M3 | 9.4_M7 | 9.4 TS1M3 | 9.4 TS1M7 | ||
| Solaris for x64 | 9.4_M3 | 9.4_M7 | 9.4 TS1M3 | 9.4 TS1M7 | ||
A fix for this issue for SAS Add-In for Microsoft Office 8.2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/G7H.html#65746A fix for this issue for SAS Enterprise Guide 8.2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/G5J.html#65746A fix for this issue for SAS Add-In for Microsoft Office for Visual Analytics 8.2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/G7I.html#65746A fix for this issue for SAS Add-in for Microsoft Office 7.15 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/B4P.html#65746A fix for this issue for SAS Enterprise Guide 7.15 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/B4N.html#65746A fix for this issue for SAS Deployment Backup and Recovery Tool 9.41 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Y20.html#65746A fix for this issue for SAS Management Console 9.4_M3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/V11.html#65746A fix for this issue for SAS Grid Manager Plug-ins for SAS Management Console 9.4_M3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/C4D.html#65746A fix for this issue for SAS Middle Tier 9.4_M3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/V10.html#65746| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2020-08-10 11:34:08 |
| Date Created: | 2020-03-25 13:17:49 |