How to rebuild your Analysis database

At a Customer, there was an issue where the SSAS cubes suddenly stopped working and in the event log, on the DW Management server,  there were many ID 33522 events: Unhandled exception in data warehouse maintenance: Work item: 155150404 Maintenance action: ManageCubePartitions Exception details:  Exception message: File system error: The following file is corrupted: Physical…


Incident reports failing with - Query execution failed for dataset 'RelatedCIs'.

I ran into a funny problem the other day when working with the SCSM Incident reports. The reports all ran fine, but when we wanted to drill furter down we got the following error: Query execution failed for dataset ‘RelatedCIs’. (rsErrorExecutingCommand) I tried to run the report directly on the SSRS server and got little…


SQL 2008 R2 support for Operations Manager 2007 R2

Many customers have been asking for the support of SQL 2008 R2 and Operations Manager 2007 R2. Today we relased a KB on how to do a clean install or an upgrade to SQL 2008R2 while running Operations Manager 2007 R2. KB Link is : – http://support.microsoft.com/kb/2425714 Be advised the KB ONLY covers Operations Manager…