parallel processing yields Generic SQL Error RRS feed

  • Question

  • I wrote up a utility program to generate test data.  Given a set of systemusers it generates N contacts for each and a bunch of accoutrements for those contacts (a mix of associated custom entities and activities.)  In an effort to speed it up I modified it to run one user and started it up two Command prompts each processing a different user.  Only one survives.  They go along for a while until one fails with Generic SQL Error.  I also tried 16 command windows -- the more "threads" the faster the failures of all but one.

    What puzzles me is that one would think this is analogous to 2 or 16 users at once.  All the transactions are creates -- nothing is writing to the same record -- except for the uncharted javascripts & assemblies.  By uncharted I mean I don't know what all is going on in the background.

    So, I guess the question is, is such failure to be expected?  If not, is the problem infrastructure/throttling of some sort or certainly due to collisions in background processing?

    Your thoughts are appreciated.


    PS- it is not like multiple users in that all "threads" use the same credentials.
    • Edited by mardukes Friday, January 9, 2015 3:50 PM additional note
    Friday, January 9, 2015 3:48 PM

All replies

  • Sounds like you're getting locking errors - which are most likely due to plugins that may be firing. If you enable tracing then you should get more information on the error, and the SQL that causes it

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

    Friday, January 9, 2015 8:06 PM