System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: UmtPortal.Controller.UserController:Search ---> System.Exception: UmtPortal.Library.UserCategory:SearchUserDesignation ---> System.Data.SqlClient.SqlException: A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.) ---> System.ComponentModel.Win32Exception: The semaphore timeout period has expired --- End of inner exception stack trace --- at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync() at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer() at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteDataset(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at UMT.Library.UserManagment.SearchUser(String strPager, String strType, String strFilter, Nullable`1 blnIsActive, Boolean blnIsDeleted, Nullable`1 intSiteIdRef, Boolean blnDistinct, Nullable`1 introleId) --- End of inner exception stack trace --- at UMT.Library.UserManagment.SearchUser(String strPager, String strType, String strFilter, Nullable`1 blnIsActive, Boolean blnIsDeleted, Nullable`1 intSiteIdRef, Boolean blnDistinct, Nullable`1 introleId) at UMT.Controller.UserManagmentController.SearchUsers(Int32& intTotalRecords, String strPager, List`1 lstType, String strFilter, Nullable`1 blnActiveFlag, Boolean blnDeletedFlag, Nullable`1 intSiteIdRef, Boolean blnDistinct, Nullable`1 roleid) --- End of inner exception stack trace --- at UMT.Controller.UserManagmentController.SearchUsers(Int32& intTotalRecords, String strPager, List`1 lstType, String strFilter, Nullable`1 blnActiveFlag, Boolean blnDeletedFlag, Nullable`1 intSiteIdRef, Boolean blnDistinct, Nullable`1 roleid) at UMT.api.umtService.GetUsers(String strTokenKey, Int32& intTotalRecords, String strPagger, List`1 lstType, String strFilter, Nullable`1 intSiteIdRef) --- End of inner exception stack trace ---