Problem Note 32159: Input tables shown in Process Designer for the SQL Join transformation are missing from the Designer tab in that transformation's Properties window
Input tables that feed into the SQL Join transformation in the
Process Designer window should always appear within the Designer tab in that transformation's Properties window. Due to an issue with the metadata, these tables might be completely omitted when the Designer tab is displayed. When this occurs, the result is incorrect code generation.
The only workaround for this problem is to remove the SQL Join transformation from Source Designer and rebuild that portion of the job.
Select 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 2000 Advanced Server | 3.4 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows 2000 Datacenter Server | 3.4 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows 2000 Server | 3.4 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows 2000 Professional | 3.4 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 3.4 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 3.4 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows Server 2003 Standard Edition | 3.4 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
| Microsoft Windows XP Professional | 3.4 | 4.2 | 9.1 TS1M3 SP4 | 9.2 TS2M0 |
*
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: | 2008-05-23 13:08:45 |
| Date Created: | 2008-05-19 15:58:41 |
