Generic SQL error while using CRM REST-Endpoint

Got some strange issues on a customer site. Some updates or deletes got a “Generic SQL Error” via the REST-Endpoint. The eventlog stated something like “invalid character in XML 0X00″ (which XML, the request is formed a a json post??). After a while debugging (which caused everything to go well) and fiddlering it turned out, that we produced a few (in our case 5 where enough) parallel requests to the service. We changed the way sending the requests to the server to a more serial than parallel way and our problems disappeard.

Lesson learned: JavaScript is not slow and able to produce a heavy load on the CRM services…

Lesson to be learned: why does the service sometimes fail on parallel requests since crm 1.2 and what to do about it?

One Response to Generic SQL error while using CRM REST-Endpoint

  1. seo consult 28. June 2013 at 17:13 #

    Hello mate, very nice and informative article you have shared with all of us. I appreciate your efforts. Thanks

Leave a Reply