Blog Post

System Center Blog
2 MIN READ

HOTFIX: Data type conversion error after you install UR5 for System Center 2012 R2 Service Manager

System-Center-Team's avatar
Feb 16, 2019
First published on TECHNET on Mar 17, 2015

After you install Update Rollup 5 for Microsoft System Center 2012 R2 Service Manager, you may experience the following issues:

1. The following event is logged on your Service Manager Data Warehouse server:

The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value

2. The Extract job no longer runs if your Data Warehouse server does not use the "Month-Date-Year" time format.

For more details as well as a download link to a hotfix that resolves this issue, please see the following:

KB3045893 - Data type conversion error after you install UR5 for System Center 2012 R2 Service Manager ( http://support.microsoft.com/en-us/kb/3045893 )

J.C. Hornbeck | Solution Asset PM | Microsoft GBS Management and Security Division

Get the latest System Center news on Facebook and Twitter :

Main System Center blog: http://blogs.technet.com/b/systemcenter/

Configuration Manager Support Team blog: http://blogs.technet.com/configurationmgr/
Data Protection Manager Team blog: http://blogs.technet.com/dpm/
Orchestrator Team blog: http://blogs.technet.com/b/orchestrator/
Operations Manager Team blog: http://blogs.technet.com/momteam/
Service Manager Team blog: http://blogs.technet.com/b/servicemanager
Virtual Machine Manager Team blog: http://blogs.technet.com/scvmm

Microsoft Intune: http://blogs.technet.com/b/microsoftintune/
WSUS Support Team blog: http://blogs.technet.com/sus/
RMS blog: http://blogs.technet.com/b/rms/
App-V Team blog: http://blogs.technet.com/appv/
MED-V Team blog: http://blogs.technet.com/medv/
Server App-V Team blog: http://blogs.technet.com/b/serverappv

Forefront Endpoint Protection blog: http://blogs.technet.com/b/clientsecurity/
Forefront Identity Manager blog: http://blogs.msdn.com/b/ms-identity-support/
Forefront TMG blog: http://blogs.technet.com/b/isablog/
Forefront UAG blog: http://blogs.technet.com/b/edgeaccessblog/
Application Proxy blog: http://blogs.technet.com/b/applicationproxyblog/
The Surface Team blog: http://blogs.technet.com/b/surface/

ConfigMgr 2012 R2

Updated Mar 11, 2019
Version 4.0
No CommentsBe the first to comment