Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




How do I increase SQL timeout?

web-app

Getting the following error when searching all issues.

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

SOURCE: .Net SqlClient Data Provider TARGETSITE: Void OnError(System.Data.SqlClient.SqlException, Boolean) STACKTRACE: 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.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Bool

 

How can I increase this timeout?

Running 2.1.1

SystemIdleProcess
· 1
SystemIdleProcess
Replies (2)
helpful
0
not helpful

Add the below to the NHibernate section of the web.config file:

<add key="hibernate.command_timeout" value="0"/>


Saar Cohen
· 5000
Saar Cohen
helpful
0
not helpful

Thanks!

That fixed it.


SystemIdleProcess
· 1
SystemIdleProcess