Usage Note 45067: SAS® OLAP Server must be restarted whenever associated DBMS servers are restarted
The SAS OLAP Server is a started task that sits in a wait state for MDX queries from an OLAP client application. Unlike a SAS Workspace Server session that is started at each submission of a SAS program and then terminated when the program completes execution, the SAS OLAP Server remains active until its SAS server session is stopped, restarted, or the physical machine that it is running on is restarted.
SAS data or third-party DBMS servers that are used in OLAP queries for drillthrough, aggregation, or ROLAP tables are initialized either when the SAS OLAP Server is started, or when they are referenced the first time. They are allocated via a SAS library assignment based on metadata information for the library definition. If one of these table servers is restarted, then the OLAP Server's connection to that server is broken and the library association is lost, which will result in disconnection errors generated by the OLAP Server.
For example, the following error was generated in the SAS OLAP Server log when a query to a ROLAP table was made against the OLAP Server following a restart of the Oracle server.
ERROR: ORACLE prepare error: ORA-03135: connection lost contact.
The server encountered an error accessing a source data table.
ERROR: SQL passthru expression contained these errors:
ERROR: ORACLE prepare error: ORA-03114: not connected to ORACLE.
Therefore, if a data server that is external to the OLAP Server session is restarted, you will need to restart the SAS OLAP Server in order to re-establish the connection with that server. This is necessary in order to allow future queries to the corresponding tables to execute correctly. The restart of the OLAP Server can be paired with any automatic restarts for your external DBMS servers.
Operating System and Release Information
| SAS System | SAS OLAP Server | z/OS | 9.1 TS1M2 | |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M2 | |
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.1 TS1M2 | |
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.1 TS1M2 | |
| Microsoft Windows 2000 Advanced Server | 9.1 TS1M2 | |
| Microsoft Windows 2000 Datacenter Server | 9.1 TS1M2 | |
| Microsoft Windows 2000 Server | 9.1 TS1M2 | |
| Microsoft Windows 2000 Professional | 9.1 TS1M2 | |
| Microsoft Windows NT Workstation | 9.1 TS1M2 | |
| Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M2 | |
| Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M2 | |
| Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M2 | |
| Microsoft Windows XP Professional | 9.1 TS1M2 | |
| 64-bit Enabled AIX | 9.1 TS1M2 | |
| 64-bit Enabled HP-UX | 9.1 TS1M2 | |
| 64-bit Enabled Solaris | 9.1 TS1M2 | |
| HP-UX IPF | 9.1 TS1M2 | |
| Linux | 9.1 TS1M2 | |
| OpenVMS Alpha | 9.1 TS1M2 | |
| Tru64 UNIX | 9.1 TS1M2 | |
*
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: | Usage Note |
| Priority: | |
| Topic: | Query and Reporting ==> OLAP (Online Analytical Processing)
|
| Date Modified: | 2011-12-08 13:46:59 |
| Date Created: | 2011-12-06 16:48:12 |