SQL Server 2005 - Errors in the metadata manager. The dimension with ID...

Hey everyone,

I've got an error that I am unfamilar with on a SQL Server 2005 Analysis Server.  The error started appearing yesterday after updating for the Conflicker virus, the server was rebooted, which caused the cluster to swing the data drives...as expected...but after swinging the drives back, I can't open the Database in SQL Server Studion from local and remote Studio instances.

The "O" drive in question in the error is the SAN attached drive.  The XML files open, and are viewable.

Please check out the attached pic and shoot me any idea of what this means.

Thanks a lot,
Chris
SQL-Error.jpg
Team-PSOAsked:
Who is Participating?
 
pinaldaveCommented:
You need to upgrade to latest Service Pack to fix this error.

Kind Regards,
Pinal
0
 
Team-PSOAuthor Commented:
We only had SP1 on the Analysis services.  Maybe Sp2 will fix this?

I see that in some other posts...but we didn't have this issue until we updated all the OS updates yesterday.

thanks again,
0
 
Team-PSOAuthor Commented:
Hey Pinal,

SP2 did fix it as I found the same error with others.

THanks,
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.