Problem Note 50965: The Table Loader transformation incorrectly deletes the key column index
 |  |  |  |
The Table Loader transformation incorrectly deletes the index on the key column when the following conditions are true:
- Load Style is set to Update/Insert on the Load Technique tab in Table Loader properties.
- Matching Rows is set to either Modify by Column(s) or Modify using Index in the Technique(s) section on the Load Technique tab in Table Loader properties.
- Before Load is set to Off in the Index Condition section on the Load Technique tab in Table Loader properties.
- An index exists on the key column used for matching the source table with the target table.
The impact of deletion of the key column index is as follows.
When Matching Rows is set to Modify by Column(s), the update process completes without errors. However, performance can be significantly impacted. The missing index results in the process performing a sequential read instead of an indexed read of the target table.
When Matching Rows is set to Modify using Index, the following error will occur due to the missing index:
ERROR: No key variables have been defined for file Target Table.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Data Integration Studio | Windows 7 Ultimate x64 | 4.21_M1 | 4.8 | 9.2 TS2M3 | 9.4 TS1M1 |
| Windows Vista for x64 | 4.21_M1 | 9.2 TS2M3 | ||||
| Windows Vista | 4.21_M1 | 9.2 TS2M3 | ||||
| Windows 7 Ultimate 32 bit | 4.21_M1 | 4.8 | 9.2 TS2M3 | 9.4 TS1M1 | ||
| Windows 7 Professional x64 | 4.21_M1 | 4.8 | 9.2 TS2M3 | 9.4 TS1M1 | ||
| Windows 7 Professional 32 bit | 4.21_M1 | 4.8 | 9.2 TS2M3 | 9.4 TS1M1 | ||
| Windows 7 Enterprise 32 bit | 4.21_M1 | 4.8 | 9.2 TS2M3 | 9.4 TS1M1 | ||
| Microsoft Windows XP Professional | 4.21_M1 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2008 for x64 | 4.21_M1 | 4.8 | 9.2 TS2M3 | 9.4 TS1M1 | ||
| Microsoft Windows Server 2008 R2 | 4.21_M1 | 4.8 | 9.2 TS2M3 | 9.4 TS1M1 | ||
| Microsoft Windows Server 2008 | 4.21_M1 | 4.8 | 9.2 TS2M3 | 9.4 TS1M1 | ||
| Microsoft Windows Server 2003 for x64 | 4.21_M1 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Standard Edition | 4.21_M1 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 4.21_M1 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 4.21_M1 | 9.2 TS2M3 | ||||
| Microsoft® Windows® for x64 | 4.21_M1 | 4.8 | 9.2 TS2M3 | 9.4 TS1M1 | ||
| Windows 7 Home Premium x64 | 4.21_M1 | 4.8 | 9.2 TS2M3 | 9.4 TS1M1 | ||
| Windows 7 Home Premium 32 bit | 4.21_M1 | 4.8 | 9.2 TS2M3 | 9.4 TS1M1 | ||
| Windows 7 Enterprise x64 | 4.21_M1 | 4.8 | 9.2 TS2M3 | 9.4 TS1M1 | ||
Incorrect deletion of a key column index can result in errors or performance degradation in the Table Loader transformation in SAS® Data Integration Studio.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2013-09-20 15:59:40 |
| Date Created: | 2013-09-05 09:50:57 |