Problem Note 64411: "No items are available" occurs and column names are appended with _1 when you select a join table in the SAS® Data Studio interface in SAS® Viya®
 |  |  |  |  |
You encounter a problem in which the column names in Table 2 (T2) are appended with an _1 suffix under the following conditions:
- You have a data plan that contains a Join transform.
- You change the second join table, Table 2 (T2), by selecting a different table that has the same column names.
When you run the data plan after making this change, you see the following error:
You encounter this problem when you perform steps similar to the following:
- Open your data plan and edit the existing Join transform.
- On the Join Tables panel, select a different Table 2 (T2) that has the same column names as the table that you are replacing.
- Navigate to the Rename Columns panel. You see that the Source Column in the newly selected Table 2 (T2) contains the _1 suffix.
- When you run the data plan, subsequent transforms that reference the original column names fail with the error "No items are available."
The error occurs because any transforms downstream from the Join transform reference the original column names that do not have the _1 suffix.
To work around this issue, delete the table by clicking the trash can icon. Then, select the new table.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Viya | Microsoft® Windows® for x64 | 3.4 | 3.5 | Viya | |
| Microsoft Windows 8 Enterprise x64 | 3.4 | 3.5 | Viya | |||
| Microsoft Windows 8 Pro x64 | 3.4 | 3.5 | Viya | |||
| Microsoft Windows 8.1 Enterprise x64 | 3.4 | 3.5 | Viya | |||
| Microsoft Windows 8.1 Pro x64 | 3.4 | 3.5 | Viya | |||
| Microsoft Windows 10 | 3.4 | 3.5 | Viya | |||
| Microsoft Windows Server 2008 R2 | 3.4 | 3.5 | Viya | |||
| Microsoft Windows Server 2008 for x64 | 3.4 | 3.5 | Viya | |||
| Microsoft Windows Server 2012 Datacenter | 3.4 | 3.5 | Viya | |||
| Microsoft Windows Server 2012 R2 Datacenter | 3.4 | 3.5 | Viya | |||
| Microsoft Windows Server 2012 R2 Std | 3.4 | 3.5 | Viya | |||
| Microsoft Windows Server 2012 Std | 3.4 | 3.5 | Viya | |||
| Windows 7 Enterprise x64 | 3.4 | 3.5 | Viya | |||
| Windows 7 Home Premium x64 | 3.4 | 3.5 | Viya | |||
| Windows 7 Professional x64 | 3.4 | 3.5 | Viya | |||
| Windows 7 Ultimate x64 | 3.4 | 3.5 | Viya | |||
| Linux for x64 | 3.4 | 3.5 | Viya | |||
An update for this issue is available for SAS Viya 3.4. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.4 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.4&softwareContextId=softwareUpdates| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-06-28 17:08:44 |
| Date Created: | 2019-06-28 13:45:11 |