Problem Note 65709: You remove links to table objects within jobs, but the links are still referenced after you promote these jobs across metadata environments
Unexpected table references are retained during a partial promotion import of SAS® Data Integration Studio jobs. This issue occurs after tables that were previously referenced within the job are removed and then the job is saved. However, all internal references to these tables are not properly deleted as expected. Specifically, these tables can still be referenced in diagram layout content for the job even though they are no longer present.
The workaround for this behavior is to ignore the table references during a partial promotion import. If the tables are not selected during the import, then the table references will not persist in the job after the import is complete.
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® for x64 | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 |
Microsoft Windows 8 Enterprise x64 | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 |
Microsoft Windows 8 Pro x64 | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 |
Microsoft Windows 8.1 Enterprise 32-bit | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 |
Microsoft Windows 8.1 Enterprise x64 | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 |
Microsoft Windows 8.1 Pro 32-bit | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 |
Microsoft Windows 8.1 Pro x64 | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 |
Microsoft Windows 10 | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 |
Microsoft Windows Server 2008 R2 | 4.7 | | 9.4 TS1M0 | |
Microsoft Windows Server 2008 for x64 | 4.7 | | 9.4 TS1M0 | |
Microsoft Windows Server 2012 Datacenter | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 |
Microsoft Windows Server 2012 R2 Datacenter | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 |
Microsoft Windows Server 2012 R2 Std | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 |
Microsoft Windows Server 2012 Std | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 |
Windows 7 Enterprise x64 | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 |
Windows 7 Professional x64 | 4.7 | 4.905 | 9.4 TS1M0 | 9.4 TS1M7 |
*
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.
When a table object is removed from a job, some references to the table might not be removed. A partial promotion import process prompts for these table references, even though the tables are no longer needed.
Type: | Problem Note |
Priority: | medium |
Date Modified: | 2020-03-30 15:59:33 |
Date Created: | 2020-03-19 14:37:49 |