Claus on Code

A data dudes random musings about code, bugs, products, life etc.


Errors in the OLAP storage engine: The metadata for the statically linked measure group, with the name of XXX, cannot be verified against the source object

I’ve been working a little with MS Analysis services lately. Yesterday I came across this error message:

Errors in the OLAP storage engine: The metadata for the statically linked measure group, with the name of XXX, cannot be verified against the source object.”

The error message is self explaining. I did indeed have more than one cube, and some of the cubes where linking to another. I had, however, been running with this setup for a long time, and never seen this problem before.

After some googling and som trial and error, I found a solution to the problem. It is not pretty, but there was nothing else to do 🙁

  • Delete the Analysis services database
  • Deploy the cubes without processing 
  • Process the cube(s) that are being linked to
  • Process the whole database

As I said before, it’s not at pretty solution, and I must admit I’m little curries about next time I have to deploy the cube.



One response to “Errors in the OLAP storage engine: The metadata for the statically linked measure group, with the name of XXX, cannot be verified against the source object”

Leave a Reply

Your email address will not be published. Required fields are marked *