SCOM 2016 DataWareHouse Perfromance Error-No Performance Data in SCOM Dashboard performance
Hello Everyone....
No Performance data shown in SCOM Dashboard. Following error is generated every 30 min or 1 hour on SCOM.
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 -, Line 1, Message: Attempt to fetch logical page (1:1554381) in database 8 failed. It belongs to allocation unit 72058873887457280 not to 72058873890668544.
One or more workflows were affected by this.
Workflow name: Microsoft.SystemCenter.DataWarehouse.CollectPerformanceData
Instance name:
Instance ID: {BC45FA1C-C438-8435-3E8E-1AA0FE20541A}
When i check event viewer on SQL Server the following events are generating with error every min or after few seconds...
Event 605:::::: Attempt to fetch logical page (1:1554381) in database 8 failed. It belongs to allocation unit 72058873887457280 not to 72058873890668544.
Event :::The Database ID 8, Page (1:5435153), slot 0 for LOB data type node does not exist. This is usually caused by transactions that can read uncommitted data on a data page. Run DBCC CHECKTABLE.
Any one have idea whats the real issue....
Thanks