Power Platform Community Forum Thread Details

As part of unit "Boosting Agent Experiences with Actions", I am trying to import "Northwind Traders" downloaded from location https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/northwind-install#download-the-solution.

While importing solution, I am getting below error:

Solution "Northwind Traders" failed to import: Failed to create entity with logical name nwind_inventorytransactions and object type code 10596. Exception: System.Data.SqlClient.SqlException (0x80131904): Resource ID : 1. The request limit for the elastic pool is 840 and has been reached. See 'https://docs.microsoft.com/azure/azure-sql/database/resource-limits-logical-server' for assistance. 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.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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.Crm.Core.DataServices.Connection.QueryBlocking.CrmCommand.ExecuteNonQuery() at Microsoft.Crm.Core.DataServices.Connection.CrmSqlDataAccessHelper.LockConnectionAndExecuteMethod[TResult](IDbConnection connection, Func`1 executeMethod) at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetryAbstract[TResult](Func`1 executeMethod, IDbCommand command, IConnectionRetryPolicy retryPolicy) at Microsoft.Crm.CrmDbConnection.<>c__DisplayClass236_0.<InternalExecuteNonQuery>b__0() at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute[TResult](ILogger logger, EventId eventId, ActivityType activityType, Func`1 func, IEnumerable`1 additionalCustomProperties) at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute[TResult](ILogger logger, XrmTelemetryActivityType activityType, Func`1 func) at Microsoft.Crm.Platform.MetadataBusinessEntities.DBCommandExecutor.ExecuteNonQuery(IDbCommand command, ISqlExecutionContext context) at Microsoft.Crm.Platform.SolutionAwareComponents.MPOCreateComponentInstanceAction.CreateIdsTableEntry(MetadataBusinessEntityMoniker moniker, ISqlExecutionContext sqlContext) at Microsoft.Crm.Platform.SolutionAwareComponents.MPOCreateComponentInstanceAction.Execute(ExecutionContext context) at Microsoft.Crm.Platform.SolutionAwareComponents.ComponentStateTransition.<>c__DisplayClass4_0.<Execute>b__1() at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute(ILogger logger, EventId eventId, ActivityType activityType, Action action, IEnumerable`1 additionalCustomProperties) at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute(ILogger logger, XrmTelemetryActivityType activityType, Action action) at Microsoft.Crm.Platform.SolutionAwareComponents.ComponentStateTransition.Execute(Int32 componentType, Guid objectId, Object operationParameter, BusinessComponentState currentState, ExecutionContext context) at Microsoft.Crm.Platform.MetadataBusinessEntities.MetadataProcessObject.DoCreate(MetadataBusinessEntity metadataEntity, ExecutionContext context) at Microsoft.Crm.Platform.MetadataBusinessEntities.MetadataProcessObject.Create(MetadataBusinessEntity metadataEntity, ExecutionContext context) at Microsoft.Crm.Platform.MetadataBusinessEntities.MetadataProcessObject.<>c__DisplayClass18_0.<Create>b__0() at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute(ILogger logger, EventId eventId, ActivityType activityType, Action action, IEnumerable`1 additionalCustomProperties) at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute(ILogger logger, XrmTelemetryActivityType activityType, Action action) at Microsoft.Crm.Platform.MetadataBusinessEntities.MetadataProcessObject.Create(IMetadataDescriptionPropertyBag metadataDescription, ExecutionContext context) at Microsoft.Crm.Metadata.AttributeCreateAction.CreateAttributeMetadataHelper() at Microsoft.Crm.Metadata.AttributeCreateAction.MetabaseOperation() at Microsoft.Crm.Metadata.EntityCreateAction.CreateDefaultAttributesMetadataOneByOne() at Microsoft.Crm.Metadata.SimpleMetadataQueueProcessor.<>c__DisplayClass3_0.<ProcessQueue>b__0() at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute(ILogger logger, EventId eventId, ActivityType activityType, Action action, IEnumerable`1 additionalCustomProperties) at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute(ILogger logger, XrmTelemetryActivityType activityType, Action action) at Microsoft.Crm.Metadata.SimpleMetadataQueueProcessor.<>c__DisplayClass2_0.<ProcessQueueInternal>b__0() at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute(ILogger logger, EventId eventId, ActivityType activityType, Action action, IEnumerable`1 additionalCustomProperties) at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute(ILogger logger, XrmTelemetryActivityType activityType, Action action) at Microsoft.Crm.Metadata.MetadataHelper.ProcessQueue(IMetadataQueueProcessor metadataQueueProcessor) at Microsoft.Crm.Metadata.MetadataHelper.ProcessQueue() at Microsoft.Crm.SqlTelemetryHelper.LogSqlTimes(Action action, String operationName, IOrganizationRequestContext context) at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute(ILogger logger, EventId eventId, ActivityType activityType, Action action, IEnumerable`1 additionalCustomProperties) at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute(ILogger logger, XrmTelemetryActivityType activityType, Action action) at Microsoft.Crm.Metadata.EntityService.CreateInternal(EntityCreateInfo entityInfo, MetadataHelper metadataHelper, Boolean isInSolutionImportMode, ExecutionContext context) at Microsoft.Crm.Metadata.EntityService.<>c__DisplayClass59_1.<CreateInternalHelper>b__3() at Microsoft.Crm.SqlTelemetryHelper.LogSqlTimes(Action action, String operationName, IOrganizationRequestContext context) at Microsoft.Crm.Metadata.EntityService.CreateInternalHelper(EntityCreateInfo entityInfo, MetadataHelper metadataHelper, Boolean shouldCreateOnlyFromReserve, ExecutionContext context) ClientConnectionId:fdc3aa14-59d8-413c-a582-941deba43385 Error Number:10936,State:1,Class:20 ClientConnectionId before routing:be1c82c8-83aa-4e04-9728-6b7f4899bbae Routing Destination:fb8ebb52ba89.tr39513.eastus1-a.worker.database.windows.net,11033

Categories:

Conversational Agents