Problem Note 65723: Changes to properties in the SPD Server Table Loader transformation are not retained when saving a job
SAS® Data Integration Studio can experience issues with retaining changes while saving a job when the job contains an SPD Server Table Loader transformation. The issue occurs when you take the following steps:
- You previously edited and saved a job, and it contained an SPD Server Table Loader transformation at the time that the job was saved.
- You open this job and then open the properties for the SPD Server Table Loader transformation. You make changes to the properties and then select OK to commit those changes.
- You attempt to save the job.
- When an asterisk (*) follows the job name on the title bar of the job, the asterisk indicates that the job is in a changed state. However, after you click Save, you expect the asterisk to disappear because the changes are saved. In this scenario, however, the asterisk remains in place next to the name, indicating that the job was not saved successfully.
The only workaround for this issue is to remove the existing SPD Server Table Loader transformation and then replace it with a new version. You must then edit the properties as desired and save the job. Note: After you save the job, you cannot edit the properties for the SPD Server Table Loader transformation without encountering this issue again.
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.
SAS® Data Integration Studio fails to save a job after you make changes to an SPD Server Table Loader transformation within the job.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2020-03-30 16:04:16 |
| Date Created: | 2020-03-23 09:55:52 |
