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