Jean-Sébastien DUCHENE Blog's

Actualité, Tips, Articles sur l'ensemble des Technologies Microsoft (Microsoft Intune, ConfigMgr, Microsoft Defender, Microsoft Purview, Microsoft Azure, Windows...)

Microsoft vient de publier un nouvel article dans la base de connaissances concernant les améliorations pour le dépannage des exceptions de time-out SQL du Data Warehouse de System Center 2012 R2 Operations Manager. Ces améliorations sont apportées par l’Update Rollup 5 qui n’est pas encore publié à l’heure où j’écris ses lignes ! Cela signifie que son arrivée est prochaine.

Les erreurs suivantes sont levées dans le journal d’évènements par la source Health Service Module :

Log Name – Operations Manager
Source – Health Service Modules
EventID – 31551/31552
Level – Error
User – N/A
Task Category – Data Warehouse
Keywords – Classic
Details –

Avant l’UR5, le detail comprenait :

Failed to store data in the Data Warehouse. The operation will be retried.
Exception "SqlException": Time-out expired. The time-out period elapsed before completion of the operation, or the server is not responding.
One or more of the following workflows were affected by this:
Workflow name: Workflow_name
Instance name: Instance_name
Instance ID: Instance_ID
Management group: Management_group_name

Après l’UR 5, on retrouve :

Failed to store data in the Data Warehouse. The operation will be retried.
Exception 'SqlTimeoutException': Timeout expired. The timeout period elapsed prior to completion of the operation, or the server is not responding.

Les deux messages suivants sont possibles:
Message 1
Timeout occurred while trying to bulk copy data to Table_name table.


Message 2
Timed-out stored procedure: Stored_procedure_name

Current time-out value: Current_time-out_value_in_seconds

This time-out can be increased by adding a registry key (type: dword 32 bit, value: revised time-out in seconds) named: 


Registry_name
at HKLM\SOFTWARE\Microsoft\Microsoft Operations Manager\3.0\Data Warehouse

One or more of the following workflows were affected by this:

Workflow name: Workflow_name
Instance name: Instance_name
Instance ID: Instance_ID
Management group: Management_group_name

On en apprend donc beaucoup plus avec la procedure stockée ou la table concernée !

Pour plus d’informations, lire la KB3029227 : How to troubleshoot SQL time-outs in Data Warehouse after you install System Center Operations Manager R2 Update Rollup 5

Facebook Like