Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 24th July 2015, 11:33
patwanirav patwanirav is offline
Member
 
Join Date: May 2011
Posts: 38
patwanirav is on a distinguished road
Baan: Baan 4 - DB: Infor - OS: Xp
How to handle Fatal Error 201 (Record Chagned After Delayed Lock) through coding.

Getting below error message while doing concurrent transaction.

Bdberrno : 201 (Record changed after delayed lock)
ExtraInfo : session: "ltsas0107m001";object: "ltsas0107m001"; function: "whwmd.dll1000.update.item.inventory.by.warehouse" sql.exec; company number: 810
query: "select whwmd215.*, whwmd210.iwhs
from whwmd215 for update, whwmd210
where whwmd215._index1 = {:i.warehouse, :i.item}
and whwmd215.cmba refers to whwmd210
as set with 1 rows
hint use index 1 on whwmd215
"
Message : FATAL ERROR: Error 201 (Record changed after delayed lock) on tcibd100810 (retry point suppressed in transaction slave)


Thanks in advance
Reply With Quote
  #2  
Old 24th July 2015, 14:54
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,322
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
Hi,

Use db.retry.point() to handle 201 errors. An attempt to update the record was failed and there is no retry point set and hence you get this error.

Quote:
201 EROWCHANGED - Row changed by other user
Description:
This error indicates that the record was changed after a delayed lock.
Solution:
Reattempt to change the row.
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
  #3  
Old 25th July 2015, 06:06
patwanirav patwanirav is offline
Member
 
Join Date: May 2011
Posts: 38
patwanirav is on a distinguished road
Baan: Baan 4 - DB: Infor - OS: Xp
Hi Bhushan,
I had already set the db.retry.point(), but still it is giving this error message. The strange thing is that when I do the concurrent transaction from ERPLN through different login it is working fine. but when I do the same thing using BDE and SOAP it is failing. Not able to find out why this is happening. Is there any help I can get from anyone ???
Reply With Quote
  #4  
Old 25th July 2015, 08:27
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,322
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
Hi,

Remove db.retry mode if used in dal.* I guess this is your code -
http://www.baanboard.com/baanboard/s...95032#poststop

It will keep calling retry point.

So, just set retry point, and use DAL without flags.
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
  #5  
Old 28th July 2015, 06:18
patwanirav patwanirav is offline
Member
 
Join Date: May 2011
Posts: 38
patwanirav is on a distinguished road
Baan: Baan 4 - DB: Infor - OS: Xp
Hi Bhushan,
I had used the same code suggested by you and it is not working in concurrent transaction. it is giving 201 (Record changed after delayed lock) error.
Reply With Quote
Sponsored Links
  #6  
Old 28th July 2015, 09:35
bhushanchanda's Avatar
bhushanchanda bhushanchanda is offline
Guru
 
Join Date: Sep 2012
Location: India
Posts: 2,322
bhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura aboutbhushanchanda has a spectacular aura about
Baan: LN FP 1-9, 10.4, a little bit of Baan IV - DB: SQL Server 2008, Oracle - OS: Windows Server 2008 R2, Unix
Hi,

If possible, post your complete code. That will help to understand the issue better.
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
  #7  
Old 26th April 2016, 08:29
gk1234 gk1234 is offline
Junior Member
 
Join Date: Oct 2003
Location: Germany
Posts: 3
gk1234 is on a distinguished road
Baan: ERP LN FP7 - DB: Oracle RAC 11.02.04 - OS: SUSE Linux 11
Have you already found a solution for this problem. I'm just working on the same problem using BDE and Soap with concurrent transactions? In LN everything is working fine. The error message is exactly the same.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Record changed after delayed lock spartacus Tools Development 14 8th August 2014 14:50
db.lock.table Error mandip Tools Development 6 11th August 2010 23:48
DAL:record changed after delayed lock baanconsultant Tools Development 3 10th May 2008 14:50
Error 201 - Record Changed after delayed lock mark_h Tools Development 15 4th January 2006 21:40


All times are GMT +2. The time now is 06:32.


©2001-2017 - Baanboard.com - Baanforums.com