Baanboard.com

Go Back   Baanboard.com > Forum > Baan SIGs > ION

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 20th April 2016, 16:15
NirajKakodkar's Avatar
NirajKakodkar NirajKakodkar is offline
Guru
 
Join Date: May 2006
Location: Finland
Posts: 339
NirajKakodkar is on a distinguished road
Baan: BAAN4C4 , BAAN 5c , LN - DB: MS SQL SERVER, ORACLE, Informix, HP Unix, AIX - OS: Windows, UNIX
Time Field cannot be modified in Outbound advice

Hi ,

I am facing a bit strange issue, I have a DLL to generate Outbound advice with method as below

whinhdllc0001.generate.ob.advice(i.runn, i.orno)

The method have run number & order number as input arguments. The DLL works perfect when called from 3GL object / 4 GL session without any issues & generates the advice properly.

But when I call the same method from BOD, the advice is not generated. I tried to debug the DAL for whinh225 but it works good as well. I tried to capture any DAL errors at the end of my DLL to check what could have failed. I found the last error message as below

"Outbound Order line (SFC Production Order XYZ 1/10 -1 ): The time field cannot be modified in outbound advice).

The strange thing is the DLL generates the desired output with same inputs arguments when called from 3GL/4GL, but when it is called from the BOD st script the same method with same input gives the above error.

Moreover I tried to fetch the message pattern to identify where this message is coming from, but no luck

Any thoughts, suggestion, advice to resolve the issue ?
__________________

Niraj N. S. Kakodkar |Linkedin

Last edited by NirajKakodkar : 20th April 2016 at 16:22. Reason: Addition
Reply With Quote
Sponsored Links
  #2  
Old 20th April 2016, 17:03
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 Niraj,

What you can do here is, you can write your DLL-A in a 3GL and then kick off the 3GL in a DLL-B using activate() or wait.and.activate(). Now call this DLL in your ST script. Check if that works for you.

As the BOD holds the commit, there might be some unhandled transaction in the standard DLL. With the above, the hold over commit will be skipped and the DLL will run normally.

Check if that works for you.

Else, you can try using -

Code:
old.id = db.get.child.transaction()
db.set.child.transaction(0)
wait.and.activate("your_3gl")
db.set.child.transaction(old.id)

Faced some locking issues due to the same. Was resolved due to the above 2 fixes.
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
Reply With Quote
  #3  
Old 20th April 2016, 17:07
NirajKakodkar's Avatar
NirajKakodkar NirajKakodkar is offline
Guru
 
Join Date: May 2006
Location: Finland
Posts: 339
NirajKakodkar is on a distinguished road
Baan: BAAN4C4 , BAAN 5c , LN - DB: MS SQL SERVER, ORACLE, Informix, HP Unix, AIX - OS: Windows, UNIX
Thank you Bhushan, thats a nice thought. I can give it a try
__________________

Niraj N. S. Kakodkar |Linkedin
Reply With Quote
  #4  
Old 20th April 2016, 18:31
NirajKakodkar's Avatar
NirajKakodkar NirajKakodkar is offline
Guru
 
Join Date: May 2006
Location: Finland
Posts: 339
NirajKakodkar is on a distinguished road
Baan: BAAN4C4 , BAAN 5c , LN - DB: MS SQL SERVER, ORACLE, Informix, HP Unix, AIX - OS: Windows, UNIX
Hi Bhushan,

It worked like a charm, somewhere in my mind I was thinking you will be the one who will give me the resolution for this. Thanks again . Keep up the good work.
__________________

Niraj N. S. Kakodkar |Linkedin
Reply With Quote
  #5  
Old 20th April 2016, 22:37
benito's Avatar
benito benito is offline
Guru
 
Join Date: Jan 2002
Location: Eastern US
Posts: 517
benito is on a distinguished road
Baan: ERPLn 10.2.1 / BaanIVc4 - DB: Oracle11/Informix - OS: Unix/Linux
nice trick! awesome.
Reply With Quote
  #6  
Old 20th April 2016, 22:45
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
Glad that worked for you.
__________________
Regards,

Bhushan

Unless you try to do something beyond what you have already mastered, you will never grow!
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
Inbound Lead Time Significance in SIC harrys Distribution, Transportation & Warehousing 0 30th May 2011 10:50
Default time is different from System Time bumbaermail Tools Administration & Installation 1 10th May 2011 10:26
Outbound Advice using Lots SandraP Distribution, Transportation & Warehousing 4 25th September 2007 16:45
Outbound Advice by Work Center batmush Distribution, Transportation & Warehousing 5 13th August 2007 05:15
UTC Format **SAT** Tools Development 10 24th September 2002 20:22


All times are GMT +2. The time now is 01:03.


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