Analysis Services SP4 problems

Hello I hope someone can help me.

On a SQL server that has had SP4 recently installed on it for both the SQL Server service and OLAP service, I am unable to browse the data of any of the Shared Dimensions or Cubes of any of the databases when I use the Analysis Manager MMC. At the time I am logged onto the server as an administrator using terminal services. Upon attempting to browse a shared dimension the following error is returned "Unable to browse the dimension <dimension name>, Type mismatch" and when attempting to browse a cube the error is "Unable to browse the cube <cube name>. An unexpected internal error has occured. Please restart the application."

The Cubes can be browsed via Excel though and all Reporting Service mdx queries are functioning correctly.

If I register the same server in Analysis Manager MMC on a different server also with SP4 all Cubes and Dimensions data can be browsed.

I tried archiving the database cubes and restoring them on a server with SP3 and all data can be browsed via the servers own Analysis Manager MMC.

Any ideas?

This can be related to an MDAC version issue if this post is correct: http://www.dbforums.com/archive/index.php/t-357508.html

Regards

Thomas Ivarsson

|||

I suspect you are right. Thank you for the help Thomas.

On the servers that have "MDAC 2.8 on Windows XP SP2" seem to have the same problem. Servers that are using "MDAC 2.8 RTM" are all functioning correctly, (as determined by "Component Checker").

Do you happen to know the link of a webpage that gives a walkthrough on how to perform a MDAC Rollback?

I have not found any information on how to do this correctly.

|||

Sorry, I have no link, except that I think there is a newsgroup for this(http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=87&SiteID=1).

Kind Regards

Thomas Ivarsson

|||

I have encountered the same situation aftr installing SP4. Please let me know how to fix this apparently MDAC related problem

Thanks

Attila

|||

I am currently administrating the production Analysis Server with Analysis Manager MMC via a remote connection that also uses "MDAC 2.8 on Windows XP SP2". This permits browsing of dimension and cube data as well as virtual cube editing. (An annoying work around).

I have discovered that "MDAC 2.8 RTM" seems to function correctly but I have not yet found the correct procedure for performing a MDAC rollback, which is quite probably quite complicated considering all the dll's and registry settings involved. All I can suggest is to browse the relevant forum as per Thomas's rely above.

Best of luck.