SUPPORT / SAMPLES & SAS NOTES
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
- 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
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| 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 | ||