Data type conversion error after you install Update Rollup 5 for System Center 2012 R2 Service Manager

Applies to: System Center 2012 R2 Service ManagerSystem Center 2012 Service ManagerMicrosoft System Center 2012 Service Manager Service Pack 1

Symptoms


After you apply Update Rollup 5 for Microsoft System Center 2012 R2 Service Manager, you may experience the following issues:
  • The following event is logged on the Service Manager Data Warehouse server:

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

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

Resolution


Hotfix information

This hotfix is available for download from the Microsoft Download Center.

Microsoft Download Center

The following hotfix is available for download from the Microsoft Download Center:


For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:
119591 How to obtain Microsoft support files from online services
Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.

Before the installation

Note You cannot uninstall this hotfix after it's installed.

Before you apply this hotfix, follow these steps:
  1. Exit all Service Manager-related applications. For example, exit the Service Manager Console, the Self-Service Portal links, and the authoring tool.
  2. Make sure that the Data Warehouse server has successfully synchronized with the management server at least one time.
  3. Make sure that the Data Warehouse server on which you install the hotfix on has Update Rollup 5 installed.

To install this hotfix, follow these steps:
  1. Download the hotfix to a target folder.
  2. Open the target folder, and then right-click SCSM2012R2_OD_KB3045893_AMD64_7.5.3079.344.exe.
  3. Click Run as administrator.
  4. Accept the Microsoft Software License Terms, and then follow the steps in the installation wizard.

Prerequisites

Before you apply this hotfix, you must have Update Rollup 5 for System Center 2012 R2 Service Manager installed.

Hotfix replacement information

This hotfix does not replace any previously released hotfix.

File information

The English (United States) version of this hotfix installs files that have the attributes that are listed in the following tables. The dates and the times for these files are listed in Coordinated Universal Time (UTC). The dates and the times for these files on your local computer are displayed in your local time together with your current daylight saving time (DST) bias. Additionally, the dates and the times may change when you perform certain operations on the files.

File nameFile versionFile sizePlatform
Microsoft.EnterpriseManagement.Orchestration.dll7.5.3079.344136 KBx64

Status


Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.