Problem Note 57873: "Update: java.lang.NullPointerException" is displayed when you run a job that contains an Update transformation with nested subqueries
 |  |  |  |
When you save and reopen a SAS® Data Integration Studio job that contains an Update transformation with nested subqueries, you might receive the following error:
Update: java.lang.NullPointerException
This error occurs when you try to run the job or when you click the Code tab in the Job Editor window.
To work around this issue, complete these steps:
- When the job is first built and functioning, open the Properties of the Update transformation.
- On the Code tab, set the Code generation mode field to User written body.
Caution: Once you set Code generation mode to User Written Body, this transformation's code becomes static and no longer automatically adjusts to any changes made to its properties.
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.4 | 4.902 | 9.3 TS1M2 | 9.4 TS1M4 |
| Microsoft Windows 8 Enterprise 32-bit | 4.4 | 4.902 | 9.3 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Enterprise x64 | 4.4 | 4.902 | 9.3 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Pro 32-bit | 4.4 | 4.902 | 9.3 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows 8 Pro x64 | 4.4 | 4.902 | 9.3 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 4.4 | 4.902 | 9.3 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Enterprise x64 | 4.4 | 4.902 | 9.3 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Pro 32-bit | 4.4 | 4.902 | 9.3 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows 8.1 Pro x64 | 4.4 | 4.902 | 9.3 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.4 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 4.4 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2003 Standard Edition | 4.4 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2003 for x64 | 4.4 | 9.3 TS1M2 | ||||
| Microsoft Windows Server 2008 | 4.4 | 4.902 | 9.3 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 R2 | 4.4 | 4.902 | 9.3 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2008 for x64 | 4.4 | 4.902 | 9.3 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 Datacenter | 4.4 | 4.902 | 9.3 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 4.4 | 4.902 | 9.3 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 R2 Std | 4.4 | 4.902 | 9.3 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows Server 2012 Std | 4.4 | 4.902 | 9.3 TS1M2 | 9.4 TS1M4 | ||
| Microsoft Windows XP Professional | 4.4 | 9.3 TS1M2 | ||||
| Windows 7 Enterprise 32 bit | 4.4 | 4.902 | 9.3 TS1M2 | 9.4 TS1M4 | ||
| Windows 7 Enterprise x64 | 4.4 | 4.902 | 9.3 TS1M2 | 9.4 TS1M4 | ||
| Windows 7 Home Premium 32 bit | 4.4 | 4.902 | 9.3 TS1M2 | 9.4 TS1M4 | ||
| Windows 7 Home Premium x64 | 4.4 | 4.902 | 9.3 TS1M2 | 9.4 TS1M4 | ||
| Windows 7 Professional 32 bit | 4.4 | 4.902 | 9.3 TS1M2 | 9.4 TS1M4 | ||
| Windows 7 Professional x64 | 4.4 | 4.902 | 9.3 TS1M2 | 9.4 TS1M4 | ||
| Windows 7 Ultimate 32 bit | 4.4 | 4.902 | 9.3 TS1M2 | 9.4 TS1M4 | ||
| Windows 7 Ultimate x64 | 4.4 | 4.902 | 9.3 TS1M2 | 9.4 TS1M4 | ||
| Windows Vista | 4.4 | 9.3 TS1M2 | ||||
| Windows Vista for x64 | 4.4 | 9.3 TS1M2 | ||||
When you run a SAS Data Integration Studio job that contains an Update transformation with nested subqueries, you might receive the following error:
"Update: java.lang.NullPointerException."
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2016-03-23 17:35:43 |
| Date Created: | 2016-03-16 10:59:39 |