Power Platform Community Forum Thread Details

Hello all.

Very much a noob question, I know, but I am just getting started with this Power Apps stuff.

I was following a tutorial and created a custom table in Dataverse. Realized I'd made a mistake (missed some crucial steps because the UI shown in the tutorial is apparently quite out of date), and since I did not so much as add a column or a shred of data to this table I tried to delete the table and start over.

My attempt to delete the table was met with literally half a screen's worth of error messages (shown below) that I cannot begin to decipher.

If anyone could suggest what's gone wrong here and how I might delete this table, I'd be very grateful.

Thanks.

Error message:

{ "Message": "No rows could be found for OptionSet with id [GUID redacted] if OptionSet were published", "ExceptionMessage": "No rows could be found for OptionSet with id [GUID redacted] if OptionSet were published", "ExceptionType": "Microsoft.Crm.BusinessEntities.CrmObjectNotFoundException", "StackTrace": " at Microsoft.Crm.Platform.MetadataBusinessEntities.MetadataProcessObject.RetrieveAsIfPublished(MetadataBusinessEntityMoniker moniker, ColumnCollection columns, Boolean retrieveDeletedItems, ISqlExecutionContext sqlContext)\r\n at Microsoft.Crm.Platform.MetadataBusinessEntities.MetadataProcessUtility.RetrieveOptionSetById(Guid optionsetId, String[] columnsToRetrieve, ISqlExecutionContext context)\r\n at Microsoft.Crm.Solution.OptionSetRootFilter.IsGlobalOptionSet(Guid objectId, ISqlExecutionContext context)\r\n at Microsoft.Crm.ObjectModel.AttributeDependencyCalculator.DetermineSolutionInternalDependencies(ExecutionContext context)\r\n at Microsoft.Crm.ObjectModel.MetadataDependencyCalculatorBase.<>c__DisplayClass3_1.<DetermineAllDependencies>b__0()\r\n at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute(ILogger logger, EventId eventId, ActivityType activityType, Action action, IEnumerable`1 additionalCustomProperties)\r\n at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute(ILogger logger, XrmTelemetryActivityType activityType, Action action)\r\n at Microsoft.Crm.ObjectModel.MetadataDependencyCalculatorBase.DetermineAllDependencies(ICollection`1 records, ExecutionContext context)\r\n at Microsoft.Crm.ObjectModel.DependencyHelperBase.<>c__DisplayClass20_0.<UpdateDependencies>b__1()\r\n at Microsoft.Crm.SqlTelemetryHelper.LogSqlTimes(Action action, String operationName, IOrganizationRequestContext context)\r\n at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute(ILogger logger, EventId eventId, ActivityType activityType, Action action, IEnumerable`1 additionalCustomProperties)\r\n at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute(ILogger logger, XrmTelemetryActivityType activityType, Action action)\r\n at Microsoft.Crm.ObjectModel.DependencyHelperBase.UpdateDependencies(ExecutionContext context, List`1& missingDependencies)\r\n at Microsoft.Crm.Dependency.ComponentCollector.<>c__DisplayClass28_1.<UpdateComponentDependencies>b__1()\r\n at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute(ILogger logger, EventId eventId, ActivityType activityType, Action action, IEnumerable`1 additionalCustomProperties)\r\n at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute(ILogger logger, XrmTelemetryActivityType activityType, Action action)\r\n at Microsoft.Crm.Dependency.ComponentCollector.<>c__DisplayClass28_0.<UpdateComponentDependencies>b__0()\r\n at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute(ILogger logger, EventId eventId, ActivityType activityType, Action action, IEnumerable`1 additionalCustomProperties)\r\n at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute(ILogger logger, XrmTelemetryActivityType activityType, Action action)\r\n at Microsoft.Crm.Dependency.ComponentCollector.<>c__DisplayClass22_0.<ProcessRecords>b__0()\r\n at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute(ILogger logger, EventId eventId, ActivityType activityType, Action action, IEnumerable`1 additionalCustomProperties)\r\n at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute(ILogger logger, XrmTelemetryActivityType activityType, Action action)\r\n at Microsoft.Crm.BusinessEntities.ExecutionContext.ProcessRecords(CreateNewCollectorOption createOption)\r\n at Microsoft.Crm.BusinessEntities.ExecutionContext.<>c__DisplayClass338_0.<ProcessDependencies>b__1()\r\n at Microsoft.Crm.SqlTelemetryHelper.LogSqlTimes(Action action, String operationName, IOrganizationRequestContext context)\r\n at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute(ILogger logger, EventId eventId, ActivityType activityType, Action action, IEnumerable`1 additionalCustomProperties)\r\n at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute(ILogger logger, XrmTelemetryActivityType activityType, Action action)\r\n at Microsoft.Crm.BusinessEntities.ExecutionContext.DependencyCalculationPreCommitHandler(Object sender, EventArgs e)\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at Microsoft.Crm.CrmTransactionEventManager.InvokePreCommitTransactionEvents()\r\n at Microsoft.Crm.CrmTransaction.<>c__DisplayClass14_0.<CommitTransaction>b__0()\r\n at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute(ILogger logger, EventId eventId, ActivityType activityType, Action action, IEnumerable`1 additionalCustomProperties)\r\n at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute(ILogger logger, XrmTelemetryActivityType activityType, Action action)\r\n at Microsoft.Crm.LegacySqlDataAccessContextImplementation.EndRequest()\r\n at Microsoft.Crm.SqlDataAccessContext.OnEndRequest()\r\n at Microsoft.Crm.BusinessEntities.ExecutionContext.OnEndRequest()\r\n at Microsoft.Crm.Extensibility.OData.CrmODataBatchHandler.<ExecuteChangeSetAsync>d__9.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Microsoft.Crm.Extensibility.OData.CrmODataBatchHandler.<>c__DisplayClass10_2.<<ExecuteRequestMessagesImplAsync>b__1>d.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.<ExecuteAsync>d__11`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.<ExecuteAsync>d__15`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Microsoft.Crm.Extensibility.OData.CrmODataUtilities.<InvokeActionAndLogMetricAsync>d__17`2.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at Microsoft.Crm.Extensibility.OData.CrmODataBatchHandler.<ExecuteRequestMessagesImplAsync>d__10.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Microsoft.Crm.Extensibility.OData.CrmODataBatchHandler.<>c__DisplayClass7_0.<<ExecuteRequestMessagesAsync>b__0>d.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.<ExecuteAsync>d__11`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.<ExecuteAsync>d__15`1.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Microsoft.Crm.Extensibility.OData.CrmODataUtilities.<InvokeActionAndLogMetricAsync>d__17`2.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at Microsoft.Crm.Extensibility.OData.CrmODataBatchHandler.<ExecuteRequestMessagesAsync>d__7.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.OData.Batch.DefaultODataBatchHandler.<ProcessBatchAsync>d__0.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Batch.HttpBatchHandler.<SendAsync>d__0.MoveNext()", "ErrorCode": "0x80040217" }



Categories:

Tables

Microsoft Dataverse