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.
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()
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.
If your FNMP server is a 64 bit OS then the registry key is [HKLM\Software\WOW6432Node\ManageSoft Corp\ManageSoft\Compliance\CurrentVersion]
on Dec 02, 2011 04:04 AM - edited on Jun 25, 2020 12:44 AM by sunshine
Hi Team,
I have 28800 timer set as mentioned still facing the same error. Can we increase more the timing or is there any other way to resolve this error ?
Please guide
@samirdivan - increasing the timeout won't necessarily stop timeout errors from occurring. That could be because whatever process is timing out is still running longer than the timeout you have configured, or because the timeout on the particular process you're running is controlled by a different timeout setting from the setting discussed in this article.
From your description it sounds like it may be appropriate to dig into the particular process that is timing out and consider if anything can be done to make it run faster instead of just increasing the timeout setting. If some insight from other people may help you with this, feel free to post over in the FlexNet Manager forum.
Hi, I did try some modifications in the timeout numbers and increased to 43,200 ( 12 Hours ) & since last week its working fine with successful import and reconciliation. I guess the issue is resolved by this increased change in values for timeout but I am still monitoring on daily basis. Hope this is the solution now