Problem Note 37094: Drilling through to a SAS® OLAP cube from a SAS® Web application might fail
 |  |  |  |  |
In some cases, drill through requests from a SAS Web application to the SAS OLAP Server might fail because of socket settings.
Symptoms of this issue include the following error in the client:
ERROR [] com.sas.commands.olap.ShowDetailDataCommand - Drill through cannot be performed. Query failed. Please contact your data administrator. An exception was thrown while waiting for a reply from the peer. Drill through cannot be performed. Query failed. Please contact your data administrator.
The SAS OLAP server log will show that the drill-through completed successfully but that the client disconnected prematurely.
The TCP/IP tcpSockWriteVector() support routine failed with error 10053 (The software caused the connection to abort.)
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 | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Web Report Studio | Microsoft® Windows® for x64 | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Windows Vista | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| 64-bit Enabled AIX | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| 64-bit Enabled Solaris | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| HP-UX IPF | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Linux for x64 | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Solaris for x64 | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| SAS System | SAS Web OLAP Viewer for Java | z/OS | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 |
| Microsoft® Windows® for x64 | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows Server 2008 | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Microsoft Windows XP Professional | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Windows Vista | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| 64-bit Enabled AIX | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| 64-bit Enabled Solaris | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| HP-UX IPF | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Linux for x64 | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
| Solaris for x64 | 4.2 | 4.2_M2 | 9.2 TS2M0 | 9.2 TS2M3 | ||
A fix for this issue for SAS Web Report Studio 4.2 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/A06.html#37094A fix for this issue for SAS Web Report Studio 4.2_M1 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/A55.html#37094A fix for this issue for SAS Web Report Viewer 4.2_M1 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/A62.html#37094| Type: | Problem Note |
| Priority: | high |
| Topic: | System Administration ==> Servers ==> OLAP System Administration ==> Web Query and Reporting ==> Interactive Querying Query and Reporting ==> OLAP (Online Analytical Processing) |
| Date Modified: | 2009-10-27 14:51:43 |
| Date Created: | 2009-09-04 10:11:26 |