HOTFIX: Data type conversion error after you install UR5 for System Center 2012 R2 Service Manager
Published Feb 16 2019 12:35 AM 194 Views
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

Version history
Last update:
‎Mar 11 2019 10:18 AM
Updated by: