Every couple of weeks I see this SSAS error when processing one of my cubes:
Internal error: Invalid enumeration value. Please call customer support! is not a valid value for this element.
An error occurred while parsing the ‘StorageMode’ element at line 1, column 2217 (‘http://schemas.microsoft.com/analysisservices/2003/engine’ namespace) under Load/ObjectDefinition/Dimension/StorageMode.
Errors in the metadata manager. An error occurred when instantiating a metadata object from the file, ‘\\?\d:\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data\FinancialCubeTEST.0.db\DimSubLedger.5.dim.xml’.
I have seen this same error on more than one cube. To fix this, remote into your server and delete the file specified in the error message (in this case, d:\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\Data\FinancialCubeTEST.0.db\DimSubLedger.5.dim.xml).
This usually works, but a few times it still did not fix it for me. Then the only option is to login to Analysis Services and delete the database (deleting the cube is not enough).
Pingback: Error 64 Internal error: Invalid enumeration value. Please call customer support! is not a valid value for this element. « "You'll Learn, Like They All Learn, The Hard Way"
Hi James, Thankyou for this post. I just ran into this annoying problem. It would constantly complain about one (.xml) file after the other. Just curious what would cause this error!
Thanks,
Samuel.
Thank you so much for this post…..I have spent hours trying to fix this….Finally its working….