Transaction Processing: Error on Batch Update [batch no.]

Issue:
User encountered error messsage ’3902 The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.’ when performing Batch Update of DM under Transaction Processing.


Cause:
This is caused due to network fluctuation.

Fix:
Check the following tables

• a_open_item
• a_open_itm_hist
• a_doc_reg
• a_ar_gl_trans

See below for sample query:
-- a_open_item
select *
from a_open_item with (nolock)
where trans_code = ‘DM’
and ref_no in (’11V6-156′, ’11V6-157′, ’11V6-158′, ’11V6-159′, ’11V6-160′, ’11V6-161′, ’11V-162′, ’11V6-163′, ’11V6-164′, ’11V6-165′)

-- a_open_itm_hist
select *
from a_open_itm_hist with (nolock)
where trans_code = ‘DM’
and ref_no in (’11V6-156′, ’11V6-157′, ’11V6-158′, ’11V6-159′, ’11V6-160′, ’11V6-161′, ’11V-162′, ’11V6-163′, ’11V6-164′, ’11V6-165′)

-- a_doc_reg
select *
from a_doc_reg with (nolock)
where trans_code = ‘DM’
and ref_no in (’11V6-156′, ’11V6-157′, ’11V6-158′, ’11V6-159′, ’11V6-160′, ’11V6-161′, ’11V-162′, ’11V6-163′, ’11V6-164′, ’11V6-165′)

-- a_ar_gl_trans
select *
from a_ar_gl_trans with (nolock)
where trans_code = ‘DM’
and batch_no = ’897′