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