List Info

Thread: Deadlocks in sales order import




Deadlocks in sales order import
country flaguser name
United States
2008-03-04 23:14:17

Hi,
I have a huge problem with a sales order import that runs in batch
with multiple batch clients.
The clients goes in deadlock immediately, and it seems to be on sales
table. The pseudo code is:
if(!salestable)
{
try
{
ttsbegin;
//process sales table
salestable.insert();
ttscommit;

}
catch(exception:eadlock)
{
retry;
}
}

try
{
ttsbegin;
//process sales line
salesline.createLine();
ttscommit;
}
catch(exception:eadlock)
{

}

I'll really appreciate any help on what this may be.
Thanks'

--
With best regards
Lars H. Sandvik-Jacobsen

__._,_.___
.

__,_._,___
[1]

about | contact  Other archives ( Real Estate discussion Medical topics )