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…


Change the Data Warehouse retention period

A customer of mine wanted the Data Warehouse retention changed from the 3 to 5 years, for reporting purposes. To see the current retention settings of the DW databases, you can use the cmdlet that comes with SCSM. Get-SCDWRetentionPeriod NOTE: if not using the correct syntax, it returns the setting of the DWRepository DB and…


Date dimensions for Incidents, Service Requests, Change Requests and Activities.

I’ve had this blog on my todo list for quite a while and finally I found some time to actually write it. My colleague Atchut Barli created an MP last year that extended the Data Warehouse Work Item cube with a date dimension for when incidents were created. This made some reports a lot more useable. http://blogs.technet.com/b/servicemanager/archive/2013/02/20/3539405.aspx Together…


Data Warehouse problems after upgrading to SP1

Recently I discovered that an otherwise working SCSM installation had begun to fail the MP synchronization after upgrading to SP1.   The following error was logged in the event log: Event ID: 33333 Description: Data Access Layer rejected retry on SqlError:Request: Ral_ExecuteSql — (statement=exec(‘IF OBJECT_ID(”[dbo].[WorkItemAffectedUserFact_2013_Jan]”) IS NULL BEGIN   CREATE TABLE [dbo].[WorkItemAffectedUserFact_2…), (RETURN_VALUE=0)  Class: 16…


SCSM 2012 Data Warehouse jobs keep failing

I often run into the same problem with the SCSM 2012 Data Warehouse, that the cubes jobs all fail. When resuming one of the jobs the following errors appear in the log: Message : An Exception was encountered while trying during cube processing.  Message=  Processing warning encountered – Location: , Source: Microsoft SQL Server 2008…