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

  • Article

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

https://support.microsoft.com/kb/2992012

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: https://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! :D