Default forms and Views no longer being created for New Dataverse Tables

[Rutu01]

On Creating a new table in Dataverse, the default views and forms are no longer being created.

This seems to be a bug that has  been reported here as well as on reddit in the past one month. 

I have also raised a support request but it's been 8 days and haven't even had initial contact yet, the last time I requested support it took more than 15 days for initial contact, they said they have a lot of backlog

I have tried the ideas mentioned in the forums and reddit but it's not working

1. Checking Default Solution

2. Waiting upto  a few hours

3. Trying to restart the job from Environment Settings => System Jobs

As a new user I don't feel comfortable using the classic mode and I'm worried about what else may be going wrong behind the scenes

This is the error as per Environment Settings=>System Jobs

Plugin Trace:

[Microsoft.Crm.MetadataService: Microsoft.Crm.MetadataService.PostCreateEntityUIProcessPlugin]
[xxxxxxxxxxx: PostCreateEntityUIProcessPlugin]



Error Message:

Exception type: Microsoft.Xrm.Sdk.InvalidPluginExecutionException
Message: Microsoft.Crm.CrmException: An unexpected error occurred. ---> System.InvalidOperationException: ExecuteNonQuery requires the command to have a transaction when the connection assigned to the command is in a pending local transaction.  The Transaction property of the command has not been initialized.
   at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async)
   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__DisplayClass235_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.CrmDbConnection.ExecuteNonQueryAbstract(IDbCommand command, Int32 sourceLineNumber, String memberName, String sourceFilePath)
   at Microsoft.Crm.CrmDbConnection.SetTransactionIsolationLevel(IsolationLevel il)
   at Microsoft.Crm.CrmTransaction.<>c__DisplayClass14_0.<CommitTransaction>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.LegacySqlDataAccessContextImplementation.EndRequest()
   at Microsoft.Crm.SqlDataAccessContext.OnEndRequest()
   at Microsoft.Crm.BusinessEntities.ExecutionContext.OnEndRequest()
   at Microsoft.Crm.Metadata.EntityUICreateAsyncHandler.PerformReserveEntityMetadataRenameOperation(Guid organizationId, IPluginExecutionContext pluginContext, EntityUIProcessRequest entityUIProcessRequest)
   at Microsoft.Crm.Metadata.EntityUICreateAsyncHandler.<>c__DisplayClass15_0.<Execute>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.EntityUICreateAsyncHandler.Execute(EntityUIProcessRequest entityUIProcessRequest, IPluginExecutionContext pluginContext)
   at Microsoft.Crm.MetadataService.PostCreateEntityUIProcessPlugin.<>c__DisplayClass3_0.<ExecuteWithRetry>b__0()
   at Microsoft.Crm.Core.Extensions.Retry.GenericRetryHelper.<>c__DisplayClass3_0`1.<ExecuteForRetryPolicy>b__0()
   at Microsoft.Crm.Core.Extensions.Retry.Executer.BaseRetryExecuter`1.Execute(Action action)
   --- End of inner exception stack trace ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at Microsoft.Crm.Core.Extensions.Retry.GenericRetryHelper.ThrowRetryException(RetryExecutionStatus executionStatus, Exception exceptionDuringExecution)
   at Microsoft.Crm.Core.Extensions.Retry.GenericRetryHelper.ExecuteWithRetryInternal[T](BaseRetryExecuter`1 executer, Func`1 func)
   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.MetadataService.PostCreateEntityUIProcessPlugin.ExecuteWithRetry(EntityUIProcessRequest entityUIProcessRequest, IPluginExecutionContext pluginContext)
   at Microsoft.Crm.MetadataService.PostCreateEntityUIProcessPlugin.ExecuteWithRetry(EntityUIProcessRequest entityUIProcessRequest, IPluginExecutionContext pluginContext)
   at Microsoft.Crm.MetadataService.PostCreateEntityUIProcessPlugin.<>c__DisplayClass2_0.<Execute>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.Asynchronous.EventOperation.InvokePlugin(AsyncExecutionContext context, IPlugin pluginInstance)
-- End stack trace --

[dpoggemann]

Hi @Rutu01 ,

Please open a case with Microsoft as this looks to be an issue in your environment specifically as it works to create the default forms in environments i am working with.

[Rutu01]

I have already opened a ticket with a fortnight ago but there isn't even initial contact yet.  This is not an environment issue as I have the same problem with all environments and even other tenants that I own.

Also multiple people in this community and on reddit have mentioned this issue with this same error log.

I believe it is a region issue and has been solved in some regions but not in others ...

[Rutu01]

Could anyone In India kindly check if they are having this same issue will be a big help thanks

[Rutu01]

13 days ago support said this is a known issue and haven't heard from them since. Unacceptable support wait times atleast in India since the past few months

[Rutu01]

Heard from them and they said it is a known issue that they are working on. Also,On creating a form manually, default forms are getting created . 

[Rutu01 · Accepted solution]

Solved by Microsoft Support, default views and forms are now being created. Sometimes it takes a few seconds as it's an async operation , but they are consistently created.