Problem Note 59823: SAS® Studio takes a long time to open database tables as a data source for tasks
 |  |  |  |  |
Many SAS Studio tasks contain an option that enables you to select a table as a data source. When you use libraries that are defined using database engines (such as Teradata), it might take up to several minutes for all the tables to appear in the selection choice.
Click the Hot Fix tab in this note to access the hot fix for this issue for SAS Studio Basic and SAS Studio Mid-Tier editions. Use the Downloads page to upgrade SAS Studio Single-User Edition to the latest release, including hot fixes.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Studio | Microsoft Windows Server 2008 | 3.4 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 |
| Microsoft Windows 10 | 3.4 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows 8.1 Pro x64 | 3.4 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows 8.1 Pro 32-bit | 3.4 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows 8.1 Enterprise x64 | 3.4 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 3.4 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows 8 Pro x64 | 3.4 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows 8 Pro 32-bit | 3.4 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows 8 Enterprise x64 | 3.4 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows 8 Enterprise 32-bit | 3.4 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft® Windows® for x64 | 3.4 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2012 Datacenter | 3.4 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2008 for x64 | 3.4 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2008 R2 | 3.4 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 3.4 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2012 R2 Std | 3.4 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2012 Std | 3.4 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Windows 7 Enterprise 32 bit | 3.4 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Windows 7 Enterprise x64 | 3.4 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Windows 7 Home Premium 32 bit | 3.4 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Windows 7 Home Premium x64 | 3.4 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Windows 7 Professional 32 bit | 3.4 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Windows 7 Professional x64 | 3.4 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Windows 7 Ultimate 32 bit | 3.4 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Windows 7 Ultimate x64 | 3.4 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| 64-bit Enabled AIX | 3.4 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| 64-bit Enabled Solaris | 3.4 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| HP-UX IPF | 3.4 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Linux for x64 | 3.4 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 | ||
| Solaris for x64 | 3.4 | 3.6 | 9.4 TS1M3 | 9.4 TS1M3 | ||
A fix for this issue for SAS Studio 3.5 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/Y75.html#59823A fix for this issue for SAS Studio 3.4 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/W62.html#59823| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2017-01-31 14:39:32 |
| Date Created: | 2017-01-27 15:45:07 |