Problem Note 38888: Opening a Private OLAP Server definition might cause SAS® Enterprise Guide® to work incorrectly
You can create server definitions to SAS® OLAP Servers prior to SAS 9.2 and third-party OLAP servers for use in SAS Enterprise Guide. Private OLAP Server definitions store the connection information required to get to these server types. Once defined, a private OLAP server can cause SAS Enterprise Guide to become unresponsive.
The issue is related to the Data Execution Prevention (DEP) feature in Microsoft Windows Vista and Microsoft Windows 7. DEP limits access by the .NET objects used in the SAS 9.1 and SAS 9.2 OLAP Data Providers. Some third-party OLAP providers also could be affected by this change in the operating system. If you are only accessing SAS 9.2 OLAP cubes, SAS recommends that you connect to the OLAP cube through the OLAP Server option rather than the private OLAP server. For SAS 9.1 users, the workaround is more complex:
- Delete the private OLAP server definition from File ► Open ► OLAP Cube.
- Close SAS Enterprise Guide.
- Locate the AppData folder for your environment. See SAS Note 17730 for details on locating the correct folder for your installation.
- Delete the OpenDlg file from the location in step 3.
- Open SAS Enterprise Guide.
- Redefine your private OLAP Server.
This process must be repeated each time the private OLAP server is opened. If possible, SAS recommends using SAS Enterprise Guide 4.1 when connecting to SAS 9.1 OLAP Servers.
Operating System and Release Information
SAS System | SAS Enterprise Guide | Windows Vista | 4.2 | 4.2 | 9.2 TS2M0 | 9.3 TS1M0 |
Microsoft Windows XP Professional | 4.2 | 4.2 | 9.2 TS2M0 | 9.3 TS1M0 |
Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.2 | 9.2 TS2M0 | 9.3 TS1M0 |
Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.2 | 9.2 TS2M0 | 9.3 TS1M0 |
Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.2 | 9.2 TS2M0 | 9.3 TS1M0 |
Microsoft® Windows® for x64 | 4.2 | 4.2 | 9.2 TS2M0 | 9.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.
Type: | Problem Note |
Priority: | high |
Topic: | Query and Reporting ==> OLAP (Online Analytical Processing)
|
Date Modified: | 2010-03-04 14:24:18 |
Date Created: | 2010-03-01 13:24:33 |