Problem Note 20001: The DEFINE statement for PROC OLAP does not honor SAS® Metadata Server connection options specified outside of the METASVR statement
The METASVR statement in the OLAP procedure allows you to specify the
connection options for your metadata environment. However, even if the
SAS Metadata Server options are defined at initialization of the server
or before the PROC OLAP code is submitted, the DEFINE statement within
the OLAP procedure does not honor the settings. Errors will be generated
when the DEFINE statement is encountered in the code.
The SAS code and log output listed below illustrate the error received
when the PROC OLAP code is submitted with metadata server connection
options predefined, but no METASVR statement has been specified.
options metaserver = host.name.com;
options metaport = 8561;
options metauser = "userid";
options metapass = "password";
options metaprotocol=bridge;
option metarepository="Foundation";
PROC OLAP;
METASVR olap_schema="SASMain - OLAP Schema";
define member '[Cubename].[Measures].[double]' AS
'[Measures].[Quantitysum]*2';
run;
NOTE: The default repository "Foundation" will be used.
NOTE: The Data Cache is inactive
COM Remote Server: host.name.com.
ERROR: COM CoCreateInstanceEx() failed: (HRESULT=80080005).
ERROR: Metadata error - A connection to the metadata server cannot
be established
ERROR: The server options failed to set during DEFINE and UNDEFINE
statement processing.
ERROR: DEFINE and UNDEFINE statement processing failed.
NOTE: The SAS System stopped processing this step because of errors.
Operating System and Release Information
SAS System | SAS OLAP Server | Tru64 UNIX | 9.1 TS1M3 | 9.2 |
64-bit Enabled AIX | 9.1 TS1M3 | 9.2 |
OpenVMS Alpha | 9.1 TS1M3 | 9.2 |
64-bit Enabled HP-UX | 9.1 TS1M3 | 9.2 |
HP-UX IPF | 9.1 TS1M3 | 9.2 |
Linux on Itanium | 9.1 TS1M3 | 9.2 |
Linux | 9.1 TS1M3 | 9.2 |
z/OS | 9.1 TS1M3 | 9.2 |
64-bit Enabled Solaris | 9.1 TS1M3 | 9.2 |
Microsoft Windows 2000 Advanced Server | 9.1 TS1M3 | 9.2 |
Microsoft Windows 2000 Datacenter Server | 9.1 TS1M3 | 9.2 |
Microsoft Windows 2000 Professional | 9.1 TS1M3 | 9.2 |
Microsoft Windows 2000 Server | 9.1 TS1M3 | 9.2 |
Microsoft Windows Server 2003 Datacenter Edition | 9.1 TS1M3 | 9.2 |
Microsoft Windows Server 2003 Enterprise Edition | 9.1 TS1M3 | 9.2 |
Microsoft Windows Server 2003 Standard Edition | 9.1 TS1M3 | 9.2 |
Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.1 TS1M3 | 9.2 |
Microsoft Windows XP 64-bit Edition | 9.1 TS1M3 | 9.2 |
Microsoft Windows NT Workstation | 9.1 TS1M3 | 9.2 |
Microsoft Windows XP Professional | 9.1 TS1M3 | 9.2 |
*
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: | medium |
Topic: | System Administration ==> Servers ==> OLAP Query and Reporting ==> OLAP (Online Analytical Processing)
|
Date Modified: | 2007-10-22 11:57:07 |
Date Created: | 2007-04-18 13:37:54 |