My first experiences with development started more than 10 years ago and since then I’ve seen all kind of weird development tool errors and bugs. I’m “happy” to see that with SQL Server 2008 R2 the dodgy errors legacy continues.
Some days ago I was building a new cube and when I clicked the ‘process’ button the following 3 error messages appeared that prevented to process the cube:
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 xxxxxxxx…….
Errors in the metadata manager. An error occurred when instantiating a metadata object from the file, ‘\\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data\xxxxxxxxxxx……xml’
I like the first line. Please call customer support! So funny…
After some internet searching, re-doing parts of the cube and even creating a new cube, the only solution that I’ve found is to totally delete (or move to another location) the cube’s folder and associated xml file.
Let’s imagine that our cube is called ‘TestCube’ and that we are having the 3 error messages described above. The solution is quite simple, just follow these steps:
The first step will be to close BIDS and stop SQL Server Analysis Services service. This will unblock the files and folders that need to be deleted.
As a second step go to ‘C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data’ folder (in a default installation) and delete:
- TestCube.##.db.xml (where ## is a two digits number) file
- TestCube.0.db folder
Once these 2 items have been deleted you can restart SQL Server Analysis Services, open the BIDS solution and process the TestCube cube. This time it will work without problems or calling customer support 🙂