Problem Note 41053: Metadata problems occur as a result of using the SQL Join transformation
SQL Join transformation corruption or orphaned metadata could occur when any the following tasks are performed:
-
removing source tables from an SQL Join transformation
-
adding source tables that were previously removed back to an SQL Join transformation. This could occur by using the Undo command.
-
removing an SQL Join transformation from a job definition
-
removing a subquery from within an SQL Join transformation
-
removing a join when the inputs to the join were not null.
The primary symptom of this problem is abnormal behavior when attempting to save a job after you've performed one or more of these tasks.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| SAS System | SAS Data Integration Studio | Microsoft Windows Server 2003 Enterprise Edition | 4.21 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 4.21 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 for x64 | 4.21 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2008 for x64 | 4.21 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.21 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft® Windows® for x64 | 4.21 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows XP Professional | 4.21 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Windows Vista | 4.21 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 |
| Windows Vista for x64 | 4.21 | 4.3 | 9.2 TS2M0 | 9.3 TS1M0 |
*
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: | high |
| Date Modified: | 2010-10-01 15:56:46 |
| Date Created: | 2010-09-28 13:52:41 |
