Usage Note 11824: VACRASH and FATAL error messages might appear when running PROC SQL
against large data sets
When you run PROC SQL queries against large data sets, the following
error message might appear:
SAS Error Event: FATAL ERROR: WRCODE=80003002, MODULE='vvtdosg':
Unexpected return from vtdelet()
Critical SAS error: z Write Access Violation In Task ( SHRWTSK2 )
Exception occurred at (67e191ab)
SAS Error Event: SAS is aborting through vacrash()
The problem is likely to occur on systems with multiple CPUs or CPUs
that support hyperthreading with repeated runs of the SQL queries.
The problem occurs because of thread synchronization issues similar to
that described in SAS Note #005158 .
To circumvent the problem, set OPTIONS NOTHREADS in the program to
run it as a single-threaded system.
Operating System and Release Information
| SAS System | Base SAS | Microsoft Windows XP Professional | 9 TS M0 | |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9 TS M0 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9 TS M0 | |
| Microsoft Windows Server 2003 Standard Edition | 9 TS M0 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9 TS M0 | |
| Microsoft Windows 2000 Server | 9 TS M0 | |
| Microsoft Windows 2000 Advanced Server | 9 TS M0 | |
| Microsoft Windows 2000 Datacenter Server | 9 TS M0 | |
| Microsoft Windows NT Workstation | 9 TS M0 | |
| Microsoft Windows 2000 Professional | 9 TS M0 | |
*
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: | Usage Note |
| Priority: | |
| Topic: | SAS Reference ==> SQL
SAS Reference ==> Procedures ==> SQL
|
| Date Modified: | 2004-03-22 14:31:57 |
| Date Created: | 2004-02-20 14:50:19 |
