SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 43554: PROC OLAPOPERATE and other administrative calls to the SAS® OLAP Server could cause the OLAP Server to fail

DetailsHotfixAboutRate It

When you navigate within a SAS OLAP cube, MDX queries are generated by the client and sent to the SAS OLAP Server to retrieve the result set for the query. This action causes the query to be added to the session object for the OLAP Server so that administrative calls, like ones made by PROC OLAPOPERATE to list sessions or disable a cube, can locate the active queries.

If an active MDX query is executed but has not fully initialized when an administrative query occurs, this can cause the thread for the administrative query to fail along with subsequent administrative calls. In addition, the OLAP Server might stop responding.

These conditions might result in a traceback such as the following:

 
0613FD72  068DEDE8  tkmdx:\tkmdx1.c\mdxCompDisableCubes_impl 6001 +(0x12)
060F574B  068DF198  0001:0001474B tkmdx.dll
0610E649  068DF1D0  0001:0002D649 tkmdx.dll
05493DEB  068DF618  tkiompeb:\pebclient.c\pebAddClientLocale 7415 +(0x9CB)
0548C845  068DFB88  tkiompeb:\pebclient.c\clientDispatch 2355 +(0x14F9)
04F98C05  068DFEE0  tkiomsvc:\tkiompdl.c\svcPuddleMain 209 +(0x14D)
050A2339  068DFF40  tkepdl:\tkepdlb.c\puddleInitBasic 668 +(0x1B)
10002289  068DFF70  tkmk:\sktMain.c\sktMain 104 +(0x14)
10003221  068DFF88  tkmk:\TKWINbktMain.c\bktMain 50 +(0xB)
75FDE4A5  068DFF94  kernel32:BaseThreadInitThunk+0xE
7782D4BD  068DFFD4  ntdll:RtlCreateUserProcess+0x8C
7782D6CF  068DFFEC  ntdll:RtlCreateProcessParameters+0x4E

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS OLAP Serverz/OS9.2 TS2M09.3 TS1M0
Microsoft® Windows® for 64-Bit Itanium-based Systems9.2 TS2M09.3 TS1M0
Microsoft Windows Server 2003 Datacenter 64-bit Edition9.2 TS2M09.3 TS1M0
Microsoft Windows Server 2003 Enterprise 64-bit Edition9.2 TS2M09.3 TS1M0
Microsoft Windows XP 64-bit Edition9.2 TS2M09.3 TS1M0
Microsoft® Windows® for x649.2 TS2M09.3 TS1M0
Microsoft Windows Server 2003 Datacenter Edition9.2 TS2M09.3 TS1M0
Microsoft Windows Server 2003 Enterprise Edition9.2 TS2M09.3 TS1M0
Microsoft Windows Server 2003 Standard Edition9.2 TS2M09.3 TS1M0
Microsoft Windows Server 2003 for x649.2 TS2M09.3 TS1M0
Microsoft Windows Server 2008 for x649.2 TS2M09.3 TS1M0
Microsoft Windows XP Professional9.2 TS2M09.3 TS1M0
Windows Vista9.2 TS2M09.3 TS1M0
Windows Vista for x649.2 TS2M09.3 TS1M0
64-bit Enabled AIX9.2 TS2M09.3 TS1M0
64-bit Enabled HP-UX9.2 TS2M09.3 TS1M0
64-bit Enabled Solaris9.2 TS2M09.3 TS1M0
HP-UX IPF9.2 TS2M09.3 TS1M0
Linux9.2 TS2M09.3 TS1M0
Linux for x649.2 TS2M09.3 TS1M0
OpenVMS on HP Integrity9.2 TS2M09.3 TS1M0
Solaris for x649.2 TS2M09.3 TS1M0
* 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.