Problem Note 35616: The FastExport module fails when it is run under an object spawner
 |  |  |  |  |
When you use SAS/ACCESS® Interface to Teradata, the FastExport module fails to run under an object spawner. If you use Base® SAS software or SAS® Enterprise Guide® as your client and you connect to a local connection, FastExport runs successfully. However, if you run FastExport under an object spawner, an error similar to the following is generated:
ERROR: Read Access Violation In Task [ SQL (2) )
Exception occurred at (531A146F)
Task Traceback
Address Frame (DBGHELP API Version 4.0 rev 5)
531A146F 0773DC34 sasiotra:mcn_main+0x46F
531A1D90 0773E0DC sasiotra:mcn_main+0xD90
6598F5FB 0773E344 sasxdbi:mcn_main+0x1E5FB
06C636C2 0773E3AC sassqx:mcn_main+0x126C2
06C6E32D 0773E424 sassqx:mcn_main+0x1D32D
06C6E1A1 0773E5FC sassqx:mcn_main+0x1D1A1
06C6CC5B 0773E628 sassqx:mcn_main+0x1BC5B
06C77279 0773E654 sassqx:mcn_main+0x26279
06C739B6 0773FF54 sassqx:mcn_main+0x229B6
600D118A 0773FF88 sassql:mcn_main+0x18A
00FE2B02 0773FFA0 sashost:Main+0xBE72
00FE6C20 0773FFB4 sashost:Main+0xFF90
7C80B683 0773FFEC kernel32:GetModuleFileNameA+0x1B4
sasiotra/tryottrm(): SELECT was processed with FastExport. 37 1537811932 Main
0 SQL (2)
NOTE: PROCEDURE SQL used (Total process time):
real time 32.26 seconds
cpu time 0.10 seconds
This error occurs because the object spawner does not have the ability to open a terminal to write FastExport messages. Currently, there is not a workaround for this problem.
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/ACCESS Interface to Teradata | z/OS | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Server | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Professional | 9.1 TS1M3 SP4 | |||
| Microsoft Windows NT Workstation | 9.1 TS1M3 SP4 | |||
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| Microsoft Windows XP Professional | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| Windows Vista | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| 64-bit Enabled Solaris | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| HP-UX IPF | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| Linux | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
| Solaris for x64 | 9.1 TS1M3 SP4 | 9.2 TS2M2 | ||
A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#035616A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#035616| Type: | Problem Note |
| Priority: | medium |
| Topic: | Data Management ==> Data Sources ==> External Databases ==> Teradata |
| Date Modified: | 2009-04-22 09:10:58 |
| Date Created: | 2009-04-20 09:57:01 |