I am getting these about every 30 minutes. They close about 10 minutes after opening. Alert: Data Warehouse failed to deploy database component Source: MC-Monitoring.domain.ORG Path: MC-Monitoring.domain.ORG Last modified by: System Last modified time: 12/23/2011 11:28:17 AM Alert description: Data Warehouse failed to deploy database component. 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: 'SQLAPPS64\APPS', 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: MC-Monitoring.domain.ORG Instance ID: {84C35977-4477-DB09-9B2C-29F4094F091F} -------------------------------------- I googled it and found a post where you can run the query below and it tells you the offending MP, and delete and re-import it. use OperationsManager GO Select MPName from ManagementPack Where MPVersionDependentId = 'dbf18271-9643-32ff-4849-00d79d9e2a9d' And the MP is: Microsoft Windows Server Reports The problem is, I don't have a MP by that name. Is there another way to fix this?

Never mind, I found it. LINK

If you installed the latest version of the base-os mp and you are running sql 2005 backend you can get these messages when trying to import the reports mp file. Will mark your answer.Bob Cornelissen - BICTT (My Blog about SCOM) - Microsoft Community Contributor 2011 Recipient