Problem Note 45181: An invalid SAS function used in an SQL procedure in a Base SAS® query might end abnormally
If you use an invalid function in Base SAS, the query might abend abnormally rather than issue an error similar to the following:
Function xxxx could not be located.
In a UNIX operating environment, an error similar to the following is issued instead:
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:
/install/SASFoundation/9.3/sasexe/sas [0x514ddd]
/install/SASFoundation/9.3/sasexe/sas [0x41e318]
/install/SASFoundation/9.3/sasexe/sas [0x41dfef]
/install/SASFoundation/9.3/sasexe/tkmk.so(bkt_signal_handler+0x144)
[0x2b6036939364]
/lib64/libpthread.so.0 [0x35cae0eb70]
/install/SASFoundation/9.3/sasexe/sassqlu(sqludf+0xc8)
[0x2aaaba61faa8]
/install/SASFoundation/9.3/sasexe/sassqlp [0x2aaaba813af6]
/install/SASFoundation/9.3/sasexe/sassqlp [0x2aaaba8122bc]
/install/SASFoundation/9.3/sasexe/sassqlp [0x2aaaba811b81]
/install/SASFoundation/9.3/sasexe/sassqlp(sqltype+0xd5)
[0x2aaaba80c355]
/install/SASFoundation/9.3/sasexe/sassqlp(sqlprep+0x18f)
[0x2aaaba7e508f]
/install/SASFoundation/9.3/sasexe/sassqx(sqlloop+0xc64)
[0x2aaaba206af4]
/install/SASFoundation/9.3/sasexe/sassql(sassql+0x276)
[0x2aaaba0bae66]
/install/SASFoundation/9.3/sasexe/sas(vvtentr+0x104) [0x41df34]
/lib64/libpthread.so.0 [0x35cae0673d]
/lib64/libc.so.6(clone+0x6d) [0x35ca2d44bd]
In Windows operating environments, an error similar to the following is issued instead:
ERROR: Read Access Violation In Task [ SQL )
Exception occurred at (03A6EEC7)
Task Traceback
Address Frame (DBGHELP API Version 4.0 rev 5)
03A6EEC7 0784E2B0 sassqlu:mcn_main+0x1DEC7
053288FF 0784E428 sassqlp:mcn_main+0x478FF
05324C94 0784E5B0 sassqlp:mcn_main+0x43C94
0530E5B8 0784E658 sassqlp:mcn_main+0x2D5B8
03A3381C 0784FF54 sassqx:mcn_main+0x2281C
600D118A 0784FF88 sassql:mcn_main+0x18A
01272B02 0784FFA0 sashost:Main+0xBE72
01276C20 0784FFB4 sashost:Main+0xFF90
7C80B713 0784FFEC kernel32:GetModuleFileNameA+0x1B4
Operating System and Release Information
SAS System | Base SAS | 64-bit Enabled AIX | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
64-bit Enabled HP-UX | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
Windows Vista | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
Windows Vista for x64 | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
Microsoft Windows XP Professional | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
Microsoft Windows 2000 Professional | 9.1 TS1M3 SP4 | |
Microsoft Windows NT Workstation | 9.1 TS1M3 SP4 | |
Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 SP4 | |
Microsoft Windows 2000 Server | 9.1 TS1M3 SP4 | |
Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 SP4 | |
Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
Tru64 UNIX | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
OpenVMS Alpha | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
Solaris for x64 | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
Linux | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
Linux on Itanium | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
64-bit Enabled Solaris | 9.1 TS1M3 SP4 | 9.3 TS1M2 |
HP-UX IPF | 9.1 TS1M3 SP4 | 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.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2011-12-21 12:45:32 |
Date Created: | 2011-12-19 15:12:24 |