Thomas Ellermanns view on System Center

This blog will discuss features, functions and views on Operations Manager and Service Manager

Browse by Tags

Related Posts
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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: ...
  • Blog Post: 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...