Problem Note 56563: Running a PROC SQL query against a database table might result in a Segmentation Violation
 |  |  |  |  |
When you run an SQL procedure query against a database table that is accessed via the META engine, you might receive a Segmentation Violation. This problem typically occurs after you apply the hot fix associated with SAS Note 52776: "A Read access violation occurs when you run a query against an SAP table in a SAS® double-byte character set (DBCS) encoding."
The following is an example of the query and the resulting error:
LIBNAME TESTLIB META LIBRARY="Oracle Test Library";
PROC SQL;
CREATE TABLE WORK.RESULT_TABLE AS
SELECT DISTINCT NAME, AGE, PUT(AGE, DOLLAR.) AS AGEX
FROM TESTLIB.CLASS
ORDER BY NAME;ERROR: An exception has been encountered.
Please contact technical support and provide them with the following
traceback information:
The SAS task name is [SQL ]
Segmentation Violation
Traceback of the Exception:
/usr/local/SASHome/SASFoundation/9.4/sasexe/sas:tktracex+0xeb
/usr/local/SASHome/SASFoundation/9.4/sasexe/sas:ht_handle_program_fault+0x290
/usr/local/SASHome/SASFoundation/9.4/sasexe/tkmk.so:bkt_signal_handler+0x222
/lib/amd64/libc.so.1:0xdcbf6
/lib/amd64/libc.so.1:0xd14d2
/lib/amd64/libc.so.1:memcpy+0x1936 [ Signal 11 (SEGV)]
/usr/local/SASHome/SASFoundation/9.4/sasexe/sassqlp:sqlpsel+0x1e54
/usr/local/SASHome/SASFoundation/9.4/sasexe/sassqlp:sqlplan+0x57
/usr/local/SASHome/SASFoundation/9.4/sasexe/sassqlp:sqlprep+0x556
/usr/local/SASHome/SASFoundation/9.4/sasexe/sassqx:0x507d9
/usr/local/SASHome/SASFoundation/9.4/sasexe/sassqx:sqlloop+0x21b
/usr/local/SASHome/SASFoundation/9.4/sasexe/sassql:sassql+0x5e5
/usr/local/SASHome/SASFoundation/9.4/sasexe/sas:vvtentr+0x119
/lib/amd64/libc.so.1:0xdc8cb
/lib/amd64/libc.so.1:0xdcaf0The Segmentation Violation occurs when the size of the SQL DICTIONARY table that is allocated for the META engine is miscalculated.
As a circumvention, assign the library using the native LIBNAME engine rather than the META engine.
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 | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | Solaris for x64 | 9.3 TS1M1 | 9.4 TS1M3 |
A fix for this issue for Base SAS 9.4_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/R19.html#56563A fix for this issue for Base SAS 9.3_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/I22.html#56563A fix for this issue for Base SAS 9.3_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/F98.html#56563| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2015-10-01 11:09:19 |
| Date Created: | 2015-09-09 11:16:05 |