Can't delete a custom Dataverse table

[IMeanWell]

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" }



[FLMike · Accepted solution]

Hello,

Essentially this says that either you never published the Table, (so deleting is moot), or you were using OptionSets as part of the Table Columns and that is not published properly. 

So deleting it can't happen because OptionSets and or the table itself has never been published properly.

Please validate that you delete any OptionSets you created(if any) for this table. And, if you have not, do a Publish all customizations, then try to delete it again.

If that does not work, go to the Table Details page, and look at its Dependencies here (as an example here is my table), under Advanced / Show Dependencies

You will see stuff like this

Remove them as dependencies on your table and delete it.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

[IMeanWell]

Well, I had not published the table, so I did so and was immediately able to delete it after that.

I guess I got confused because my table was appearing in the list.

Lesson learned. Thanks!

[FLMike]

Hi @IMeanWell 

@Yeah it’s there in a pseudo implemented state so you can go away and come back later and keep working. 

glad it worked out. 

[Anonymous]

Also seeing the same issue. Publishing the table makes no difference. I can delete the table from a solution, but trying to delete form the environment results in a similar error as OP. I have to delete the entire environment as a workaround.