Baanboard.com

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

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
18%
200 - 500 GB
26%
500 - 800 GB
3%
800 - 1200 GB
9%
1200 - 1500 GB
12%
1500 - 2000 GB
12%
> 2000 GB
21%
Total votes: 34

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 10th February 2003, 19:09
fmorais's Avatar
fmorais fmorais is offline
Senior Member
 
Join Date: Mar 2002
Location: Portugal
Posts: 164
fmorais is on a distinguished road
Baan: B4c4 - DB: MSSQL, Oracle, Informix, BBase - OS: Windows, AIX
Unhappy Calling subsession from subsession in AFS hangs

Hi everybody,

Trying to create an session to insert Purchase Invoices with AFS. I call

tfgld1101m000 which then calls
tfacp1110s000 which calls
tfacp1120s000

I can go untill tfacp1110s000 and the record is correctly inserted on this session. The problem is that when I call tfacp1120s000 the session hangs. This happens either using or not using debugger.

Nothing relevant appears on the afs.log:
>tfacp1110s000 put.field:tfacp200.ninv 21010037
>tfacp1110s000 put.field:tfacp200.suno 295
>tfacp1110s000 put.field:tfacp200.docd 730516
>tfacp1110s000 put.field:tfacp200.ccur EUR
>tfacp1110s000 put.field:screen.amnt 33.02
>tfacp1110s000 put.field:tfacp200.dued 730559
>tfacp1110s000 insert
35->add.set+save
36<-api.child.startedtfacp1120s00035

It seems the program is not controlling well the tfacp1120s000 session.

I already tried to insert an extra save before calling tfacp1120s000.

The relevant part of the code is:

stpapi.handle.subproc("tfacp1110s000","tfacp1120s000","add")
stpapi.continue.process("tfacp1110s000", error.msg)

|Companhia
stpapi.put.field("tfacp1120s000","tfgld102.tcom",str$(companhia))
|Conta
stpapi.put.field("tfacp1120s000","tfgld102.leac","AB")
|Valor
stpapi.put.field("tfacp1120s000","amount",str$(valor))

retval = stpapi.insert("tfacp1120s000", do.save, erro)

stpapi.end.session("tfacp1120s000")

Can somebody give a hand? (quickly please)

Thanks a lot
Fred
__________________
The Sleeper has Awakened.
Reply With Quote
  #2  
Old 10th February 2003, 20:32
mark_h's Avatar
mark_h mark_h is offline
Guru
 
Join Date: Sep 2001
Location: Kentucky, USA
Posts: 7,145
mark_h will become famous soon enough
Baan: Baan 4C4 A&D1 - DB: Oracle - OS: Sun Solaris
Subsession

Is it doing an activate or a zoom? I am not familiar with this session and how it gets activated. I did find this thread and maybe it will help. Do you own source where you can put the tfacp sessions in debug mode?

Also might want to make sure you have the latest tools solution and session solution.

Mark
Reply With Quote
Sponsored Links
  #3  
Old 10th February 2003, 23:36
fmorais's Avatar
fmorais fmorais is offline
Senior Member
 
Join Date: Mar 2002
Location: Portugal
Posts: 164
fmorais is on a distinguished road
Baan: B4c4 - DB: MSSQL, Oracle, Informix, BBase - OS: Windows, AIX
Smile Problem Solved

Mark,

Thanks for your help.
Looking at the thread you suggested and testing a bit more gave some new ideas and...

I found out that if you interactivelly do a save (not clicking continue) in session tfacp1110s000, it automatically calls tfacp1120s000...

The problem was really in stpapi.insert in tfacp1110s000. (perhaps because the do.save option was true, tfacp1120s000 was being called without the respective handling, which was only done after).

So I altered the code:

|Insert record in tacp1110s000
|kill tfacp1120s000 if it appears
stpapi.handle.subproc("tfacp1110s000","tfacp1120s000","kill")
retval = stpapi.insert("tfacp1110s000", do.save, erro)

|Call tfacp1120s000
stpapi.handle.subproc("tfacp1110s000","tfacp1120s000","add")
stpapi.continue.process("tfacp1110s000", error.msg)

Now it works ok.
Fred
__________________
The Sleeper has Awakened.
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
Calling tibom1110m000 with AFS kmcinc AFS/DDC/OLE: Function servers 1 27th October 2003 22:27
Getting error when calling AFS for tssma3110m000 mfaisal AFS/DDC/OLE: Function servers 12 23rd October 2003 23:32
calling AFS? RAMSBaan AFS/DDC/OLE: Function servers 0 30th April 2003 21:49
AFS - session hangs prademaker AFS/DDC/OLE: Function servers 7 22nd July 2002 11:24
Unable to start subsession from subsession in BOI arunprasath Tools Development 9 25th February 2002 16:04


All times are GMT +2. The time now is 17:10.


©2001-2018 - Baanboard.com - Baanforums.com