We just applied CU4 to our SCOM 2007 R2 environment, and started getting the following alerts New, Closed in 2 minutes, would highly appreciate for any input. >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Alert: Data Warehouse performance data writer process failed to perform maintenance operation Source: PSCOMMS02.core.umdnj.edu Path: PSCOMMS02.core.umdnj.edu Last modified by: System Last modified time: 5/15/2012 11:47:59 AM Alert description: Data Warehouse performance data writer process failed to perform maintenance operation. Data was written to the Data Warehouse staging area but processing failed on one of the subsequent operations. Exception 'SqlException': Sql execution failed. Error 777971002, Level 18, State 1, Procedure PerformanceProcessStaging, Line 283, Message: Sql execution failed. Error 605, Level 21, State 3, Procedure PerformanceProcessStaging, Line 215, Message: Attempt to fetch logical page (1:526) in database 6 failed. It belongs to allocation unit 72058614431875072 not to 72058614432202752. One or more workflows were affected by this. Workflow name: Microsoft.SystemCenter.DataWarehouse.CollectPerformanceData Instance name: PSCOMMS02.core.umdnj.edu Instance ID: {FB228E5A-6E36-7B05-1790-2F12B25CA0C3} Management group: SCOM <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< Thanks in advance, Manjun

When you did the CU update, did you run the two scripts on your SQL servers per the update guide? http://blogs.technet.com/b/kevinholman/archive/2011/02/01/opsmgr-2007-r2-cu4-rollup-hotfix-ships-and-my-experience-installing-it.aspx Backup the Operations and Warehouse databases, and all unsealed MPs.Apply the hotfix to the RMSRun the SQL script(s) update against the OpsDB AND Warehouse DB.Import the updated management packs provided.Apply the hotfix to all secondary Management Servers.Apply the hotfix to my Gateway Servers.Apply the hotfix to my agents by approving them from pendingApply the hotfix my dedicated consoles (Terminal servers, desktop machines, etc)Apply the hotfix to my Web Console serverApply the hotfix to my Audit collection serversUpdate manually installed agents. well, manually. - From Kevin's guide. Regards, Blake Email: mengotto<at>hotmail.com Blog: http://discussitnow.wordpress.com/

Yes, I did follow the steps you listed above, thanks, ManjunManjun

Hi, Regarding the error, please also check it referring to the following post: Standard Dataset Maintenance troubleshooter for System Center Operations Manager 2007 http://blogs.technet.com/b/operationsmgr/archive/2011/09/06/standard-dataset-maintenance-troubleshooter-for-system-center-operations-manager-2007.aspx Hope this helps. Thanks. Nicholas Li TechNet Community Support

This error generally signifies page or allocation corruption in the specified database. For resolution pls. refer the following technet document: http://www.microsoft.com/technet/support/ee/transform.aspx?ProdName=SQL+Server&ProdVer=9.0&EvtID=605&EvtSrc=MSSQLServer Roger

Roger, Thanks for confirming with what did is corrent to resolve this issue,Manjun