Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
LuckyJim
Starting Member
9 Posts |
 Posted - 2010-07-13 : 05:52:38
|
| Hi all,Trying to deploy to our Dev env I am getting this error message (apologies for length). Error 1 Errors in the metadata manager. The 'd:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Data\' storage location of the FACT Month End Stock CURRENT partition does not exist, is too long, or contains characters that are not valid or are reserved.I suspect that the path length is the problem.I guess I need to set the properties of the Analysis Server to something like 'D:\DEV' and see if that works but I was hoping someone here might have an eureka moment.TIA. |
|
|
LuckyJim
Starting Member
9 Posts |
Posted - 2010-07-13 : 07:02:13
|
| Okay I scripted the deployment out and did a search on the path it was trying to use.It was right it doesnt exist :-)It is trying to deploy a partitioned cube with this <Stroagelocation>d:\program files.....</StorageLocation>Looks like this tag only exists for partitioned cubes.I guess I could manually change it in the xmla script but anyone know where I can change it in BIDS ? |
 |
|
|
LuckyJim
Starting Member
9 Posts |
Posted - 2010-07-13 : 07:51:52
|
| found it - cube/partitions/properties. Doh |
|
|
|
|
|
|
Trying to deploy - metadata errors