Post
by bkort@web2market.com » Thu Jul 25, 2013 11:04 am
We got the same thing too. The error is below.
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Source Error:
Line 24: if (string.IsNullOrEmpty(keywords)) Response.Redirect(AbleCommerce.Code.NavigationHelper.GetAdminUrl());
Line 25: Caption.Text = String.Format(Caption.Text, keywords);
Line 26: _SearchAreaResults = SearchDataSource.Search(keywords, SearchArea.All, 100);
Line 27: ProductUrl = Page.ResolveUrl("~/Admin/Products/EditProduct.aspx?ProductId={0}");
Line 28: UserUrl = Page.ResolveUrl("~/Admin/People/Users/EditUser.aspx?UserId={0}");
Source File: c:\inetpub\wwwroot\remybattery_gold\Admin\Search.aspx.cs Line: 26
Stack Trace:
[SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.]
System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +404
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +412
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1363
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +59
System.Data.SqlClient.SqlDataReader.get_MetaData() +118
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +6414593
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +6416162
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +538
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +28
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +256
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +19
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() +23
NHibernate.AdoNet.AbstractBatcher.ExecuteReader(IDbCommand cmd) +845
NHibernate.Loader.Loader.GetResultSet(IDbCommand st, Boolean autoDiscoverTypes, Boolean callable, RowSelection selection, ISessionImplementor session) +580
NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +275
NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) +205
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +195
[GenericADOException: could not execute query
[ SELECT DISTINCT TOP 100 U.* FROM ac_Users U WHERE U.StoreId = @p0 AND U.UserId IN (SELECT [Key] FROM CONTAINSTABLE(ac_Users, *, @p1 )) OR U.UserId IN (SELECT A.UserId FROM ac_Addresses AS A INNER JOIN CONTAINSTABLE(ac_Addresses, *, @p1 ) AS FTS ON FTS.[KEY] = A.AddressId WHERE A.IsBilling = 1 ) ]
Name:storeId - Value:1 Name:keywords - Value:"test"
[SQL: SELECT DISTINCT TOP 100 U.* FROM ac_Users U WHERE U.StoreId = @p0 AND U.UserId IN (SELECT [Key] FROM CONTAINSTABLE(ac_Users, *, @p1 )) OR U.UserId IN (SELECT A.UserId FROM ac_Addresses AS A INNER JOIN CONTAINSTABLE(ac_Addresses, *, @p1 ) AS FTS ON FTS.[KEY] = A.AddressId WHERE A.IsBilling = 1 ) ]]
NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) +637
NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) +23
NHibernate.Impl.SessionImpl.ListCustomQuery(ICustomQuery customQuery, QueryParameters queryParameters, IList results) +504
NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters, IList results) +440
NHibernate.Impl.SessionImpl.List(NativeSQLQuerySpecification spec, QueryParameters queryParameters) +435
NHibernate.Impl.SqlQueryImpl.List() +290
CommerceBuilder.Search.Providers.SqlFtsSearchProvider.SearchUsers(String keywords, Int32 maximumRows) +592
CommerceBuilder.Search.SearchDataSource.Search(String keywords, SearchArea searchArea, Int32 maximumRows) +369
AbleCommerce.Admin.Search.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\remybattery_gold\Admin\Search.aspx.cs:26
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +25
System.EventHandler.Invoke(Object sender, EventArgs e) +0
System.Web.UI.Control.LoadRecursive() +71
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3064
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.2012