Overview

When performing a maintenance job the following error is displayed:

Unexpected maintenance error! Aborting maintenance...

This article provides a resolution for the issue described above.

 

Environment

• EventsManager 2011
• EventsManager 2010
• EventsManager 8
• All supported environments

 

Root Cause

TCP Offload allows the Network Card itself to handle a large part of the TCP/IP processing instead of relying on the Operating System. This can cause issues when large amounts of data have to be requested from the SQL Server.

 

Resolution

Check the Microsoft SQL Server that holds the GFI EventsManager database for the following:

1. The driver is enabled for TCP Offload. Do the following:
   
   1. Navigate to the Device Manager.
   2. Under Network Adapters, in the Advanced tab, check if the TCP Offload entry is set to Enabled.
      
      
2. The operating system is enabled for TCP Offload. Do the following:
   1. From the command prompt on the SQL Server run the command:
      netsh int tcp show global
   2. Check if the result is:
      Chimney Offload State: enabled
      Note: if the result is automatic (Win7 & 2008 only), it depends on the connection:
      • Offloads if the connection is 10 GbE.
      • Has an RTT (Round Trip Time) < 20ms.
      • The connection has exchanged at least 130KB of data.
        
        
3. Check if the TCP Offload is working by using the following command:
   netstat -nt > c:\netstat.txt and look for connections with an Offloaded state.
   
   
4. If the Microsoft SQL Server is using TCP Offload, disable offloading with the following command and see if it solves the problem:
   netsh int tcp set global chimney=disabled

You may also see the message below:

The DBImportExport log will show the following logging:
2011-09-07, 10:45:17, 657, 0, 10e0, 74c, error, DbImportExport.dll, fetch_get, Unexpected exception: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
.......
2011-09-07, 10:45:51, 345, 0, 10e0, 74c, error, DbImportExport.dll, RunJob, Unexpected exception: ExecuteReader requires an open and available Connection. The connection's current state is closed