Usage Note 41369: The error "File LIB.TABLE.DATA does not exist" occurs when you try to open a large PostgreSQL table with SAS® 9.2
The following error occurs when you try to open a large PostgreSQL table with SAS/ACCESS Interface to ODBC.
ERROR: File LIB.TABLE.DATA does not exist.
By default, the PostgreSQL ODBC driver loads the entire table into memory, which can lead to out-of-memory conditions or other error conditions in the driver. The error returned to SAS indicates that the table does not exist and the error message is produced.
You can change this behavior in the PostgreSQL ODBC-driver setup dialog window by enabling the Use Declare/Fetch option under Datasource Options. This option enables the driver to keep only a small subset of the table in memory, and then the table can be accessed from SAS successfully.
Operating System and Release Information
SAS System | SAS/ACCESS Interface to ODBC | Microsoft Windows XP 64-bit Edition | 9.2 TS2M3 | |
Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS2M3 | |
Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS2M3 | |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS2M3 | |
Microsoft® Windows® for x64 | 9.2 TS2M3 | |
Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS2M3 | |
Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS2M3 | |
Microsoft Windows Server 2003 Standard Edition | 9.2 TS2M3 | |
Microsoft Windows Server 2003 for x64 | 9.2 TS2M3 | |
Microsoft Windows Server 2008 | 9.2 TS2M3 | |
Microsoft Windows Server 2008 for x64 | 9.2 TS2M3 | |
Microsoft Windows XP Professional | 9.2 TS2M3 | |
Windows 7 Enterprise 32 bit | 9.2 TS2M3 | |
Windows 7 Enterprise x64 | 9.2 TS2M3 | |
Windows 7 Home Premium 32 bit | 9.2 TS2M3 | |
Windows 7 Home Premium x64 | 9.2 TS2M3 | |
Windows 7 Professional 32 bit | 9.2 TS2M3 | |
Windows 7 Professional x64 | 9.2 TS2M3 | |
Windows 7 Ultimate 32 bit | 9.2 TS2M3 | |
Windows 7 Ultimate x64 | 9.2 TS2M3 | |
Windows Vista | 9.2 TS2M3 | |
Windows Vista for x64 | 9.2 TS2M3 | |
*
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.
The error "File LIB.TABLE.DATA does not exist" occurs when you attempt to open a large PostgreSQL table with the SAS® System. By default, PostgreSQL loads the entire table in memory, which can lead to out of memory or other error conditions between the database and the client.
Type: | Usage Note |
Priority: | |
Topic: | Data Management ==> Data Sources ==> External Databases ==> ODBC (Open Database Connectivity)
|
Date Modified: | 2010-11-05 15:18:06 |
Date Created: | 2010-10-22 11:16:47 |