locked
ScaleGroupOrganizationMaintenanceJobs lastresultcode=1 even asyncoperationabse remain 100k records RRS feed

  • Question

  • 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

All replies

  • If you want ot investigate further, then I think your next step would be to enable tracing . However, it looks like the AsyncOperationBase table has ben cleared out OK, and the remaining tables don't have many records in them, so I don't think you have a big problem
    Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk
    Wednesday, August 10, 2011 12:08 PM
    Moderator