Update Rollup 4 for System Center 2012 R2 – important update for the Service Manager Data Warehouse

So, Update Rollup 4 for System Center 2012 R2 is out as you might know 😀


I encourage you to install UR4 for Service Manager because next to other fixes, there's a very important fix included here for the Data Warehouse.

This is part of the fixes and improvements we are trying to bring to the Data Warehouse: http://support.microsoft.com/kb/2989601

Data Warehouse Transform jobs have a hardcoded 60-minute time-out. Therefore, Data Warehouse jobs cannot be disabled for very long because the volume of data to be transformed can quickly pile up. This can cause an issue if the volume exceeds the amount that can be processed by the transform modules within the time-out period.

This fix included in UR4 has 2 parts: an improvement of an involved stored procedure which makes it be able to run faster + a new registry setting that can be created to be able to control the default timeout for the command, as well as changing the default from 60 to 180 seconds.

Happy updating! 😀

Comments (2)
  1. Hi Herb,

    This is how you should do it:
    – install the DW component
    – register the DW from the Console
    – wait until MPSyncJob finishes and until all Management Packs appear as Deployment = Completed in the Data Warehouse -> Management Packs view
    – apply UR4 now on the DW

    Hope that helps! 😀

  2. Herb says:

    How should I do the update if I already have the SCSM management server at UR4 and want to add a data warehouse server? I keep getting an error when trying to add UR4 to the data warehouse (not connected to the management server)

Comments are closed.

Skip to main content