MEN IN CLOUD
17Mar/15Off

KB3045893 – Hotfix for Data Warehouse bug in Service Manager 2012 R2 UR5

Posted by Rémy BOVI

Suite à de nombreux problèmes de synchronisation du DWH après le passage en UR5 de SCSM 2012 R2, Microsoft vient de sortir un correctif en urgence.

Le lien est ici : http://www.microsoft.com/en-in/download/confirmation.aspx?id=46368

Symptoms
After Update Rollup 5 for Microsoft System Center 2012 R2 Service Manager (SM) is installed, you may experience the following issue:

If your Data Warehouse server does not use Month-Date-Year time format, then an event “The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value” is logged in your Service Manager Data Warehouse, and the Extract job no longer runs.

Resolution (Hotfix Information)
A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing the problem described in this article. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next software update that contains this hotfix.

 

18Oct/13Off

SCSM 2012 : Data Warehouse High Availability

Posted by Rémy BOVI

Voilà un super post qui traite de la haute dispo sur le DWH de SCSM. Merci à Nate Lasnoski (MVP) pour son post.

L'article est ici : http://blogs.technet.com/b/servicemanager/archive/2013/10/17/service-manager-data-warehouse-high-availability.aspx