Problem Note 20460: Joining two tables can cause your system to stop responding or can cause an access-violation problem
If you attempt to join two tables through an SQL statement, your SAS® session might stop
responding, or you could receive the following access-violation error message:
ERROR: Read Access Violation In Task [ DATASTEP )
ERROR: Read Access Violation In Task [ DATASTEP )
ERROR: Read Access Violation In Task [ DATASTEP )
Exception occurred at (659F5341)
Exception occurred at (659F5341)
Exception occurred at (659F5341)
Task Traceback
Task Traceback
Task Traceback
Address Frame (DBGHELP API Version 4.0 rev 5)
Address Frame (DBGHELP API Version 4.0 rev 5)
Address Frame (DBGHELP API Version 4.0 rev 5)
659F5341 06ECF924 sasiomet:mcn_main+0x14341
659F5341 06ECF924 sasiomet:mcn_main+0x14341
659F5341 06ECF924 sasiomet:mcn_main+0x14341
60024DB9 06ECF948 sassqp:mcn_main+0x3DB9
60024DB9 06ECF948 sassqp:mcn_main+0x3DB9
60024DB9 06ECF948 sassqp:mcn_main+0x3DB9
06F24543 06ECF974 sassqx:mcn_main+0x23543
06F24543 06ECF974 sassqx:mcn_main+0x23543
06F24543 06ECF974 sassqx:mcn_main+0x23543
600E2577 06ECF994 sasesql:mcn_main+0x1577
600E2577 06ECF994 sasesql:mcn_main+0x1577
600E2577 06ECF994 sasesql:mcn_main+0x1577
671A1C73 06ECFCB8 sasyoio:mcn_main+0xC73
671A1C73 06ECFCB8 sasyoio:mcn_main+0xC73
671A1C73 06ECFCB8 sasyoio:mcn_main+0xC73
678F7E39 06ECFDC4 sasyh:mcn_main+0x6E39
678F7E39 06ECFDC4 sasyh:mcn_main+0x6E39
678F7E39 06ECFDC4 sasyh:mcn_main+0x6E39
678F13AD 06ECFDEC sasyh:mcn_main+0x3AD
678F13AD 06ECFDEC sasyh:mcn_main+0x3AD
678F13AD 06ECFDEC sasyh:mcn_main+0x3AD
679540A9 06ECFE94 sasxkern:mcn_main+0x30A9
679540A9 06ECFE94 sasxkern:mcn_main+0x30A9
679540A9 06ECFE94 sasxkern:mcn_main+0x30A9
0125B621 06ECFED0 sashost:Main+0x4991
0125B621 06ECFED0 sashost:Main+0x4991
0125B621 06ECFED0 sashost:Main+0x4991
012591DE 06ECFF14 sashost:Main+0x254E
012591DE 06ECFF14 sashost:Main+0x254E
012591DE 06ECFF14 sashost:Main+0x254E
679610FA 06ECFF48 sasxkern:mcn_main+0x100FA
679610FA 06ECFF48 sasxkern:mcn_main+0x100FA
679610FA 06ECFF48 sasxkern:mcn_main+0x100FA
67311426 06ECFF88 sasds:mcn_main+0x426
67311426 06ECFF88 sasds:mcn_main+0x426
67311426 06ECFF88 sasds:mcn_main+0x426
01262B02 06ECFFA0 sashost:Main+0xBE72
01262B02 06ECFFA0 sashost:Main+0xBE72
01262B02 06ECFFA0 sashost:Main+0xBE72
01266C20 06ECFFB4 sashost:Main+0xFF90
01266C20 06ECFFB4 sashost:Main+0xFF90
01266C20 06ECFFB4 sashost:Main+0xFF90
7C80B683 06ECFFEC kernel32:GetModuleFileNameA+0x1B4
7C80B683 06ECFFEC kernel32:GetModuleFileNameA+0x1B4
7C80B683 06ECFFEC kernel32:GetModuleFileNameA+0x1B
This error occurs if you perform the following steps:
-
Submit a LIBNAME statement using the META engine to assign
a metadata library that points to an Oracle database.
-
Submit an SQL procedure that creates a view by joining two tables
in the metadata library.
-
Submit a DATA step that creates a data set view by setting the
SQL view that you created in step 2.
If you encounter the access-violation message or a system interruption after
performing these steps, this hot fix resolves the problem. If you encounter
this problem under other circumstances, this hot fix does not apply.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SAS System | SAS Metadata Server | Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows XP Professional | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows 2000 Server | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows 2000 Professional | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Solaris for x64 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| z/OS | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| HP-UX IPF | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| OpenVMS Alpha | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| 64-bit Enabled AIX | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
*
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: | medium |
| Topic: | SAS Reference ==> LIBNAME Engines
|
| Date Modified: | 2008-05-20 16:48:53 |
| Date Created: | 2007-06-26 12:25:21 |
