Problem Note 50024: The SQL procedure sporadically fails with the error "An exception has been encountered"
The following segmentation violation might occur when you run a PROC SQL step that references SAS® Scalable Performance Data Server (SPD Server) tables:
ERROR: An exception has been encountered.
Please contact technical support and provide them with the following traceback
information:
The SAS task name is [SQL (2) ]
Segmentation Violation
Traceback of the Exception
optsasSASHomeSASFoundation9.3sasexesas() [0x514e3d]
optsasSASHomeSASFoundation9.3sasexesas() [0x41e338]
optsasSASHomeSASFoundation9.3sasexesas() [0x41e00f]
optsasSASHomeSASFoundation9.3sasexetkmk.so(bkt_signal_handler+0x144) [0x7fbf77b49364]
lib64libpthread.so.0() [0x3dd3c0f490]
optsasSASHomeSASFoundation9.3sasexesasiomet(__intel_new_memcpy+0x1570) [0x7fbf354a9ff0]
This error, which occurs sporadically, is generated when the SAS SPD Server tables exist in a library that is assigned using the META LIBNAME engine.
To avoid the problem, assign the library using the native SASSPDS LIBNAME engine rather than the META engine.
Operating System and Release Information
SAS System | Base SAS | z/OS | 9.3_M2 | | 9.3 TS1M2 | |
Z64 | 9.3_M2 | | 9.3 TS1M2 | |
Microsoft® Windows® for x64 | 9.3_M2 | | 9.3 TS1M2 | |
Microsoft Windows Server 2003 Datacenter Edition | 9.3_M2 | | 9.3 TS1M2 | |
Microsoft Windows Server 2003 Enterprise Edition | 9.3_M2 | | 9.3 TS1M2 | |
Microsoft Windows Server 2003 Standard Edition | 9.3_M2 | | 9.3 TS1M2 | |
Microsoft Windows Server 2003 for x64 | 9.3_M2 | | 9.3 TS1M2 | |
Microsoft Windows Server 2008 | 9.3_M2 | | 9.3 TS1M2 | |
Microsoft Windows Server 2008 for x64 | 9.3_M2 | | 9.3 TS1M2 | |
Microsoft Windows XP Professional | 9.3_M2 | | 9.3 TS1M2 | |
Windows 7 Enterprise 32 bit | 9.3_M2 | | 9.3 TS1M2 | |
Windows 7 Enterprise x64 | 9.3_M2 | | 9.3 TS1M2 | |
Windows 7 Home Premium 32 bit | 9.3_M2 | | 9.3 TS1M2 | |
Windows 7 Home Premium x64 | 9.3_M2 | | 9.3 TS1M2 | |
Windows 7 Professional 32 bit | 9.3_M2 | | 9.3 TS1M2 | |
Windows 7 Professional x64 | 9.3_M2 | | 9.3 TS1M2 | |
Windows 7 Ultimate 32 bit | 9.3_M2 | | 9.3 TS1M2 | |
Windows 7 Ultimate x64 | 9.3_M2 | | 9.3 TS1M2 | |
Windows Vista | 9.3_M2 | | 9.3 TS1M2 | |
Windows Vista for x64 | 9.3_M2 | | 9.3 TS1M2 | |
64-bit Enabled AIX | 9.3_M2 | | 9.3 TS1M2 | |
64-bit Enabled HP-UX | 9.3_M2 | | 9.3 TS1M2 | |
64-bit Enabled Solaris | 9.3_M2 | | 9.3 TS1M2 | |
HP-UX IPF | 9.3_M2 | | 9.3 TS1M2 | |
Linux | 9.3_M2 | | 9.3 TS1M2 | |
Linux for x64 | 9.3_M2 | | 9.3 TS1M2 | |
Solaris for x64 | 9.3_M2 | | 9.3 TS1M2 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
A segmentation violation occurs sporadically when you run PROC SQL on SAS® Scalable Performance Data Server (SPD Server) tables in a library that is assigned with the META engine.
Type: | Problem Note |
Priority: | high |
Topic: | Data Management ==> Data Sources ==> Metadata
|
Date Modified: | 2013-06-03 14:24:22 |
Date Created: | 2013-05-23 11:52:29 |