solution import impact when users are online? RRS feed

  • Question

  • Hello, I was curious - what is the impact to users of importing solutions while users are online?  I think I've done this before and the result seemed to be a low to no impact js error which was really just an annoyance. Nothing even worth investigating. So what has been your experience with this, what is the worst case scenario that could happen with this and what is the worst case scenario that you have actually experienced/observed with this? Obviously, solutions should only be imported during scheduled downtime but I'm really just curious about the potential impact of doing this while users are on the system?
    Wednesday, May 7, 2014 7:27 PM

All replies

  • Solution import is very write-heavy to the DB. Especially complex solutions. As such, you could give users performance issues that make CRM hard to use during import. Also, if you include any sitemap or form changes, they won't get those until the refresh, which might cause confusion, or even an error on save if you made a new field required.

    That's about all I can think of, though.

    The postings on this site are solely my own and do not represent or constitute Hitachi Solutions' positions, views, strategies or opinions.

    • Proposed as answer by Mamatha Swamy Wednesday, May 7, 2014 9:38 PM
    Wednesday, May 7, 2014 7:42 PM
  • The solution import runs as one database transaction, which holds many SQL locks. The most likely problem from the locks is that CRM user operations can timeout during the import, but you may also find that the import fails if it cannot obtain locks if there is too much user activity. I tend to find these issues are most signifcant if the solution contains new attributes, as these need to change the underlying table structure

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

    Thursday, May 8, 2014 8:27 AM