• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 812
  • Last Modified:

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
0
Team-PSO
Asked:
Team-PSO
  • 2
1 Solution
 
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
 
pinaldaveCommented:
You need to upgrade to latest Service Pack to fix this error.

Kind Regards,
Pinal
0
 
Team-PSOAuthor Commented:
Hey Pinal,

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

THanks,
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now