Dynamics Community Forum Thread Details

High volume inserts

Hello,

at our client we create a high volume of sales/purchase (+10k/hr sometimes) order pairs using a batch job running with 8 threads on four AOSes.

Not all the time, but occasionally we see this error (either purchLine or salesLine) :

Cannot create a record in Order lines (SalesLine). Sales order: SO000012477, DTNPROC. The record already exists. Our orders have mostly one line, sometimes a few more.

We believe that this is an error with the TransIdIdx and the InventTransId. Two processes creating two different orders at pretty much the same time and one of them is failing

because the inventTransId has already been used. If we reprocess one of these failed transactions (creation of order pair in a tts), they work, so I don't think there's a problem with the

data that we use.

Is this even possible ? Has someone seen something like this before ? Can two processes pull the same number from a numbersequence if they do that at pretty much the same

time ? This is really high volume, processing data and creating order pairs as fast as D365 can.

We are not manually pulling the inventTransId from the number sequence, this happens with the insert.

Best regards

Frank

Quick Links

Leaderboard