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.