Title

Kodyaz Development Resources

Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Vista, etc.
Welcome to Kodyaz Development Resources Sign in | Join | Help
in Search

Eralper's Blog on Software Development



Errors in the metadata manager. The {0} storage location of the {1} partition does not exist, is too long, or contains characters that are not valid or are reserved.

Still continue to try to process and deploy the MS SQL Server 2005 Analysis Services project on my lap top.

Again a new error :

Errors in the metadata manager.
The 'P:\Olap2005\OlapProject_Data\' storage location of the CustomersStatic partition does not exist, is too long, or contains characters that are not valid or are reserved.

That is related to a cube which has StorageLocation of the Measure Group and Partition is set to a non default location which can not be reached or not defined on the computer that the BI project exists.

A realized that find a partition in an OLAP project by just knowing the name is difficult. This time it was easy for me since the name was remembering the cube name. So using a standart in naming of the partitions will be helpfull.

To resolve the issue, I set the StorageLocation of the measure group to C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Backup which is the default place.

 

Published Friday, November 03, 2006 8:48 AM by eralper
Filed Under:

Comments

No Comments
Anonymous comments are disabled
Copyright © 2004 - 2008 Eralper Yilmaz. All rights reserved.
Powered by Community Server, by Telligent Systems