Today I had my first expierence with the updated Windows Server OS Management Pack which can be downloaded at the following location: http://www.microsoft.com/download/en/details.aspx?id=9296
Of course I read the manual before importing it into a test Operations Manager Management Group. But I have to admit I oversaw one important comment in the guide.
So I imported all the .MP files and as normal practice I monitored the errors in the console and in the eventlog soon after the import finished. The error that appeared in the eventlog after a couple of minutes was the following:
Log Name: Operations Manager
Source: Health Service
Modules Date: 24-11-2011 10:23:46
Event ID: 31565
Task Category: Data Warehouse
Level: Error
Keywords: Classic
User: N/A
Computer: <RMS FQDN>
Description: Failed to deploy Data Warehouse component. The operation will be retried. Exception 'DeploymentException': Failed to perform Data Warehouse component deployment operation: Install; Component: Script, Id: '3a49a530-26a2-c525-35fe-69df5898f150', Management Pack Version-dependent Id: 'dbf18271-9643-32ff-4849-00d79d9e2a9d'; Target: Database, Server name: '<DB ServerName>', Database name: 'OperationsManagerDW'. Batch ordinal: 1; Exception: Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near ','. Incorrect syntax near ','. Incorrect syntax near ','. Incorrect syntax near ','. Incorrect syntax near the keyword 'ELSE'.
One or more workflows were affected by this.
Workflow name: Microsoft.SystemCenter.DataWarehouse.Deployment.Component Instance name: <RMS FQDN> Instance ID: {E5EEDF23-3C06-B007-D7F1-E6D2BA8659DF} Management group: <SCOM Management Group Name> Event Xml: <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event"> <System> <Provider Name="Health Service Modules" /> <EventID Qualifiers="49152">31565</EventID> <Level>2</Level> <Task>3</Task> <Keywords>0x80000000000000</Keywords> <TimeCreated SystemTime="2011-11-24T09:23:46.000000000Z" /> <EventRecordID>18630414</EventRecordID> <Channel>Operations Manager</Channel> <Computer><SCOM RMS FQDN></Computer> <Security /> </System> <EventData> <Data><Management Group Name></Data> <Data>Microsoft.SystemCenter.DataWarehouse.Deployment.Component</Data> <Data><SCOM RMS FQDN></Data> <Data>{E5EEDF23-3C06-B007-D7F1-E6D2BA8659DF}</Data> <Data>DeploymentException</Data> <Data>Failed to perform Data Warehouse component deployment operation: Install; Component: Script, Id: '3a49a530-26a2-c525-35fe-69df5898f150', Management Pack Version-dependent Id: 'dbf18271-9643-32ff-4849-00d79d9e2a9d'; Target: Database, Server name: 'SCOM DB Server Name', Database name: 'OperationsManagerDW'. Batch ordinal: 1; Exception: Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated with a semicolon. Incorrect syntax near ','. Incorrect syntax near ','. Incorrect syntax near ','. Incorrect syntax near ','. Incorrect syntax near the keyword 'ELSE'.</Data> </EventData> </Event>
After 10 minutes the same error appeared in the Operations Manager EventLog and this keeps repeating every ten minutes. So I decided to pick up the guide again and once again it became clear why this step cannot be forgotten! The new management pack contains a new .MP called Microsoft.Windows.Server.Reports.mp
In the MP guide it is clearly stated that this MP is not compatible with SQL 2005 and only with SQL 2008. This means the new reports are not available if you are running the OpsMgr Databases on SQL 2005. The solution is of course simple, just delete te reports MP or move your databases to a SQL 2008 installation.
After deleting the MP the error events in the Operations Manager log are not reoccuring and the correlated Alert in the OpsMgr Console closed itself.
