Welcome to EMC Consulting Blogs Sign in | Join | Help

David Francis Blog

SSAS 2005 - Deployment issues following changes to statically linked measure groups

If you are making changes to a linked object measure group after you have created the initial link, such as adding a new measure, you can come across the following error when you next deploy the solution.

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

When I first came across this I expected just changing the Deployment Mode to Deploy All would fix it but this doesn't appear to be the case.

Then I thought restarting the AS service would flush and reload the memory held metadata - no effect.

The only way round this is:

1) Backup your Analysis Services database.

2) Delete the database.

3) Redeploy the underlying linked cube and reprocess.

4) Delete and recreate the link between the two objects.

5) Redeploy and reprocess the rest of the Analysis Services database.

 Hope that helps.



Published Wednesday, October 03, 2007 4:17 PM by David.Francis


No Comments
Anonymous comments are disabled
Powered by Community Server (Personal Edition), by Telligent Systems