• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Triggers (XE on AS/400 Co-exist)

AS400Guru

Well Known Member
Hello Folks,

Just wondering if any of the experts out there implementing OW XE
Co-existence have faced this problem.
We have some custom files on the AS/400 and there are triggers attached to
these files.

If we try to do any updates,deleted or inserts...the specific operation is
performed but the screen just hangs and the hourglass is displayed.The
application has to be terminated via the task manager.

However if we remove the triggers on the files, it just works fine.

Some of the JDe files have triggers on them and they seem to have worked
fine.

Is there any special procedure to be followed for triggers on Custom
files????.

Any help and insight would be greatly appreciated.
Thanks so much.

AS/400 V4R5 OW XE SP 13, trying to Co-exist.
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
 

AKOCH1

Member
Hi,

I think you are having a problem with the Standard JDE-Triggers.

What file are you working on?

I have seen your problem in B7332 on Work order entry, got trigger X0016E
hanging there.

When your screen hangs, go on the AS/400 and check the Msg's for QSYSOPR.
You might have one from a JDE Trigger that says that there is an array
problem.
Once you reply to this message, your OneWorld Session comes back to life!

André


____________________________________________________________
B7.3.3.2, SP 11.3, Citrix, AS/400, Co-existence with A7.3 cum11/E9/X2
 

AS400Guru

Well Known Member
Hey All,
Okie..Heres what was happening.....First let me ask you CNC guys out
there...if its possible to map 2 environments on the WORLD side to 1
environment on the OW side?.The reason being all the Objects on World are
stored on the XXXOBJ lib and Data on the XXXDTA lib.
In a Co-exist environment we just map the DTA to the OW in OCM.

However if there is a custom file and has a trigger attached to it, the
trigger program will not have a problem while being invoked cos its a
qualified call. But if in a scenario where there are other programs being
invoked from the trigger program itself...lets say some JDE vanilla
pgms,ideally they will be in the JDFOBJ lib. The OW will not find this
Object since the mapping just points to DTA lib in a Co-Exist environment.:(
If we move the corresponding objects to the DTA lib,which is not the
standard on the WORLD side the call from OW works....This is a temporary
solution though....Just wondering if anyone has faced a similar problem and
whether CNC can take care of such a issue.

Thanks for all the Help.


>From: AKOCH1 <AKOCH1@jppbe.jnj.com>
>Reply-To: jdelist@jdelist.com
>To: jdelistml@jdelist.com
>Subject: RE: Triggers (XE on AS/400 Co-exist) ~~5313:5344
>Date: Fri, 9 Feb 2001 09:26:12 -0800 (PST)
>
>Hi,
>
>I think you are having a problem with the Standard JDE-Triggers.
>
>What file are you working on?
>
>I have seen your problem in B7332 on Work order entry, got trigger X0016E
>hanging there.
>
>When your screen hangs, go on the AS/400 and check the Msg's for QSYSOPR.
>You might have one from a JDE Trigger that says that there is an array
>problem.
>Once you reply to this message, your OneWorld Session comes back to life!
>
>André
>
>
>____________________________________________________________
>B7.3.3.2, SP 11.3, Citrix, AS/400, Co-existence with A7.3 cum11/E9/X2
>
>
>
>
>
>--------------------------
>To view this thread, visit the JDEList forum at:
>http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=5344
>*************************************************************
>This is the JDEList One World / XE Mailing List.
>Archives and information on how to SUBSCRIBE, and
>UNSUBSCRIBE can be found at http://www.JDELIST.com
>*************************************************************
>

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
 

Blaine67

Member
Within each of your ODBC settings, define your library list on ther server tab.
You can enter more than one library seperated by a comma. Example for the
AS/400 COMMON - Production: PRDOBJ,PRDDTA,PRDCOM etc. In this list you put
your custom library (PRDOBJ) with your custom programs or trigger programs etc.
This is where the library list is built for the AS/400 session. Hope this
helps........................


Brian Kamps
Tech Specialist
Hoffman Enclosures
 
Top