SUPPORT / SAMPLES & SAS NOTES
Problem Note 51423: Using a long XMLSELECT search string in the SAS® Open Metadata Interface might generate the error "The XMLSELECT options length is invalid"
 |  |  |  |  |
When you use a long XMLSELECT search string in the SAS Open Metadata Interface, the following error might occur:
The XMLSELECT options length is invalid.
This error occurs when the internal buffer length is too small to hold the SAS® WHERE clause that is created from the XMLSelect attribute criteria.
The following long XMLSELECT search is an example of a search that creates this error:
XMLSelect search="*[@name = '767' or @name = '856' or @name = '1870' or @name =
'1735' or @name = '611' or @name = '1869' or @name = '2367' or @name = '3944' or
@name = '4154' or @name = '4742' or @name = '4815' or @name = '4755' or @name =
'4818' or @name = '4807' or @name = '2962' or @name = '2963' or @name = '4305'
or @name = '4850' or @name = '4854' or @name = '4623' or @name = '4625' or @name
= '4733' or @name = '4863' or @name = '2415' or @name = '4693' or @name = '4722'
or @name = '4734' or @name = '4780' or @name = '4858' or @name = '4782' or @name
= '4647' or @name = '4778' or @name = '2861' or @name = '1507' or @name = '1480'
or @name = '3977' or @name = '3978' or @name = '3979' or @name = '3980' or @name
= '4808' or @name = '4810' or @name = '4881' or @name = '4735' or @name = '4740'
or @name = '4837' or @name = '4839' or @name = '4685' or @name = '4683' or @name
= '4754' or @name = '3974' or @name = '3975' or @name = '3976' or @name = '4835'
or @name = '4833' or @name = '4834' or @name = '631' or @name = '503' or @name =
'538' or @name = '1498' or @name = '1721' or @name = '4450' or @name = '3682' or
@name = '4758' or @name = '4865' or @name = '4871' or @name = '4873' or @name =
'4875' or @name = '4877' or @name = '3937' or @name = '3956' or @name = '3999'
or @name = '4013' or @name = '4022' or @name = '4033' or @name = '4035' or @name
= '4038' or @name = '4048' or @name = '4128' or @name = '4130' or @name = '4133'
or @name = '4143' or @name = '4159' or @name = '4663' or @name = '4675' or @name
= '4747' or @name = '4749' or @name = '4751' or @name = '4761' or @name = '4763'
or @name = '4765' or @name = '4224' or @name = '4775' or @name = '4769' or @name
= '4773' or @name = '4771' or @name = '4812' or @name = '4221' or @name = '4817'
or @name = '4819' or @name = '4776' or @name = '3004' or @name = '4848' or @name
= '4846' or @name = '4844' or @name = '4841' or @name = '4511' or @name =
'3411']"
Currently, there is no solution or workaround for this problem.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Metadata Server | z/OS | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 |
| Microsoft® Windows® for x64 | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Microsoft Windows 8 Enterprise 32-bit | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Microsoft Windows 8 Enterprise x64 | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Microsoft Windows 8 Pro 32-bit | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Microsoft Windows 8 Pro x64 | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Microsoft Windows 8.1 Pro | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 for x64 | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2008 | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2008 R2 | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2008 for x64 | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2012 Datacenter | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2012 R2 Std | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2012 Std | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Microsoft Windows XP Professional | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Windows 7 Enterprise 32 bit | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Windows 7 Enterprise x64 | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Windows 7 Home Premium 32 bit | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Windows 7 Home Premium x64 | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Windows 7 Professional 32 bit | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Windows 7 Professional x64 | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Windows 7 Ultimate 32 bit | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Windows 7 Ultimate x64 | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Windows Vista | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Windows Vista for x64 | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| 64-bit Enabled AIX | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| 64-bit Enabled HP-UX | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| 64-bit Enabled Solaris | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| HP-UX IPF | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Linux | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Linux for x64 | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||
| Solaris for x64 | 9.3_M2 | 9.3_M2 | 9.3 TS1M2 | 9.3 TS1M2 | ||