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?