[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
|