Server Error in '/' Application.

Resource ID : 1. The request limit for the elastic pool is 400 and has been reached. See 'https://docs.microsoft.com/azure/azure-sql/database/resource-limits-logical-server' for assistance.

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: Resource ID : 1. The request limit for the elastic pool is 400 and has been reached. See 'https://docs.microsoft.com/azure/azure-sql/database/resource-limits-logical-server' for assistance.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[SqlException (0x80131904): Resource ID : 1. The request limit for the elastic pool is 400 and has been reached. See 'https://docs.microsoft.com/azure/azure-sql/database/resource-limits-logical-server' for assistance.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +277
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +765
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4616
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +88
   System.Data.SqlClient.SqlDataReader.get_MetaData() +103
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) +621
   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) +3387
   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) +707
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +83
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +302
   Sitecore.Data.DataProviders.Sql.DataProviderCommand.ExecuteReader() +99

[DataException: Error executing SQL command: 
DECLARE @children TABLE (ID UNIQUEIDENTIFIER PRIMARY KEY (ID))
INSERT INTO @children (ID)
SELECT [ID]
FROM [Items] WITH (NOLOCK)
WHERE [ParentID] = @itemId

DECLARE @result TABLE
(
		[ItemId] [uniqueidentifier] NOT NULL,
		[Order] [int] Not Null,
		[Version] [int] Not Null,
		[Language] [nvarchar](50) NOT NULL,
		[Name] [nvarchar](256) NULL,
		[Value] [nvarchar](max) NOT NULL,
		[FieldId] [uniqueidentifier] NULL,
		[MasterID] [uniqueidentifier] NULL,
		[ParentID] [uniqueidentifier] NULL,
		[Created] [datetime] NULL

	INDEX IX CLUSTERED(
		[ItemId],
		[Order] ASC,
		[Language] DESC,
		[Version] DESC
		)
)

INSERT INTO @result
SELECT
  [Id] AS [ItemId],
  0 AS [Order],
  0 AS [Version],
  '' AS [Language],
  [Name] AS [Name],
  '' AS [Value],
  [TemplateID] AS [FieldId],
  [MasterID],
  [ParentID],
  [Created]
FROM
  [Items]
WHERE
  [Id] IN (SELECT [ID] FROM @children)
UNION ALL
SELECT
  [ParentId] AS [ItemId],
  1 AS [Order],
  0 AS [Version],
  '' AS [Language],
  NULL AS [Name],
  '' AS [Value],
  NULL,
  NULL,
  [Id],
  NULL AS [Created]
FROM [Items]
WHERE
  [ParentId] IN (SELECT [ID] FROM @children)
UNION ALL
SELECT
  [ItemId],
  2 AS [Order],
  0 AS [Version],
  '' AS [Language],
  NULL AS [Name],
  [Value],
  [FieldId],
  NULL,
  NULL,
  NULL AS [Created]
FROM [SharedFields]
WHERE
  [ItemId] IN (SELECT [ID] FROM @children)
UNION ALL
SELECT
  [ItemId],
  2 AS [Order],
  0 AS [Version],
  [Language],
  NULL AS [Name],
  [Value],
  [FieldId],
  NULL,
  NULL,
  NULL AS [Created]
FROM [UnversionedFields]
WHERE [ItemId] IN (SELECT [ID] FROM @children)
UNION ALL
SELECT
  [ItemId],
  2 AS [Order],
  [Version],
  [Language],
  NULL AS [Name],
  [Value],
  [FieldId],
  NULL,
  NULL,
  NULL AS [Created]
FROM [VersionedFields]
WHERE
  [ItemId] IN (SELECT [ID] FROM @children)

SELECT * 
FROM @result
ORDER BY
  [ItemId],
  [Order] ASC,
  [Language] DESC,
  [Version] DESC
]

[Exception: Resource ID : 1. The request limit for the elastic pool is 400 and has been reached. See 'https://docs.microsoft.com/azure/azure-sql/database/resource-limits-logical-server' for assistance.]
   Sitecore.Data.DataProviders.Sql.DataProviderCommand.ExecuteReader() +285
   Sitecore.Data.DataProviders.Sql.DataProviderReader..ctor(DataProviderCommand command) +58
   Sitecore.Data.DataProviders.Sql.<>c__DisplayClass29_0.<CreateReader>b__0() +72
   Sitecore.Data.DataProviders.NullRetryer.Execute(Func`1 action, Action recover) +293
   Sitecore.Data.DataProviders.Sql.SqlDataApi.CreateReader(String sql, Object[] parameters) +281
   Sitecore.Data.SqlServer.SqlServerDataProvider.ExecuteLoadItemDefinitionsSql(String sql, Object[] parameters, SafeDictionary`2 prefetchData) +166
   Sitecore.Data.DataProviders.Sql.SqlDataProvider.PrefetchAllChildren(ID itemId) +237
   Sitecore.Data.DataProviders.Sql.SqlDataProvider.EnsureChildrenPrefetched(ID parentId, IDList childIds) +321
   Sitecore.Data.DataProviders.Sql.SqlDataProvider.GetChildIDs(ItemDefinition itemDefinition, CallContext context) +161
   Sitecore.Data.DataProviders.DataProvider.GetChildIDs(ItemDefinition item, CallContext context, DataProviderCollection providers) +120
   Sitecore.Data.DataSource.GetChildIDs(ID itemID) +73
   Sitecore.Nexus.Data.DataCommands.GetChildrenCommand.‮‮‍‍​‏‫‭​‮‍‍‏‬​‫‎‮‬‬‌‌‬‭‎‮(Item ) +52
   Sitecore.Nexus.Data.DataCommands.GetChildrenCommand.‪‪‬​‍‫‎‍‫‏‫‫‫‫‮​‫‎‬‭‍‌‮‮(Item ) +267
   Sitecore.Data.Engines.EngineCommand`2.Execute() +93
   Sitecore.Data.Managers.ItemProvider.GetChildren(Item item, ChildListOptions options) +73
   Sitecore.Data.Managers.ItemProvider.GetChildren(Item item, SecurityCheck securityCheck, ChildListOptions options) +60
   Sitecore.Data.Managers.ItemProvider.HasChildren(Item item, SecurityCheck securityCheck) +175
   Sitecore.Data.DataManager.Sitecore.Data.Query.IQueryable.GetChildIDs(ID itemID) +68
   Sitecore.Data.Query.QueryContext.get_Children() +146
   Sitecore.Data.Query.Children.Evaluate(Query query, QueryContext node) +102
   Sitecore.Data.Query.Opcode.Process(Query query, QueryContext contextNode, Predicate predicate, Opcode nextStep, Object& result) +170
   Sitecore.Data.Query.Children.Evaluate(Query query, QueryContext node) +179
   Sitecore.Data.Query.Opcode.Process(Query query, QueryContext contextNode, Predicate predicate, Opcode nextStep, Object& result) +170
   Sitecore.Data.Query.Children.Evaluate(Query query, QueryContext node) +179
   Sitecore.Data.Query.Opcode.Process(Query query, QueryContext contextNode, Predicate predicate, Opcode nextStep, Object& result) +170
   Sitecore.Data.Query.Children.Evaluate(Query query, QueryContext node) +179
   Sitecore.Data.Query.Opcode.Process(Query query, QueryContext contextNode, Predicate predicate, Opcode nextStep, Object& result) +170
   Sitecore.Data.Query.Children.Evaluate(Query query, QueryContext node) +179
   Sitecore.Data.Query.Opcode.Process(Query query, QueryContext contextNode, Predicate predicate, Opcode nextStep, Object& result) +170
   Sitecore.Data.Query.Children.Evaluate(Query query, QueryContext node) +179
   Sitecore.Data.Query.Opcode.Process(Query query, QueryContext contextNode, Predicate predicate, Opcode nextStep, Object& result) +170
   Sitecore.Data.Query.Self.Evaluate(Query query, QueryContext node) +53
   Sitecore.Data.Query.Query.SelectSingleItem(String query, QueryContext contextNode, Database database) +103
   Constellation.Feature.Redirects.Repository.GetNewUrl(SiteInfo site, String requestUrl) +242
   Foundation.Products.Pipelines.ProductPageResolver.Execute(HttpRequestArgs args) in F:\BuildAgent\agent\_work\1\s\Foundation.Products\Pipelines\ProductPageResolver.cs:65
   (Object , Object ) +15
   Sitecore.Pipelines.CorePipeline.Run(PipelineArgs args) +490
   Sitecore.Pipelines.DefaultCorePipelineManager.Run(String pipelineName, PipelineArgs args, String pipelineDomain, Boolean failIfNotExists) +236
   Sitecore.Pipelines.DefaultCorePipelineManager.Run(String pipelineName, PipelineArgs args, String pipelineDomain) +23
   Sitecore.Web.RequestEventsHandler.OnPostAuthenticateRequest(HttpContextBase context) +218
   Sitecore.Nexus.Web.HttpModule.‪‏‪‌‪‍‌‮‬​‬‍‎​‏‍‪‭‎‌‍‪‪‮‮(Object , EventArgs ) +207
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +223
   System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) +220
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +94


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.8.4690.0