Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Reassigning Records Locking Up CRM 4 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi folks.

    We just started having a problem when attempting to reassign records in CRM.  Nothing was changed to the system as far as we know (i.e. server updates, crm updates, etc). 

    Here is a description of the issue:

    When we select one or more (bulk) records to reassign to another user, it just times out the system and I get a (Not Responding) at the top of the window OR it after 10 minutes or so we receive a message that reads it couldn’t complete the process.  This is a simple process that we have executed countless times over the past 5 years and now all of a sudden isn't cooperating.

    Here are some environment specs:

    Windows Server 2008 STD R2

    CRM 4 Server Rollup 21

    Wednesday, March 4, 2015 6:40 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    The problem could relate to cascading rules. If one or more of the 1:N relationships on the entity have Cascading Assign configured, then the assign will apply to all child records, and to any further child records with Cascading Assign. Either the SQL process to identify the records to reassign, or the query to actually reassign them, can generate a large number of SQL locks, which would explain your symptoms.

    Try changing the Cascading Assign behaviour to see if this resolves the issue

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    • Marked as answer by Dynamix12 Saturday, March 5, 2016 11:38 PM
    Thursday, March 5, 2015 9:17 AM
    Moderator