Problem Note 17888: Segmentation Violation error issued when using PROC SQL and SAS/ACCESS® with a LENGTH= option larger than 32
 |  |  |  |  |
The following segmentation violation may be issued when using SAS/ACCESS with PROC SQL and a LENGTH option value is larger that 32.
Segmentation Violation In Task [ SQL ] Fault Occurred at [/TECH/SOL2.V9.1.3.GOLDEN/SAS_9.1/sasexe/sas:vmfree_kibbles+0x1a8] Task Traceback /TECH/SOL2.V9.1.3.GOLDEN/SAS_9.1/sasexe/sas:vmfree_kibbles+0x1a8 /TECH/SOL2.V9.1.3.GOLDEN/SAS_9.1/sasexe/sassqlu:sqltxt2+0xf1e8 /TECH/SOL2.V9.1.3.GOLDEN/SAS_9.1/sasexe/sassqlu:sqltxt2+0x29b0 /TECH/SOL2.V9.1.3.GOLDEN/SAS_9.1/sasexe/sassqlu:sqltxt2+0xe920 /TECH/SOL2.V9.1.3.GOLDEN/SAS_9.1/sasexe/sassqlu:sqltxt2+0x29dc /TECH/SOL2.V9.1.3.GOLDEN/SAS_9.1/sasexe/sassqlu:sqltxt2+0x8168 /TECH/SOL2.V9.1.3.GOLDEN/SAS_9.1/sasexe/sassqlu:sqltxt2+0x244 /TECH/SOL2.V9.1.3.GOLDEN/SAS_9.1/sasexe/sassqlp:sqlpnas+0xd78 /TECH/SOL2.V9.1.3.GOLDEN/SAS_9.1/sasexe/sassqlp:sqlpsel+0x8d4 /TECH/SOL2.V9.1.3.GOLDEN/SAS_9.1/sasexe/sassqlp:sqlplan+0x48 /TECH/SOL2.V9.1.3.GOLDEN/SAS_9.1/sasexe/sassqlp:sqlprep+0x678 /TECH/SOL2.V9.1.3.GOLDEN/SAS_9.1/sasexe/sassqx:sqlloop+0x658 /TECH/SOL2.V9.1.3.GOLDEN/SAS_9.1/sasexe/sassqx:sqlloop+0x16c /TECH/SOL2.V9.1.3.GOLDEN/SAS_9.1/sasexe/sassql:sassql+0x2e0 /TECH/SOL2.V9.1.3.GOLDEN/SAS_9.1/sasexe/sas:vvtentr+0x120
The following code demonstrates the error:
libname oralib oracle user=orauser password=orapwd path=orapath;
proc sql;
create table work.us6403192 as
select 'DAL_ADJUSTMENT_BALANCE' as table_name length=50,
ACCOUNT length = 7,
(SUM(GLM_CEQ_CCY_AMT )) as GLM_CEQ_CCY_AMT
length = 8 format = 21.2
informat = 21.2 from oralib.oratable
group by 1,2;
To workaround this problem, reduce the LENGTH= value to 32 or less.
Select 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 | Microsoft Windows XP Professional | 9.1 TS1M3 SP3 | 9.2 TS1M0 |
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 SP3 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 SP3 | 9.2 TS1M0 | ||
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 SP3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Server | 9.1 TS1M3 SP3 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 SP3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Professional | 9.1 TS1M3 SP3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 SP3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 SP3 | 9.2 TS1M0 | ||
| 64-bit Enabled Solaris | 9.1 TS1M3 SP3 | 9.2 TS1M0 | ||
| Linux | 9.1 TS1M3 | 9.2 TS1M0 | ||
| z/OS | 9.1 TS1M3 SP3 | 9.2 TS1M0 | ||
| Linux on Itanium | 9.1 TS1M3 | 9.2 TS1M0 | ||
| OpenVMS Alpha | 9.1 TS1M3 SP3 | 9.2 TS1M0 | ||
| HP-UX IPF | 9.1 TS1M3 | 9.2 TS1M0 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP3 | 9.2 TS1M0 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 SP3 | 9.2 TS1M0 | ||
A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#017888A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :
http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#017888| Type: | Problem Note |
| Priority: | high |
| Topic: | SAS Reference ==> SQL SAS Reference ==> Procedures ==> SQL |
| Date Modified: | 2008-03-04 15:10:00 |
| Date Created: | 2006-06-16 10:12:05 |