Problem Note 17800: WHERE clause is not allowed with preset index
 |  |  |  |  |
When issuing a WHERE clause with Workunit journaling, the following error may appear:
WHERE clause is not allowed with preset index.
The Metadata server log will contain:
Could not get the first value in this index
follow by many lines of:
WHERE Clause is not allowed with preset index
To circumvent the problem, turn off Workunit journaling.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | SAS Metadata Server | Microsoft Windows XP Professional | 9.1 TS1M3 | 9.2 TS1M0 |
| Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows NT Workstation | 9.1 TS1M3 | |||
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Server | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Professional | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | 9.2 TS1M0 | ||
| 64-bit Enabled Solaris | 9.1 TS1M3 | 9.2 TS1M0 | ||
| z/OS | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Linux | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Linux on Itanium | 9.1 TS1M3 | 9.2 TS1M0 | ||
| HP-UX IPF | 9.1 TS1M3 | 9.2 TS1M0 | ||
| 64-bit Enabled HP-UX | 9.1 TS1M3 | 9.2 TS1M0 | ||
| OpenVMS Alpha | 9.1 TS1M3 | 9.2 TS1M0 | ||
| 64-bit Enabled AIX | 9.1 TS1M3 | 9.2 TS1M0 | ||
| Tru64 UNIX | 9.1 TS1M3 | 9.2 TS1M0 | ||
A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:
http://www.sas.com/techsup/download/hotfix/e9_sbcs_prod_list.html#017800A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at :
http://www.sas.com/techsup/download/hotfix/e9_dbcs_prod_list.html#017800| Type: | Problem Note |
| Priority: | alert |
| Topic: | System Administration ==> Servers ==> Metadata |
| Date Modified: | 2006-07-06 23:06:02 |
| Date Created: | 2006-05-31 15:47:48 |