Problem Note 47065: Unable to open Microsoft Analysis Services OLAP cubes in the 64-bit version of SAS® Enterprise Guide® 5.1
When using the 64-bit version of SAS Enterprise Guide 5.1 to open a Microsoft Analysis Services OLAP cube using the Microsoft OLE DB Provider for Analysis Services 10.0, the following error occurs :
An error occurred opening cube "YourCubeNameHere". An unknown failure occurred while
connecting to the server or provider. No other information can be
surfaced. Specified cast is not valid.
Another possible error is as follows:
Application Error
SAS Enterprise Guide has encountered a problem
We recommend that you save your work and restart SAS Enterprise Guide.
--------------------------------------------------------------------------------
-----------------------
Exception information
--------------------------------------------------------------------------------
-----------------------
Specified cast is not valid.
-------------------------- Technical Information Follows
--------------------------
Exception Details:
----------------------------------------
Exception type: System.InvalidCastException
Message: Specified cast is not valid.
Source: SAS.OCT.OlapClientEngine
Target Site: ToInt
Stack Trace:
at SAS.OCT.CubeUtilities.PropertyConvert.ToInt(Object o)
at SAS.OCT.CubeData.SchemaRow.GetValueAsInt(Int32 column, Int32 defaultValue)
at SAS.OCT.CubeData.Function..ctor(Cube owningCache, String name, SchemaRow
row)
at SAS.OCT.CubeData.Functions.CreateItemFromSchemaRow(SchemaRow row)
at SAS.OCT.CubeData.MetadataCollection`2.DoUpdateData()
at SAS.OCT.CubeData.Functions.IsSupported(String functionName)
at SAS.OCT.CubeData.Supports..ctor(Cube cube)
at SAS.OCT.CubeManagement.CommonDataManager.CreateUniqueNameHashtable()
at SAS.OCT.MdxQueryBuilder.QueryBuilder.InitializeSerializedProperties()
at SAS.OCT.MdxQueryBuilder.QueryBuilder.ResetToDefaultQuery()
at SAS.OCT.CubeManagement.QueryViewManager..ctor(Int32 viewerId,
CommonDataManager cdm, Boolean allowUndo, Boolean executeDefaultQuery, XmlNode
savedState, String mdx, Boolean useBookmarkDefaultViewIfAvailable,
QueryViewOptions queryViewOptions)
The only workaround is to use the 32-bit version of SAS Enterprise Guide 5.1.
Operating System and Release Information
| SAS System | SAS Enterprise Guide | Microsoft® Windows® for x64 | 5.1 | 6.1 | | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 5.1 | 6.1 | | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Enterprise Edition | 5.1 | 6.1 | | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Standard Edition | 5.1 | 6.1 | | 9.3 TS1M0 |
| Microsoft Windows Server 2003 for x64 | 5.1 | 6.1 | | 9.3 TS1M0 |
| Microsoft Windows Server 2008 | 5.1 | 6.1 | | 9.3 TS1M0 |
| Microsoft Windows Server 2008 for x64 | 5.1 | 6.1 | | 9.3 TS1M0 |
| Microsoft Windows XP Professional | 5.1 | 6.1 | | 9.3 TS1M0 |
| Windows 7 Enterprise 32 bit | 5.1 | 6.1 | | 9.3 TS1M0 |
| Windows 7 Enterprise x64 | 5.1 | 6.1 | | 9.3 TS1M0 |
| Windows 7 Home Premium 32 bit | 5.1 | 6.1 | | 9.3 TS1M0 |
| Windows 7 Home Premium x64 | 5.1 | 6.1 | | 9.3 TS1M0 |
| Windows 7 Professional 32 bit | 5.1 | 6.1 | | 9.3 TS1M0 |
| Windows 7 Professional x64 | 5.1 | 6.1 | | 9.3 TS1M0 |
| Windows 7 Ultimate 32 bit | 5.1 | 6.1 | | 9.3 TS1M0 |
| Windows 7 Ultimate x64 | 5.1 | 6.1 | | 9.3 TS1M0 |
| Windows Vista | 5.1 | 6.1 | | 9.3 TS1M0 |
| Windows Vista for x64 | 5.1 | 6.1 | | 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.
The 64-bit Microsoft OLE DB for OLAP Provider 10.0 returns a different value than the 32-bit provider, which prevents the 64-bit version of SAS Enterprise Guide 5.1 from accessing a cube.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2012-07-26 14:23:09 |
| Date Created: | 2012-07-25 14:25:17 |
