Problem Note 41596: Keys and indexes that are associated with Teradata tables are not properly registered or updated in the metadata
 |  |  |  |  |
Key and index definitions are not registered or updated correctly in SAS® metadata for tables that are referenced using the SAS/ACCESS® Interface to Teradata.
If you issue a Register Tables... or Update Metadata... request within SAS® Management Console 9.2 or SAS® Data Integration Studio 4.21 for a Teradata table that has keys or indexes, these keys or indexes are not registered in the metadata.
To work around this issue, manually define the metadata for keys or indexes for the relevant tables.
- Open Properties on the table object.
- Go to the Indexes or Keys tabs and define the missing content.
Click the Hot Fix tab in this note to access the hot fix for this issue.
A similar issue is documented in SAS Note 42915
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Teradata | 64-bit Enabled HP-UX | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| 64-bit Enabled AIX | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista for x64 | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 for x64 | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft® Windows® for x64 | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| z/OS | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| 64-bit Enabled Solaris | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| HP-UX IPF | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Linux | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Linux for x64 | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Solaris for x64 | 9.21 | 9.3 | 9.2 TS2M0 | 9.3 TS1M0 | ||
A fix for this issue for SAS/ACCESS Interface to Teradata 9.21_M1 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/A98.html#41596A fix for this issue for SAS/ACCESS Interface to Teradata 9.21_M2 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/C71.html#41596| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2010-11-15 11:57:47 |
| Date Created: | 2010-11-15 10:23:08 |