-
Titel
Change Auditor client crashes when saving changes -
Beschreibung
Change Auditor client crashes when saving changes and the following error is produced:
"This channel can no longer be used to send messages as the output session was auto-closed due to server-initiated shutdown. Either disable auto-close by setting the DispatchRuntime.AutomaticInputSessionShutdown to false, or consider modifying the shutdown protocol with the remote server."
-
Ursache
This may occur if ongoing SQL timeouts have caused the coordinator task queue to become full of event batches waiting successful insertion into the database.
Investigate the coordinator log for re-occurring/constant messages like:
"[WARN][ChangeAuditor.Coordinator.EventAggregatorTask.IsCriticalQueueSize(0)] Too many events in Scheduler task queue: 1702 (maximum: 1000), cannot accept more"
and
[INFO][Dell.Data.ClientSql.HandleException(0)] SQL error: TIMEOUT on INSERT INTO dbo.tablename
-
Lösung
1. Add the SQLTimeout and BulkSQLTimeout registry keys on all coordinators:
SQL command timeoutLocation: RegistryPath: HKEY_LOCAL_MACHINE\SOFTWARE\Quest\ChangeAuditorValue Name: SQLTimeoutValue Type: DWORDValue: Default = 30 seconds (Decimal) change to 300 seconds (Decimal)Value: Maximum time in seconds for SQL command to execute. Impacts most client and Coordinator queries.
Bulk event insert timeoutLocation: RegistryPath: HKEY_LOCAL_MACHINE\SOFTWARE\Quest\ChangeAuditorValue Name: BulkSQLTimeoutValue Type: DWORDValue: Default = 30 seconds (Decimal) change to 300 seconds (Decimal)Value: Maximum time in seconds for coordinator bulk event insert SQL command to execute. Impacts Coordinator event insertion queries.2. Restart coordinator services for settings to take effect.