Summary

A failure error occurs during the inventory import/reconcile with an error similar to the following:

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Symptoms

FATAL: Import failed. Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
 at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
 at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
 at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
 at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
 at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
 at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
 at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
 at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
 at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
 at ManageSoft.Database.DatabaseCommand.ExecuteNonQuery()
 at ManageSoft.Database.Impl.DatabaseLayerBaseSql.Execute(CommandType p_CommandType, String p_CommandText, DatabaseParameter[] p_Parameters)
 at ManageSoft.Database.Impl.DatabaseLayerBase.Execute(String p_StoredProcedure, DatabaseParameter[] p_Parameters)
 at ManageSoft.Compliance.Database.Impl.Procedures.LicenseAssignmentResetToEasyLicenses()
 at ManageSoft.Compliance.Importer.Procedures.ManageSoft.LicenseReconcile.RunSQLLicenseReconcile()
 at ManageSoft.Compliance.Importer.Procedures.ManageSoft.LicenseReconcile.ReconcileLicenses()

Cause

By default, the compliance importer is set to run for approximately 10 minutes per procedure and the full import will run for a total of 2 hours. If there are large amounts of data to process in a particular procedure (for example, file evidence or usage data), then it can timeout and close the connection.

Resolution

• Open the registry on the FNMP server
• On 32bit systems - Navigate to [HKLM\Software\ManageSoft Corp\ManageSoft\Compliance\CurrentVersion]
• On 64bit systems - Navigate to [HKLM\Software\Wow6432Node\ManageSoft Corp\ManageSoft\Compliance\CurrentVersion]
• Create the below registry key
  • Type: REG_DWORD
  • Name: CommandTimeout
  • Value: Decimal value for seconds (eg: 28800 = 8 hours)

Additional Information

If your FNMP server is a 64 bit OS then the registry key is [HKLM\Software\WOW6432Node\ManageSoft Corp\ManageSoft\Compliance\CurrentVersion]