Problem Note 49348: Creating RDBMS tables using PRESERVE_TAB_NAMES=YES might generate an error in SAS® Enterprise Guide®
 |  |  |  |  |
Creating RDBMS tables with the PRESERVE_TAB_NAMES=YES on the LIBNAME statement might generate the following error in SAS Enterprise Guide:
"table-name" does not exist. You will need to refresh the task that created it before it can be opened.
Typically, the error occurs the first time that you attempt to create the table if the table name is all lowercase. Subsequent attempts to create the same table are successful.
To resolve this issue, download the latest hot fix for SAS Enterprise Guide 5.1.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Enterprise Guide | Microsoft® Windows® for x64 | 5.1 | 6.1 | 9.2 TS2M0 | |
| Microsoft Windows 8 Pro | 5.1 | |||||
| Microsoft Windows 95/98 | 5.1 | |||||
| Microsoft Windows 2000 Advanced Server | 5.1 | |||||
| Microsoft Windows 2000 Datacenter Server | 5.1 | |||||
| Microsoft Windows 2000 Server | 5.1 | |||||
| Microsoft Windows 2000 Professional | 5.1 | |||||
| Microsoft Windows NT Workstation | 5.1 | |||||
| Microsoft Windows Server 2003 Datacenter Edition | 5.1 | 6.1 | 9.2 TS2M0 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 5.1 | 6.1 | 9.2 TS2M0 | |||
| Microsoft Windows Server 2003 Standard Edition | 5.1 | 6.1 | 9.2 TS2M0 | |||
| Microsoft Windows Server 2003 for x64 | 5.1 | 6.1 | 9.2 TS2M0 | |||
| Microsoft Windows Server 2008 | 5.1 | 6.1 | 9.2 TS2M3 | |||
| Microsoft Windows Server 2008 for x64 | 5.1 | 6.1 | 9.2 TS2M0 | |||
| Microsoft Windows Server 2012 | 5.1 | |||||
| Microsoft Windows XP Professional | 5.1 | 6.1 | 9.2 TS2M0 | |||
| Windows 7 Enterprise 32 bit | 5.1 | 6.1 | 9.2 TS2M3 | |||
| Windows 7 Enterprise x64 | 5.1 | 6.1 | 9.2 TS2M3 | |||
| Windows 7 Home Premium 32 bit | 5.1 | 6.1 | 9.2 TS2M3 | |||
| Windows 7 Home Premium x64 | 5.1 | 6.1 | 9.2 TS2M3 | |||
| Windows 7 Professional 32 bit | 5.1 | 6.1 | 9.2 TS2M3 | |||
| Windows 7 Professional x64 | 5.1 | 6.1 | 9.2 TS2M3 | |||
| Windows 7 Ultimate 32 bit | 5.1 | 6.1 | 9.2 TS2M3 | |||
| Windows 7 Ultimate x64 | 5.1 | 6.1 | 9.2 TS2M3 | |||
| Windows Millennium Edition (Me) | 5.1 | |||||
| Windows Vista | 5.1 | 6.1 | 9.2 TS2M0 | |||
| Windows Vista for x64 | 5.1 | 6.1 | 9.2 TS2M0 | |||
A fix for this issue for SAS Add-in for Microsoft Office 5.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/G36.html#49348A fix for this issue for SAS Enterprise Guide 5.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/G35.html#49348| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2013-03-07 10:55:56 |
| Date Created: | 2013-03-04 15:02:15 |