Problem Note 69317: SAS/ACCESS® Interface to Teradata support for Teradata Tools and Utilities (TTU) 17.xx in UNIX and Microsoft Windows environments
Support for TTU 17.xx and later with SAS/ACCESS Interface to Teradata begins with SAS® 9.4M8 (TS1M8) and the SAS® Viya® platform 23.02. Earlier releases of SAS might work with TTU 17.xx but are not supported. Customers should upgrade to to SAS 9.4M8 or the SAS Viya platform 23.02 to be fully supported.
The following options for using TTU are available:
- For SAS® 9.4M3 (TS1M3) through SAS® 9.4M7 (TS1M7), use TTU 16.20 to connect to Teradata 17.10 or earlier.
- For SAS 9.4M8 and later, use TTU 17.10 or later to connect to Teradata 17.10 or later.
AIX customers should review SAS KB0036387, "SAS/ACCESS® Interface to Teradata does not support Teradata Tools and Utilities (TTU) 17.xx and later in AIX environments."
If you attempt to use TTU 17.xx and later with earlier SAS releases, you might encounter symptoms that include failures, a lack of response, and/or errors, such as the following:
ERROR: FastExport either failed before connecting to SAS or timed out before invoking the access module.
ERROR: Multiload failed to invoke the access module. Possible causes include:
(a) Invalid restart table name
(b) Slow network delaying Multiload login to Teradata
(c) MultiLoad unable to find the access module
(d) No space in database to create the restart table.
SAS WTABORT (Program program-name.sas) The SAS System has detected an abort condition. An Exception occurred during wthtrm().
Please Contact Technical Support.
Tasks
[MAIN ] [WAITING ] pri[ 5] reb[8C252AE0] WC[0] WN[1]
[IDLETASK] [READY ] pri[ 9] reb[8C252AE0]
[EVENTTSK] [WAITING ] pri[ 0] reb[8C252AE0] WC[0] WN[1]
[sasxkern] [WAITING ] pri[ 3] reb[8C252AE0] WC[0] WN[1]
[Session ] [WAITING ] pri[ 3] reb[8FF984E0] WC[0] WN[1]
[TKSRV ] [WAITING ] pri[ 3] reb[8FF98B80] WC[0] WN[1]
[Program ] [RUNNING ] pri[ 7] reb[8FF996A0]
[DOS Moni] [WAITING ] pri[ 7] reb[8FF9EBA0] WC[0] WN[1]
ERROR: Extension Load Failure: OS Error: -1 (Symbol resolution failed for SASHOME/SASFoundation/9.4/sasexe/sasiotpt.so because:
Symbol
__ct__Q5_3ncr8teradata6client3API10ConnectionFv (number 34) is not exported from dependent
module /usr/lib/libtelapi.so.
Symbol
__dt__Q5_3ncr8terad)
TERADATA: trrlbk: ROLLBACK WORK
Operating System and Release Information
SAS System | SAS/ACCESS Interface to Teradata | Microsoft® Windows® for x64 | | 9.4 TS1M8 |
Microsoft Windows 8 Enterprise 32-bit | | 9.4 TS1M8 |
Microsoft Windows 8 Enterprise x64 | | 9.4 TS1M8 |
Microsoft Windows 8 Pro 32-bit | | 9.4 TS1M8 |
Microsoft Windows 8 Pro x64 | | 9.4 TS1M8 |
Microsoft Windows 8.1 Enterprise 32-bit | | 9.4 TS1M8 |
Microsoft Windows 8.1 Enterprise x64 | | 9.4 TS1M8 |
Microsoft Windows 8.1 Pro 32-bit | | 9.4 TS1M8 |
Microsoft Windows 8.1 Pro x64 | | 9.4 TS1M8 |
Microsoft Windows 10 | | 9.4 TS1M8 |
Microsoft Windows 11 | | 9.4 TS1M8 |
Microsoft Windows Server 2008 | | 9.4 TS1M8 |
Microsoft Windows Server 2008 R2 | | 9.4 TS1M8 |
Microsoft Windows Server 2008 for x64 | | 9.4 TS1M8 |
Microsoft Windows Server 2012 Datacenter | | 9.4 TS1M8 |
Microsoft Windows Server 2012 R2 Datacenter | | 9.4 TS1M8 |
Microsoft Windows Server 2012 R2 Std | | 9.4 TS1M8 |
Microsoft Windows Server 2012 Std | | 9.4 TS1M8 |
Microsoft Windows Server 2016 | | 9.4 TS1M8 |
Microsoft Windows Server 2019 | | 9.4 TS1M8 |
Microsoft Windows Server 2022 | | 9.4 TS1M8 |
Windows 7 Enterprise 32 bit | | 9.4 TS1M8 |
Windows 7 Enterprise x64 | | 9.4 TS1M8 |
Windows 7 Home Premium 32 bit | | 9.4 TS1M8 |
Windows 7 Home Premium x64 | | 9.4 TS1M8 |
Windows 7 Professional 32 bit | | 9.4 TS1M8 |
Windows 7 Professional x64 | | 9.4 TS1M8 |
Windows 7 Ultimate 32 bit | | 9.4 TS1M8 |
Windows 7 Ultimate x64 | | 9.4 TS1M8 |
64-bit Enabled HP-UX | | 9.4 TS1M8 |
64-bit Enabled Solaris | | 9.4 TS1M8 |
HP-UX | | 9.4 TS1M8 |
HP-UX IPF | | 9.4 TS1M8 |
Linux for x64 | | 9.4 TS1M8 |
Solaris for x64 | | 9.4 TS1M8 |
z/OS | | |
SAS System | SAS/ACCESS Interface to Teradata (on SAS Viya) | Linux for x64 | Viya platform | Viya platform |
*
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.
Due to changes in TTU 17.xx clients, SAS cannot support these client versions in earlier releases of SAS and the SAS Viya platform
Type: | Problem Note |
Priority: | high |
Topic: | Data Management ==> Data Sources ==> External Databases ==> Teradata
|
Date Modified: | 2023-05-19 09:49:04 |
Date Created: | 2022-06-21 05:44:51 |