locked
MS CRM 2011 Deletion service showing the error RRS feed

  • Question

  • For one of my MS CRM 2011 organization its giving the error as below when deletion service trying the execute.

    Please let me know the solution to fix this error.

    Error: Deletion Service encountered an internal error for

    OrganizationId: b46cf534-f43f-e211-b4d7-0050569c2a1e

    OrgName: CRMDev

    Exception: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'UseReadForm'.

    Invalid column name 'QuickFindRecordLimitEnabled'.

    Invalid column name 'AllowUserFormModePreference'.

    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.SqlDataReader.TryConsumeMetaData()

    at System.Data.SqlClient.SqlDataReader.get_MetaData()

    at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

    at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)

    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)

    at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

    at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)

    at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()

    at Microsoft.Crm.CrmDbConnection.InternalExecuteWithRetry[TResult](Func`1 ExecuteMethod, IDbCommand command)

    at Microsoft.Crm.CrmDbConnection.InternalExecuteReader(IDbCommand command, Boolean capturePerfTrace)

    at Microsoft.Crm.CrmDbConnection.ExecuteReader(IDbCommand command, Boolean impersonate, Boolean capturePerfTrace)

    at Microsoft.Crm.BusinessEntities.BusinessProcessObject.ExecuteQuery(CrmDbConnection dbConnection, IDbCommand command, ISqlExecutionContext context, Nullable`1 commandTimeout)

    at Microsoft.Crm.BusinessEntities.BusinessProcessObject.DoRetrieve(BusinessEntityMoniker moniker, BusinessEntity entity, EntityExpression entityExpression, ExecutionContext context, Int32 languageCode, DatabaseQueryTarget queryTarget)

    at Microsoft.Crm.BusinessEntities.BusinessProcessObject.Retrieve(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context, Int32 languageCode, DatabaseQueryTarget queryTarget)

    at Microsoft.Crm.BusinessEntities.BusinessProcessObject.Retrieve(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context, Int32 languageCode)

    at Microsoft.Crm.BusinessEntities.BusinessProcessObject.Retrieve(BusinessEntityMoniker moniker, EntityExpression entityExpression, ExecutionContext context)

    at Microsoft.Crm.Caching.OrganizationSettingsCacheLoader.LoadCacheData(Guid key, ExecutionContext context)

    at Microsoft.Crm.Caching.ObjectModelCacheLoader`2.LoadCacheData(TKey key, IOrganizationContext context)

    at Microsoft.Crm.Caching.CrmMultiOrgCache`2.CreateEntry(TKey key, IOrganizationContext context)

    at Microsoft.Crm.Caching.CrmMultiOrgCache`2.LookupEntry(TKey key, IOrganizationContext context)

    at Microsoft.Crm.BusinessEntities.SecurityLibrary.CheckPrivilegeGroupForOrganization(WindowsIdentity identity, IOrganizationContext context)

    at Microsoft.Crm.BusinessEntities.SecurityLibrary.GetPrivilegedUserCallerAndBusinessGuidsFromThread(WindowsIdentity identity, IOrganizationContext context)

    at Microsoft.Crm.Authentication.CrmWindowsIdentity.DoRecognizeUser(String userToken, Guid organizationId, LocatorServiceContext locatorServiceContext)

    at Microsoft.Crm.Authentication.BaseCrmIdentity.RecognizeCrmUser(Guid organizationId, LocatorServiceContext locatorServiceContext)

    at Microsoft.Crm.Authentication.BaseCrmIdentity.RecognizeCrmUser(Guid organizationId)

    at Microsoft.Crm.Extensibility.InternalSdkContextInitializer.SetHttpContext(WindowsIdentity windowsIdentity, Guid organizationId, Guid callerId)

    at Microsoft.Crm.Extensibility.InprocessServiceProxy.DeleteCore(String entityName, Guid id)

    at Microsoft.Xrm.Sdk.Client.OrganizationServiceProxy.Delete(String entityName, Guid id)

    at Microsoft.Crm.Asynchronous.DeletionServiceProvider.DeleteSubscription(Guid subscriptionId, Guid userId)

    at Microsoft.Crm.DeletionService.CleanupExpiredSubscriptions(CrmDbConnection connection, IDeletionServiceProvider deletionServiceProvider)

    at Microsoft.Crm.DeletionService.Run(IDeletionServiceProvider deletionServiceProvider)


    -- Milind

    Tuesday, December 31, 2013 7:49 PM

All replies

  • This looks like the organisation database has a SQL schema version that is inconsistent with the version of the CRM binaries. What Update rollup version do you have installed on the CRM server, and what is the version of the organisation (you can find this in Deployment Manager). If they are different, then there should be an option in Deployment Manager to Update the organisation

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Friday, January 3, 2014 12:22 PM
    Moderator
  • The build and the database version is 5.0.9690.1992 i.e. running on UR 6.

     

    I do have multiple tenant on the CRM server but the error message I am getting for this organization.


    -- Milind

    Friday, January 3, 2014 9:17 PM