Problem Note 44425: Campaigns and diagrams might fail to complete execution or fail to connect to the database when they use the SAS® Scalable Performance Data Server
 |  |  |  |  |
SAS® Marketing Automation campaigns and diagrams might fail to execute when they use the SAS Scalable Performance Data Server as their data source. This problem frequently occurs when you run multiple campaigns or diagrams concurrently. The error messages in the SAS Marketing Automation log that usually accompany this issue are:
ERROR: 10054 - WSAECONNRESET. ERROR: Error in the LIBNAME statement.
or
ERROR: Broken pipe.
When a diagram or campaign finishes executing, its connections with the SPD Server are not immediately released. The number of active connections to the SPD Server might accumulate, exceeding a threshold either within the operating system or within the SPD Server.
To reduce the frequency of this problem, add the following libref parameter to the SPD Server libref statements used in SAS Marketing Automation:
DISCONNECT=YES
At the end of any custom code, individually clear each libref that is used in the code, as in this example:
LIBNAME MYSPDS CLEAR; LIBNAME YOURSPDS CLEAR;
This problem is fixed by applying hot fix B57002 or later to the underlying SAS SPD Server.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SPDS | Scalable Performance Data Server | Windows 7 Enterprise x64 | 4.52 | 4.52 HF2 | ||
| Windows 7 Enterprise 32 bit | 4.52 | 4.52 HF2 | ||||
| Microsoft Windows XP Professional | 4.52 | 4.52 HF2 | ||||
| Microsoft Windows Server 2008 for x64 | 4.52 | 4.52 HF2 | ||||
| Microsoft Windows Server 2008 | 4.52 | 4.52 HF2 | ||||
| Microsoft Windows Server 2003 for x64 | 4.52 | 4.52 HF2 | ||||
| Microsoft Windows Server 2003 Standard Edition | 4.52 | 4.52 HF2 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 4.52 | 4.52 HF2 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 4.52 | 4.52 HF2 | ||||
| Microsoft Windows NT Workstation | 4.52 | 4.52 HF2 | ||||
| Microsoft Windows 2000 Professional | 4.52 | 4.52 HF2 | ||||
| Microsoft Windows 2000 Server | 4.52 | 4.52 HF2 | ||||
| Microsoft Windows 2000 Datacenter Server | 4.52 | 4.52 HF2 | ||||
| Microsoft Windows 2000 Advanced Server | 4.52 | 4.52 HF2 | ||||
| Microsoft Windows 95/98 | 4.52 | 4.52 HF2 | ||||
| Microsoft Windows XP 64-bit Edition | 4.52 | 4.52 HF2 | ||||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 4.52 | 4.52 HF2 | ||||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 4.52 | 4.52 HF2 | ||||
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 4.52 | 4.52 HF2 | ||||
| Solaris for x64 | 4.52 | 4.52 HF2 | ||||
| Linux on Itanium | 4.52 | 4.52 HF2 | ||||
| Linux for x64 | 4.52 | 4.52 HF2 | ||||
| HP-UX IPF | 4.52 | 4.52 HF2 | ||||
| 64-bit Enabled Solaris | 4.52 | 4.52 HF2 | ||||
| 64-bit Enabled HP-UX | 4.52 | 4.52 HF2 | ||||
| 64-bit Enabled AIX | 4.52 | 4.52 HF2 | ||||
| Windows Vista for x64 | 4.52 | 4.52 HF2 | ||||
| Windows Vista | 4.52 | 4.52 HF2 | ||||
| Windows Millennium Edition (Me) | 4.52 | 4.52 HF2 | ||||
| Windows 7 Ultimate x64 | 4.52 | 4.52 HF2 | ||||
| Windows 7 Ultimate 32 bit | 4.52 | 4.52 HF2 | ||||
| Windows 7 Professional x64 | 4.52 | 4.52 HF2 | ||||
| Windows 7 Professional 32 bit | 4.52 | 4.52 HF2 | ||||
| Windows 7 Home Premium x64 | 4.52 | 4.52 HF2 | ||||
| Windows 7 Home Premium 32 bit | 4.52 | 4.52 HF2 | ||||
A fix for this issue for Scalable Performance Data Server 4.52 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/B57.html#44425| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2012-01-03 08:21:19 |
| Date Created: | 2011-09-27 14:27:40 |