New KMS MP released version 6.0.7234.0 and some things you should know
A new KMS (Key Management Services) MP is released. I don't expect this is a widely used MP out there…. but there are some things you should know if you ever imported the previous versions.
First – the new MP is available on the catalog: http://technet.microsoft.com/en-us/opsmgr/cc539535.aspx
DO NOT download this MP directly via the R2 direct download mechanism. You need to get this one from the web catalog. As in all MP’s – you need to read the guide FIRST… because the “Before you import” section is critical.
- The new MP is not backward compatible with the previous MP. You MUST delete any previous version of the KMS MP you have installed.
- If you used the previous version of the KMS MP – you might have noticed some issues. For instance, the old KMS MP added a unique dataset type to the warehouse, with a grooming procedure just for the KMS dataset. These didn't work. When you download the new MP, it comes with instructions and a cleanup script to fix this. If you ever imported the old MP – you are affected. You will see the following events on your RMS every 10-11 minutes:
Log Name: Operations Manager
Source: Health Service Modules
Date: 9/23/2009 4:20:53 PM
Event ID: 31552
Task Category: Data Warehouse
Level: Error
Keywords: Classic
User: N/A
Computer: OMRMS.opsmgr.net
Description:
Failed to store data in the Data Warehouse.
Exception 'SqlException': Sql execution failed. Error 777971002, Level 16, State 1, Procedure StandardDatasetGroom, Line 303, Message: Sql execution failed. Error 2812, Level 16, State 62, Procedure StandardDatasetGroom, Line 145, Message: Could not find stored procedure 'KMS_EventGroom'.
One or more workflows were affected by this.
Workflow name: Microsoft.SystemCenter.DataWarehouse.StandardDataSetMaintenance
Instance name: KMS Activation Event Data Set
Instance ID: {35CE8740-3FCF-FA7F-D733-1ECD0FBE0D7F}
Management group: PROD1
So – here are the necessary steps to get this new MP working (from reading the MP guide):
- Delete the old MP (typically going to be version 6.0.6278.9)
- Run the cleanup SQL script against the OperationsManagerDW (Warehouse) database.
- Import the new MP.
If you had previously imported the old KMS MP – and are getting this event on your RMS, and you no longer wish to use the KMS MP anymore….. you can clean this up using the script that is included with the new MP. So for a cleanup ONLY – where you do not wish to use the KMS MP:
- Make sure the old KMS MP is deleted.
- Run the cleanup SQL script against the OperationsManagerDW (Warehouse) database.
The script output simply displays this when complete:
A cleaned up environment will no longer have any KMS datasets, or stored procedures for grooming this dataset. You can inspect for these with the following queries against the warehouse:
select * from standarddataset WHERE SchemaName = 'KMSEvent'
select * from sysobjects where name like ('%kms%')
Once the cleanup script has been run – these should return no results.
***Note – the new MP does not contain any reports. The old MP had reports the leveraged the KMS Dataset, but the new MP does not.
