Problem Note 41581: DEFER=YES option in an OLEDB library may return a read access violation in the Query Builder of SAS® Enterprise Guide
If you have an OLEDB library defined in SAS® Management console that contains the DEFER=YES option, you may receive the following read access violation in the Query Builder of SAS® Enterprise Guide:
ERROR: Read Access Violation In Task [ SQL (2) ]
Exception occurred at (062575E3)
Task Traceback
Address Frame (DBGHELP API Version 4.0 rev 5)
00000000062575E3 000000000834ACD0 sasioole:mcn_main+0x165E3
0000000006268388 000000000834AD80 sasioole:mcn_main+0x27388
0000000006125647 000000000834AD88 sasxdbi:mcn_main+0x24647
000000000808D047 000000000834B718 sassqlu:mcn_main+0x1C047
00000000080875E1 000000000834CB40 sassqlu:mcn_main+0x165E1
0000000008092AF0 000000000834CC40 sassqlu:mcn_main+0x21AF0
0000000008094ADD 000000000834D9B0 sassqlu:mcn_main+0x23ADD
00000000080941BD 000000000834DA10 sassqlu:mcn_main+0x231BD
0000000008086208 000000000834DB10 sassqlu:mcn_main+0x15208
00000000080851B1 000000000834DCB0 sassqlu:mcn_main+0x141B1
000000000808B91D 000000000834ECE0 sassqlu:mcn_main+0x1A91D
0000000008092AF0 000000000834EDE0 sassqlu:mcn_main+0x21AF0
000000000807AE1A 000000000834EE20 sassqlu:mcn_main+0x9E1A
000000000807AAAF 000000000834F0C0 sassqlu:mcn_main+0x9AAF
000000000748AF4D 000000000834F0C8 sassqlp:mcn_main+0x29F4D
0000000007489724 000000000834F8F0 sassqlp:mcn_main+0x28724
000000000747CD92 000000000834FA60 sassqlp:mcn_main+0x1BD92
000000000749F137 000000000834FB40 sassqlp:mcn_main+0x3E137
000000000735B431 000000000834FB48 sassqx:mcn_main+0x2A431
000000000735A82B 000000000834FE60 sassqx:mcn_main+0x2982B
00000000080112CB 000000000834FE68 sassql:mcn_main+0x2CB
0000000002935B2E 000000000834FEF8 sashost:Main+0xE176
000000000293A985 000000000834FF50 sashost:Main+0x12FCD
0000000076C7495D 000000000834FF58 kernel32:BaseThreadInitThunk+0xD
0000000076E78791 000000000834FF88 ntdll:RtlUserThreadStart+0x21
This can occur when all of these conditions are met:
The Defer option is set to Yes in the library. By default, the value is set to No. The Defer option is defined on the Connection tab in the Advanced Options of the library properties. The option reads "Whether to defer a connection until needed:".
The library is preassigned
A table from this library is opened in the Query builder where a computed column is created from a column in the table.
To circumvent this problem, remove the Defer option from the library or do not preassign the library in the SAS® Management console.
Operating System and Release Information
| SAS System | SAS Enterprise Guide | Microsoft® Windows® for x64 | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 Standard Edition | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2003 for x64 | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows Server 2008 for x64 | 4.2 | | 9.2 TS2M0 | |
| Microsoft Windows XP Professional | 4.2 | | 9.2 TS2M0 | |
| Windows Vista | 4.2 | | 9.2 TS2M0 | |
| Windows Vista for x64 | 4.2 | | 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 |
| Date Modified: | 2010-11-16 09:59:38 |
| Date Created: | 2010-11-12 12:49:30 |
