Problem Note 57131: SAS® Data Integration Studio jobs that contain an SQL subquery lose subquery metadata after you run the Analyze and Repair Tool
 |  |  |  |  |
SAS Data Integration Studio jobs that contain an SQL Set, Update, or Delete transformation that contains a subquery definition might lose the subquery metadata after you run the Analyze and Repair Metadata Tool in SAS® Management Console.
The loss of metadata can occur when the Analyze Metadata Tool incorrectly determines subquery metadata to be Orphaned Job Metadata. When the Repair component of the tool is run to correct the Orphaned Job Metadata, the subquery metadata is deleted, which removes the subquery definition from within the transformation.
For additional information, see SAS Note 54671: "The Orphaned Job Metadata tool might remove valid targetTransformation objects."
A workaround to this issue is not to run the Repair Metadata Tool against Orphaned Job Metadata.
Click the Hot Fix tab in this note to access the hot fix for this issue.
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 Professional 32 bit | 4.9 | 4.902 | 9.4 TS1M2 | 9.4 TS1M4 |
| Windows 7 Home Premium x64 | 4.9 | 4.902 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Windows 7 Home Premium 32 bit | 4.9 | 4.902 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Windows 7 Enterprise x64 | 4.9 | 4.902 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Windows 7 Enterprise 32 bit | 4.9 | 4.902 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 Std | 4.9 | 4.902 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 R2 Std | 4.9 | 4.902 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 4.9 | 4.902 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 Datacenter | 4.9 | 4.902 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 for x64 | 4.9 | 4.902 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 R2 | 4.9 | 4.902 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 | 4.9 | 4.902 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Pro 32-bit | 4.9 | 4.902 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Pro | 4.9 | 4.902 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Enterprise x64 | 4.9 | 4.902 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 4.9 | 4.902 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Pro x64 | 4.9 | 4.902 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Pro 32-bit | 4.9 | 4.902 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Enterprise x64 | 4.9 | 4.902 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft® Windows® for x64 | 4.9 | 4.902 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Windows 7 Ultimate x64 | 4.9 | 4.902 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Windows 7 Professional x64 | 4.9 | 4.902 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Windows 7 Ultimate 32 bit | 4.9 | 4.902 | 9.4 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Enterprise 32-bit | 4.9 | 4.902 | 9.4 TS1M2 | 9.4 TS1M4 | ||
A fix for this issue for SAS Middle Tier 9.4_M3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/V10.html#57131A fix for this issue for SAS Management Console 9.4_M3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/V11.html#57131A fix for this issue for Data Integration Studio 4.901 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/W51.html#57131A fix for this issue for SAS Middle Tier 9.4_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/R75.html#57131A fix for this issue for SAS Management Console 9.4_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/R76.html#57131A fix for this issue for SAS Management Console 9.3_M2 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/I15.html#57131| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2016-01-20 10:03:47 |
| Date Created: | 2015-11-23 12:36:23 |