SCOM 2016 DataWareHouse Perfromance Error-No Performance Data in SCOM Dashboard performance

Dev99 00 41 Reputation points
2020-10-26T06:13:01.46+00:00

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

Microsoft System Center
Microsoft System Center
A suite of Microsoft systems management products that offer solutions for managing datacenter resources, private clouds, and client devices.
965 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.