grow database after importing organization RRS feed

  • Question

  • hi my friends

    we encounter a disaster problem, one day after importing an oranization, we undrestood  that organization database has been grown abnormally up to 74 Gigabyte!!! most of space was related to workflowlogbase(42GB) and asynchoperation(30GB) tables.

    in workflowbase table , i saw bunch of error record , its message column was :

    Microsoft.Crm.CrmSqlGovernorRequestDeniedException: Unable to acquire lock on entity serviceappointment with id 6d60a599-e55f-e311-aaf7-005056b73b44     at Microsoft.Crm.Workflow.Services.ActivityServiceBase.TryAcquireLockWithRetry(String entityLogicalName, Guid entityId)     at Microsoft.Crm.Workflow.Services.UpdateActivityService.<>c__DisplayClass1.<UpdateInternal>b__0(IOrganizationService sdkService)     at Microsoft.Crm.Workflow.Services.ActivityServiceBase.ExecuteInTransactedContext(ActivityDelegate activityDelegate)     at Microsoft.Crm.Workflow.Services.UpdateActivityService.UpdateInternal(Entity entity, String stepId)     at Microsoft.Crm.Workflow.Services.UpdateActivityService.ExecuteInternal(ActivityContext executionContext, UpdateEntity updateEntity)     at Microsoft.Crm.Workflow.Services.UpdateActivityService.Execute(ActivityContext executionContext, UpdateEntity updateEntity)     at System.Activities.CodeActivity.InternalExecute(ActivityInstance instance, ActivityExecutor executor, BookmarkManager bookmarkManager)     at System.Activities.Runtime.ActivityExecutor.ExecuteActivityWorkItem.ExecuteBody(ActivityExecutor executor, BookmarkManager bookmarkManager, Location resultLocation)

    i didnt find any thing about this error in internet!!

    i ran some query that had  found in microsoft technet, in order to clean these tables , but the execution of queries were not finished after 4 hours until i stoped them.  unfortunately now the tables in database is not available, and our customer cant create any other thing in CRM , they get SQL Server time out error.

    please help us , what can we do fix this problem whithout restoring previous database,


    • Edited by samira_a Monday, December 16, 2013 5:06 AM
    Sunday, December 15, 2013 2:48 PM