Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
regarding changing business unit error RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    hi,

    I am facing one strange error. when changing a user business unit one error message is apperaing and its not changing the user business unit. i verified the event viewer, but there it is showing an error - targetinvocationexception.

    I have checked so many forums regarding this, but so many are saying to increase the oledbtimeout,..

    If any one have any idea regarding this please help me.

     

    version - 4.0,enterprise, onpremise, this error is appearing for all the users

     

     

     

     

     

    Wednesday, February 9, 2011 6:06 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    That sounds like poor performance of AsyncOperationBase table which can happen when the table grows over the time. Try suggestions from the KB article 986520.

    HTH

    George Doubinski, MVP http://crm.georged.id.au
    • Proposed as answer by Amarsen Vangoor Thursday, February 10, 2011 10:25 PM
    • Marked as answer by samuel s Saturday, February 19, 2011 4:32 AM
    Thursday, February 10, 2011 10:11 PM
    Moderator

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    http://social.microsoft.com/Forums/en-IE/crmdeployment/thread/044013f1-1ded-420e-a955-fa2fe5935447
    Regards Faisal
    Wednesday, February 9, 2011 6:54 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thanks for the reply...

     

    But this is not relevant to my error.  I am facing an error when changing the business unit. ( actually it is logging in as warning in event viewer) . One error window dialog is appearing and not changing the business unit.

     

     

    Thursday, February 10, 2011 4:05 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Check if the user is in some team.

    Remove the member from the team and try changing the business unit.

    Thursday, February 10, 2011 5:48 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    What error you are getting, and send me the exact scenario
    Thursday, February 10, 2011 6:01 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    When changing the user business unit i am getting the below mentioned error. this is i obtained from eventviewer Exception information: Exception type: TargetInvocationException Exception message: Exception has been thrown by the target of an invocation.
    Thursday, February 10, 2011 11:00 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Samuel,

    Can you enable tracing on CRM server as documented here and get more details about the error you're getting, including the call stack?

    Thanks

    --

    George Doubinski, MVP http://crm.georged.id.au
    Thursday, February 10, 2011 11:52 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    From trace i got this below exception

     

    Exception when executing non-query: update AsyncOperationBase set OwningBusinessUnit = 'bu-guid' where OwningUser = 'user-guid' Exception: System.Data.SqlClient.SqlException: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.

     

     

    Note : - few days back it executed smoothly. Why its suddenly changed ? can we find this change using  any tool or method?

     

    Please suggest me
    Thursday, February 10, 2011 3:46 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    That sounds like poor performance of AsyncOperationBase table which can happen when the table grows over the time. Try suggestions from the KB article 986520.

    HTH

    George Doubinski, MVP http://crm.georged.id.au
    • Proposed as answer by Amarsen Vangoor Thursday, February 10, 2011 10:25 PM
    • Marked as answer by samuel s Saturday, February 19, 2011 4:32 AM
    Thursday, February 10, 2011 10:11 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Thnks for the reply...

     

    For this error in forums, so many are suggesting to increase the values  oledbtimeout and extendeddbtimeout registry entries. So i am not sure which one is correct. Please tell me what is the difference and which one is correct.

    please check the below link - http://community.dynamics.com/product/crm/f/117/p/4353/6630.aspx

     

    Please le me know the correct approach and reason as well

     

    thnaks in advance

    Friday, February 11, 2011 4:44 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Samuel,

    I would seriously look at cleaning out the table before fiddling with timeouts. It's known for its notorious sometimes uncontrollable growth. For example, in our production environment we have regular scripts cleaning this table, otherwise after about a month system grinds to a halt.

    Cheers

    George

     

    George Doubinski, MVP http://crm.georged.id.au
    Friday, February 11, 2011 4:59 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi George,

     

    may be its true, but i didnt try that approach. i used timeout registry and its working. i setting up the server in dev environment and i will try in that . i will let u know. but the cleaning up process script seems to be little bit hrad. why dont we use the sdk sample for cleaning of data from async table ( they have given sample program in sdk)

     

    Thanks for the help.

    Saturday, February 19, 2011 4:32 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    hi,

    I am facing one strange error. when changing a user business unit one error message is apperaing and its not changing the user business unit. i verified the event viewer, but there it is showing an error - targetinvocationexception.

    I have checked so many forums regarding this, but so many are saying to increase the oledbtimeout,..

    If any one have any idea regarding this please help me.

     

    version - 4.0,enterprise, onpremise, this error is appearing for all the users

     

     

     

     

     


    Would you pls give some details? I've no clear idea about your words.
    Saturday, March 26, 2011 9:34 PM