System.Data.SqlClient.SqlException (0x80131904): Lock request time out period exceeded. Invalid object name '#ALL'. 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.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 OpenAccessRuntime.CommandWrapper.ExecuteReader(CommandBehavior behavior) at Telerik.OpenAccess.Runtime.Logging.LoggingDbCommand.ExecuteDbDataReader(CommandBehavior behavior) at Telerik.OpenAccess.Data.Common.OACommand.ExecuteReader(CommandBehavior behavior) at Telerik.OpenAccess.OpenAccessContextBase.ExecuteQuery[T](String commandText, CommandType commandType, DbParameter[] parameters) at IBSSFImplementations.Model.API.DbContext.GetFeaturedListings(Int32 top, Guid siteId) in C:\Sources\ibidsmart\IBS.V.2\IBSSFImplementations\Model\API\DbContext.cs:line 1672 at IBSSFImplementations.Inventory.InventoryManager.<>c__DisplayClass33_0.<GetFeaturedListings>b__0() in C:\Sources\ibidsmart\IBS.V.2\IBSSFImplementations\Inventory\InventoryManager.cs:line 578 at IBSSFImplementations.Helpers.ApplicationCacheHelper.GetOrAddObject(String CacheKey, Int32 ExpirationInSeconds, Func`1 createFunc) in C:\Sources\ibidsmart\IBS.V.2\IBSSFImplementations\Helpers\ApplicationCacheHelper.cs:line 21 at IBSSFImplementations.Inventory.InventoryManager.GetFeaturedListings(Int32 top, Guid siteId) in C:\Sources\ibidsmart\IBS.V.2\IBSSFImplementations\Inventory\InventoryManager.cs:line 577 at IBSCustom.MVCWidgets.InventoryWidgets.Helpers.FeaturedListingsHelper.GetFeaturedListingsModel(Int32 top) in C:\Sources\ibidsmart\IBS.V.2\IBSCustom\MVCWidgets\InventoryWidgets\Helpers\FeaturedListingsHelper.cs:line 21 at IBSCustom.MVCWidgets.InventoryWidgets.Controllers.FeaturedListingsController.Index() in C:\Sources\ibidsmart\IBS.V.2\IBSCustom\MVCWidgets\InventoryWidgets\Controllers\FeaturedListingsController.cs:line 29 at lambda_method(Closure , ControllerBase , Object[] ) at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass15.<InvokeActionMethodWithFilters>b__12() at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName) ClientConnectionId:2761f5c4-d2ed-419d-a858-edfe98947e58 Error Number:1222,State:56,Class:16