Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

James Serra's Blog

James is currently a Senior Business Intelligence Architect/Developer and has over 20 years of IT experience. James started his career as a software developer, then became a DBA 12 years ago, and for the last five years he has been working extensively with Business Intelligence using the SQL Server BI stack (SSAS, SSRS, and SSIS). James has been at times a permanent employee, consultant, contractor, and owner of his own business. All these experiences along with continuous learning has helped James to develop many successful data warehouse and BI projects. James has earned the MCITP Business Developer 2008, MCITP Database Administrator 2008, and MCITP Database Developer 2008, and has a Bachelor of Science degree in Computer Engineering. His blog is at .

SSAS error when processing the cube

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).

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.