15Hi,
I am unable to create Lookup field of Company entity in my custom Entity. Getting SQL Server error with below message.
Please advice.
Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=9.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: Exception output:: System.Data.SqlClient.SqlException (0x80131904): Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (0x80004005): The wait operation timed out
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.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
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.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command)
at Microsoft.Crm.CrmDbConnection.<>c__DisplayClass107_0.<InternalExecuteNonQuery>b__0()
at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute[TResult](ILogger logger, EventId eventId, ActivityType activityType, Func`1 func)
at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute[TResult](ILogger logger, XrmTelemetryActivityType activityType, Func`1 func)
at Microsoft.Crm.Metadata.SqlHelper.ExecuteNonQuery(ISqlExecutionContext context, IDbCommand sqlCommand)
at Microsoft.Crm.Metadata.SqlHelper.ExecuteNonQuery(MetadataHelper helper, String sqlCommand)
at Microsoft.Crm.Metadata.EntityAttributeCreateBatchingAction.ExecuteBatchForTable(String tableName, Boolean isPrimary)
at Microsoft.Crm.Metadata.EntityAttributeCreateBatchingAction.DatabaseOperation()
at Microsoft.Crm.Metadata.MetadataHelper.ProcessDatabaseActions(CounterList listCounters)
at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute[TResult](ILogger logger, EventId eventId, ActivityType activityType, Func`1 func)
at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute[TResult](ILogger logger, XrmTelemetryActivityType activityType, Func`1 func)
at Microsoft.Crm.Metadata.MetadataHelper.ProcessDatabaseOperationsInternal(CounterList listCounters)
at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute(ILogger logger, EventId eventId, ActivityType activityType, Action action)
at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute(ILogger logger, XrmTelemetryActivityType activityType, Action action)
at Microsoft.Crm.Metadata.MetadataHelper.<ProcessQueue>b__110_0()
at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute(ILogger logger, EventId eventId, ActivityType activityType, Action action)
at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute(ILogger logger, XrmTelemetryActivityType activityType, Action action)
at Microsoft.Crm.Metadata.RelationshipServiceBase.CreateMultipleRelatedRelationships(IRelationshipCreateInfo[] relationshipInfos, ExecutionContext context)
at Microsoft.Crm.Metadata.RelationshipServiceBase.Create(IRelationshipCreateInfo relationshipInfo, ExecutionContext context)
at Microsoft.Crm.Metadata.RelationshipServiceBase.Create(IRelationshipCreateInfo createInfo, Guid solutionId)
at Microsoft.Crm.Metadata.EntityRelationshipService.Create(IRelationshipCreateInfo relationshipInfo, Guid solutionId)
at Microsoft.Crm.Application.WebServices.SystemCustomization.RelationshipCreate.Execute(Guid solutionId, ParameterBag paramBag)
at Microsoft.Crm.Application.WebServices.SystemCustomization.SystemCustomization.CreateAttribute(XmlNode data)
ClientConnectionId:127705c7-f243-4de4-89c4-74a2e006e7ef
