![]() | ![]() | ![]() | ![]() | ![]() |
When submitting a query to the SAS® OLAP Server, a dimension member that contains a single quote, such as Mel's Merchandise, might cause an error when you attempt to sort or total the query results. The error would be similar to the following:
Caused by: com.sas.iquery.dataretrieval.DataRetrievalException: Exception occurred while attempting to access data. [ com.sas.iquery.dataretrieval.DataRetrievalException: Exception occurred when retrieving the ResultSet. [ com.sas.iquery.dataretrieval.DataRetrievalException: Unable to execute query. [ com.sas.iquery.execution2.ExecutionException: Exception while executing MDX query. [ com.sas.storage.olap.OLAPException: An MDX syntax error occurred [ com.sas.iom.SASIOMDefs.GenericError: An MDX syntax error occurred [ com.sas.iom.SASIOMDefs.GenericError: Syntax error detected on line 25 at column 256. Found End of Statement, expecting (, *, +, -, '.', /, :, <, <=, <>, =, >, >=, AND, AS, IS, MEMBER, OR, SELECT, SET, XOR, ||. ] ] ] ] ] ]
Select the Hot Fix tab in this note to access the hot fix for this issue.
Product Family | Product | System | SAS Release | |
Reported | Fixed* | |||
SAS System | SAS OLAP Server | z/OS | 9.1 TS1M3 SP4 | 9.2 TS1M0 |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 SP4 | |||
Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 SP4 | |||
Microsoft Windows 2000 Server | 9.1 TS1M3 SP4 | |||
Microsoft Windows 2000 Professional | 9.1 TS1M3 SP4 | |||
Microsoft Windows NT Workstation | 9.1 TS1M3 SP4 | |||
Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
Microsoft Windows XP Professional | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
Windows Vista | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
64-bit Enabled AIX | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
64-bit Enabled HP-UX | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
64-bit Enabled Solaris | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
HP-UX IPF | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
Linux | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
Linux on Itanium | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
OpenVMS Alpha | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
Solaris for x64 | 9.1 TS1M3 SP4 | 9.2 TS1M0 | ||
Tru64 UNIX | 9.1 TS1M3 SP4 | 9.2 TS1M0 |