Re: Aurora - Advanced Orders - Record Locks
Suzanne Selvey <[email protected]> Wed, 19 Jan 2011 13:30:45 -0500
| Newsgroups | gmane.comp.systems.as400.jbausers |
|---|---|
| Message-ID | <[email protected]> |
Thanks Barbara. Unfortunately, all of the files are open with file locks. COYPOF INP57L04 ACSUMMAR OEP56L01 INP40L01 OEP55A OEP40A ORDLNORD ORDHDORD PARTS CUSNAMES STKBAL -> Several More, Too Many to List All of them. Including AO002FT, AO011FT, AO023FT. It is like the *INLR is never being turned on in AO002, AO011 and AO023. This is after you get back to the intial order screen and hitting an F3 to get completely out. In JBA, I see the files open and all of them are closed on the F3. > Date: Wed, 19 Jan 2011 13:18:37 -0500 > From: bbyrne-W1GZM/[email protected] > To: system21-Zwy7GipZuJhWk0Htik3J/[email protected] > Subject: Re: [SYSTEM21] Aurora - Advanced Orders - Record Locks > > we went on Aurora Aug 2009 and did have a locking problem. > A change was made to AO005 > 2 lines added > Else > UnLock OEPWBL00 > > right after line > Update OERWB > > > ______________________ > > > Thanks > > Barbara Byrne > > IT Manager > Greatex Mills Inc. > > -----Original Message----- > From: system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] > [mailto:system21-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Suzanne Selvey > Sent: Wednesday, January 19, 2011 11:35 AM > To: system21-Zwy7GipZuJhWk0Htik3J/[email protected] > Subject: [SYSTEM21] Aurora - Advanced Orders - Record Locks > > > We are currently in the middle of upgrading to Aurora. > Infor has said that they are not familiar with this issue and have been > unable to provide immediate assistance. > > Has anyone else run into this issue with Advanced Order Entry/Amend? > > The Aurora code has been converted to RPGLE and now runs under the > AULSTD activation group. > > The initial driver program AO001CLP overrides the commonly used > databases and leaves the data paths open to improve file processing > between the multiple AO programs. > For example: > OVRDBF FILE(PARTS) SECURE(*YES) OVRSCOPE(*CALLLVL) SHARE(*YES) > OPNDBF FILE(PARTS) OPTION(*ALL) > > The *INLR is still parameterized in the AO RPGLE programs, as it was in > JBA. I did see a specific line of code to turn on *INLR only in AO001. > > The problem is.... > > When completing the Order normally, either through Entry or Amend the > files are left open and records are locked. > > I have put several programs through debug and saw AO001CLP close each > file and run the Reclaim Resource Command. > > But the files are actually still open and locking records, so that Order > Allocation, etc. blow up on record locks. > We can't have the users sign off and back on every time they put in an > order. > > The system programs XA000CL, etc. programs are running in AULAM > activation group. > It appears that all of the AO programs are running in the AULSTD > activation group. > I noticed that some of the service programs/modules???? are running in > *DFTACTGRP. Could this be causing the problem? > > AO005 QUAMODSP4 AULSTD > QRNXIO QSYS AULSTD > QWSGET QSYS *DFTACTGRP > QT3REQIO QSYS *DFTACTGRP > > > I am not sure if it is an issue with the *INLR parameters or an issue > related to using activation groups. > > I tried using the Reclaim Activation Group command in AO001CLP, but it > just dumped all over the place. > > Has anyone else run into this is with Aurora? > How do the *INLR parameters get turned on in AO005, AO009, AO013, etc? > > Any suggestions??? > > Thanks, > Suzanne Selvey > _______________________________________________ > This is the System 21 Users (SYSTEM21) mailing list To post a message > email: SYSTEM21-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list > options, > visit: http://lists.midrange.com/mailman/listinfo/system21 > or email: SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected] > Before posting, please take a moment to review the archives at > http://archive.midrange.com/system21. > > _______________________________________________ > This is the System 21 Users (SYSTEM21) mailing list > To post a message email: SYSTEM21-Zwy7GipZuJhWk0Htik3J/[email protected] > To subscribe, unsubscribe, or change list options, > visit: http://lists.midrange.com/mailman/listinfo/system21 > or email: SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected] > Before posting, please take a moment to review the archives > at http://archive.midrange.com/system21. > _______________________________________________ This is the System 21 Users (SYSTEM21) mailing list To post a message email: SYSTEM21-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/system21 or email: SYSTEM21-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/system21.