Troubleshooting: The 'AllowedRowsExpression' element in the 'http://schemas.microsoft.com/analysisservices/2011/engine/300/300' namespace is unexpected.
Exception/Error Message:
The 'AllowedRowsExpression' element in the 'http://schemas.microsoft.com/analysisservices/2011/engine/300/300' namespace is unexpected.
Scenario:
You may experience this exception under various circumstances. Some of are given below (not exhaustive).
- .NET client program trying to perform some operation on the SSAS cube using Analysis Management Object (AMO) for .net libraries.
- While upgrading the SQL Server Analysis Service (SSAS) 2008 to 2012.
- Any application using older major version of Microsoft.AnalysisServices.DLL [SSAS 2008] file to connect to a new major version of the Microsoft.AnalysisServices.DLL [SSAS 2012].
FIX:
- Download & Install the following MSIs in the order given below. Those MSIs can be downloaded from the Microsoft® SQL Server® 2012 Feature Pack. (During installation, if you receive a misleading error like "A network error occurred while attempting to read from the file..", that means you already have it on the given box. You can verify by following the steps given at the How to determine client library version on a workstation).
[Choose x86/x64 depending on your system. To find out what is the CPU family, please go to Start->Run and then type msinfo32. It will show you what is the CPU family]
SQL_AS_OLEDB.msi
SQL_AS_ADOMD.msi
SQL_AS_AMO.msi
Note:
- OLEDB libraries are used by ADOMD & AMO. Hence, install OLEDB first as a safe approach.
- If you are doing the installation for the Web application running with IIS. Please ensure you use correct logon to perform the installation. Otherwise, installation folders may not be available for your application’s AppPool identity and your website may throw 401 for your visitors.
- If you are dealing with compiled .net code with old AMO DLLs, you have to recompile the code after correcting the DLLreferences and deploy on the server.
Applies To:
Microsoft® SQL Server® 2008 & 2012 ADOMD.NET
Microsoft® Analysis Services OLE DB Provider for Microsoft® SQL Server® 2008 & 2012
Microsoft® SQL Server® 2008 & 2012 Analysis Management Objects