locked
Error: Deletion Service failed to clean up table= CleanUpInactiveWorkflowAssembliesProcedure RRS feed

  • Question

  • Every day at 17:15 our CRM implementation grinds to halt for roughly 15 minutes. On examining Event Viewer I can see the following two events.

    1. Event Source: MSCRMDeletionServiceEvent
      ID: 16387
      Description: Error: Deletion Service failed to clean up table=CleanUpInactiveWorkflowAssembliesProcedure
    2. Event Source: MSCRMAsyncService
      Event ID: 17415
      Description: Host XXXCRM1: error while processing organization 07112204-746a-df11-9291-001d096b0cf6. Exception: System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

    I have experienced similar issues in the past and set up a Scheduled Task in SQL to run the clean up routines as listed in the following knowledge base article however it seems that this is also failing now.

    Does any one have any ideas?

    • KB: Performance is slow if the AsyncOperationBase table becomes too large in Microsoft Dynamics CRM 4.0 - http://support.microsoft.com/default.aspx/kb/968520
    • SQL Statement Error: The DELETE statement conflicted with the REFERENCE constraint "asyncoperation_workflowwaitsubscription". The conflict occurred in database "XXX_MSCRM", table "dbo.WorkflowWaitSubscriptionBase", column 'AsyncOperationId'.
    Wednesday, June 16, 2010 2:53 PM

Answers

  • Nick,

    The one I look at always is AsyncOperationBase.

    However, from your numbers above it doesn't appear that it is bloated out of size.

    You should run the other steps noted in the KB article. Then check the size afterwards to confirm that it processed the records and it is lower.


    Jerry http://www.crminnovation.com
    • Marked as answer by Jim Glass Jr Monday, June 28, 2010 3:08 PM
    Thursday, June 24, 2010 12:10 AM

All replies

  • How many rows and how large is the async table?
    What is the size of the CRM database?
    In other words the async table is contributing to what overall % of the DB size?

    Also use this tool to change the time the deletion service runs to an off hour rather than the default which is when CRM was initially installed. http://code.msdn.microsoft.com/ScaleGroupJobEditor


    Jerry http://www.crminnovation.com
    Wednesday, June 16, 2010 10:05 PM
  • Jerry, thanks for the reply however I am not 100% sure which table I need to look at however ....

    Total DB Size: 8297.06 MB
    AsycOpertaionBase Rows: 130159
    AsycOpertaionBase Data: 401264 KB (391 MB)
    AsycOpertaionBase Index: 47808 KB 

    In addition to this when I run the count element of part of the KB in my original post the results are as follows ...

    Script:
    Select Count(AsyncOperationId)
    from AsyncOperationBase WITH (NOLOCK)
    where OperationType in (1, 9, 12, 25, 27, 10)
    AND StateCode = 3 AND StatusCode IN (30,32)


    Result: 73806

    In the meantime I will change the time deletion service time using the tool listed ... thank you !

    Friday, June 18, 2010 8:37 AM
  • Nick,

    The one I look at always is AsyncOperationBase.

    However, from your numbers above it doesn't appear that it is bloated out of size.

    You should run the other steps noted in the KB article. Then check the size afterwards to confirm that it processed the records and it is lower.


    Jerry http://www.crminnovation.com
    • Marked as answer by Jim Glass Jr Monday, June 28, 2010 3:08 PM
    Thursday, June 24, 2010 12:10 AM