SCOM 2016 Data Warehouse Timeout

Question

We have a SCOM 2016 instance and are seeing continuous events (31551 Health Service Modules) about failing to store data in the Data Warehouse with an execution timeout Expired description. I have checked with our SQL team and they don't see any SQL issues.
Please advise.
Thanks

Failed to store data in the Data Warehouse. The operation will be retried.
Exception 'SqlTimeoutException': Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Timed out stored procedure: MaintenanceModeChange

One or more workflows were affected by this.

Workflow name: Microsoft.SystemCenter.DataWarehouse.Synchronization.MaintenanceMode
Instance name: Data Warehouse Synchronization Service
Instance ID: {E0EB9961-03CE-F7E5-5636-C6EE14995D62}

Answer 1

Hi

Have you added the recommended registry keys from Kevin Holmans blog tpo each management server?

https://kevinholman.com/2017/03/08/recommended-registry-tweaks-for-scom-2016-management-servers/

See items 5 and 6. After a registry change; it probably needs a server reboot to pick up the changes. Certainly restart the SCOM services on the Management Servers.

I'm not sure if they will fix the specific error of "MaintenanceModeChange" - there is a fix listed here but it means running a SQL statement against the SQL servers which wouldn't be supported unless you raised a Microsoft case so if you did this without direction from Microsoft it would be at your own risk.

https://social.technet.microsoft.com/Forums/ie/en-US/c2c7dc6d-0fbc-43f2-8d40-589d51d50276/failed-to-store-data-in-the-data-warehouse?forum=operationsmanagergeneral

Are you seeing delays with servers going into \ coming out of maintenance mode.

Answer 2

Thanks graham66. Will check it out.