Problem Note 58469: When you import a SAS® Data Integration Studio job containing a Lookup transformation, "Error: Lookup has no target column mapping information" occurs
 |  |  |  |  |
When you import a SAS Data Integration Studio job containing one or more Lookup transformations, an error similar to the following might occur when you submit the job or request code generation:
This problem occurs when you import the Lookup transformation without its associated table objects or when you use two steps to import the Lookup transformation and its associated table objects. In either of these scenarios, when you open the imported job, you see the green check mark on the desktop that indicates that the job is complete. However, when you click the Code tab, you receive the error message shown above.
To work around this problem, when importing a SAS Data Integration Studio job that contains one or more Lookup transformations, you must import the job along with its associated table objects in a single step.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Data Integration Studio | Microsoft® Windows® for x64 | 4.7 | 4.7_M4 | 9.4 TS1M0 | 9.4 TS1M4 |
| Microsoft Windows 8 Enterprise x64 | 4.7 | 4.7_M4 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Enterprise x64 | 4.7 | 4.7_M4 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 4.7 | 4.7_M4 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Pro x64 | 4.7 | 4.7_M4 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 R2 Std | 4.7 | 4.7_M4 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 Std | 4.7 | 4.7_M4 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 R2 | 4.7 | 4.7_M4 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows 10 | 4.7 | 4.7_M4 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Pro x64 | 4.7 | 4.7_M4 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Pro 32-bit | 4.7 | 4.7_M4 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Windows 7 Enterprise x64 | 4.7 | 4.7_M4 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Windows 7 Professional x64 | 4.7 | 4.7_M4 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 for x64 | 4.7 | 4.7_M4 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 Datacenter | 4.7 | 4.7_M4 | 9.4 TS1M0 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 4.7 | 4.7_M4 | 9.4 TS1M0 | 9.4 TS1M4 | ||
A fix for this issue for SAS Management Console 9.4_M3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/V11.html#58469A fix for this issue for SAS Middle Tier 9.4_M3 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/V10.html#58469A fix for this issue for Data Integration Studio 4.901 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/W51.html#58469| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2016-06-29 13:44:39 |
| Date Created: | 2016-06-22 11:18:42 |