Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > AFS/DDC/OLE: Function servers

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 2nd October 2017, 16:20
VishalMistry's Avatar
VishalMistry VishalMistry is offline
Guru
 
Join Date: Dec 2004
Location: India, Gujarat
Posts: 573
VishalMistry has a little shameless behaviour in the past
Baan: Baan IV, ERPLn - DB: SQL Server 2000 / 2008 - OS: Windows Server 2003 / 2008
Wink AFS hangs on second iteration of update

Hello,

I have a session which calls upon AFS of tdsls4102s000 (sales order lines) for updating the warehouse in open sales order lines. The issue is the session just hangs on second record when it tries to update. It goes through perfectly on first record, but when the select query reaches second record, after successfully puting (tdsls041.orno & tdsls041.pono) it simply hangs on the stpapi.update call.

I have attached script with a hope to find what could be wrong in the script. Any hint will be highly appreaciated.

Vishal
Attached Files
File Type: cln script.cln (3.6 KB, 9 views)
Reply With Quote
Sponsored Links
  #2  
Old 2nd October 2017, 17:54
rahul ingale rahul ingale is offline
Member
 
Join Date: May 2011
Location: Hyderabad
Posts: 33
rahul ingale is on a distinguished road
Baan: baan infor - DB: sql - OS: windows xp
Check return value of stpapi.update.if return value is zero then recover the session.use set commands AFS.LoG = 1 to check how AFS running.file will be created in temp folder.
__________________
IRL
Reply With Quote
  #3  
Old 2nd October 2017, 18:41
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 6,934
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Watch you background processes. Make sure the update is not starting something unaccounted for in the code. And if necessary close the session inside the selectdo or even try a suspend statement after each update(give the background session plenty of time to process before trying the next record).
__________________
Mark

GO Cards!
My latest mantra - make sure you have latest stpapi patches and the latest session object. If on LN then please explore the option of using DAL2 functionality.

Shared Solutions for Baan systems provided free by Baan Board.
Play the Google game and help Baanboard get better rankings. Do your part. Click here to find how.
Reply With Quote
  #4  
Old 11th October 2017, 18:31
VishalMistry's Avatar
VishalMistry VishalMistry is offline
Guru
 
Join Date: Dec 2004
Location: India, Gujarat
Posts: 573
VishalMistry has a little shameless behaviour in the past
Baan: Baan IV, ERPLn - DB: SQL Server 2000 / 2008 - OS: Windows Server 2003 / 2008
Wink Problem solved

Hello Mark,

I thoroughly tested and it was not an issue related to any sub-process started. I just had to check the result of stpapi.update call, before making any further stpapi call. In case the stpapi.update call fails, then any subsequent stpapi call would fail.

I have attached script part for reference in case someone faces similar issue.

Thanks,
Vishal
Attached Files
File Type: txt script.txt (1.4 KB, 10 views)
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
AFS field values are not imported to update session balayaswanth Blogs and Web links 1 20th April 2017 14:10
AFS logic on how to update Lot number in Outbound eric.dizon AFS/DDC/OLE: Function servers 8 20th August 2014 07:54
tibom1213m000(Detect low level code and loop) Issue mark_h Tools Development 8 3rd December 2012 19:29
Update field value i.e. not a form field through AFS! Ankita AFS/DDC/OLE: Function servers 12 18th May 2008 04:06
AFS hangs in stpapi.put.field garias AFS/DDC/OLE: Function servers 1 30th January 2005 23:13


All times are GMT +2. The time now is 23:24.


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