views:

25

answers:

1

Suddenly I can't process a SSAS project anymore. The error I get is 'x.partitions' is not valid and cannot be opened. Check the 'x.partitions' file

Last thing I remember was a checkin of the project into TFS. A good idea to fix this would be very much appreciated.

The Cube that is causing the problem is a cube with 2 linked cubes in it. (I assume it shouldn't have anything to do with it)

A: 

have you looked at the actual partitions file? you wont be able to see in BIDS i think unless you show all files. You might have to look on disk. What about your queries for your partitions? can you get to your partitions in BIDS?

ScaleOvenStove
On the file system I had a look at this file, it didn't look like it had all it should in it. I could somehow work around it now by deleting the partition completely and creating a new one and manipulating the project file. I'm not sure how much a recent rename of the cube has something to do with it. One day later I got the error "Object reference not set to an instance of an object". Either something with my solution/project is totally messed up or renaming is not a good idea with TFS and BI projects within VS2008 SP1.
nojetlag
yeah, it isn't an easy thing, you end up having to go into the XML for the objects and modify things
ScaleOvenStove