SSAS deployment error: Internal error: Invalid enumeration value. Please call customer support! is not a valid value for this element.
- by Kevin Shyr
The first search on this error yielded some blog posts that says to check SQL server version. It suggested that I couldn't deploy a SSAS project originally set for SSAS 2008 to a SSAS 2008 R2, which didn't make sense to me. Combined with the fact that the error message was telling me to call customer support. Why do I need to call customer support unless something catastrophic happened?Turns out that one of the file on the SQL server is corrupt. I could simply delete the database on the SSAS server and re-run deployment. Problem solved.SSAS errors in visual studio:
Normal
0
false
false
false
EN-US
X-NONE
X-NONE
MicrosoftInternetExplorer4
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-qformat:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-fareast-font-family:"Times New Roman";
mso-fareast-theme-font:minor-fareast;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
Error
10 Internal error:
Invalid enumeration value. Please call customer support! is not a valid value
for this
element.
0
0
Error
11 An error
occurred while parsing the 'StorageMode' element at line 1, column 10523
('http://schemas.microsoft.com/analysisservices/2003/engine' namespace) under
Load/ObjectDefinition/Dimension/StorageMode.
0
0
Error
12 Errors in the
metadata manager. An error occurred when instantiating a metadata object from
the file, '\\?\E:\Program Files\Microsoft SQL
Server\MSAS10_50.MSSQLSERVER\OLAP\Data\DWH Sales
Facts.0.db\Competitor.48.dim.xml'.
0
0