Using ExecuteMultipleRequest to batch create record if there is performance problem.

(0) Share

Report

Posted on by Stone Huang

455

Hi Guys,

When I'm using ExecuteMultipleRequest to batch create record, I hit occasionally an exception "Connection State is closed. Please open the connection before executing the command.". I'm sure what are reasons. I used the tool CrmDiagTool2011 to grab this exception, I saw some details about System.Data.SqlClient.TdsParserStateObject, I don't know if I use service.create() to create record one by one, if this problem can be fixed.

BTW, I don't create many records at a time, probably less than a dozen. The most troubling part is that this problem doesn't recur every time.

I'm using dynamics 365 op verison.

Thanks,

Stone

I have the same question (0)