ScaleGroupOrganizationMaintenanceJobs lastresultcode=1 even asyncoperationabse remain 100k records

• Question

• 

  

  0

  Sign in to vote

  Hi,
  by running this SQL i can get information on hard delete status:
  
  use mscrm_config    
  select * from ScaleGroupOrganizationMaintenanceJobs
  where OrganizationId in (select Id from Organization where DatabaseName = 'myCRM_mscrm') and OperationType = 14
  
  when my AsyncOperationBase contains 7 million records, I understand that hard delete will fail.
  However, it still fail to execute when the async table was purged to 100k records remain.
  
  select count(*) from <tables_base>  where deletionstatecode=2
  
  CRM table                                                     Total count
  SdkMessageProcessingStepBase        422
  AsyncOperationBase                   84 records
  QueueItemBase                           50
  WorkflowBase                              23
  
  after run the hard deletion job,
  AsyncOperationBase records was purged successfully but not for other table. and LastResultCode return 1, which means error I think.
  

  CRM table                                                     Total count
  SdkMessageProcessingStepBase        422
  QueueItemBase                           50
  WorkflowBase                              23
  
  What other action I can apply to solve / investigate this issue?

  Wednesday, August 10, 2011 8:42 AM